Hi all,
I have to read the content of a text file ( about 5000 lines ) for each of its
line i have to run some SELECT queries and in a certain case an INSERT or
UPDATE statement.
Well, i open one connection , i open a WHILE cycle to read the file content and
at the end of the WHILE i close the connection.
Using a connection from a pool of Jboss ( i use DB2) with setAutoCommit set to
TRUE everything works fine but the INSERT or UPDATE statements dont't go fine
and i don't get any error.
If i use a file with just 500 lines everything works fine.
I dont' know how to explain this case.
I tryed to get a connection directly e set the AUTOCOMMIT to false and before
closing the connection call the COMMIT method but i still get the same problem.
Is it a problem of DB2 which doesn't support a lot of statement in the same
transaction or what ?
Any suggestion ?
Cheers.
Stefano
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3914540#3914540
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3914540
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
JBoss-user mailing list
JBoss-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-user
