Doest setLimit work with Sybase?

[Terence Kwan]

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:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>