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.

1. 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)
2. 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.