Hi Group.  I'm having a problem executing a SQL CALL from Castor.  If anyone here has 
some experience with this please drop me a line.

ERROR:

java.lang.IllegalArgumentException: Only 0 fields in this query
        at org.exolab.castor.jdo.engine.OQLQueryImpl.bind(OQLQueryImpl.java:153)
        at org.exolab.castor.jdo.engine.OQLQueryImpl.bind(OQLQueryImpl.java:231)
        at com.bac.amg.castortest.TestCastor.test(TestCastor.java:86)
        at com.bac.amg.castortest.TestMain.main(TestMain.java:45)
Exception in thread "main" 


QUERY:

"CALL SQL SELECT party_id, last_nm, first_nm, middle_nm, tax_id, birth_dt, 
assoc_termntn_d FROM app.assoc WHERE party_id < $1 AS " + 
com.bac.amg.castortest.Associate.class.getName()

MAPPING:

  <class name="com.bac.amg.castortest.Associate" identity="partyID">
    <description>Associate</description>
    <map-to table="app.assoc" xml="assoc" />
    <field name="partyID" type="string">
      <sql name="party_id" type="numeric" />
    </field>
    <field name="lastName" type="string">
      <sql name="last_nm" type="char" />
    </field>
    <field name="firstName" type="string">
      <sql name="first_nm" type="char" />
    </field>
    <field name="middleName" type="string">
      <sql name="middle_nm" type="char" />
    </field>
    <field name="taxID" type="string">
      <sql name="tax_id" type="char" />
    </field>
    <field name="birthDate" type="date">
      <sql name="birth_dt" type="date" />
    </field>
    <field name="terminationDate" type="date">
      <sql name="assoc_termntn_dt" type="date" />
    </field>
  </class>

----------------------------------------------------------- 
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
        unsubscribe castor-dev

Reply via email to