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

[ http://jira.jboss.com/jira/browse/JBESB-1833?page=all ] Jiri Pechanec updated JBESB-1833: --------------------------------- Description: 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 was: The BLOB support, added as part of JBESB-1690, is not sufficient for postgres. The issue lies in the creation of the table entries as the code uses the statement.setObject method to initialise the parameter. We need to change this to use the setCharacterStream/setBinaryStream equivalents. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira