[esb-issues] [JBoss JIRA] Commented: (JBESB-1805) SQLCourier BLOB support does not work on postgres

Tue Jul 15 13:46:05 EDT 2008

    [ http://jira.jboss.com/jira/browse/JBESB-1805?page=comments#action_12421408 ] 

Kevin Conner commented on JBESB-1805:
-------------------------------------

Added explicit support for BINARY, VARBINARY, LONGVARBINARY, CHAR, VARCHAR and LONGVARCHAR.

Fixed in trunk in revision 21043.

> SQLCourier BLOB support does not work on postgres
> -------------------------------------------------
>
>                 Key: JBESB-1805
>                 URL: http://jira.jboss.com/jira/browse/JBESB-1805
>             Project: JBoss ESB
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>          Components: Rosetta
>    Affects Versions: 4.2.1 CP3, 4.3
>            Reporter: Kevin Conner
>         Assigned To: Kevin Conner
>             Fix For: 4.2.1 CP4, 4.4
>
>
> 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