This week's book giveaways are in the iOS and Features new in Java 8 forums. We're giving away four copies each of Barcodes with iOS: Bringing together the digital and physical worlds and Core Java for the Impatient and have the authors on-line! See this thread and this one 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 ]