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

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.