SOLVED: oracle.sql.TIMESTAMP cannot be cast to java.lang.Comparable null

Question

I'm posting this here so that hopefully, if some other ColdFusion user has the same problem in the future, it might be easier for them to solve than it was for us.

The first error we came across in relation to this is in the subject, but I'll put it here too:

oracle.sql.TIMESTAMP cannot be cast to java.lang.Comparable null

Also, we encountered another similar error:

oracle.sql.TIMESTAMP cannot be converted to a date

After hours of messing around with it, we finally came across this post: http://www.altova.com/forum/default.aspx?g=postmessage&t=1000001733&f=38

Basically, adding this line to the JVM settings in the ColdFusion Admin screen will do:

-Doracle.jdbc.J2EE13Compliant=true

Enjoy!

Anton

Anonymous · Answer

Oh, and remember that changing this setting will affect all ColdFusion applications on your server, so you may need to test them to make sure they still work properly (like we're having to do right now).

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded