You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-user@db.apache.org by servetkarabas <se...@uekae.tubitak.gov.tr> on 2009/11/11 10:32:46 UTC
Re: Bug : Derby table invisible from JPA provider
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.