This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
I need help in making the JDBC call in my code more efficient.
I have written XML parser to parse XML file to create appropriate Insert statment from the file.
In method endElement in testcalss I am making call to class InsertData.
Please see below for the code of InsertData.
Can someone help me to make this code efficient. I need to run each insert statement seperately so that even if one of the Insert fails the program continues. Is use of PrepareStatment OK or do I need to change this? If and how can I use Bind Variables here?
The program runs fine for smaller files but when the file size is huge (9MB ) the program is too slow or fails with memory issues.
[ May 23, 2005: Message edited by: Gemini Moses ]
[edited by Jeanne to add code tags] [ May 23, 2005: Message edited by: Jeanne Boyarsky ]