Path: news.easynews.com!easynews!priapus.visi.com!news-out.visi.com!hermes.visi.com!newsfeed.media.kyoto-u.ac.jp!newsgate.cuhk.edu.hk!cuhk-bullish!newsfeeder.ust.hk!nntp.pacific.net.hk!not-for-mail
From: "Ming Fai" <mingfai@hongkong.com>
Newsgroups: comp.databases.oracle.server
Subject: Seek help on OCI JDBC problem
Date: Thu, 8 Aug 2002 21:37:39 +0800
Organization: Pacific Supernet Limited
Lines: 58
Message-ID: <aitsh8$87j$1@hfc.pacific.net.hk>
NNTP-Posting-Host: ip187.bb168.pacific.net.hk
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Xref: easynews comp.databases.oracle.server:157268
X-Received-Date: Thu, 08 Aug 2002 06:42:21 MST (news.easynews.com)

hi,

I've got seriously trouble in using OCI driver on both Linux and W2k. My DB
is on Linux, and the version is Oracle9i Release 9.0.1.0.0. The operation is
perfect when using thin driver. For OCI, I've tried all combination of
JDK1.3.1_03 and 1.4.0_01 with the OCI driver provides by the Oracle
installation and downloaded from technet. Could anybody help to answer the
following questions:

1. When using JDK 1.4.0_01, with ojdbc14.jar and nls_charset12.zip in
classpath. I got the following error:
java.sql.SQLException: Character Set Not Supported !!: DBConversion

note:
i. nls_lang is set, but it seems it's not relevent
NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1; export NLS_LANG

 when query nls_database_parameters, the following are the values:

PARAMETER        VALUE
------------------------------ ---------
NLS_LANGUAGE        AMERICAN
NLS_TERRITORY        AMERICA
NLS_CHARACTERSET    US7ASCII

i've tried to set NLS_LANG to US7ASCII as well.
NLS_LANG=AMERICAN_AMERICA.US7ASCII; export NLS_LANG

is it relevent at all?

ii. i tried to put the nls_charset12.zip/jar in the oracle installation and,
in the 2nd time, the one in 9.2.0.1 version downloaded from technet.

any idea? does anybody ever use OCI JDBC to connect to 9i successfully?


2. When using JDK 1.3.1_03, with classes12.jar/zip and nls_charset12.zip in
classpath. I got an exception with a monster code string
java.sql.SQLException: "tÈ ¿Ì È ¿W@HüV@ È ¿ìR@ôÈ ¿H]" (the quote is added by
me)

it seems to be a character set problem again. any idea?


3. Is there any difference between
jdbc:oracle:oci:@OraDB , and
jdbc:oracle:oci8:@OraDB ?

note: i've tried both, and tnsping to OraDB does work.


Could anybody who has successfully experience in using OCI JDBC driver share
his experience?

regards,
mingfai