Patches item #1057570, was opened at 2004-10-31 00:24 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376687&aid=1057570&group_id=22866
Category: JBossCMP Group: v3.2 Status: Open Resolution: None Priority: 5 Submitted By: Marc Lavergne (mlavergn) Assigned to: Nobody/Anonymous (nobody) Summary: Oracle BLOB fails in JDBCUtil.setParameter for LONGVARBINARY Initial Comment: Oracle's thin JDBC driver fails in JDBCUtil.setParameter for LONGVARBINARY when setting BLOBs. There is a similar problem reported in 525663 but it does not address this particular concern. This is required for Nukes BLOB file storage when using an Oracle backend. The attached patch offers a solution but I wonder if there's a better way of achieving the result. In brief, Oracle's handling of BLOBs is quite unique. This patch detects the presence of the Oracle JDBC driver, then sets up a routine to create an oracle.sql.BLOB object. Since the oracle.sql.BLOB object is Oracle specific, the build file for server gets an added classpath dependency. I know this isn't the best place for this but since the Oracle driver isn't part of /thirdparty, I didn't want to mess with the buildfragments. Also, given that the routine is in JDBCUtil, the only way to get the underlying Oracle connection required for oracle.sql.LOB.createTemporary(), is to expose the managed connection in WrappedConnection.java. This is particularly troublesome because it creates a dependency on the "connector" module in the "server" module. Anyhow, this works, but I certainly welcome a cleaner implementation, especially with regards to satisfying the dependence I just mentioned. See patch for the nuts and bolts of it. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376687&aid=1057570&group_id=22866 ------------------------------------------------------- This SF.Net email is sponsored by: Sybase ASE Linux Express Edition - download now for FREE LinuxWorld Reader's Choice Award Winner for best database on Linux. http://ads.osdn.com/?ad_id=5588&alloc_id=12065&op=click _______________________________________________ JBoss-Development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
