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 82522 - SQLException executing statement "CREATE TABLE CUSTOMER....
Summary: SQLException executing statement "CREATE TABLE CUSTOMER....
Status: RESOLVED INVALID
Alias: None
Product: javaee
Classification: Unclassified
Component: Persistence (show other bugs)
Version: 5.x
Hardware: PC Windows XP
: P3 blocker (vote)
Assignee: Andrei Badea
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-08-11 19:31 UTC by shawnxie
Modified: 2007-10-25 13:57 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description shawnxie 2006-08-11 19:31:11 UTC
Hi, 
I am running the example presented at 
http://testwww.netbeans.org/kb/55/customer-book.html with 5.5 beta 2. 
Everything goes find as expected. However, I find the following exception in 
the log panel of Sun Java System Application Server of the IDE:

Trying to create reference for application in target server  completed 
successfully
Trying to start application in target server  completed successfully
JDO76614: Deployment encountered SQL Exceptions:
        JDO76609: Got SQLException executing statement "CREATE TABLE 
DISCOUNT_CODE (DISCOUNT_CODE VARCHAR(255) NOT NULL, RATE DECIMAL, PRIMARY KEY 
(DISCOUNT_CODE))": org.apache.derby.client.am.SqlException: 
Table/View 'DISCOUNT_CODE' already exists in Schema 'APP'.
        JDO76609: Got SQLException executing statement "CREATE TABLE CUSTOMER 
(CUSTOMER_ID INTEGER NOT NULL, CITY VARCHAR(255), STATE VARCHAR(255), ZIP 
VARCHAR(255) NOT NULL, PHONE VARCHAR(255), ADDRESSLINE1 VARCHAR(255), FAX 
VARCHAR(255), EMAIL VARCHAR(255), ADDRESSLINE2 VARCHAR(255), CREDIT_LIMIT 
INTEGER, NAME VARCHAR(255), DISCOUNT_CODE VARCHAR(255), PRIMARY KEY 
(CUSTOMER_ID))": org.apache.derby.client.am.SqlException: Table/View 'CUSTOMER' 
already exists in Schema 'APP'.

    Although this exception message does not prevent this application from 
running, it is ugly to be presented to the end user and it may become 
misleading when trouble shooting an app that fails to run. 

-Shawn Xie
Comment 1 Marian Mirilovic 2006-11-06 15:03:26 UTC
both said you've already created tables you are trying to create again ... I
know nothing about examples you are describing ... so reassign to more
appropriate component , feel free to reassign
Comment 2 Andrei Badea 2006-11-07 12:27:55 UTC
This does not look like an enhancement, marking as such. Please attach your
persistence.xml file.
Comment 3 Andrei Badea 2007-01-07 15:07:55 UTC
Marking as incomplete until the information requested in my previous post is
provided.
Comment 4 Andrei Badea 2007-10-25 13:57:32 UTC
No reply from submitter for a long time, closing.