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

[Guest]

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

[Guest]

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).

[Guest]

And this was for ColdFusion 8.1 and Oracle 10g, I believe.  Sorry for the multiple posts!