XADataSource

[sameer_inn]

I am using jboss3.2.0 and OracleXaDataSource for configuring Oracke8i under
jdk1.3.1

i want to run local transaction.

i have written a small MBean and written an update statement.

DataSource ds=(javax.sql.DataSource) lContext.lookup("java:/OracleDS");
Connection con=ds.getConnection();
con.setAutoCommit(false);
Statement stmt=con.createStatement();
stmt.executeUpdate("insert into employee values('E1','asad')");
con.commit();


when i run this applications the server throws
java.sql.SQLException: Use explicit XA call.


but when i run the same application
under jdk1.4.1 and OracleXADataSource for oracle9i it's runnining fine
without error

could u help me out?

[davidjencks]

With this much info I'd guess there is a bug in the Oracle 8i driver.

[skely76]

Could you please tell me which version of Oracle Driver you're using. I'm also facing a similar problem... I'm not able to get a connection object through XA datasource.. I've posted a new Subject in the following link: http://www.jboss.org/modules/bb/index.html?module=bb&op=viewtopic&t= you've got around this problem, you might be able to help me out. Thanks.

regards,
Skely