Hi, My guess is that the SQL generation should not be different between JTA and RESOURCE_LOCAL.
Can you please add default trace level logging to both the scenarios and attach the logs here. That way we can compare between both scenarios and find if there are any differences in the properties between JTA and RESOURCE_LOCAL. You may already know, adding "<property name="openjpa.Log" value="DefaultLevel=TRACE"/>" to persistence.xml will set the logging level to trace. Regards, Ravi. brobbsnet wrote: > > please my project runs ok and generate all Sql statements under > RESOURCE_LOCAL persistence.xml. when i change to run in the container > using JTA , it does not generate the same number on sql statements causing > the application to throw exceptions. > > for example when i run a test under RESOURCE_LOCAL, it prints out this two > sql statements as follows. > > 1. TRACE [main] openjpa.jdbc.SQL - <t 1981891711, conn 35138160> > executing prepstmnt 1171248050 SELECT t0.PRSN_ID, > t1.CUSTOMER_ID,.......................etc......... > TRACE [main] openjpa.jdbc.SQL - <t 1981891711, conn 35138160> [16 ms] > spent > > 2. ChampAppEJBPU TRACE [main] openjpa.jdbc.SQL - <t 1981891711, conn > 596825604> executing prepstmnt 1703379623 SELECT t0.INVOICE_ID, > t0.EST_WAIVER, ........................................etc.... > > The same persistence.xml setup on the server using JTA and XA datasource > only prints out one statement. > > TRACE [main] openjpa.jdbc.SQL - <t 1981891711, conn 35138160> executing > prepstmnt 1171248050 SELECT t0.PRSN_ID, > t1.CUSTOMER_ID,.......................etc......... > > This results in the data from the second sql missing to the application. > > clearly something is wrong. I am using WASCE (websphere community edition > Version 2.1.1.2) and Apache Derby database. Is there something in the JTA > configuration that i am missing ? > > Any thoughts will be appreciated. > > > -- View this message in context: http://n2.nabble.com/inconsistent-SQL%27s-RESOURCE_LOCAL-Vrs-JTA-tp3331934p3336665.html Sent from the OpenJPA Users mailing list archive at Nabble.com.
