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 - java_ee_6_pet_catalog tutorial not working with Java DB
Summary: java_ee_6_pet_catalog tutorial not working with Java DB
Status: RESOLVED FIXED
Alias: None
Product: usersguide
Classification: Unclassified
Component: JavaEE (show other bugs)
Version: 6.x
Hardware: All All
: P2 blocker (vote)
Assignee: Milan Kuchtiak
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-09-10 14:41 UTC by Antonin Nebuzelsky
Modified: 2009-09-18 22:36 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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