Re: JDBC output coming out as hex

In article <92eeeff0.0301272219.316e1662_at_posting.google.com>, Rauf Sarwar <rs_arwar_at_hotmail.com> wrote:
>postmaster_at_cjc.org (Cheng-Jih Chen) wrote in message news:<v3b062klb8601a_at_news.supernews.com>...
>> The server is running 9.2.0.2 on Windows, and we're connecting using
>> the JDBC thin client. The problem we're seeing is that SELECT output
>> from JDBC is coming out as hex; accessing the same data using SQLPlus
>> returns as regular characters.
>>
>> The same JDBC connecting to a 9.2.0.2 server on Solaris returns the
>> data correctly.
>>
>> NLS settings between the two servers are identical.
>>
>> Does anyone have any suggestions? Thanks.
>
>
>Are you seeing this behavior from the same client connecting to both
>databases on Sun and Windows? What is the server characterset?

We're seeing it only on connections to the Windows server. The client has always run on Windows. The server on Windows is 9i, same as on Solaris.

>When using thin/oci jdbc drivers, make sure you have this file in your
>classpath for full NLS conversion,
>[ORACLE_HOME]\jdbc\lib\nls_charset11.jar for jdk/jre 1.1
>[ORACLE_HOME]\jdbc\lib\nls_charset12.jar for jdk/jre 1.2, 1.3 or 1.4

We've tried that.

>Check Regional settings of your client. Unlike jdbc OCI driver and
>Sqlplus, thin jdbc driver does not have access to NLS settings in the
>registry. Instead, it reads Regional settings.
>
>Look at section "Known Problems/Limitations In This Release" in
>Readme.txt located under ORACLE_HOME\jdbc.

We'll give this a try. Received on Thu Jan 30 2003 - 16:38:45 CST