5 Replies Latest reply: Aug 10, 2012 9:49 AM by david.karr RSS

    Getting OracleXAException for "select 1 from dual"

      I have an app that utilizes several datasources, all on Oracle. I just added another datasource today whose associated database is configured a little differently than the others, but that may be irrelevant. I changed the app to use the new datasource, and it appears to be working fine.

      However, I'm now seeing lines like the following in my log:

      <2-Aug-2012 2:02:14 o'clock PM PDT> <Error> <JDBC> <BEA-001112> <Test "SELECT 1 FROM DUAL" set up for pool "newds" failed with exception: "oracle.jdbc.xa.OracleXAException".>

      I tried turning on all the obvious Weblogic debugging flags with JDBC in the name, but I didn't see any additional information in the log around this error.

      What can I do to get more information about this?