Attn : Kyle - JTA Enabling in WAS 4.0.2(Urgent)

[kishore harindran]

I have deployed my application in IBM Websphere Application Server 4.0.2 advanced edition for multiplatforms.
My application consists of entity beans ,session beans , servelts,jsps and java beans.The transaction attribute of entity bean is 'REQUIRED' and transaction attribute of session bean is 'REQUIRES NEW'.we are following session facade design pattern.In my session bean,i am calling a method which is inside the java bean which uses database Connection from the oracle connection pool.
While i am accessing that method, it is giving
the following error:
"JTA is not enabled - Transaction Rollback"
and this error is pointing at method defined in Java bean.
How can i enable JTA in IBM Websphere Application Server 4.0.3 ?
Please help me out.
Regards
Kishore

[Kyle Brown]

Originally posted by kishore harindran:
I have deployed my application in IBM Websphere Application Server 4.0.2 advanced edition for multiplatforms.
My application consists of entity beans ,session beans , servelts,jsps and java beans.The transaction attribute of entity bean is 'REQUIRED' and transaction attribute of session bean is 'REQUIRES NEW'.we are following session facade design pattern.In my session bean,i am calling a method which is inside the java bean which uses database Connection from the oracle connection pool.
While i am accessing that method, it is giving
the following error:
"JTA is not enabled - Transaction Rollback"
and this error is pointing at method defined in Java bean.
How can i enable JTA in IBM Websphere Application Server 4.0.3 ?
Please help me out.
Regards
Kishore

OK, quick question -- when you say you are using the "Oracle connection pool". Are you looking up a DataSource defined in WebSphere from WebSphere's JNDI server, or are you using some Oracle-specific pooling API? If so, then it won't work. You must use the standard J2EE API to make transactions work in WebSphere.
Kyle

[kishore harindran]

Thanks for your reply.
For connection pooling, we are not using Oracle Specific connection API.we are getting connection from the Datasource defined in Websphere Application Server.We are using oracle thin driver for datasource whose implementation class for the same is :
"oracle.jdbc.pool.OracleConnectionPoolDataSource".
Awaiting ur reply.
Regards
Kishore

[Ravi Kumar Ravuru]

Hello Kyle,
Please reply for the above question...we are in need of it urgently.......Awaiting ur response.
Regards
Ravi

[Kyle Brown]

OK, you're using the wrong implementation class for 2PC. You need to use oracle.jdbc.xa.client.OracleXADataSource
instead. See The InfoCenter for more details.
Kyle