Hi,
i come from Adabas D 12, i have problems to 'lock' database entry...
Here is my Javacode:
dis.sql_error_lock_collision =
"com.sap.dbtech.jdbc.exceptions.DatabaseException: SAP DBTech SQL: [400]
(at 64) Lock collision";
try {
Class.forName( dis.sql_treiber);
conn_sperr = DriverManager.getConnection( dis.sql_url, dis.sql_user,
dis.sql_password);
conn_sperr.setAutoCommit( false);
stat = conn_sperr.createStatement();
stat.execute("lock (nowait) row adressen key adnr = '" + adnr + "' in
exclusive mode");
stat.close();
}
catch (Exception ex) {
if ( ex.toString().equals( dis.sql_error_lock_collision)) {
sub.em("SIMON DIS - Adressen", "Der Datensatz wird schon
bearbeitet!");
}
else {
sub.em("SIMON DIS - Adresse", "Der Datensatz konnte nicht gesperrt
werden!\n" + ex);
dis.sql_cat.error( "Personen - Datensatz konnte nicht gesperrt
werden " + adnr, ex);
}
adresse_gesperrt = false;
return ( false);
}
After pressing the button to start the code the programm freezes.
With Adabas this code works fine.
What do i wrong?
regards
Andreas
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
