Thank you
I cleared the problem by setting the auto commit back to false before closing the connection and it worked and the RollBack exception is now no more.
Yet the follwing message is still there:
ConnectionFac I J2CA0122I: Resource reference jdbc/dsOraXA could not be located, so default values of the following are used: [Resource-ref settings]
res-auth: 1 (APPLICATION)
res-isolation-level: 0 (TRANSACTION_NONE)
res-sharing-scope: true (SHAREABLE)
res-resolution-control: 999 (undefined)
[Other attributes]
isCMP1_x: false (not CMP1.x)
isJMS: false (not JMS)
I read the IBM link
http://publib.boulder.ibm.com/infocenter/wsphelp/index.jsp?topic=/com.ibm.websphere.nd.doc/info/ae/ae/rdat_jnditips.html Does it mean that while using a user specified JNDI name to look up the
data source such message can be expected?
is there any way to suppress this log message?
I'm using the JNDI name as jdbc/dsOraXA, and calling this like
javax.sql.DataSource DSN =(javax.sql.DataSource) initialContext.lookup("jdbc/dsOraXA");
I also tried
javax.sql.DataSource DSN =(javax.sql.DataSource) initialContext.lookup("java:comp/env/jdbc/dsOraXA");
But both failed!!. The latter gave me a Name not found Exception!
Thanks for any help
Pious