Question
cannot be cast to coldfusion.server.j2ee.sql.JRunConnectionHandle
I searched under all categories in this support forum and did
not
get back even one result.
search string used:
"cannot be cast to coldfusion.server.j2ee.sql.JRunConnectionHandle"
Has anyone else encountered this error?
I'm on Windows 2003 and XP, Tomcat 6.0.14 and using JNDI Datasources.
I'm going from CF 8.0 Enterprise hot fix 2 to CF 8.0 Enterprise
hot fix 3. And I'm connecting to Oracle 10.2 RAC.
The full error message reads as follows:
Error casting an object of type org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper cannot be cast to coldfusion.server.j2ee.sql.JRunConnectionHandle 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. org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper cannot be cast to coldfusion.server.j2ee.sql.JRunConnectionHandle
Everything was working fine until I applied cumulative hot fix 3.
http://www.adobe.com/go/kb403070
If I un-install the update, I don't get the error.
It seems the issue is related to cumulative hot fix 3 AND the use
of the <cfqueryparam ... /> tag.
Meaning, this works...
<cfquery name="qData" datasource="ds">
SELECT * FROM some_table
WHERE some_column = 'some_value'
</cfquery>
But this does not work...
<cfquery name="qData" datasource="ds">
SELECT * FROM some_table
WHERE some_column = <cfqueryparam value="some_value" cfsqltype="cf_sql_varchar" />
</cfquery>
If you have any thoughts, please let me know. I am really motivated
to get this working.
get back even one result.
search string used:
"cannot be cast to coldfusion.server.j2ee.sql.JRunConnectionHandle"
Has anyone else encountered this error?
I'm on Windows 2003 and XP, Tomcat 6.0.14 and using JNDI Datasources.
I'm going from CF 8.0 Enterprise hot fix 2 to CF 8.0 Enterprise
hot fix 3. And I'm connecting to Oracle 10.2 RAC.
The full error message reads as follows:
Error casting an object of type org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper cannot be cast to coldfusion.server.j2ee.sql.JRunConnectionHandle 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. org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper cannot be cast to coldfusion.server.j2ee.sql.JRunConnectionHandle
Everything was working fine until I applied cumulative hot fix 3.
http://www.adobe.com/go/kb403070
If I un-install the update, I don't get the error.
It seems the issue is related to cumulative hot fix 3 AND the use
of the <cfqueryparam ... /> tag.
Meaning, this works...
<cfquery name="qData" datasource="ds">
SELECT * FROM some_table
WHERE some_column = 'some_value'
</cfquery>
But this does not work...
<cfquery name="qData" datasource="ds">
SELECT * FROM some_table
WHERE some_column = <cfqueryparam value="some_value" cfsqltype="cf_sql_varchar" />
</cfquery>
If you have any thoughts, please let me know. I am really motivated
to get this working.
