Sorry, I sent THAT mail on "12 Jan 2007 18:03:38 -0000" (see headers)...
No idea why it took that long, but the question was already answered (as I
reposted using the web interface & the bug tracker).

Regrads,
Steffen

> -----Original Message-----
> From: Firebird-Java@yahoogroups.com
> [mailto:Firebird-Java@yahoogroups.com] On Behalf Of Steffen Heil
> Sent: Friday, January 12, 2007 6:47 PM
> To: Firebird-Java@yahoogroups.com
> Subject: [Firebird-Java] Propably Bug in JayBird or Firebird
> Importance: High
>
> Hi
>
> I think I found a strange bug in JayBird or Firebird.
> I open a connection in non-auto-commit mode. I delete all
> entries in a table and insert some new entries. That fails
> (acutally a bug in my software).
> However the database should NOT get corrupted, as the
> transaction is NEVER commited.
> That works as expected.
>
> If I try again, it fails again (as expected).
> However, this time the database IS CORRUPTED, as the
> transaction seems to get partially commited.
>
> That effect already destroyed 3 databases of mine.
> However I could isolate to problem and build a test case,
> which shows the behavior.
>
> So, please: Show me what I'm doing wrong and don't
> disillustrate me that atomicity is broken in firbird 2.0.0.
>
> Regards,
> Steffen
>
>
>
> //set SQL DIALECT 3;
> //
> //set names UTF8;
> //
> //create database 'c:\test.fdb'
> //user 'SYSDBA' password 'xxxxxx'
> //page_size 16384
> //default character set UTF8;
> //
> //create table TEST (
> // A varchar(10),
> // B varchar(10)
> //);
> //
> //insert into TEST (A, B) values ('as', 'as'); // //commit work;
>
>
> import java.sql.Connection;
> import java.sql.PreparedStatement;
> import java.sql.SQLException;
> import java.util.HashMap;
> import java.util.Map;
>
> import org.firebirdsql.pool.FBWrappingDataSource;
>
>
> public class TestCase
> {
>
> static Map<String,Object> settings = new
> HashMap<String,Object>();
>
> static FBWrappingDataSource dataSource;
>
>
> private static void test()
> {
> Connection connection = null;
> PreparedStatement deleteStatement = null;
> PreparedStatement insertStatement = null;
> try {
> connection = dataSource.getConnection();
> connection.setAutoCommit( false );
> deleteStatement =
> connection.prepareStatement( "delete from test" );
> deleteStatement.executeUpdate();
> insertStatement =
> connection.prepareStatement( "insert into test ( a, b )
> values ( ?, ? )" );
> insertStatement.setString( 1, "test" );
> insertStatement.executeUpdate();
> connection.commit();
> } catch ( SQLException e ) {
> e.printStackTrace();
> } finally {
> try { deleteStatement.close(); } catch
> ( Throwable t
> ) {}
> try { insertStatement.close(); } catch
> ( Throwable t
> ) {}
> try { connection.close(); } catch (
> Throwable t ) {}
> }
> }
>
>
> @SuppressWarnings( "boxing" )
> public final static void main( String[] args )
> throws Exception
> {
> if ( args.length == 0 )
> args = new String[] {
> "127.0.0.1:c:/test.fdb", "sysdba", "xxxxxx" };
>
> dataSource = new FBWrappingDataSource();
> dataSource.setCharSet( "utf-8" );
> dataSource.setDatabase( args[ 0 ] );
> dataSource.setNonStandardProperty(
> "sql_dialect", Integer.toString( 3 ) );
> dataSource.setEncoding( "utf8" );
> dataSource.setMaxPoolSize( 1 );
> dataSource.setPassword( args[ 2 ] );
> dataSource.setUserName( args[ 1 ] );
> try {
> test();
> } catch ( Exception e ) {
> System.out.println( "First try failed." );
> }
> // uncomment to trigger the problem.
> // try {
> // test();
> // } catch ( Exception e ) {
> // System.out.println( "Second try failed." );
> // }
> // at this point, the table IS EMPTY
> dataSource.shutdown();
> }
>
> }
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
> Yahoo! Groups Links
>
>
>

[Non-text portions of this message have been removed]