Return-Path: Delivered-To: apmail-openjpa-dev-archive@www.apache.org Received: (qmail 25441 invoked from network); 24 Oct 2010 14:24:44 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 24 Oct 2010 14:24:44 -0000 Received: (qmail 6194 invoked by uid 500); 24 Oct 2010 14:24:44 -0000 Delivered-To: apmail-openjpa-dev-archive@openjpa.apache.org Received: (qmail 6025 invoked by uid 500); 24 Oct 2010 14:24:41 -0000 Mailing-List: contact dev-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@openjpa.apache.org Delivered-To: mailing list dev@openjpa.apache.org Received: (qmail 6017 invoked by uid 99); 24 Oct 2010 14:24:40 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 24 Oct 2010 14:24:40 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.22] (HELO thor.apache.org) (140.211.11.22) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 24 Oct 2010 14:24:40 +0000 Received: from thor (localhost [127.0.0.1]) by thor.apache.org (8.13.8+Sun/8.13.8) with ESMTP id o9OEOJw6025940 for ; Sun, 24 Oct 2010 14:24:19 GMT Message-ID: <985290.47731287930259060.JavaMail.jira@thor> Date: Sun, 24 Oct 2010 10:24:19 -0400 (EDT) From: "Jeremy Bauer (JIRA)" To: dev@openjpa.apache.org Subject: [jira] Assigned: (OPENJPA-1853) iSeries DB2 problem with using @GeneratedValue(strategy=GenerationType.IDENTITY) In-Reply-To: <2637556.46931287916046949.JavaMail.jira@thor> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/OPENJPA-1853?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jeremy Bauer reassigned OPENJPA-1853: ------------------------------------- Assignee: Jeremy Bauer > iSeries DB2 problem with using @GeneratedValue(strategy=GenerationType.IDENTITY) > -------------------------------------------------------------------------------- > > Key: OPENJPA-1853 > URL: https://issues.apache.org/jira/browse/OPENJPA-1853 > Project: OpenJPA > Issue Type: Bug > Components: sql > Affects Versions: 2.0.0, 2.0.1 > Environment: DB2 on IBM iSeries V5R4, jt400.jar (JTOpen) > Reporter: Andreas Tomik > Assignee: Jeremy Bauer > Priority: Critical > > I get the following error when I try to insert new row to a table that has a "generated always Identity" Column. > Exception in thread "main" org.apache.openjpa.persistence.RollbackException: An error occurred attempting to invoke JDBC 3 method. Your driver or database may not support JDBC 3 features. > at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:584) > at de.meyerwerft.qs.laborpruef.laborprobe.dbaccess.LaborprobeBean.crtTest(LaborprobeBean.java:38) > at de.meyerwerft.test.JSE_Client.jlm_run(JSE_Client.java:35) > at de.meyerwerft.test.JSE_Client.(JSE_Client.java:10) > at de.meyerwerft.test.JSE_Client.main(JSE_Client.java:17) > Caused by: org.apache.openjpa.persistence.PersistenceException: An error occurred attempting to invoke JDBC 3 method. Your driver or database may not support JDBC 3 features. > at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1963) > at org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81) > at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1479) > at org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:925) > at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:560) > ... 4 more > Caused by: org.apache.commons.lang.exception.NestableRuntimeException: An error occurred attempting to invoke JDBC 3 method. Your driver or database may not support JDBC 3 features. > at org.apache.openjpa.lib.jdbc.DelegatingConnection.invokeJDBC3(DelegatingConnection.java:597) > at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:577) > at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:571) > at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:571) > at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:571) > at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:563) > at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.prepareStatement(PreparedStatementManagerImpl.java:287) > at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:112) > at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:81) > at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:99) > at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:87) > at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:550) > at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:106) > at org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:59) > at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:103) > at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:76) > at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:731) > at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131) > at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2139) > at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2037) > at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1955) > ... 8 more > Caused by: java.lang.reflect.InvocationTargetException > 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:597) > at org.apache.openjpa.lib.jdbc.DelegatingConnection.invokeJDBC3(DelegatingConnection.java:593) > ... 28 more > Caused by: java.sql.SQLException: The driver does not support this function. > at com.ibm.as400.access.JDError.throwSQLException(JDError.java:415) > at com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS400JDBCConnection.java:2210) > ... 33 more > I have the following in persistence.xml > ... > > > > ... > In Version 1.2.3 this function works fine. > Thank you, > Andreas Tomik -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.