5 Replies Latest reply on Jul 15, 2002 12:07 PM by Brad Leupen

    Blob storing problem with CMP

    Alex Rublin Newbie

      I am using Jboss3.0 beta 2 and Oracle 9i.
      In oracle-service xml I using thin driver and DriverClass=oracle.jdbc.driver.OracleDriver

      in jbosscmp-jdbc.xml file I defined comments as:
      <cmp-field>
      <field-name>comments</field-name>
      <column-name>comments</column-name>
      <jdbc-type>JAVA_OBJECT</jdbc-type>
      <sql-type>BLOB</sql-type>
      </cmp-field>

      when I am trying to store Blob type the following exception:
      ---
      19:13:36,078 ERROR [MyEJB] Could not create entity
      javax.ejb.EJBException: Internal error setting parameters for field comments Embedded Exception Invalid column type
      at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCAbstractCMPFieldBridge.setArgumentParameters(JDBCAbstractCMPFieldBridge.java:242)
      at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCAbstractCMPFieldBridge.setInstanceParameters(JDBCAbstractCMPFieldBridge.java:215)
      ---
      Do I need to use different driver?
      Or what wrong with that?

      Thanks