Thank you. It really worked.  Here is the command I used:

<cfquery name="insertJavaObject" dataSource="#Application.ds#">

          INSERT INTO unqualified_list_t (my_id, unqualified_list) values (

                                <cfqueryPARAM value = "#his.getMyId()#" CFSQLType = 'CF_SQL_BIGINT'>,

                              <cfqueryPARAM value = "#his#" CFSQLType = 'CF_SQL_OTHER'>  )

</cfquery>

his is a Java object. But How do I read back...I am a little frustrated working with ColdFusion. Because Google search does not provide good results for topics related to ColdFusion. I don't know why, I tried like 2hours still can find't out how to read back. I can read back as normal but it is a Byte Array object. What tag can I use to conver it to Java object? The below is the read statement. After this I try to display the BLOB object read, it says "

ByteArray objects cannot be converted to strings."

Then I tried Google search but can't find any threads useful....

Thank you for helping!!

<cfquery name="readJavaObject" dataSource="#Application.ds#">

          select *

          from unqualified_list_t

</cfquery>

I want to add one more question see if anyone knows the answer.

The following method "saveJavaObject" will save the Java object "his" to a database table. In the signature of saveJavaObject method, its cfargument for "theObject" is of type any. But the "his" object passed in that method becomes other type, I think it becomes String type. Anyone knows how to make sure "his" passed to the method saveJavaObject remains "any" type? Thank you!!

<cfinvoke component="aCFCComponent" method="saveJavaObject" returnvariable="result" >

<cfinvokeargument name="theObject" value="his"/>

</cfinvoke>

Good to see you again cfSearching!

Adding # sign really works. I thought I tried # last time...but anyway, thanks.

Also, #his# is a Java object. So using CF_SQL_LONGVARBINARY or CF_SQL_BLOB as the type does not work. The system reports can't convert to '[B' if I use CF_SQL_BLOB, and it reports data invalid error if I use SQL_LONGVARBINARY.

Thanks, finally able to write Java object to MySQL and read it back from MySQL. Great!

I have one more question see if you know the answer.

Below is the block of code I used to read the BLOB back from MySQL then convert it to a Java object. In particular, I use this line "<cfset var bytes = rs.getBytes("unqualified_list")>" to read the BLOB back. I have to use "unqualified_list" String to read it. I can't use an integer index to read it, something like <cfset var bytes = rs.getBytes(1)>. The system will report column '1' not found. Obviously it treats the integer 1 as "1". Do you know a way to work around it?

Thanks!!!

what....I have spent this much time doing something that exist in CF 9 already...