> insertStatement.setString( 1, "test" );

Where do you set the second parameter? Or is that the bug?
Does anything in the finally block throw an exception?

-----Original Message-----
From: Firebird-Java@yahoogroups.com
[mailto:Firebird-Java@yahoogroups.com] On Behalf Of Steffen Heil
Sent: Friday, January 12, 2007 12: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




Disclaimer: This message (including attachments) is confidential and may be privileged. If you have received it by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. RxStrategies, Inc. shall not be liable for the improper or incomplete transmission of the information contained in this communication or for any delay in its receipt or damage to your system. RxStrategies, Inc. does not guarantee that the integrity of this communication has been maintained nor that this communication is free from viruses, interceptions or interference.