Dear all,
I am currently facing a Character Set issue with JDBC Adapter and JDBC OCI driver.
We want to retrieve data from an Oracle 8.1.7 database which using arabic character set “AR8ISO8859P6”.
Here is our environment :
OS HP-UX 11.23i Itanium 64
Integration Server 6.5
JDBC Adapter 6.5
JVM 1.4
Copied following Oracle driver files ojdbc14.jar, orai18n.jar in IntegrationServer/lib/jars
Oracle client 10.2.0
Target is database server is Oracle 8.1.7
Set properly following environment variables :
export NLS_LANG=AMERICAN_AMERICA.AR8ISO8859P6
export ORACLE_HOME=/oracle/client (Oracle client installation directory)
export CLASSPATH=/oracle/product/10.2.0/db_1/jlib/orai18n.jar:$ORACLE_HOME/jdbc/lib/ojdbc14.jar
export SHLIB_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/jdbc/lib:/oracle/product/10.2.0/db_1/lib
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/jdbc/lib:/oracle/product/10.2.0/db_1/lib
export PATH=/oracle/product/10.2.0/db_1/bin
While creating a JDBC connection to the Oracle 8.1.7 database.
- Using the thin driver, i have no problem to enable the connection but the retrieved characters are not proper arabic (this is normal because JDBC thin driver doesn’t support arabic character set)
- Using the oci driver, i can’t even enable the connection, i encounter following error :
[ART.118.5036] Adapter Runtime (Connection) : Unable to configure connection manager
t2cGetCharSet
Does anyone of you have an idea ?
Thanks,
Djibril.