I tried latest JDBC driver from otn.oracle.com. As I found, this
driver excellently work with CLOBs (insert, select, update) and
can select BLOBs too. But when I try to insert BLOB, I receive an
error "Error casting an object of type to an incompatible type. This
usually indicates a programming error in Java, although it could also
mean you have tried to use a foreign object in a different way than it
was designed."
I use <CFQUERYPARAM> in <CFQUERY> to insert or update data with
cfsqltype == CF_SQL_BLOB (if I change data type to CF_SQL_BINARY,
ColdFusion throws other error: "Invalid data [EMAIL PROTECTED] for CFSQLTYPE
CF_SQL_BINARY").
Also I found (it may be helpful for CF/ORACLE developers) that CFMX
DataDirect Oracle driver *really* does not support CLOBs/BLOBs at all
as well as bundle CFMX JDBC/ODBC bridge with Microsoft ODBC driver for
Oracle.
Alex.
------------------------------------------
Environment details
------------------------------------------
* ColdFusion MX 6.1 ENT.
* Windows 2000 SP4 + postfixes
* Oracle 8.1.7
* Oracle client 9.2.0.1, JDBC driver 9.2.0.3 (ojdbc14.jar, ocrs12.zip, nls_charset12.zip)
* CLOB and BLOB checkboxes in datasource configuration in CF Admin are
checked.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
