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

Yoram Ayalon wrote:
> it is the issue you suspect! when I set the class path to use the older
> jdbc (classes12.zip) this problem went away.
>
> however, I cannot go back to that version since these drivers do not
> support updating CLOB fields with > 4K data... this is why we went to
> the latest JDBC drivers.
>
> I will ask coldFusion, but its an uphill battle to talk to these guys
> ever since they were gobbled by Adobe.
>
> anything anything else I might try ?
>
> is there any alternative in the market to Oracle JDBC, which does not
> cost zillions, like what DataDirect is asking?
>
> Yoram

Hi. I don't know of another commerical JDBC driver for Oracle, for free or purchase. If you used BEA's WebLogic you would have one... We don't offer a driver for use or purchase except with WebLogic.

Is coldFusion a java application? If you can add this argument to the java call, it should work. It defines the driver property as we would want it.

java -Doracle.jdbc.V8Compatible=true ....

In any case, we now know the issue, and cold fusion has to have a way of setting driver-specific properties... Good luck,
Joe Weinstein at BEA Systems Received on Wed Jul 19 2006 - 12:46:29 CDT