[esb-issues] [JBoss JIRA] Commented: (JBESB-1833) SQLCourier BLOB/CLOB support does not work on Oracle

SQLCourier BLOB/CLOB support does not work on Oracle ---------------------------------------------------- Key: JBESB-1833 URL: http://jira.jboss.com/jira/browse/JBESB-1833 Project: JBoss ESB Issue Type: Bug Security Level: Public(Everyone can see) Components: Rosetta Affects Versions: 4.3, 4.2.1 CP3 Reporter: Jiri Pechanec Assigned To: Kevin Conner Fix For: 4.4, 4.2.1 CP4 The BLOB and CLOB support, added as part of JBESB-1690, is not sufficient for oracle When the CLOB is used, the following exception is thrown java.lang.NullPointerException at org.jboss.soa.esb.listeners.gateway.SqlTableGatewayListener.pollForCandidates(SqlTableGatewayListener.java:490) at org.jboss.soa.esb.listeners.gateway.SqlTableGatewayListener.doRun(SqlTableGatewayListener.java:177) at org.jboss.soa.esb.listeners.lifecycle.AbstractThreadedManagedLifecycle.run(AbstractThreadedManagedLifecycle.java:115) at java.lang.Thread.run(Thread.java:595) When the BLOB is used the following exception is thrown java.lang.NullPointerException at org.jboss.soa.esb.listeners.gateway.SqlTableGatewayListener.pollForCandidates(SqlTableGatewayListener.java:493) at org.jboss.soa.esb.listeners.gateway.SqlTableGatewayListener.doRun(SqlTableGatewayListener.java:177) at org.jboss.soa.esb.listeners.lifecycle.AbstractThreadedManagedLifecycle.run(AbstractThreadedManagedLifecycle.java:115) at java.lang.Thread.run(Thread.java:595) It looks like the Oracle reports BLOB datatype when CLOB is used and vice versa