db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From servetkarabas <ser...@uekae.tubitak.gov.tr>
Subject Re: Bug : Derby table invisible from JPA provider
Date Wed, 11 Nov 2009 09:32:46 GMT

Hi,

You have to remove property from persistence.xml

old line
<property-name="xxxx.ddl-generation" values = "drop-and-create-tables">

new line
<!--property-name="xxxx.ddl-generation" values = "drop-and-create-tables"-->


regards,
servet



Brieuc Desoutter wrote:
> 
> Hi,
> 
> I'm learning JPA from the book Pro EJB 3 : Java Persistence API.
> 
> For the following mapping from chapter 4 :
>   Employee (*) <------> (0..1) Department
> 
> I have the following annotation :
> 
> @Entity
> @Table( name="emp", schema="APP" )
> public class Employee {
> 
> 	@ManyToOne
> 	@JoinColumn( name="dept_id" )
> 	private Department department;
> 
> 	[...]
> }
> 
> @Entity
> @Table( name="dept", schema="APP" )
> public class Department {
> 
> 	@OneToMany( mappedBy="department" )
> 	private Collection<Employee> employees;
> 
> 	[...]
> }
> 
> Tables are created before-hand with an sql script executed from ij as  
> shown in the derby_db_creation.txt file attached.
> 
> ij version 10.5
> ij> connect 'jdbc:derby:EmpServDB;create=true;';
> ij> run 'initDB.sql';
> ij> --DROP TABLE dept;
> --DROP TABLE emp;
> --DROP TABLE parking_space;
> --DROP TABLE id_gen;
> 
> CREATE TABLE dept (
>     id INTEGER,
>     name VARCHAR(40),
>     CONSTRAINT pk_dept
>         PRIMARY KEY (id)
> );
> 0 rows inserted/updated/deleted
> ij> INSERT INTO dept(id,name) VALUES (0,'Board');
> 1 row inserted/updated/deleted
> ij> INSERT INTO dept(id,name) VALUES (1,'Administration');
> 1 row inserted/updated/deleted
> ij> INSERT INTO dept(id,name) VALUES (2,'Sales');
> 1 row inserted/updated/deleted
> ij> INSERT INTO dept(id,name) VALUES (3,'PreSales');
> 1 row inserted/updated/deleted
> ij> INSERT INTO dept(id,name) VALUES (4,'Services');
> 1 row inserted/updated/deleted
> ij> INSERT INTO dept(id,name) VALUES (5,'Product');
> 1 row inserted/updated/deleted
> ij> CREATE TABLE emp (
>     id INTEGER,
>     name  VARCHAR(50),
>     dob DATE,
>     s_date DATE,
>     type VARCHAR(40),
>     sal INTEGER,
>     comm VARCHAR(140),
>     dept_id INTEGER,
>     pspace_id INTEGER,
>     CONSTRAINT pk_emp
>         PRIMARY KEY (id)
> );
> 0 rows inserted/updated/deleted
> ij> INSERT INTO emp(id,name,dept_id) VALUES (0,'john doe 1',0);
> 1 row inserted/updated/deleted
> ij> INSERT INTO emp(id,name,dept_id) VALUES (1,'john doe 2',4);
> 1 row inserted/updated/deleted
> ij> INSERT INTO emp(id,name,dept_id) VALUES (2,'john doe 3',5);
> 1 row inserted/updated/deleted
> ij> INSERT INTO emp(id,name,dept_id) VALUES (3,'john doe 4',3);
> 1 row inserted/updated/deleted
> ij> INSERT INTO emp(id,name,dept_id) VALUES (4,'john doe 5',2);
> 1 row inserted/updated/deleted
> ij> INSERT INTO emp(id,name,dept_id) VALUES (5,'john doe 6',1);
> 1 row inserted/updated/deleted
> ij> CREATE TABLE parking_space (
>     id INTEGER,
>     lot INTEGER,
>     location VARCHAR(12),
>     CONSTRAINT pk_parking_space
>         PRIMARY KEY (id)
> );
> 0 rows inserted/updated/deleted
> ij> CREATE TABLE id_gen (
>     gen_name VARCHAR(80),
>     gen_val INTEGER,
>     CONSTRAINT pk_id_gen
>         PRIMARY KEY (gen_name)
> );
> 0 rows inserted/updated/deleted
> ij> INSERT INTO id_gen (gen_name, gen_val) VALUES ('Dep_Gen', 5);
> 1 row inserted/updated/deleted
> ij> INSERT INTO id_gen (gen_name, gen_val) VALUES ('Emp_Gen', 5);
> 1 row inserted/updated/deleted
> ij> INSERT INTO id_gen (gen_name, gen_val) VALUES ('PSpace_Gen', 0);
> 1 row inserted/updated/deleted
> ij> select * from dept;
> ID         |NAME                                    
> ----------------------------------------------------
> 0          |Board                                   
> 1          |Administration                          
> 2          |Sales                                   
> 3          |PreSales                                
> 4          |Services                                
> 5          |Product                                 
> 
> 6 rows selected
> ij>
> 
> 
> 
> The Many-to-one mapping from Employee to Department works fine but  
> then the inverse relationship does not work correctly : the JPA  
> provider ( toplink ) complains that it can't find the table APP.DEPT  
> as shown in the attached file exception_stack_trace.txt
> 
> [TopLink Warning]: 2009.08.01
> 06:04:42.094--ServerSession(962420767)--Ignoring LAZY fetch type on
> element [private java.lang.String org.cocogeo.jpa.Employee.comments]
> within entity class [class org.cocogeo.jpa.Employee]. All basic mappings
> default to use EAGER fetching.
> [TopLink Info]: 2009.08.01
> 06:04:42.496--ServerSession(962420767)--TopLink, version: Oracle TopLink
> Essentials - 2.0 (Build b41-beta2 (03/30/2007))
> [TopLink Info]: 2009.08.01
> 06:04:43.291--ServerSession(962420767)--file:/Users/brieucd/Projects/JPATutorial/out/production/JPATutorial/-EmployeeService
> login successful
> [TopLink Warning]: 2009.08.01
> 06:04:43.527--UnitOfWork(1034330964)--Exception [TOPLINK-4002] (Oracle
> TopLink Essentials - 2.0 (Build b41-beta2 (03/30/2007))):
> oracle.toplink.essentials.exceptions.DatabaseException
> Internal Exception: java.sql.SQLSyntaxErrorException: Table/View
> 'APP.DEPT' does not exist.
> Error Code: 30000
> Call: SELECT id, name FROM APP.dept WHERE (id = ?)
> 	bind => [0]
> Query: ReadObjectQuery(org.cocogeo.jpa.Department)
> Exception in thread "main" Local Exception Stack: 
> Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.0 (Build b41-beta2
> (03/30/2007))): oracle.toplink.essentials.exceptions.DatabaseException
> Internal Exception: java.sql.SQLSyntaxErrorException: Table/View
> 'APP.DEPT' does not exist.
> Error Code: 30000
> Call: SELECT id, name FROM APP.dept WHERE (id = ?)
> 	bind => [0]
> Query: ReadObjectQuery(org.cocogeo.jpa.Department)
> 	at
> oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:304)
> 	at
> oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:551)
> 	at
> oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:437)
> 	at
> oracle.toplink.essentials.threetier.ServerSession.executeCall(ServerSession.java:465)
> 	at
> oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:213)
> 	at
> oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:199)
> 	at
> oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.selectOneRow(DatasourceCallQueryMechanism.java:620)
> 	at
> oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectOneRowFromTable(ExpressionQueryMechanism.java:2277)
> 	at
> oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectOneRow(ExpressionQueryMechanism.java:2252)
> 	at
> oracle.toplink.essentials.queryframework.ReadObjectQuery.executeObjectLevelReadQuery(ReadObjectQuery.java:350)
> 	at
> oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:709)
> 	at
> oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:609)
> 	at
> oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:677)
> 	at
> oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:731)
> 	at
> oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2219)
> 	at
> oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:937)
> 	at
> oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:894)
> 	at
> oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerImpl.findInternal(EntityManagerImpl.java:323)
> 	at
> oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerImpl.findInternal(EntityManagerImpl.java:299)
> 	at
> oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerImpl.find(EntityManagerImpl.java:133)
> 	at DepartmentTest.main(DepartmentTest.java:24)
> Caused by: java.sql.SQLSyntaxErrorException: Table/View 'APP.DEPT' does
> not exist.
> 	at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown
> Source)
> 	at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
> 	at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
> Source)
> 	at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
> Source)
> 	at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown
> Source)
> 	at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown
> Source)
> 	at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown
> Source)
> 	at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown
> Source)
> 	at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown
> Source)
> 	at org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown
> Source)
> 	at org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown
> Source)
> 	at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown
> Source)
> 	at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown
> Source)
> 	at
> oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1147)
> 	at
> oracle.toplink.essentials.internal.databaseaccess.DatabaseCall.prepareStatement(DatabaseCall.java:597)
> 	at
> oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:470)
> 	... 19 more
> Caused by: java.sql.SQLException: Table/View 'APP.DEPT' does not exist.
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
> Source)
> 	at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
> Source)
> 	... 35 more
> Caused by: ERROR 42X05: Table/View 'APP.DEPT' does not exist.
> 	at org.apache.derby.iapi.error.StandardException.newException(Unknown
> Source)
> 	at
> org.apache.derby.impl.sql.compile.FromBaseTable.bindTableDescriptor(Unknown
> Source)
> 	at
> org.apache.derby.impl.sql.compile.FromBaseTable.bindNonVTITables(Unknown
> Source)
> 	at org.apache.derby.impl.sql.compile.FromList.bindTables(Unknown Source)
> 	at org.apache.derby.impl.sql.compile.SelectNode.bindNonVTITables(Unknown
> Source)
> 	at org.apache.derby.impl.sql.compile.DMLStatementNode.bindTables(Unknown
> Source)
> 	at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown
> Source)
> 	at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown
> Source)
> 	at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
> 	at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
> 	at
> org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown
> Source)
> 	... 29 more
> 
> 
> 
> 
> I check with another JPA provider ( OpenJPA ) and got the same problem  
> as shown in openJPA_exception.txt
> 
> 6858  EmployeeService  WARN   [main] openjpa.Enhance - The field comments
> in type org.cocogeo.jpa.Employee is configured to be lazily loaded, but
> lazy loading is not available for classes that use fieldaccess when not
> running the OpenJPA enhancer or when dynamic class redefinition is not
> available.
> Exception in thread "main" <openjpa-1.2.0-r422266:683325 nonfatal general
> error> org.apache.openjpa.persistence.PersistenceException: Table/View
> 'APP.DEPT' does not exist. {SELECT t0.name FROM APP.dept t0 WHERE t0.id =
> ?} [code=30000, state=42X05]
> 	at
> org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4238)
> 	at
> org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4203)
> 	at
> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:102)
> 	at
> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:88)
> 	at
> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:64)
> 	at
> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initialize(JDBCStoreManager.java:282)
> 	at
> org.apache.openjpa.kernel.DelegatingStoreManager.initialize(DelegatingStoreManager.java:111)
> 	at
> org.apache.openjpa.kernel.ROPStoreManager.initialize(ROPStoreManager.java:57)
> 	at org.apache.openjpa.kernel.BrokerImpl.initialize(BrokerImpl.java:894)
> 	at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:852)
> 	at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:769)
> 	at
> org.apache.openjpa.kernel.DelegatingBroker.find(DelegatingBroker.java:183)
> 	at
> org.apache.openjpa.persistence.EntityManagerImpl.find(EntityManagerImpl.java:452)
> 	at DepartmentTest.main(DepartmentTest.java:24)
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Table/View
> 'APP.DEPT' does not exist. {SELECT t0.name FROM APP.dept t0 WHERE t0.id =
> ?} [code=30000, state=42X05]
> 	at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:201)
> 	at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:57)
> 	at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:228)
> 	at
> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:164)
> 	at
> org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:140)
> 	at
> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:164)
> 	at
> org.apache.openjpa.jdbc.kernel.JDBCStoreManager$RefCountConnection.prepareStatement(JDBCStoreManager.java:1449)
> 	at
> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:153)
> 	at
> org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:525)
> 	at
> org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:485)
> 	at
> org.apache.openjpa.jdbc.sql.SelectImpl.prepareStatement(SelectImpl.java:463)
> 	at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:379)
> 	at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:325)
> 	at
> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.getInitializeStateResult(JDBCStoreManager.java:441)
> 	at
> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initializeState(JDBCStoreManager.java:321)
> 	at
> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initialize(JDBCStoreManager.java:277)
> 	... 8 more
> NestedThrowables:
> java.sql.SQLSyntaxErrorException: Table/View 'APP.DEPT' does not exist.
> 	at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown
> Source)
> 	at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
> 	at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
> Source)
> 	at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
> Source)
> 	at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown
> Source)
> 	at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown
> Source)
> 	at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown
> Source)
> 	at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown
> Source)
> 	at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown
> Source)
> 	at org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown
> Source)
> 	at org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown
> Source)
> 	at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown
> Source)
> 	at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown
> Source)
> 	at
> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:166)
> 	at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:225)
> 	at
> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:164)
> 	at
> org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:140)
> 	at
> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:164)
> 	at
> org.apache.openjpa.jdbc.kernel.JDBCStoreManager$RefCountConnection.prepareStatement(JDBCStoreManager.java:1449)
> 	at
> org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:153)
> 	at
> org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:525)
> 	at
> org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:485)
> 	at
> org.apache.openjpa.jdbc.sql.SelectImpl.prepareStatement(SelectImpl.java:463)
> 	at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:379)
> 	at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:325)
> 	at
> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.getInitializeStateResult(JDBCStoreManager.java:441)
> 	at
> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initializeState(JDBCStoreManager.java:321)
> 	at
> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initialize(JDBCStoreManager.java:277)
> 	at
> org.apache.openjpa.kernel.DelegatingStoreManager.initialize(DelegatingStoreManager.java:111)
> 	at
> org.apache.openjpa.kernel.ROPStoreManager.initialize(ROPStoreManager.java:57)
> 	at org.apache.openjpa.kernel.BrokerImpl.initialize(BrokerImpl.java:894)
> 	at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:852)
> 	at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:769)
> 	at
> org.apache.openjpa.kernel.DelegatingBroker.find(DelegatingBroker.java:183)
> 	at
> org.apache.openjpa.persistence.EntityManagerImpl.find(EntityManagerImpl.java:452)
> 	at DepartmentTest.main(DepartmentTest.java:24)
> Caused by: java.sql.SQLException: Table/View 'APP.DEPT' does not exist.
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
> Source)
> 	at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
> Source)
> 	... 36 more
> Caused by: ERROR 42X05: Table/View 'APP.DEPT' does not exist.
> 	at org.apache.derby.iapi.error.StandardException.newException(Unknown
> Source)
> 	at
> org.apache.derby.impl.sql.compile.FromBaseTable.bindTableDescriptor(Unknown
> Source)
> 	at
> org.apache.derby.impl.sql.compile.FromBaseTable.bindNonVTITables(Unknown
> Source)
> 	at org.apache.derby.impl.sql.compile.FromList.bindTables(Unknown Source)
> 	at org.apache.derby.impl.sql.compile.SelectNode.bindNonVTITables(Unknown
> Source)
> 	at org.apache.derby.impl.sql.compile.DMLStatementNode.bindTables(Unknown
> Source)
> 	at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown
> Source)
> 	at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown
> Source)
> 	at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
> 	at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
> 	at
> org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown
> Source)
> 	... 30 more
> 
> Process finished with exit code 1
> 
> 
> 
> 
> I did some more tests using another DB ( MySQL ) to verify my  
> annotations and tables.
> I created the tables in MySQL using the same script and run the same  
> test with both toplink and openJPA as JPA providers ( I had to remove  
> the schema attribue of the @Table annotation which is required for  
> Derby ) and everthing works fine.
> 
> I've also attached my persistence.xml file
> 
> <?xml version="1.0" encoding="UTF-8"?>
> <persistence xmlns="http://java.sun.com/xml/ns/persistence" version="1.0">
> 
>   <persistence-unit name="EmployeeService"
> transaction-type="RESOURCE_LOCAL">
>     <class>org.cocogeo.jpa.Department</class>
>     <class>org.cocogeo.jpa.Employee</class>
>     <class>org.cocogeo.jpa.ParkingSpace</class>
>     <properties>
>       <!-- MySQL + Toplink -->
>       <property name="toplink.jdbc.driver" value="com.mysql.jdbc.Driver"/>
>       <property name="toplink.jdbc.url"
> value="jdbc:mysql://localhost:3306/EmpServDB"/>
>       <property name="toplink.jdbc.user" value="root"/>
>       <property name="toplink.jdbc.password" value=""/>
>       <property name="toplink.logging.level" value="INFO"/>
> 
>       <!-- MySQL + OpenJPA -->
>       <!--<property name="openjpa.ConnectionURL"
> value="jdbc:mysql://localhost:3306/EmpServDB"/>-->
>       <!--<property name="openjpa.ConnectionDriverName"
> value="com.mysql.jdbc.Driver"/>-->
>       <!--<property name="openjpa.ConnectionUserName" value="root"/>-->
>       <!--<property name="openjpa.ConnectionPassword" value=""/>-->
>       <!--<property name="openjpa.Log" value="DefaultLevel=WARN,
> Tool=INFO"/>-->
> 
>       <!-- Derby + Toplink -->
>       <!--<property name="toplink.jdbc.driver"
> value="org.apache.derby.jdbc.EmbeddedDriver"/>-->
>       <!--<property name="toplink.jdbc.url"
> value="jdbc:derby:EmpServDB"/>-->
>       <!--<property name="toplink.jdbc.user" value="APP"/>-->
>       <!--<property name="toplink.jdbc.password" value="APP"/>-->
>       <!--<property name="toplink.logging.level" value="INFO"/>-->
> 
>       <!-- Derby + OpenJPA -->
>       <!--<property name="openjpa.ConnectionURL"
> value="jdbc:derby:EmpServDB"/>-->
>       <!--<property name="openjpa.ConnectionDriverName"
> value="org.apache.derby.jdbc.EmbeddedDriver"/>-->
>       <!--<property name="openjpa.ConnectionUserName" value="APP"/>-->
>       <!--<property name="openjpa.ConnectionPassword" value="APP"/>-->
>       <!--<property name="openjpa.Log" value="DefaultLevel=WARN,
> Tool=INFO"/>-->
> 
>     </properties>
>   </persistence-unit>
> </persistence>
> 
> 
> 
> Thanks for your help.
> 
> Regards
> 
> Brieuc
> 
> 
> 
> 
> 
> 

-- 
View this message in context: http://old.nabble.com/Bug-%3A-Derby-table-invisible-from-JPA-provider-tp24770995p26298426.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.


Mime
View raw message