Re: strange problem using DATE fields from coldfusion/MX (jdbc)

From: <joeNOSPAM_at_BEA.com>
Date: 19 Jul 2006 08:54:09 -0700
Message-ID: <1153324449.618465.272700@p79g2000cwp.googlegroups.com>

Yoram Ayalon wrote:
> Joe,
>
> I hope you can help me, since I am stuck between Oracle and Adobe, each
> blaming the other...
>
> I tried to add the parameters to the connection string, the obvious way
> was Data Sources section of the ColdFusion, which is where you define
> all the parameters to the JDBC driver. they have a section calls
> "connection string", under "advanced settings", which was empty, and I
> added the string you specified. no luck. I noticed that after some
> time, either a reset of ColdFusion or a reboot, these settings get
> erased.
>
> these are the settings on the machine as reported by coldFusion. in the
> summary of the data source you don't see the connection string.
>
> I am no Java expert. I see no other place where to configure the JDBC
> connection and add to it the connection parameter.
>
> the JDBC driver we are using is the oracle 10g, ojdbc14.jar
>
> Java and JVM
> ===============
> Java virtual machine path C:/CFusionMX7/runtime/jre
> Initial memory size MB
> Maximum memory size 512 MB
> Class path
> -Dcoldfusion.classPath={application.home}/../../classes,{application.home}/../lib/updates,{application.home}/../lib/,{application.home}/../gateway/lib/,{application.home}/../wwwroot/WEB-INF/cfform/jars,D:\oracle\ora92\jdbc\lib\10_ojdbc14.jar
>
> JVM arguments -server -Dsun.io.useCanonCaches=false
> -XX:MaxPermSize=128m -Dcoldfusion.rootDir={application.home}/../
> -Dcoldfusion.libPath={application.home}/../lib
>
>
> oracle_develop (the data source we are trying to configure)
> ===============
> CF data source name oracle_develop
> Description
> Driver
> JDBC URL jdbc:oracle:thin:@dbdevelop:1521:FDEV12
> Username devuser
> Login timeout 30 seconds
> Long text buffer size 64000
> Timeout 1200 seconds
> Maintain connections Yes
> Interval 420 seconds
> Restricted SQL operations
> Disable connections No

Ok, two things:
1 - Ask ColdFusion how to set driver-specific properties, such as in the standard JDBC:

Properties p = new Properties();

p.put("user", "scott");
p.put("password", "tiger");
p.put("oracle.jdbc.V8Compatible", "true");

conn =
DriverManager.getConnection("jdbc:oracle:thin:@dbdevelop:1521:FDEV12", p );

2 - Try substituting an old version of Oracle's driver instead of the ojdbc14.jar.
Try an 8.1.7 version of their classes12.zip, and see if it works without the
new property. That will prove it's the issue I suspect.

Joe Weinstein at BEA Systems Received on Wed Jul 19 2006 - 10:54:09 CDT