Return-Path: Delivered-To: apmail-ibatis-user-cs-archive@www.apache.org Received: (qmail 48542 invoked from network); 11 Jul 2007 15:50:52 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 11 Jul 2007 15:50:52 -0000 Received: (qmail 53623 invoked by uid 500); 11 Jul 2007 15:50:53 -0000 Delivered-To: apmail-ibatis-user-cs-archive@ibatis.apache.org Received: (qmail 53612 invoked by uid 500); 11 Jul 2007 15:50:53 -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 53601 invoked by uid 99); 11 Jul 2007 15:50:53 -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:50:53 -0700 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE X-Spam-Check-By: apache.org Received-SPF: neutral (herse.apache.org: local policy) Received: from [199.43.38.101] (HELO mlnya403er.ml.com) (199.43.38.101) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 11 Jul 2007 08:50:47 -0700 Received: from mlnyc854bh.amrs.win.ml.com (unknown [141.128.12.204]) by mlnya403er.ml.com (Postfix) with ESMTP id B294F5520A for ; Wed, 11 Jul 2007 11:50:25 -0400 (EDT) Content-Transfer-Encoding: 7bit Importance: normal Priority: normal Received: from MLNYC803BH.amrs.win.ml.com ([141.128.12.21]) by mlnyc854bh.amrs.win.ml.com with Microsoft SMTPSVC(5.0.2195.6920); Wed, 11 Jul 2007 11:49:57 -0400 Received: from MLNYC728MB.amrs.win.ml.com ([141.128.12.73]) by MLNYC803BH.amrs.win.ml.com with Microsoft SMTPSVC(5.0.2195.6920); Wed, 11 Jul 2007 11:49:57 -0400 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1896 Content-Class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C7C3D3.218383E6" Subject: RE: Generators&FB Date: Wed, 11 Jul 2007 11:49:57 -0400 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Generators&FB thread-index: AcfD0CeXVQpwsOxYRBa45DgF9MykSgAAufmA From: "Clough, Samuel \(USPC.PRG.Atlanta\)" To: X-OriginalArrivalTime: 11 Jul 2007 15:49:57.0086 (UTC) FILETIME=[217F5FE0:01C7C3D3] X-Virus-Checked: Checked by ClamAV on apache.org This is a multi-part message in MIME format. ------_=_NextPart_001_01C7C3D3.218383E6 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable I know zero about firebird, so is this a firebird syntax or are you trying to use iBatis properties to dynamically set the database table name? _____ =20 From: Jakub Scheibe [mailto:jakub.scheibe@gmail.com]=20 Sent: Wednesday, July 11, 2007 11:28 AM To: user-cs@ibatis.apache.org Subject: Generators&FB 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.=20 -------------------------------------------------------- Princeton Retirement Group, Inc - Important Terms=20 This E-mail is not intended for distribution to, or use by, any person = or entity in any location where such distribution or use would be = contrary to law or regulation, or which would subject Princeton = Retirement Group, Inc. or any affiliate to any registration requirement = within such location.=20 This E-mail may contain privileged or confidential information or may = otherwise be protected by work product immunity or other legal rules. No = confidentiality or privilege is waived or lost by any mistransmission. = Access, copying or re-use of information by non-intended or = non-authorized recipients is prohibited. If you are not an intended = recipient of this E-mail, please notify the sender, delete it and do not = read, act upon, print, disclose, copy, retain or redistribute any = portion of this E-mail.=20 The transmission and content of this E-mail cannot be guaranteed to be = secure or error-free. Therefore, we cannot represent that the = information in this E-mail is complete, accurate, uncorrupted, timely or = free of viruses, and Princeton Retirement Group, Inc. cannot accept any = liability for E-mails that have been altered in the course of delivery. = Princeton Retirement Group, Inc. reserves the right to monitor, review = and retain all electronic communications, including E-mail, traveling = through its networks and systems (subject to and in accordance with = local laws). If any of your details are incorrect or if you no longer = wish to receive mailings such as this by E-mail please contact the = sender by reply E-mail.=20 -------------------------------------------------------- ------_=_NextPart_001_01C7C3D3.218383E6 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
I know zero about firebird, so is this a = firebird syntax or=20 are you trying to use iBatis properties to dynamically set the database = table=20 name?

From: Jakub Scheibe=20 [mailto:jakub.scheibe@gmail.com]
Sent: Wednesday, July 11, = 2007 11:28=20 AM
To: user-cs@ibatis.apache.org
Subject:=20 Generators&FB

Hi,

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

SELECT=20 GEN_ID(my_generator_name, 1) from RDB$DATABASE

I'm getting error = like=20 this:

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

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

Any idea how should I do it in=20 iBatis?

Regards,
Jakub.

Princeton Retirement Group, Inc - Important Terms

This E-mail is not intended for distribution to, or use by, any = person or entity in any location where such distribution or use would be = contrary to law or regulation, or which would subject Princeton = Retirement Group, Inc. or any affiliate to any registration requirement = within such location.

This E-mail may contain privileged or confidential information or may = otherwise be protected by work product immunity or other legal rules. No = confidentiality or privilege is waived or lost by any mistransmission. = Access, copying or re-use of information by non-intended or = non-authorized recipients is prohibited. If you are not an intended = recipient of this E-mail, please notify the sender, delete it and do not = read, act upon, print, disclose, copy, retain or redistribute any = portion of this E-mail.

The transmission and content of this E-mail cannot be guaranteed to = be secure or error-free. Therefore, we cannot represent that the = information in this E-mail is complete, accurate, uncorrupted, timely or = free of viruses, and Princeton Retirement Group, Inc. cannot accept any = liability for E-mails that have been altered in the course of delivery. = Princeton Retirement Group, Inc. reserves the right to monitor, review = and retain all electronic communications, including E-mail, traveling = through its networks and systems (subject to and in accordance with = local laws). If any of your details are incorrect or if you no longer = wish to receive mailings such as this by E-mail please contact the = sender by reply E-mail.

------_=_NextPart_001_01C7C3D3.218383E6--