Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: softfail (hermes.apache.org: transitioning domain of
 michaelbaranov@mail.ru does not designate 195.209.41.194 as permitted sender)
Date: Mon, 14 Feb 2005 16:34:59 +0200
From: michaelbaranov@mail.ru
Reply-To: michaelbaranov@mail.ru
Message-ID: <1123980353.20050214163459@mail.ru>
To: derby-user@db.apache.org
Subject: IDENTITY_VAL_LOCAL
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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.