getting batchupdate exception while inserting recored for second time...

[Ganeshkumar cheekati]

this is code i wrote ..to connect to database and also getting filename,filedate and filesize from one folder but if i am trying to insert same records again then i am getting the error as

Statements that produce resultsets are not allowed in batch comments...

    
import java.sql.*;
import java.io.*;
import java.util.Properties;
import java.text.SimpleDateFormat;
public class DatabaseConnection{

  public static void main(String[] args)  {

	String url ="";
	String driver = "";
    String userName = "";
    String password = "";
    Connection conn = null;
	String sFileName="";
	String sPath="";
	
	

	CallableStatement oCallableStatement = null;
		
	ResultSet oResultSet=null;


	Properties props = new Properties();
	try{
		props.load(new FileInputStream("properties/db.properties"));
		url =props.getProperty("db.url");
		driver = props.getProperty("db.driver");
    	userName = props.getProperty("db.username");
     	password = props.getProperty("db.password");
		sPath=props.getProperty("db.path");
    
    System.out.println(url);
	System.out.println(driver);
	System.out.println(userName);
	System.out.println(password);
	System.out.println(sPath);
	}
	catch(Exception e)
	  {
		e.printStackTrace();
	  }


	try {
      	Class.forName(driver).newInstance();
      	conn = DriverManager.getConnection(url,userName,password);
      	System.out.println("Connected to the database"+conn);

	oCallableStatement = conn.prepareCall("{call procedurename..(?,?,?)}"); 
		 
	System.out.println("after procedure call..........");
	String sFileSize="";
	String sFinalName="";
	String formattedDate="";

    	File folder = new File(sPath);
    	File[] listOfFiles = folder.listFiles();

    	for (int i = 0; i < listOfFiles.length; i++) {

			if(listOfFiles[i].isFile())
			{
     
	sFileName=listOfFiles[i].getName();
	sFileSize=listOfFiles[i].length()/1024+"KB";

	System.out.println("File " + sFileName);
	System.out.println("File size" + listOfFiles[i].length()/1024+"KB");
	SimpleDateFormat formatter = new SimpleDateFormat("dd MMMM yyyy 	hh:mm:ss");
	formattedDate = formatter.format(listOfFiles[i].lastModified());
	System.out.println("dd-MMM-yyyy date is ==>"+formattedDate);
	//sFinalName=sFileName+"~"+formattedDate+"~"+sFileSize+"";
	//sFinalName="<next>"+sFinalName;
   	 //System.out.println("input to that procedure is..."+sFinalName);
			
	conn.setAutoCommit(false);

      		
	oCallableStatement.setString(1,sFileName);
	oCallableStatement.setString(2,formattedDate);
	oCallableStatement.setString(3,sFileSize);
	System.out.println("after setting parameters....");
	oCallableStatement.addBatch();
	System.out.println("after adding to batch...");
			}
	}

	System.out.println("b4 exe batch");
	int[] iNoRows = oCallableStatement.executeBatch();
	conn.commit();
    conn.setAutoCommit(true);
	    
	System.out.println("records inserted...? >>>>  "+ iNoRows.length);
	System.out.println("after exe batch");
	conn.close();
      	System.out.println("Disconnected from database");
    	}
		catch(BatchUpdateException b) {
      System.err.println("-----BatchUpdateException-----");
      System.err.println("SQLState:  " + b.getSQLState());
      System.err.println("Message:  " + b.getMessage());
      System.err.println("Vendor:  " + b.getErrorCode());
      System.err.print("Update counts:  ");
      int [] updateCounts = b.getUpdateCounts();
      for (int i = 0; i < updateCounts.length; i++) {
        System.err.print(updateCounts[i] + "   ");
      }
      System.err.println("");

    } catch(SQLException ex) {
      System.err.println("-----SQLException-----");
      System.err.println("SQLState:  " + ex.getSQLState());
      System.err.println("Message:  " + ex.getMessage());
      System.err.println("Vendor:  " + ex.getErrorCode());
    }

		
		
		
		
		catch (Exception e) {
      	e.printStackTrace();
   	}
	finally {
      	if (oCallableStatement != null) {
				try {
					
					oCallableStatement.close();
				} catch (SQLException sqle) {
					System.out.println(sqle.getMessage());

				}
				oCallableStatement = null;
			}
        	if (oResultSet != null) {
				try {
					
					oResultSet.close();
				} catch (SQLException sqle) {
					System.out.println(sqle.getMessage());

				}
				oResultSet = null;
			}
        	if (conn != null) {
				try {
					conn.close();
				} catch (SQLException sqle) {
					System.out.println(sqle.getMessage());
				}
				conn = null;
			}      
      }
    }
  }

  

can anyone help me?

[Michael Angstadt]

What does the stored procedure do? It looks like it's trying to return data via a SELECT statement, and that JDBC has a problem with that.

Also, you should use foreach loops. For example:

for (File file : listOfFiles) {  
  if(file.isFile()){
    //...
  }
}

And you should move the SimpleDateFormat object outside of the for loop because otherwise, you're creating it over and over again. Ditto for the setAutoCommit(false) line.