Hi,

I am trying to insert German and French character data into 9i database running on Linux 32 bit. We are using java "thin" driver for this . When I insert data using SQL prompt, I am able to store it into the database, but when I try to do it with java program which uses "thin" driver, it throws the error " oracle.AQ.AQOracleSQLException: Cannot map Unicode to Oracle character " while storing French characters, but for German characters it works fine.

Is this a problem caused due to the "thin" driver which I am using or some jdk version problem. Can anybody put some light on this?

Thanks and Regards,
Manoj Rawat.

Quoting from Metalink

The Oracle Thin driver supports the following character sets
trough basic zip/jar files (classes111.zip, classes111.jar,
classes12.zip and classes12.jar, ojdbc14.jar) they contain all the
necessary classes to provide complete NLS support for:

- Oracle Character sets for CHAR/VARCHAR/LONGVARCHAR/CLOB type data
that is not retrieved or inserted as a data member of an Oracle 8
Object or Collection type.

- NLS support for CHAR/VARCHAR data members of Objects and
Collections for a few commonly used character sets. These
character sets are: US7ASCII, WE8DEC, WE8ISO8859P1 and UTF8.


If your database use a other character set (WE8ISO8859P15,WE8MSWIN1252,
EE8MSWIN1250,...)
you must include nls_charsetxx.zip/nls_charsetxx.jar in your CLASSPATH.

Hth
--
Sybrand Bakker
Senior Oracle DBA