That's what I suspected :( So, is there any other way to call $ in my context? Like fe. < < ...
On 11/07/07, Michael Schall <[EMAIL PROTECTED]> wrote:
$ has special meaning to iBatis so you need to escape it. Only one will be sent to the database. I think... :) On 7/11/07, Jakub Scheibe < [EMAIL PROTECTED]> wrote: > > That's a proper firebird syntax. If I will use in any sql editor on fb I > will get value. > When I want to use it in iBatis like this > > <select id="GetId" parameterClass="Id" resultMap="rmId"> > SELECT GEN_ID(my_generator_name, 1) from RDB$DATABASE > </select> > > I'm getting error that I mentioned about. I don't want to use any > dynamical statement. > RDB$DATABASE is the system table in fb. > > > On 11/07/07, Clough, Samuel (USPC.PRG.Atlanta) <[EMAIL PROTECTED]> > wrote: > > > > 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? > > > > ------------------------------ > > *From:* Jakub Scheibe [mailto:[EMAIL PROTECTED] > > *Sent:* Wednesday, July 11, 2007 11:28 AM > > *To:* [email protected] > > *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. > > ------------------------------ > > * > > > > 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. > > ------------------------------ > > > >
