ORA-17059 
Author Message
 ORA-17059
What may cause an ORA-17059 exception ?
I use JDBC thin driver and Oracle8i Release 3 on Solaris 8.
My JDBC client and Oracle8i server are on the same box.

Thanks in advance.



Mon, 21 Feb 2005 03:50:15 GMT
 ORA-17059

The character set used in database is US7ASCII.
None of those NLS parameters are set in environment when the client is
started up.


Quote:
> What may cause an ORA-17059 exception ?
> I use JDBC thin driver and Oracle8i Release 3 on Solaris 8.
> My JDBC client and Oracle8i server are on the same box.

> Thanks in advance.



Mon, 21 Feb 2005 04:32:31 GMT
 ORA-17059
On Wed, 4 Sep 2002 15:50:15 -0400, "Harry Sheng"

Quote:

>What may cause an ORA-17059 exception ?
>I use JDBC thin driver and Oracle8i Release 3 on Solaris 8.
>My JDBC client and Oracle8i server are on the same box.

>Thanks in advance.

I see you expect this group is going to look up the error text for
you.
You are mistaken in that.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address



Mon, 21 Feb 2005 06:24:33 GMT
 ORA-17059
Hi, Sybrand

The error message says "Fail to convert to internal representation".
What I really want to know is, fail to convert [what] to internal
representation.
I only find that ORA-17059 is a TTC adapter exception, and no other further
information could be found from the net.

So I can only guess that client and server use different character set,
and at some point Oracle failed to convert one character set to the other.

But how could this happen ? The character set used in server is US7ASCII,
and none of those NLS parameters are set in the client environment. Besides,
the client and server stay on the same Solaris8 box.

Could you please kindly tell me what may cause this ORA-17059 error ?

Thanks alot.

Harry


Quote:
> On Wed, 4 Sep 2002 15:50:15 -0400, "Harry Sheng"

> >What may cause an ORA-17059 exception ?
> >I use JDBC thin driver and Oracle8i Release 3 on Solaris 8.
> >My JDBC client and Oracle8i server are on the same box.

> >Thanks in advance.

> I see you expect this group is going to look up the error text for
> you.
> You are mistaken in that.

> Regards

> Sybrand Bakker, Senior Oracle DBA

> To reply remove -verwijderdit from my e-mail address



Mon, 21 Feb 2005 09:39:47 GMT
 ORA-17059
hmmm .. don't remember ever seeing that error.
If you think that it is being caused by a particular data.
Try finding out what data it is.
Then do this query in oracle:

select col_name, dump(col_name)
from the_table
where .... <appropriate where clause>
/

See if the data has non-us7ascii data in it?

Java... afaik .. works in ucs2 charset ... so it might be
trying to convert the us7ascii data into ucs2 .. and fails in that.
17059 is a jdbc error code.

If you don't set nls_lang .. it should default to us7ascii in solaris.

Anurag

Quote:

> Hi, Sybrand

> The error message says "Fail to convert to internal representation".
> What I really want to know is, fail to convert [what] to internal
> representation.
> I only find that ORA-17059 is a TTC adapter exception, and no other further
> information could be found from the net.

> So I can only guess that client and server use different character set,
> and at some point Oracle failed to convert one character set to the other.

> But how could this happen ? The character set used in server is US7ASCII,
> and none of those NLS parameters are set in the client environment. Besides,
> the client and server stay on the same Solaris8 box.

> Could you please kindly tell me what may cause this ORA-17059 error ?

> Thanks alot.

> Harry



> > On Wed, 4 Sep 2002 15:50:15 -0400, "Harry Sheng"

> > >What may cause an ORA-17059 exception ?
> > >I use JDBC thin driver and Oracle8i Release 3 on Solaris 8.
> > >My JDBC client and Oracle8i server are on the same box.

> > >Thanks in advance.

> > I see you expect this group is going to look up the error text for
> > you.
> > You are mistaken in that.

> > Regards

> > Sybrand Bakker, Senior Oracle DBA

> > To reply remove -verwijderdit from my e-mail address



Mon, 21 Feb 2005 11:37:39 GMT
 ORA-17059
Hello!

Could we see code?

Sergey M.



Quote:
> What may cause an ORA-17059 exception ?
> I use JDBC thin driver and Oracle8i Release 3 on Solaris 8.
> My JDBC client and Oracle8i server are on the same box.

> Thanks in advance.



Mon, 21 Feb 2005 23:35:23 GMT
 
 [ 6 post ] 

 Relevant Pages 

1. SQL Errors 17059 and 17882 -- help

2. 17059-NC-RALEIGH/DURHAM-Crystal Reports-MS ACCESS-MS EXCHANGE-ODBC-ORACLE-UNIX-V

3. 17059-NC-RALEIGH/DURHAM-Crystal Reports-MS ACCESS-MS EXCHANGE-ODBC-ORACLE-UNIX-V

4. 17059-NC-RALEIGH/DURHAM-Crystal Reports-MS ACCESS-MS EXCHANGE-ODBC-ORACLE-UNIX-V

5. 17059-NC-RALEIGH/DURHAM-Crystal Reports-MS ACCESS-MS EXCHANGE-ODBC-ORACLE-UNIX-V

6. 17059-NC-RALEIGH/DURHAM-Crystal Reports-MS ACCESS-MS EXCHANGE-ODBC-ORACLE-UNIX-V

7. 17059-NC-RALEIGH/DURHAM-Crystal Reports-MS ACCESS-MS EXCHANGE-ODBC-ORACLE-UNIX-V

8. MDSE 2000 setup failed - Could not set up Net-Library 'SSNETLIB'.. Error: 17059, Severity: 18, State: 0

9. tnsnames.ora, sqlnet.ora, listner.ora

10. Create new DB errors (ORA-01610, ORA-01194, ORA-01110)

11. Error: ORA-01034, ORA-09243, ORA-02042


 
Powered by phpBB® Forum Software