Try this in your sql map
<select id="GetId" parameterClass="Id" resultMap="rmId">
SELECT GEN_ID(my_generator_name, 1) from RDB$$DATABASE
</select>
If this doesn't work I'm out of suggestions.
On 7/11/07, Jakub Scheibe <[EMAIL PROTECTED]> wrote:
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.
> > > ------------------------------
> > >
> >
> >
>
