Return-Path: Delivered-To: apmail-ibatis-user-cs-archive@www.apache.org Received: (qmail 39537 invoked from network); 11 Jul 2007 15:28:32 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 11 Jul 2007 15:28:32 -0000 Received: (qmail 84066 invoked by uid 500); 11 Jul 2007 15:28:35 -0000 Delivered-To: apmail-ibatis-user-cs-archive@ibatis.apache.org Received: (qmail 83822 invoked by uid 500); 11 Jul 2007 15:28:34 -0000 Mailing-List: contact user-cs-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-cs@ibatis.apache.org Delivered-To: mailing list user-cs@ibatis.apache.org Received: (qmail 83810 invoked by uid 99); 11 Jul 2007 15:28:34 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 11 Jul 2007 08:28:34 -0700 X-ASF-Spam-Status: No, hits=3.2 required=10.0 tests=DNS_FROM_AHBL_RHSBL,HTML_10_20,HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: domain of jakub.scheibe@gmail.com designates 64.233.162.234 as permitted sender) Received: from [64.233.162.234] (HELO nz-out-0506.google.com) (64.233.162.234) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 11 Jul 2007 08:28:30 -0700 Received: by nz-out-0506.google.com with SMTP id x3so1317373nzd for ; Wed, 11 Jul 2007 08:28:09 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; b=k8RmKS+W2HokXQP2LMvDdnmr5Ih30GNiinzAClVHtfhkCEPjX/KeDPcCEQFzLhPeUVzXaWK0KPCJdL8sayIzkpmSt8oSYsNtEfIHJFowp8Ae9DRsuRn2wo6dq1kWhYPnsC429G+o235i6aFyojP/lyekU8nCgIeBlBiK9exwr3w= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type; b=EMRb1DSElO0TzvkPVIR728ej/PClxY/SRqjcENySzTD5R25Rc4R8XIzfzRS9+tPzRuVpklnFDOZzHstSsqMfOu3sKXR5PBHQYbWViWS+uuO7XePVQ6gonA+fABI1z4btMooAzcm6fbW686hJsCb1MZn8zaMiIaytap4QOrMdPao= Received: by 10.114.192.1 with SMTP id p1mr5234480waf.1184167689223; Wed, 11 Jul 2007 08:28:09 -0700 (PDT) Received: by 10.114.254.18 with HTTP; Wed, 11 Jul 2007 08:28:09 -0700 (PDT) Message-ID: <32163a230707110828o253adb41jeb33499e15aa3dd1@mail.gmail.com> Date: Wed, 11 Jul 2007 16:28:09 +0100 From: "Jakub Scheibe" To: user-cs@ibatis.apache.org Subject: Generators&FB MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_6676_11048383.1184167689204" X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_6676_11048383.1184167689204 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi, I want to get gen_id from my database (firebird), but when I'm trying to execute this sql query by iBatis SELECT GEN_ID(my_generator_name, 1) from RDB$DATABASE I'm getting error like this: Unterminated dynamic element in sql (SELECT GEN_ID(my_generator_name, 1) from RDB$DATABASE).. Looks like there is a problem with $ in RDB$DATABASE. Any idea how should I do it in iBatis? Regards, Jakub. ------=_Part_6676_11048383.1184167689204 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi,

I want to get gen_id from my database (firebird), but when I'm trying to execute this sql query by iBatis

SELECT GEN_ID(my_generator_name, 1) from RDB$DATABASE

I'm getting error like this:

Unterminated dynamic element in sql (SELECT GEN_ID(my_generator_name, 1) from RDB$DATABASE)..

Looks like there is a problem with $ in RDB$DATABASE.

Any idea how should I do it in iBatis?

Regards,
Jakub.
------=_Part_6676_11048383.1184167689204--