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

[Kevin Conner (JIRA)]

    [ http://jira.jboss.com/jira/browse/JBESB-1833?page=comments#action_12417959 ] 
            
Kevin Conner commented on JBESB-1833:
-------------------------------------

Thanks Jirka, I'll take another look at this.

> 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

-- 
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