Re: Make MySQL syntax work in Informix
On Thu, 2007-07-05 at 07:59 -0700, Southwell Schuyler wrote:
> I have a semi-canned package (JasperSoft JasperReports / JasperServer)
> that I am attempting to make use Informix as it's report repository, in
> lieu of installing an Oracle / MySQL instance.
>
> I have the schema (successfully ?) converted (I won't know for certain
> until I can get the JasperServer product (installed in Tomcat) to come
> up.
>
>
> It is failing on the following MySQL/Oracle syntax:
>
> -----
>
> SELECT hibernate_sequence.nextval FROM dual;
You need a sequence:
CREATE SEQUENCE hibernate_sequence
HTH,
--
Carsten Haese
http://informixdb.sourceforge.net