posted 19 years ago
Hi all,
I am using BEA weblogic8.1 app server .
i have a Session bean deployed with container managed transaction .
the Transaction Attribute ofthe bean is "REQUIRED" and the Transaction type is Container Managed Transaction .
i am using Oracle9i Database with oracle.jdbc.xa.client.OracleXADataSource driver .
Now the problem is that i have about 2,50,000 records in a flat file which I want to INSERT in an ORACLE9i TABLE , but it roles back when i want to insert the records more than 4,500 , after it reads and finaly wants to commit .
if the flat file contains 4500 records it works fine and commits in the database ,but when i incrase the size of the data in the flatfile it fils to commit and transaction roles back.
Although i have changed the JTA Timeout Seconds: from 300 to 600 seconds but within 2 minutes even it roles back after trying to commit (may be the data size is too big for one commit) .
is there any way that i can control the Commit behaviour of weblogic8.1 using container managed Transaction ?
I tried to commit using UserTransaction every 4000 records but still it throws "javax.transaction.xa.XAException" saying that i cannot use the local transaction with XA driver .
Is there any way that for a perticular bean i can controll the transaction so that after every 1000 or 2000 records it automatically commits the transaction or let me allow to do the same with XADrivers .
thanks in advance ,
Anurag.
Anurag priya
SCJP 2(83%); Brain Bench Certified for: Masters level EJB2.0(97%) - Masters level J2EE (83%) - BEA-WebLogic Application Server8.1 (86% )