Hi Rajeev, The product version in trace looked good. Now, have you followed the example in (openjpa-persistence-jdbc/src/test/java folder), the java source ? org.apache.openjpa.persistence.jdbc.TestIsolationLevelOverride
Could you give it a try ? We were able to get correct SQL generation using DB2/NT SQL09050 (v9.5) I do not see why it would fail with DB2/LINUXX8664 SQL09050 . I can take a look at your testcase if you can send it to me. Catalina On Fri, Mar 28, 2008 at 2:45 AM, Rajeev Jha <[EMAIL PROTECTED]> wrote: > Hello catalina > > I have pasted the trace from my environment. Please let me know if you > need more info. I can work around the issue by setting isolation > levels directly in DB2 session but this is one feature i want to use. > > Thanks > > - rajeev. > > ================================================================================ > INFO [main] openjpa.jdbc.JDBC - Using dictionary class > "org.apache.openjpa.jdbc.sql.DB2Dictionary" (DB2/LINUXX8664 SQL09050 > ,IBM DB2 JDBC Universal Driver Architecture 3.2.49). > 1954 vwc.model TRACE [main] openjpa.jdbc.JDBC - catalogSeparator: . > catalogTerm: null > databaseProductName: DB2/LINUXX8664 > databaseProductVersion: SQL09050 > driverName: IBM DB2 JDBC Universal Driver Architecture > driverVersion: 3.2.49 > > > =================================================================================== > > > On Fri, Mar 28, 2008 at 4:12 AM, catalina wei <[EMAIL PROTECTED]> > wrote: > > Hi Rajeev, > > Do you have trace info about your databaseProductName and > > databaseProductVersion for DB2 v9.5? > > Could you send that to me? It will help in diagnosing the problem. > > > > I am running DB2 v9.1, I have this in trace: > > > > databaseProductName: DB2/NT > > databaseProductVersion: SQL09010 > > driverName: IBM DB2 JDBC Universal Driver Architecture > > ... > > > > > > Catalina Wei > > >
