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 ]