db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Terence Kwan" <terencek...@hotmail.com>
Subject Doest setLimit work with Sybase?
Date Tue, 21 Jan 2003 13:40:01 GMT
Hi all,

Does Torque support setLimit for Criteria with Sybase? It seems that 
although DBSybase.getLimitStyle() returns LIMIT_STYLE_SYBASE, BasePeer does 
not handle LIMIT_STYLE_SYBASE. The specific bit of code has been commented 
out in BasePeer. Thus if a Criteria.setLimit() is used, an exception will be 
thrown with this message: Incorrect syntax near 'LIMIT'.

I am using Sybase ASE 11.9.2 with the com.sybase.jdbc2.jdbc.SybDriver driver 
from jConnect5.5.

Any information will be most appreciated.



The new MSN 8: smart spam protection and 2 months FREE*  

View raw message