2 Replies Latest reply on Aug 2, 2003 8:27 PM by woowindice

    CMP Bean field mapped to OracleCLOB

    Sathyakumar Newbie

      Hi All,

      I was just trying out entity bean with cmp field whose data type in the back end is CLOB. I am using Oracle8i as my database.

      I was not sure of the value to give in <sql-type> tah in jboss-cmp....xml file. I gave the it as CLOB itself.(Same as jdbc-type), but when i try to create the bean, i get a very lengthy exception at the server side.

      Following is the console output of JBoss server.

      16:54:19,768 INFO [TxConnectionManager$TxConnectionEventListener] Unregistered handle that was not registered! null for managedConnection: org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@62161d
      16:54:19,768 INFO [TxConnectionManager$TxConnectionEventListener] Unregistered handle that was not registered! null for managedConnection: org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@62161d
      16:54:19,778 INFO [JBossManagedConnectionPool] Exception destroying ManagedConnection
      org.jboss.resource.JBossResourceException: SQLException; - nested throwable: (java.sql.SQLException: Io exception: Connection reset by peer: socket write error)
      at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkException(BaseWrapperManagedConnection.java:445)
      at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.destroy(BaseWrapperManagedConnection.java:229)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.doDestroy(InternalManagedConnectionPool.java:374)
      ...
      ...

      Is there anything that i need to configure for CLOB fields to work with oracle.

      I tried the same without giving <jdbc-type> tags in other databases(PostGreSQl, SAPDB) and it worked.

      Also Entity Beans with cmp field mapped to Oracle BLOB field works fine, (even without me having to give <jdbc-type> value in rdbms xml file), The only problem is with the cmp fields mapped to Oracle CLOB fields.

      Thanks in advance
      Sathya