You are viewing a plain text version of this content. The canonical link for it is here.

Posted to torque-dev@db.apache.org by Michael Beier <mb...@VPS.DE> on 2004/04/01 16:23:27 UTC

lockTable Method

Hi,

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 should 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

mbeier@vps.de