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

Thu Jun 19 08:15:37 EDT 2008

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

> 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.2.1 CP3, 4.3
>            Reporter: Jiri Pechanec
>         Assigned To: Kevin Conner
>             Fix For: 4.2.1 CP4, 4.4
>
>
> 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