0 Replies Latest reply on Nov 27, 2006 4:40 PM by Modou Sanyang

    Is JBOSS 4.0.5GA is Generating Incorrect SQL?

    Modou Sanyang Newbie

      Hi All,
      I posted this to the wrong forum before. I couldn't find a way to move it over here, so am reposting here:

      I have the following bean definition in jbosscmp-jdbc.xml:

      <entity>
       <ejb-name>SeqEJB</ejb-name>
       <datasource>myDataSourceName</datasource>
       <table-name>MYSEQ</table-name>
       <cmp-field>
       <field-name>id</field-name>
       <column-name>id</column-name>
       </cmp-field>
       <entity-command name="oracle-sequence">
       <attribute name="sequence">SchemaName.General_Seq</attribute>
       </entity-command>
       </entity>


      JBOSS Generates the following create statement:

      {call INSERT INTO MYSEQ(id, ) VALUES (SchemaName.General_Seq.NEXTVAL, ) RETURNING id INTO ? }
      


      Which leads to the following SQLException:

      java.sql.SQLException: ORA-06550: line 1, column 32:
      PL/SQL: ORA-01747: invalid user.table.column, table.column, or column specification
      ORA-06550: line 1, column 7:
      PL/SQL: SQL Statement ignored


      Am I doing something wrong? Any help will be most appreciated.

      regards,
      Modou.