jBLOB

Usually it is difficult to decide were to store files, uploaded by application users - as file on hard disk or in a database, using BLOB or CLOB fields. But for those of you who want to store files in a database we recommend these CFX Java tags.
It was not easy to work with large database objects in early ColdFusion versions. And we had some hardships resolved by using present CFX tags.
jBLOB library is a set of easy to use ColdFusion CFX Java classes used to read and write binary information to and from database with BLOB or CLOB fields. jBLOB can be used to upload docs (images, MS Office files, etc) into Oracle, MSSQL and any databases with ODBC connection. The set of classes can be used on UNIX and NT platforms so jBLOB is universal and ultimate solution for ColdFusion developers who work with large data objects, stored in BLOB or CLOB fields.
Installation procedure has four steps:

1. Check/install JDBC drivers
2. Copy and register CFX tags
3. Create demo database MSSQLBLOB
4. Copy ColdFusion demo script to web server directory

Tag Syntax

<CFX_BLOBUPDATE 
	sqlServerName="127.0.0.1" 
	PortNumber="1433" 
	LOGIN="test" 
	PASSWORD="test" 
	QUERYSTRING="UPDATE [data_base]..[file_table] 
	             SET BIN=? WHERE FILEID = #FileID#" 
	FILENAME="#cffile.serverfile#"
	reload="Auto"
>

Note: demo version can store files with size up to 8000 bytes only! Free download: MSSQL version ODBC version ORACLE version (OCI8) ORACLE version (THIN) download page