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