0 Replies Latest reply on Aug 26, 2006 11:59 AM by F B

    ERROR [STDERR] java.sql.SQLException: Table (my_seq) not sel

    F B Newbie

      Informix 9.4 is reporting

      ERROR [STDERR] java.sql.SQLException: Table (equifax_seq) not selected in query.

      and Hibernate is outputing the following from "showsql=true"
      select my_seq.nextval from systables where tabid=1;

      This exact same query works fine from iSQL

      ref:
      http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.em.doc/errors_ids100.html
      http://java-source.net/open-source/sql-clients/isql-viewer