Re: Handling String date format "0000-00-00 00:00:00" removed in latest version???
Posted by: Simon Haldon
Date: February 23, 2005 06:58AM

The other change between connector J 3.0 and 3.1 versions seems to be a failure to run a query using the LIMIT keyword with a placeholder parameter. Can anyone confirm that this is not supported any more or whether there is some environmental variable I need to change.

E.g.

a_query.append("SELECT x from y where z=? ")
a_query.append(" LIMIT ? ")

This now gives an SQL syntax error under 3.1.6+, but runs fine under 3.0.x.
I couldn't find any relevant reference to LIMIT in the changelog.

Cheers
Simon.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.