Hi,
I have a problem with my firebird application.
I do a customer-management program.
If I click on "edit customer" i intend to do the following

[CODE]
private boolean connect()
{
try
{
Connection firebird_connection =
DriverManager.getConnection(databaseURL, username,userpass);
firebird_connection.setAutoCommit(false);

firebird_connection.setTransactionIsolation(Connec
tion.TRANSACTION_SERIALIZABLE);

isconnected = true;
return true;
}
catch (java.sql.SQLException e)
{
System.out.println(e.getMessage());
return false;
}
}
[/CODE]

Now when I do "SELECT * FROM CUSTOMERS WHERE customerID = ? FOR UPDATE
WITH LOCK" on Connection1 - everything works fine.
If a 2nd connection is created (another user) who does the same
"select 4 update" nothing happens.

could someone help me?

cheers YnoC