FMJDBC & batch

[erik13]

Hello everyone,

I'm working on a java project which have to get informations from text files and have to save them in a Filemaker database.

For this, I use Batch in a Statement. There is no problem at the beginning... I create a statement from the connection then i create batch but when I try to execute the batch, the Exception "com.filemaker.jdbc.FMSQLException: [FileMaker][FileMaker JDBC] Batch entry stopped." is thrown.

So who can help me please?

This is a part of the code:

try{

      if(current_statement==null) this.current_statement =   connection.createStatement();

      con.setAutoCommit(false);

      this.current_statement.addBatch("INSERT INTO Lot (contenu__t) VALUES('140a')");

     this.current_statement.executeBatch();

     this.connection.commit();

}

catch(Exception e){

     e.printStackTrace();

}

Thanks,

Eric

[erik13]

I found what's happen...

When you have a SQL Error, the batch didn't accept your query :