even from sample database in netbeans i can not create a entity
Hi
each time with each database when i create entity bean from database with netbeans 5.5 i become this message and i can not read the data from database!
(see please the server log ): Got SQLException executing statement "CREATE TABLE ......
I am confused because:
1-i can create the entity classes from database as java code and even persistent unit for this entities
2-Even with the samples database f.i. Manufactorer coming with the sun application server i become this message and i can read any data from database in my jsps.
I will be thankful for your help
here the portion of server log file:
[#|2007-05-17T13:47:00.504+0200|INFO|sun-appserver-pe9.0|javax.enterprise.system.stream.out|_ThreadID=19;_ThreadName=Thread-62;|[TopLink Config]: 2007.05.17 01:47:00.504--ServerSession(4170703)--Connection(22273059)--Connected: jdbc:derby://localhost:1527/sample
User: app
Database: Apache Derby Version: 10.1.3.1
Driver: Apache Derby Network Client JDBC Driver Version: 10.1.3.1
|#]
[#|2007-05-17T13:47:00.514+0200|INFO|sun-appserver-pe9.0|javax.enterprise.system.stream.out|_ThreadID=19;_ThreadName=Thread-62;|[TopLink Config]: 2007.05.17 01:47:00.514--ServerSession(4170703)--Connection(3321496)--connecting(DatabaseLogin(
platform=>JavaDBPlatform
user name=> ""
connector=>JNDIConnector datasource name=>null
))
|#]
[#|2007-05-17T13:47:00.514+0200|INFO|sun-appserver-pe9.0|javax.enterprise.system.stream.out|_ThreadID=19;_ThreadName=Thread-62;|[TopLink Config]: 2007.05.17 01:47:00.514--ServerSession(4170703)--Connection(23363144)--Connected: jdbc:derby://localhost:1527/sample
User: app
Database: Apache Derby Version: 10.1.3.1
Driver: Apache Derby Network Client JDBC Driver Version: 10.1.3.1
|#]
[#|2007-05-17T13:47:00.545+0200|INFO|sun-appserver-pe9.0|javax.enterprise.system.stream.out|_ThreadID=19;_ThreadName=Thread-62;|[TopLink Info]: 2007.05.17 01:47:00.545--ServerSession(4170703)--file:/C:/Sun/SDK/domains/domain1/applications/j2ee-apps/Manufactorer/Manufactorer-ejb_jar/-Manufactorer-ejbPU login successful
|#]
[#|2007-05-17T13:47:00.555+0200|INFO|sun-appserver-pe9.0|javax.enterprise.system.stream.out|_ThreadID=19;_ThreadName=Thread-62;|[TopLink Config]: 2007.05.17 01:47:00.555--ServerSession(4170703)--Connection(9783607)--disconnect
|#]
[#|2007-05-17T13:47:00.555+0200|INFO|sun-appserver-pe9.0|javax.enterprise.system.stream.out|_ThreadID=19;_ThreadName=Thread-62;|[TopLink Info]: 2007.05.17 01:47:00.555--ServerSession(4170703)--file:/C:/Sun/SDK/domains/domain1/applications/j2ee-apps/Manufactorer/Manufactorer-ejb_jar/-Manufactorer-ejbPU logout successful
|#]
[#|2007-05-17T13:47:00.865+0200|WARNING|sun-appserver-pe9.0|javax.enterprise.resource.jdo.codegen.ejb|_ThreadID=19;_ThreadName=Thread-62;_RequestID=dd3a83f6-bf1a-460f-9363-0b4865ca61a1;|JDO76609:
Got SQLException executing statement "CREATE TABLE MANUFACTURER (MANUFACTURER_ID INTEGER NOT NULL, STATE VARCHAR(255), ZIP VARCHAR(255), ADDRESSLINE1 VARCHAR(255), PHONE VARCHAR(255), CITY VARCHAR(255), FAX VARCHAR(255), ADDRESSLINE2 VARCHAR(255), EMAIL VARCHAR(255), NAME VARCHAR(255), REP VARCHAR(255), PRIMARY KEY (MANUFACTURER_ID))": org.apache.derby.client.am.SqlException: Table/View 'MANUFACTURER' already exists in Schema 'APP'.|#]
[#|2007-05-17T13:47:01.436+0200|INFO|sun-appserver-pe9.0|javax.enterprise.system.tools.deployment|_ThreadID=19;_ThreadName=Thread-62;|deployed with moduleid = Manufactorer|#]
[#|2007-05-17T13:47:02.828+0200|INFO|sun-appserver-pe9.0|javax.enterprise.system.tools.admin|_ThreadID=16;_ThreadName=httpWorkerThread-4848-0;ApplicationDeployEvent -- enable Manufactorer;|ADM1041:Sent the event to instance:[ApplicationDeployEvent -- enable Manufactorer]|#]
[#|2007-05-17T13:47:03.088+0200|INFO|sun-appserver-pe9.0|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=httpWorkerThread-4848-0;|[TopLink Config]: 2007.05.17 01:47:03.088--ServerSession(24854674)--The alias name for the entity class [class ejb3.Manufacturer] is being defaulted to: Manufacturer.
|#]
[#|2007-05-17T13:47:03.118+0200|INFO|sun-appserver-pe9.0|javax.enterprise.system.core.naming|_ThreadID=16;_ThreadName=httpWorkerThread-4848-0;java:comp/env/ejb3.ManufacturerFacade/em;|naming.bind|#]
[#|2007-05-17T13:47:03.178+0200|INFO|sun-appserver-pe9.0|javax.enterprise.system.core.classloading|_ThreadID=16;_ThreadName=httpWorkerThread-4848-0;Manufactorer;|LDR5010: All ejb(s) of [Manufactorer] loaded successfully!|#]
[#|2007-05-17T13:47:03.208+0200|INFO|sun-appserver-pe9.0|javax.enterprise.system.container.web|_ThreadID=16;_ThreadName=httpWorkerThread-4848-0;Manufactorer:Manufactorer-war.war;server;/Manufactorer-war;|WEB0100: Loading web module [Manufactorer:Manufactorer-war.war] in virtual server [server] at [/Manufactorer-war]|#]
[#|2007-05-17T13:47:03.519+0200|INFO|sun-appserver-pe9.0|javax.enterprise.resource.webcontainer.jsf.config|_ThreadID=16;_ThreadName=httpWorkerThread-4848-0;/Manufactorer-war;|Initializing Sun's JavaServer Faces implementation (1.2_02-b03-FCS) for context '/Manufactorer-war'|#]
[#|2007-05-17T13:47:04.020+0200|INFO|sun-appserver-pe9.0|javax.enterprise.resource.webcontainer.jsf.config|_ThreadID=16;_ThreadName=httpWorkerThread-4848-0;/Manufactorer-war;|Completed initializing Sun's JavaServer Faces implementation (1.2_02-b03-FCS) for context '/Manufactorer-war'|#]
