You better post your problem in firebird-support group. There you will get much faster response.

Doychin

--- In Firebird-Java@yahoogroups.com, Serge Bogatyrev <sergebogatyrjov@...> wrote:
>
> ...probably, attachments are not supported.
>
> -------------------------------------------------------------
> package error.sample.batch;
>
> import java.io.File;
> import java.sql.Connection;
> import java.sql.DriverManager;
> import java.sql.PreparedStatement;
> import java.sql.SQLException;
> import java.sql.Statement;
> import java.util.UUID;
>
> import org.firebirdsql.management.FBManager;
> import org.junit.Test;
>
> /**
> * @author Serge Bogatyrev
> */
> public class BatchTest {
>
> private static final String INSERT_SQL = "insert into foo (id, name,
> note) values (?, ?, ?)";
>
> private static final String CREATE_TABLE_SQL = "create table foo (id
> int not null primary key,"
> + "name varchar(100) not null, note blob)";
>
> private static final String DROP_TABLE_SQL = "drop table foo";
>
> @Test
> public void test() throws Exception {
> Connection c = prepareDatabaseAndConnect();
> try {
>
> // Prepare and use statement
> PreparedStatement insert = c.prepareStatement(INSERT_SQL);
> for (int i = 0; i < 100; i++) {
> insert.setInt(1, i);
> insert.setString(2, String.valueOf(i));
> insert.setString(3, UUID.randomUUID().toString());
> insert.addBatch();
> }
> insert.executeBatch();
>
> // This commit is important for the first error.
> c.commit();
>
> // "335544332. invalid transaction handle" will be throw in loop.
> // To get next error "335544329. invalid BLOB ID" uncomment the following
> // line.
>
> // c.prepareStatement("select 1 from rdb$database");
>
> // Here we are using the same statement.
> for (int i = 100; i < 102; i++) {
> insert.setInt(1, i);
> insert.setString(2, String.valueOf(i));
> insert.setString(3, UUID.randomUUID().toString());
> insert.addBatch();
> }
> insert.executeBatch();
> insert.close();
>
> } finally {
> c.close();
> }
> }
>
> private Connection prepareDatabaseAndConnect() throws Exception,
> ClassNotFoundException,
> SQLException {
> String user = "sysdba";
> String password = "masterkey";
> File dbFile = new File(System.getProperty("java.io.tmpdir"), "batch.fdb");
>
> FBManager m = new FBManager("PURE_JAVA");
> m.start();
> m.createDatabase(dbFile.getPath(), user, password);
> m.stop();
>
> Class.forName("org.firebirdsql.jdbc.FBDriver");
> Connection c = DriverManager.getConnection("jdbc:firebirdsql:localhost:"
> + dbFile.getAbsolutePath(), user, password);
> c.setAutoCommit(true);
>
> Statement stm = c.createStatement();
> try {
> stm.executeUpdate(DROP_TABLE_SQL);
> } catch (Exception e) {
> }
> stm.executeUpdate(CREATE_TABLE_SQL);
> stm.close();
>
> c.setAutoCommit(false);
> return c;
> }
>
> }
> -------------------------------------------------------------
> On Fri, Aug 28, 2009 at 3:49 PM, Serge
> Bogatyrev<sergebogatyrjov@...> wrote:
> > Hi, all
> >
> >
> > I tryed to use batches and discovered a chain of bugs.
> >
> > I am using connection pool with (obviously) statement caching. All
> > errors occur when a prepared statement is used in context of new
> > transaction. And all works fine when I replacing the "blob" with
> > "varchar(100)".
> >
> > All bugs are described in the test.
> >
> >
> > Serge Bogatyrev.
> >
>