RE: Make MySQL syntax work in Informix

Yeah, I even tried that, believing it was trying a variant of SELECT 'hibernate_sequence'.nextval FROM dual /or/ 'hibernate_sequence'.dual Same error. (FYI, we are Informix 10.00.FC6) I see that Cheetah has implemented a "sysdual" table, and was going to try to synonym that and see if this'll run in IDS 11.x, but without the underlying modification to the SQL parser, etc., I don't know if it will work... I suspect it something to do with Hibernate, but not being an expert (or barely a newbie), I'm not sure if I can fake something in the hibernate config files... Thanks for the suggestion, however. --Sky -----Original Message----- From: Priest, Darryl [mailto:darryl.priest@dlapiper.com] Sent: Thursday, July 05, 2007 8:10 AM To: Southwell Schuyler Subject: RE: Make MySQL syntax work in Informix Is it possible that select statement implying that dual needs to be owned by the 'user' hibernate_sequence? HTH, -D -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Southwell Schuyler Sent: Thursday, July 05, 2007 10:59 AM To: informix-list@iiug.org Subject: Make MySQL syntax work in Informix 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; 14:45:20,272 WARN JDBCExceptionReporter,main:77 - SQL Error: -217, SQLState: IX000 14:45:20,300 ERROR JDBCExceptionReporter,main:78 - Column (nextval) not found in any table in the query (or SLV is undefined). ----- I have implemented several variants of the 'dual' table (everything from Jonathan Leffler's 'dual' view to an actual table), and have also created the hibernate_sequence table. Both tables have a 'nextval' column. If I do this without the nextval column in the table, then I get an error that states column hibernate_sequence not in any table... --- Is there ANY way to write a VIEW / SYNONYM / SELECT TRIGGER (this is relatively low volume) to FAKE this query into executing? I really would like to avoid implementing the Oracle / MySQL instance if at all possible. Thanks, Schuyler L. Southwell Software Engineer, Consulting Maricopa County Attorney's Office tel: 602 506 8107 southwel@mcao.maricopa.gov _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list <font face="Arial" size="2" color="#008000"> Please consider the environment before printing this email.</font> ________________________________________________________________________ _____________ The information contained in this email may be confidential and/or legally privileged. It has been sent for the sole use of the intended recipient(s). If the reader of this message is not an intended recipient, you are hereby notified that any unauthorized review, use, disclosure, dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please contact the sender by reply email and destroy all copies of the original message. To contact our email administrator directly, send to postmaster@dlapiper.com Thank you. ________________________________________________________________________ _____________