Hi,

I am using Interbase 6.0 on Linux with jboss-tomcat-2.1-beta.  I have 
created a schema and a CMP entity bean, along with the required XML files 
for deployment.

Deployment works fine, but when I access the bean with a client I am 
getting the following exception:

interbase.interclient.ColumnConversionException: [interclient] Invalid 
data conversion: Wrong result column type for requested conversion.
See API reference for exception 
interbase.interclient.ColumnConversionException

The bean, and schema, are very simple.  They contain and integer based 
key and a VARCHAR(10) for a description (just a simple ref table).  After 
reviewing much of the documentation on the jBoss site, relating to CMP 
beans, and downloading the jbosstest suite to compare notes, I can't seem 
to find where my configuration needs to be fixed - I'm assuming that the 
configuration is incorrect at least.

Here are the relevant excerpts:

jaws.xml

    <entity>
      <ejb-name>BooleanRef</ejb-name>
      <table-name>Boolean_Ref</table-name>
      <create-table>false</create-table>

      <cmp-field>
        <field-name>booleanRefKey</field-name>
        <column-name>BOOLEAN_REF_KEY</column-name>
        <jdbc-type>INTEGER</jdbc-type>
        <sql-type>INTEGER</sql-type>
      </cmp-field>

      <cmp-field>
        <field-name>description</field-name>
        <column-name>DESCRIPTION</column-name>
        <jdbc-type>VARCHAR</jdbc-type>
        <sql-type>VARCHAR(10)</sql-type>
      </cmp-field>
      
    </entity>

ejb-jar.xml

   <entity>
      <display-name>BooleanRef</display-name>
      <ejb-name>BooleanRef</ejb-name>
      <home>com.ejb.BooleanRefHome</home>
      <remote>com.ejb.BooleanRef</remote>
      <ejb-class>com.ejb.BooleanRefBean</ejb-class>
      <persistence-type>Container</persistence-type>      
      <prim-key-class>com.ejb.BooleanRefPK</prim-key-class>
      <reentrant>False</reentrant>

      <cmp-field><field-name>booleanRefKey</field-name></cmp-field>
      <cmp-field><field-name>description</field-name></cmp-field>
      
    </entity>

Any suggestions or help would be very much appreciated.

Thanks,
John

_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to