Unfortunately, this code does not give me much clues about what is going wrong. However, the code can definately be improved a lot.
- The pstmt should be prepared outside the loop. The ide about prepared statements is to prepare them once, then reuse them. Your code is a prefect example, but doesn't use the trick. You should see a speed improvement because of this. - you have a finally block which closes the pstmt and the connection. Good. But then you should not close them beforehand. You are goind to close them twice. Next question is how you get your connection? You call a helper method, but that code is not shown. Joachim View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3822978#3822978 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3822978 ------------------------------------------------------- SF.Net is sponsored by: Speed Start Your Linux Apps Now. Build and deploy apps & Web services for Linux with a free DVD software kit from IBM. Click Now! http://ads.osdn.com/?ad_id=1356&alloc_id=3438&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
