db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael Beier" <mbe...@VPS.DE>
Subject Placing Locks
Date Thu, 12 Feb 2004 09:59:17 GMT

There is a lockTable method in the DB-adapter classes (not in all, only Oracle, Sapdb and
Sybase seems to have used copy and paste, others dont contain this method or implement it
correctly (to make a correct lock table statement)) , this contains a fixed statement "SELECT
next_id FROM". This can only work on the ID_table, because only there is a column next_id.

This schould be "SELECT * FROM" (at least in Oracle and Sybase(respective MSSQL)) to work
for all Tables.

Can someone confirm this and maybe correct it ?

Or is it so by design?(Why?)

Michael Beier


  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message