At 02.42 06/09/2004, you wrote:
> Date: Sat, 04 Sep 2004 18:07:44 +0200
> To: [EMAIL PROTECTED]
> From: Andrea Gabellini <[EMAIL PROTECTED]>
> Subject: Re: Oracle bug report
> Reply-To: [EMAIL PROTECTED]
>
> Hi,
>
> looking at the code, the server return SQL_DOWN if there is
> any type of error.
>
> Errors like "ORA-01401: inserted value too large for column"
> are set by the
> Oracle server, so the server is up and running.
>
> In this situation it's not a good idea to reconnect the socket.
>
> Performing some tests, I found two specific errors that mean
> "database
> down": ORA-03113 and ORA-03114.
>
> So I wrote a new function, sql_check_error (like the mysql one), that
> checks the error code and return SQL_DOWN or -1.
>
> I don't know if this solve the bug, but surely it manages
> better the query.
>
> In this patch I set the "commit on success".
>
I am of the belief that this is an Oracle 8 (8.1.7.0.0) problem. The machine I'm running on, was upgraded to Oracle 9.2 last week. The problem still occurred if I used the the Oracle 8 Shared Libs. However, it disappears when using the 9.2 versions of those libs.
I'm using the 8.1.7 library to connect to a 9.2 database. I can't upgrade my library because I'm working with Solaris and x86 hardware. The last oracle client for this platform is the 8.1.
If this is a bug of the library I'm very happy, but I think that the oracle driver in FR must manage better the OCI_ERROR condition.
Actually EVERY error returns SQL_DOWN, and this is not correct if the error is generated by the server because the server is up and running.
Andrea
Perhaps, there is a patch for Oracle 8 that addresses this issue.
Regards, Omar El-Hassan
--------------------------------------- Television... a medium. So called because it is neither rare nor well-done. --------------------------------------- Ing. Andrea Gabellini Email: [EMAIL PROTECTED] Tel: 0549 886111 (Italy) Tel. +378 0549 886111 (International)
Intelcom San Marino S.p.A. Strada degli Angariari, 3 47891 Rovereta Repubblic of San Marino
http://www.omniway.sm http://www.intelcom.sm
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
