On May 2, 2008, at 8:01 AM, Knut Anders Hatlen wrote:
That's the error you'll get if you execute the query in a Derby
release that doesn't support the ROW_NUMBER function (e.g., Derby
10.3). So I would have double checked that the JDBC application in
fact uses Derby 10.4. derby.log should tell you which version was
used.
Sorry it took me so long to reply...
Thanks to all for the responses. You are correct, just a little Jar
file madness. Once we *really* put the 10.4 jar in place, things
worked swimmingly.
Thanks again!
Geoff