Hi

I'm trying to create a transaction with this code:

try
{
conex.getConnection().setAutoCommit(false);
conex.getConnection().createStatement().execute("set transaction
name tr1 read committed");
}
catch (SQLException ex3)
{
ex3.printStackTrace();
}

and I get this error:

org.firebirdsql.jdbc.FBSQLException: GDS Exception. Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 8
transaction
at
org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.java:81)
at
org.firebirdsql.jdbc.FBConnection.prepareStatement(FBConnection.java:223)
at controlcierres.pruebas.factel.<init>(factel.java:121)
at controlcierres.pruebas.factel.main(factel.java:132)
at org.firebirdsql.gds.GDSException: Dynamic SQL Error

Can anybody guide me on how to begin-commit a transaction.

Thanks, Fernando.