Hi, Jacek: Sometimes I do not have access to newsgroup :)
My persistence.xml file : <?xml version="1.0" encoding="UTF-8"?> <persistence version="1.0" xmlns="http://java.sun.com/xml/ns/persistence"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd";> <persistence-unit name="testPU" transaction-type="JTA"> <provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider> <jta-data-source>jdbc/Mysql</jta-data-source> <properties> <property name="openjpa.jdbc.SynchronizeMappings" value="buildSchema(SchemaAction='add,deleteTableContents')" /> <property name="openjpa.Log" value="DefaultLevel=TRACE,SQL=TRACE" /> </properties> </persistence-unit> </persistence> Exception : [#|2007-04-14T14:43:36.077+0200|INFO|sun-appserver9.1|javax.enterprise.system.container.ejb|_ThreadID=29;_ThreadName=p: thread-pool-1; w: 126;| javax.ejb.EJBException at com.sun.ejb.containers.BaseContainer.processSystemException(BaseContainer.java:3813) at com.sun.ejb.containers.BaseContainer.completeNewTx(BaseContainer.java:3713) at com.sun.ejb.containers.BaseContainer.postInvokeTx(BaseContainer.java:3515) at com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:1305) at com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:1267) at com.sun.ejb.containers.EJBObjectInvocationHandler.invoke(EJBObjectInvocationHandler.java:197) at com.sun.ejb.containers.EJBObjectInvocationHandlerDelegate.invoke(EJBObjectInvocationHandlerDelegate.java:64) at $Proxy112.deleteAllStart(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at com.sun.corba.ee.impl.presentation.rmi.ReflectiveTie._invoke(ReflectiveTie.java:125) at com.sun.corba.ee.impl.protocol.CorbaServerRequestDispatcherImpl.dispatchToServant(CorbaServerRequestDispatcherImpl.java:658) at com.sun.corba.ee.impl.protocol.CorbaServerRequestDispatcherImpl.dispatch(CorbaServerRequestDispatcherImpl.java:198) at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequestRequest(CorbaMessageMediatorImpl.java:1722) at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequest(CorbaMessageMediatorImpl.java:1582) at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleInput(CorbaMessageMediatorImpl.java:964) at com.sun.corba.ee.impl.protocol.giopmsgheaders.RequestMessage_1_2.callback(RequestMessage_1_2.java:179) at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequest(CorbaMessageMediatorImpl.java:734) at com.sun.corba.ee.impl.transport.SocketOrChannelConnectionImpl.dispatch(SocketOrChannelConnectionImpl.java:478) at com.sun.corba.ee.impl.transport.SocketOrChannelConnectionImpl.doWork(SocketOrChannelConnectionImpl.java:1360) at com.sun.corba.ee.impl.orbutil.threadpool.ThreadPoolImpl$WorkerThread.run(ThreadPoolImpl.java:509) Caused by: <0.9.7-incubating-SNAPSHOT nonfatal general error> org.apache.openjpa.persistence.PersistenceException: Table 'test.Operator' doesn't exist {p repstmnt 4201797 DELETE FROM Operator} [code=1146, state=42S02] FailedObject: [EMAIL PROTECTED] at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:3781) at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:94) at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:64) at org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeBulkOperation(JDBCStoreQuery.java:505) at org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeDelete(JDBCStoreQuery.java:420) at org.apache.openjpa.kernel.ExpressionStoreQuery$DataStoreExecutor.executeDelete(ExpressionStoreQuery.java:679) at org.apache.openjpa.kernel.QueryImpl.delete(QueryImpl.java:1000) at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:793) at org.apache.openjpa.kernel.QueryImpl.deleteAll(QueryImpl.java:858) at org.apache.openjpa.kernel.QueryImpl.deleteAll(QueryImpl.java:854) at org.apache.openjpa.kernel.DelegatingQuery.deleteAll(DelegatingQuery.java:538) at org.apache.openjpa.persistence.QueryImpl.executeUpdate(QueryImpl.java:301) at pl.jee.start.OperationFacadeBean.deleteEntities(OperationFacadeBean.java:159) at pl.jee.start.OperationFacadeBean.deleteAllStart(OperationFacadeBean.java:165) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at com.sun.enterprise.security.application.EJBSecurityManager.runMethod(EJBSecurityManager.java:1051) at com.sun.enterprise.security.SecurityUtil.invoke(SecurityUtil.java:165) at com.sun.ejb.containers.BaseContainer.invokeTargetBeanMethod(BaseContainer.java:2846) at com.sun.ejb.containers.BaseContainer.intercept(BaseContainer.java:3930) at com.sun.ejb.containers.EJBObjectInvocationHandler.invoke(EJBObjectInvocationHandler.java:190) ... 17 more Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Table 'test.Operator' doesn't exist {prepstmnt 4201797 DELETE FROM Operator} [code=1146, st ate=42S02] at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:188) at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$800(LoggingConnectionDecorator.java:53) at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:85 4) at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:266) at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1360) at org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeBulkOperation(JDBCStoreQuery.java:498) ... 36 more |#] Thanks for your help. regards -- View this message in context: http://www.nabble.com/%28No%29existing-table-in-SQL-server-tf3565587.html#a9962231 Sent from the open-jpa-dev mailing list archive at Nabble.com.
