SQLException: Non supported character set: oracle-character-set-178
400826Aug 6 2003 — edited Oct 1 2003Hello,
I run a j2ee application on the Sun J2EE Application server.
I migrated to 0racle 9.2.0.3.
I have an ejb making a connexion with the oci driver
and in it I manipulate XMLType:
PreparedStatement pst = cnx.prepareStatement(sql);
XMLType xt = XMLType.createXML(cnx, "<ENTETE></ENTETE>");
pst.setObject(1, xt);
I've got an exception on the setObject method :
java.sql.SQLException: Non supported character set: oracle-character-set-178
at oracle.gss.util.NLSError.throwSQLException(NLSError.java:46)
at oracle.sql.CharacterSetUnknown.failCharsetUnknown(CharacterSetFactory
Thin.java:171)
at oracle.sql.CharacterSetUnknown.convert(CharacterSetFactoryThin.java:1
35)
at oracle.xdb.XMLType.getBytesString(XMLType.java:1687)
at oracle.xdb.XMLType.getBytesValue(XMLType.java:1623)
at oracle.xdb.XMLType.toDatum(XMLType.java:431)
at oracle.jdbc.driver.OraclePreparedStatement.setORAData(OraclePreparedS
tatement.java:2745)
at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedSt
atement.java:3208)
I have the nsl_charset12.zip , ojdbc14.jar,xdb.jar,xmlparserv2.jar in the J2EE_CLASSPATH of my server.
Does any one have an idea.
Thanks , Edwige