This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 171935

Summary: java_ee_6_pet_catalog tutorial not working with Java DB
Product: usersguide Reporter: Antonin Nebuzelsky <anebuzelsky>
Component: JavaEEAssignee: Milan Kuchtiak <mkuchtiak>
Status: RESOLVED FIXED    
Severity: blocker CC: pjiricka
Priority: P2    
Version: 6.x   
Hardware: All   
OS: All   
Issue Type: DEFECT Exception Reporter:

Description Antonin Nebuzelsky 2009-09-10 14:41:28 UTC 
http://blogs.sun.com/carolmcdonald/entry/java_ee_6_pet_catalog

I decided to do the tutorial with Java DB. Step 7 of the "Create the Pet Catalog database" section fails with

Error code -1, SQL state 42821: Columns of type 'DECIMAL' cannot hold values of type 'CHAR'. 
Line 170, column 1
... and more like that

when executing the provided catalog.sql script.
Comment 1 Petr Jiricka 2009-09-15 15:00:35 UTC 
The author of the sample fixed the SQL script, so this will be fixed when we include the latest version of the sample.
Comment 2 Milan Kuchtiak 2009-09-16 14:18:44 UTC 
Yes, the current example works for MySQL only.
Comment 3 Milan Kuchtiak 2009-09-16 16:39:00 UTC 
Fixed.

Updated to latest version working with JavaDB:
http://hg.netbeans.org/main/rev/b234b141af8e
Comment 4 Quality Engineering 2009-09-18 22:36:51 UTC 
Integrated into 'main-golden', will be available in build *200909181401* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress)
Changeset: http://hg.netbeans.org/main-golden/rev/b234b141af8e
User: mkuchtiak@netbeans.org
Log: #171935: updating PetCatalog example