db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ben Walding <...@walding.com>
Subject Re: Doest setLimit work with Sybase?
Date Tue, 21 Jan 2003 21:10:53 GMT
No idea if it does or not, but within Sybase you can do

SET ROWCOUNT X  and the session will only select / delete / insert that 
many rows before stopping.

Hence, it should be feasible to code it easily

SET ROWCOUNT 0 disables the limit.

Terence Kwan wrote:

> 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.
>
> Thanks,
>
> Terence
>
>
>
>
>
> _________________________________________________________________
> The new MSN 8: smart spam protection and 2 months FREE*  
> http://join.msn.com/?page=features/junkmail
>
>
> -- 
> To unsubscribe, e-mail:   
> <mailto:turbine-torque-user-unsubscribe@jakarta.apache.org>
> For additional commands, e-mail: 
> <mailto:turbine-torque-user-help@jakarta.apache.org>
>
>



Mime
View raw message