Inserting 23000 records
[nobr]I was wondering if there was a better way to do this than i'm doing here is my code:
String strSQL ="";
while(objDBFReader.hasNextRecord())
{
Object[] objRecords = objDBFReader.nextRecord();
if(!containsString(strProvinces, objRecords[0].toString()))
strProvinces.add(objRecords[0].toString());
if(!containsString(strYears, objRecords[2].toString()))
strYears.add(objRecords[2].toString());
try
{
strSQL ="INSERT INTO CROP_CENSUS30 VALUES('";
strSQL += objRecords[0]+"' ,"+objRecords[1]+", ";
strSQL += objRecords[2]+", '"+objRecords[3]+"', ";
for(int x = 4; x < objRecords.length; x++)
{
if(objRecords[x] !=null && !objRecords[x].toString().equals(""))
strSQL +=objRecords[x]+" ,";
else
strSQL +="'' ,";
}
strSQL=strSQL.substring(0,strSQL.length()-2);
strSQL +=")";
objStatement.addBatch(strSQL);
}
catch(Exception e2)
{
out.println("<fieldset>Error Processing Record:"+intRecords+"<br/> Error Message: "+e2.getMessage()+"<br /> SQL Statement: <br/>"+strSQL+"</fieldset>");
}
intRecords++;
}
objDBFReader.close();
objDBFReader =null;
out.println("Inserting "+intRecords+" into CROP_CENSUS30 ...");
out.flush();
objStatement.executeBatch();
[/nobr]
