Bug ID: 6485234
Votes 0
Synopsis Got SQL exception when using NB to run java5ee sample customer-cmp-ear
Category sunone_application_server:sample_apps
Reported Against
Release Fixed
State In progress, bug
Related Bugs
Submit Date 23-OCT-2006
Description I am using 9.1 build 22 with the NB 5.5 RC2 build on window XP
I am using NB to run javaee5 sample app customer-cmp-ear. I saw the SQL exception. We
should put in some needed DB setup and clean up steps, so the output will show error
free.
---- job output ------
run:
Duplicated project name in import. Project customer-cmp-ear-impl defined first in D:\AppServer Install\9.0UR1sdk\samples\javaee5\enterprise\customer-cmp-ear\nbproject\ant-deploy.xml and again in D:\AppServer Install\9.0UR1sdk\samples\javaee5\enterprise\customer-cmp-ear\nbproject\build-impl.xml
run-bp:
Duplicated project name in import. Project customer-cmp-ear-impl defined first in D:\AppServer Install\9.0UR1sdk\samples\javaee5\enterprise\customer-cmp-ear\nbproject\ant-deploy.xml and again in D:\AppServer Install\9.0UR1sdk\samples\javaee5\enterprise\customer-cmp-ear\nbproject\build-impl.xml
run-nb:
Duplicated project name in import. Project customer-cmp-ear-impl defined first in D:\AppServer Install\9.0UR1sdk\samples\javaee5\enterprise\customer-cmp-ear\nbproject\ant-deploy.xml and again in D:\AppServer Install\9.0UR1sdk\samples\javaee5\enterprise\customer-cmp-ear\nbproject\build-impl.xml
pre-init:
init-private:
init-userdir:
init-user:
init-project:
do-init:
post-init:
init-check:
init:
Duplicated project name in import. Project customer-cmp-ear-impl defined first in D:\AppServer Install\9.0UR1sdk\samples\javaee5\enterprise\customer-cmp-ear\nbproject\ant-deploy.xml and again in D:\AppServer Install\9.0UR1sdk\samples\javaee5\enterprise\customer-cmp-ear\nbproject\build-impl.xml
pre-init:
init-private:
init-userdir:
init-user:
init-project:
do-init:
post-init:
init-check:
init:
deps-jar:
deps-j2ee-archive:
init:
init:
deps-jar:
Created dir: D:\AppServer Install\9.0UR1sdk\samples\javaee5\enterprise\customer-cmp-ear\customer-cmp-ejb\build\jar
Created dir: D:\AppServer Install\9.0UR1sdk\samples\javaee5\enterprise\customer-cmp-ear\customer-cmp-ejb\build\ear-module
Copying 1 file to D:\AppServer Install\9.0UR1sdk\samples\javaee5\enterprise\customer-cmp-ear\customer-cmp-ejb\build\ear-module\META-INF
Compiling 9 source files to D:\AppServer Install\9.0UR1sdk\samples\javaee5\enterprise\customer-cmp-ear\customer-cmp-ejb\build\ear-module
Note: D:\AppServer Install\9.0UR1sdk\samples\javaee5\enterprise\customer-cmp-ear\customer-cmp-ejb\src\java\enterprise\customer_cmp_ejb\ customer \Customer.java uses unchecked or unsafe operations.
Note: Recompile with -Xlint:unchecked for details.
compile:
library-inclusion-in-manifest:
Created dir: D:\AppServer Install\9.0UR1sdk\samples\javaee5\enterprise\customer-cmp-ear\customer-cmp-ejb\dist
Building jar: D:\AppServer Install\9.0UR1sdk\samples\javaee5\enterprise\customer-cmp-ear\customer-cmp-ejb\dist\customer-cmp-ejb.jar
dist-ear:
deps-jar:
Created dir: D:\AppServer Install\9.0UR1sdk\samples\javaee5\enterprise\customer-cmp-ear\customer-cmp-appclient\build\ear-module
Copying 1 file to D:\AppServer Install\9.0UR1sdk\samples\javaee5\enterprise\customer-cmp-ear\customer-cmp-appclient\build\ear-module\META-INF
Compiling 1 source file to D:\AppServer Install\9.0UR1sdk\samples\javaee5\enterprise\customer-cmp-ear\customer-cmp-appclient\build\ear-module
compile:
library-inclusion-in-manifest:
Copying 1 file to D:\AppServer Install\9.0UR1sdk\samples\javaee5\enterprise\customer-cmp-ear\build
Created dir: D:\AppServer Install\9.0UR1sdk\samples\javaee5\enterprise\customer-cmp-ear\customer-cmp-appclient\dist
Building jar: D:\AppServer Install\9.0UR1sdk\samples\javaee5\enterprise\customer-cmp-ear\customer-cmp-appclient\dist\customer-cmp-appclient.jar
dist-ear:
init:
deps-jar:
compile:
library-inclusion-in-manifest:
dist-ear:
init:
deps-module-jar:
deps-ear-jar:
init:
deps-jar:
compile:
library-inclusion-in-manifest:
dist-ear:
deps-jar:
Created dir: D:\AppServer Install\9.0UR1sdk\samples\javaee5\enterprise\customer-cmp-ear\customer-cmp-war\build\ear-module\WEB-INF\classes
Created dir: D:\AppServer Install\9.0UR1sdk\samples\javaee5\enterprise\customer-cmp-ear\customer-cmp-war\build\ear-module\META-INF
Copying 1 file to D:\AppServer Install\9.0UR1sdk\samples\javaee5\enterprise\customer-cmp-ear\customer-cmp-war\build\ear-module\META-INF
Copying 10 files to D:\AppServer Install\9.0UR1sdk\samples\javaee5\enterprise\customer-cmp-ear\customer-cmp-war\build\ear-module
library-inclusion-in-archive:
library-inclusion-in-manifest:
compile:
compile-jsps:
do-ear-dist:
Created dir: D:\AppServer Install\9.0UR1sdk\samples\javaee5\enterprise\customer-cmp-ear\customer-cmp-war\dist
Building jar: D:\AppServer Install\9.0UR1sdk\samples\javaee5\enterprise\customer-cmp-ear\customer-cmp-war\dist\customer-cmp-war.war
dist-ear:
pre-pre-compile:
Created dir: D:\AppServer Install\9.0UR1sdk\samples\javaee5\enterprise\customer-cmp-ear\build\jar
pre-compile:
do-compile:
Copying 2 files to D:\AppServer Install\9.0UR1sdk\samples\javaee5\enterprise\customer-cmp-ear\build\META-INF
Copying 1 file to D:\AppServer Install\9.0UR1sdk\samples\javaee5\enterprise\customer-cmp-ear\build
Copying 1 file to D:\AppServer Install\9.0UR1sdk\samples\javaee5\enterprise\customer-cmp-ear\build
post-compile:
compile:
pre-dist:
do-dist-without-manifest:
Created dir: D:\AppServer Install\9.0UR1sdk\samples\javaee5\enterprise\customer-cmp-ear\dist
Building jar: D:\AppServer Install\9.0UR1sdk\samples\javaee5\enterprise\customer-cmp-ear\dist\customer-cmp-ear.ear
do-dist-with-manifest:
post-dist:
dist:
pre-run-deploy:
Distributing D:\AppServer Install\9.0UR1sdk\samples\javaee5\enterprise\customer-cmp-ear\dist\customer-cmp-ear.ear to [localhost:4848_server]
Start registering the project's server resources
Finished registering server resources
deployment started : 0%
deployment finished : 100%
Deploying application in domain completed successfully
Trying to create reference for application in target server completed successfully
Trying to start application in target server completed successfully
WARNING:
JDO76614: Deployment encountered SQL Exceptions:
JDO76609: Got SQLException executing statement "CREATE TABLE ADDRESS (addressID VARCHAR(255) NOT NULL, CITY VARCHAR(255), ZIP VARCHAR(255), STREET VARCHAR(255), STATE VARCHAR(255), PRIMARY KEY (addressID))": org. customer .derby.client.am.SqlException: Table/View 'ADDRESS' already exists in Schema 'APP'.
JDO76609: Got SQLException executing statement "ALTER TABLE CUSTOMER_ADDRESS ADD CONSTRAINT CSTMRDddrsssddrssD FOREIGN KEY (addresses_addressID) REFERENCES ADDRESS (addressID)": org. customer .derby.client.am.SqlException: Constraint 'CSTMRDDDRSSSDDRSSD' is invalid: there is no unique or primary key constraint on table 'APP.ADDRESS' that matches the number and types of the columns in the foreign key.
Enable of customer-cmp-ear in target server completed successfully
Enable of application in all targets completed successfully
All operations completed successfully
post-run-deploy:
run-deploy:
Duplicated project name in import. Project customer-cmp-ear-impl defined first in D:\AppServer Install\9.0UR1sdk\samples\javaee5\enterprise\customer-cmp-ear\nbproject\ant-deploy.xml and again in D:\AppServer Install\9.0UR1sdk\samples\javaee5\enterprise\customer-cmp-ear\nbproject\build-impl.xml
pre-init:
init-private:
init-userdir:
init-user:
init-project:
do-init:
post-init:
init-check:
init:
deps-jar:
deps-j2ee-archive:
init:
init:
deps-jar:
compile:
library-inclusion-in-manifest:
dist-ear:
deps-jar:
compile:
library-inclusion-in-manifest:
dist-ear:
init:
deps-jar:
compile:
library-inclusion-in-manifest:
dist-ear:
init:
deps-module-jar:
deps-ear-jar:
init:
deps-jar:
compile:
library-inclusion-in-manifest:
dist-ear:
deps-jar:
library-inclusion-in-archive:
library-inclusion-in-manifest:
compile:
compile-jsps:
do-ear-dist:
dist-ear:
pre-pre-compile:
pre-compile:
do-compile:
post-compile:
compile:
pre-dist:
do-dist-without-manifest:
Building jar: D:\AppServer Install\9.0UR1sdk\samples\javaee5\enterprise\customer-cmp-ear\dist\customer-cmp-ear.ear
do-dist-with-manifest:
post-dist:
dist:
pre-run-deploy:
Redeploying D:\AppServer Install\9.0UR1sdk\samples\javaee5\enterprise\customer-cmp-ear\dist\customer-cmp-ear.ear
Start registering the project's server resources
Finished registering server resources
While redeploying, trying to stop the application in target server completed successfully
While redeploying, trying to remove reference for application in target server completed successfully
deployment started : 0%
deployment finished : 100%
Deploying application in domain completed successfully
Trying to create reference for application in target server completed successfully
Trying to start application in target server completed successfully
WARNING:
JDO76614: Deployment encountered SQL Exceptions:
JDO76609: Got SQLException executing statement "ALTER TABLE CUSTOMER_ADDRESS DROP CONSTRAINT CSTMRDddrsssddrssD": org. customer .derby.client.am.SqlException: ALTER TABLE failed. There is no constraint 'APP.CSTMRDDDRSSSDDRSSD' on table 'APP.CUSTOMER_ADDRESS'.
All operations completed successfully
Enable of customer-cmp-ear in target server completed successfully
Enable of application in all targets completed successfully
All operations completed successfully
post-run-deploy:
run-deploy:
Browsing: http://localhost:8080/customer-cmp-war/
run-display-browser:
Duplicated project name in import. Project customer-cmp-ear-impl defined first in D:\AppServer Install\9.0UR1sdk\samples\javaee5\enterprise\customer-cmp-ear\nbproject\ant-deploy.xml and again in D:\AppServer Install\9.0UR1sdk\samples\javaee5\enterprise\customer-cmp-ear\nbproject\build-impl.xml
pre-init:
init-private:
init-userdir:
init-user:
init-project:
do-init:
post-init:
init-check:
init:
run-ac:
BUILD SUCCESSFUL (total time: 20 seconds)
Posted Date : 2006-10-23 23:33:51.0