Geoff,
thanks for listing the concrete issues you had with the Oracle drivers.
I agree, one should expect every software to have some subtle and yet
unknown bugs, but if support is not willing to help, that's definitely
very disappointing.
Regards,
Heinz Wehner
(Karlsruhe, Germany)
> -----Urspr�ngliche Nachricht-----
>
> There's a standard JDBC method called PreparedStatement.setBinaryStream
> which doesn't work on Blob objects even though it should. Oracle tried to
> argue that it wasn't in the spec but Sun said it was so they had to admit
> "it will be more 'complete' if PreparedStatement.setBinaryStream() was
> allowed to write to a BLOB directly". Then they tried to tell me to use
> their proprietary API - yuck! Here's the comment thats going to be in the
> readme for the 8.1.6 version of the driver
>
> " There is a limitation regarding the use of stream input for LOB
> types. Stream input for LOB types can only be used for 8.1.6
> JDBC OCI driver connecting to an 8.1.6 Oracle server. The use of
> stream input for LOB types in all other configurations may result
> in data corruption. PreparedStatement stream input APIs include:
> setBinaryStream(), setAsciiStream(), setUnicodeStream(),
> setCharacterStream() and setObject(). "
>
> I think other than that it's probably spec complaint. I would say if you
> are going to use BLOBs, avoid the Oracle drivers. Thats where we had all
> our problems. If not, you're probably OK. Also, if you want support in
> case of problems, go for a payware driver.
>
> Also, don't even think about using LONG RAW, there's a concurrency bug in
> the Oracle drivers which Oracle have refused to fix...!
>
> Geoff
>
>
> -----Original Message-----
>
>> Geoff,
>>
>> since we are currently in the process of deciding which JDBC driver
>> should be used for accessing an Oracle8i database, I'd like to ask you
>> for some more details regarding the non-conformance of Oracle's drivers.
>> Can you please elaborate? We'd like to check if these problems are
>> really that serious for us as they must have been for you.
>>
>> Regards,
>>
>> Heinz Wehner
>> (Karlsruhe, Germany)
>>
>>
>>> -----Urspr�ngliche Nachricht-----
>>>
>>> Actually, both of Oracle's drivers _suck_. I'd suggest using a quality
>>> payware third party driver like Merant or Weblogic if you want a stable
>>> driver!
>>>
>>> We've had to do all sorts of evil workarounds to get the Oracle driver
>>> to work. And then when you try and report bugs you have to contend with
>>> Oracle claiming their driver is JDBC compliant when even Sun agree it's
>>> not... They bring new meaning to the word "support".. :-)
>>>
>>> Cheers
>>>
>>> Geoff
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
