Patches item #525663, was opened at 2002-03-04 14:16 You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=376687&aid=525663&group_id=22866
Category: JBossCMP Group: v2.4 (stable) Status: Open Resolution: None Priority: 5 Submitted By: Andrew McCulloch (amccullo) Assigned to: Nobody/Anonymous (nobody) Summary: CMP and oracle blobs Initial Comment: Using Oracle 8.1.7 and JBoss 2.4.4 it is not possible to use CMP and Oracle blobs over a certain size. This is because JBoss uses the setBinaryStream() for Blobs over 2000 bytes. According to Oracle documentation the only supported method is to use setBlob() with a java.sql.Blob object. To do this you must first verify that the sql type of the data is BLOB and then create a java.sql.Blob instance to set. I modified the signature or JDBCCommand.setParameter() to accept the SQLType of the data and then check for BLOB and use the correct method if present. I also modified code that calls setParameter to pass in the SQLType. I have tested this with the Seropto third party Oracle driver from inetsoftware and it works well. See http://main.jboss.org/thread.jsp?forum=46&thread=6828 for details. ---------------------------------------------------------------------- You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=376687&aid=525663&group_id=22866 _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
