db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Benjamin Yu <Benjam...@InformativeResearch.com>
Subject RE: lockTable Method
Date Thu, 01 Apr 2004 18:10:22 GMT
If possible, I too would like a better clarification of the use of
lockTable, since the DBAdapter dev documentation is a bit ambiguous as to
when to implement the lockTable methods.

> others dont contain this method or implement
I did notice that some are subclasses of another adapter that implement the
methods.

Thanks,
Ben

-----Original Message-----
From: Michael Beier [mailto:mbeier@VPS.DE]
Sent: Thursday, April 01, 2004 6:23 AM
To: torque-dev@db.apache.org
Subject: 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


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org


Mime
View raw message