db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From michaelbara...@mail.ru
Subject IDENTITY_VAL_LOCAL
Date Mon, 14 Feb 2005 14:34:59 GMT
Greetings!

I'm experiencing a problem using the IDENTITY_VAL_LOCAL function. Any
query with this function fails with an SQLException with message:

      Unexpected token: IDENTITY_VAL_LOCAL in statement ........
      
I have the identity column in one of my tables, on which I successfully
perform single-record inserts. Well, it seems it just doesn't even
parse! I'm really upset about it. I have to use a workaround like:

SELECT MAX(TABLE_ID) FROM MY_TABLE;

instead of IDENTITY_VAL_LOCAL().

Can anyone help?

I'm using:
JRE 1.4.2
Apache DERBY v.1.7.3

Thanks!
Michael.



Mime
View raw message