Doest setLimit work with Sybase?

[Terence Kwan <te...@hotmail.com>]

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

Re: Doest setLimit work with Sybase?

[Ben Walding <be...@walding.com>]

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:   
> <ma...@jakarta.apache.org>
> For additional commands, e-mail: 
> <ma...@jakarta.apache.org>
>
>