2 Replies Latest reply on Sep 6, 2002 5:08 AM by cnwy

    run cmp2.0 example fail

    cnwy Newbie

      I have passed "ant setup","ant tear down".

      but raise exception when try "ant test"

      [junit] 2) testSelectOperatingZipCodes_declaredsqlorg.jboss.docs.cmp2.crimeportal.CrimePortalTest)
      [junit] javax.ejb.FinderException: Find failed: java.sql.SQLException: ORA-00904: invalid column name

      BTW.I have changed some setting for the example.
      DataSource :oracle9i
      change DESC to DESCRIPTION(jbosscmp-jdbc.xml)

      the section for ejbSelectOperatingZipCodes_declaredsql:

      <query-method>
      <method-name>ejbSelectOperatingZipCodes_declaredsql</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <declared-sql>


      <ejb-name>LocationEJB</ejb-name>
      <field-name>zipCode</field-name>
      hangout

      <![CDATA[ , organization o, gangster g ]]>
      <![CDATA[
      LCASE(o.name) = {0} AND o.name = g.organization AND
      g.hangout = hangout.id
      ]]>
      <![CDATA[ hangout.zip ]]>
      </declared-sql>


      what's wrong?