Re: non supported character set characterset error

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 12 Feb 2005 16:29:00 -0800
Message-ID: <1108254540.813278.221420@o13g2000cwo.googlegroups.com>

gbegley_at_gmail.com wrote:
> nls_charset12.jar _IS_ on my classpath but I am still getting an
> unsupported character set error. (Non supported character set:
> oracle-character-set-178)
>
> If anyone knows why, I would love to know.
>
> Here are the details
>
> // Table defined as
> CREATE TABLE xml_store (
> id NUMBER,
> doc_type_cr_fk NUMBER,
> ref_name VARCHAR(64),
> xml_data XMLType,
> PRIMARY KEY ( id )
> );
>
> PreparedStatement st = ...
> String s = "<?xml version=\"1.0\" encoding=\"UTF-8\"?><update>Test:
> "+new java.util.Date()+"</update>";
> XMLType xt = XMLType.createXML(connection,s);
> ((OraclePreparedStatement)st).setOPAQUE( index, xt );
>
> gives the following error:
>
> Hibernate: update XML_STORE set REF_NAME=?, DOC_TYPE_CR_FK=?,
> XML_DATA=? where ID=?
> 5949 [main] WARN net.sf.hibernate.util.JDBCExceptionReporter - SQL
> Error: 17056, SQLState: null
> 5949 [main] ERROR net.sf.hibernate.util.JDBCExceptionReporter - Non
> supported character set: oracle-character-set-178
> 5949 [main] ERROR net.sf.hibernate.util.JDBCExceptionReporter -
could
> not update: [com.epacube.data.model.XmlStore#1]
> 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(CharacterSetFactoryThin.java:171)
> at
>

oracle.sql.CharacterSetUnknown.convert(CharacterSetFactoryThin.java:135)
> at oracle.xdb.XMLType.getBytesString(XMLType.java:1215)
> at oracle.xdb.XMLType.getBytesValue(XMLType.java:1151)
> at oracle.xdb.XMLType.toDatum(XMLType.java:323)
> at oracle.xdb.XMLType.toBytes(XMLType.java:1274)
> at
>

oracle.jdbc.driver.OraclePreparedStatement.setOPAQUE(OraclePreparedStatement.java:1757)
> at
>

com.epacube.dao.HibernateOXMLType.nullSafeSet(HibernateOXMLType.java:63)
> at
> net.sf.hibernate.type.CustomType.nullSafeSet(CustomType.java:118)
> at
>

net.sf.hibernate.persister.EntityPersister.dehydrate(EntityPersister.java:394)
> at
>

net.sf.hibernate.persister.EntityPersister.update(EntityPersister.java:693)
> at
>

net.sf.hibernate.persister.EntityPersister.update(EntityPersister.java:668)
> at
>

net.sf.hibernate.impl.ScheduledUpdate.execute(ScheduledUpdate.java:53)
> at
> net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2306)
> at
> net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2260)
> at
> net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2185)
> at
>

com.epacube.test.XMLStoreTest.testXmlStoreUpdate(XMLStoreTest.java:82)
>
>

ClassPath:C:\IntelliJ\3.0.5\lib\junit.jar;C:\home\ibm\AppServer\java\jre\lib\i18n.jar;C:\home\ibm\AppServer\java\jre\lib\jaws.jar;C:\home\ibm\AppServer\java\jre\lib\rt.jar;C:\home\ibm\AppServer\java\jre\lib\ext\activation.jar;C:\home\ibm\AppServer\java\jre\lib\ext\certpath.jar;C:\home\ibm\AppServer\java\jre\lib\ext\classes12.jar;C:\home\ibm\AppServer\java\jre\lib\ext\ibmjcefips.jar;C:\home\ibm\AppServer\java\jre\lib\ext\ibmjcefw.jar;C:\home\ibm\AppServer\java\jre\lib\ext\ibmjceprovider.jar;C:\home\ibm\AppServer\java\jre\lib\ext\ibmjgssprovider.jar;C:\home\ibm\AppServer\java\jre\lib\ext\ibmjsse.jar;C:\home\ibm\AppServer\java\jre\lib\ext\ibmjssefips-ob.jar;C:\home\ibm\AppServer\java\jre\lib\ext\ibmorb.jar;C:\home\ibm\AppServer\java\jre\lib\ext\ibmpkcs.jar;C:\home\ibm\AppServer\java\jre\lib\ext\ibmpkcs11.jar;C:\home\ibm\AppServer\java\jre\lib\ext\ibmspnego.jar;C:\home\ibm\AppServer\java\jre\lib\ext\indicim.jar;C:\home\ibm\AppServer\java\jre\lib\ext\iwsorbutil.jar;C:\home\ibm\AppServer\java\jre\lib\ext\jaas.jar;
C:\home\ibm\AppServer\java\jre\lib\ext\jaas_activelm.jar;C:\home\ibm\AppServer\java\jre\lib\ext\jaas_lm.jar;C:\home\ibm\AppServer\java\jre\lib\ext\JawBridge.jar;C:\home\ibm\AppServer\java\jre\lib\ext\local_policy.jar;C:\home\ibm\AppServer\java\jre\lib\ext\log.jar;C:\home\ibm\AppServer\java\jre\lib\ext\mail.jar;C:\home\ibm\AppServer\java\jre\lib\ext\PD.jar;C:\home\ibm\AppServer\java\jre\lib\ext\runtime12.jar;C:\home\ibm\AppServer\java\jre\lib\ext\US_export_policy.jar;C:\home\epacube\v2\lib\junittesthelper-v20040130-SDI-MOD.jar;C:\home\epacube\v2\unit-test\classes;C:\ibm\web\epaCUBE2.ear\epacubeII.war\WEB-INF\lib\jstl-v1.0.jar;C:\home\epacube\v2\lib\jakarta-tag-standard-v1.0.5.jar;C:\home\ibm\web\epaCUBE2.ear\epacubeII.war\WEB-INF\classes;C:\home\ibm\web\epaCUBE2.ear\activation.jar;C:\home\ibm\web\epaCUBE2.ear\appclasses.jar;C:\home\ibm\web\epaCUBE2.ear\asf-adm-vBO61.jar;C:\home\ibm\web\epaCUBE2.ear\asf-java-vBO61.jar;C:\home\ibm\web\epaCUBE2.ear\aspectjrt-v1.1.1.jar;C:\home\ibm\web\epaCUBE2.ear\bo-orb-vBO61.j
ar;C:\home\ibm\web\epaCUBE2.ear\bolib.jar;C:\home\ibm\web\epaCUBE2.ear\bsh-v2.0b1.jar;C:\home\ibm\web\epaCUBE2.ear\cactus-ant-v1.5.jar;C:\home\ibm\web\epaCUBE2.ear\cactus-v1.5.jar;C:\home\ibm\web\epaCUBE2.ear\cglib-full-v2.0-RC2.jar;C:\home\ibm\web\epaCUBE2.ear\commons-collections-v2.1.jar;C:\home\ibm\web\epaCUBE2.ear\commons-httpclient-v2.0-rc2.jar;C:\home\ibm\web\epaCUBE2.ear\commons-lang-v1.0.1.jar;C:\home\ibm\web\epaCUBE2.ear\commons-logging-v1.0.3.jar;C:\home\ibm\web\epaCUBE2.ear\crimson-v1.1.3.jar;C:\home\ibm\web\epaCUBE2.ear\dom4j-core-v1.4.jar;C:\home\ibm\web\epaCUBE2.ear\ehcache-v0.7.jar;C:\home\ibm\web\epaCUBE2.ear\hibernate-v2.1-final.jar;C:\home\ibm\web\epaCUBE2.ear\httpunit-v1.5.3.jar;C:\home\ibm\web\epaCUBE2.ear\infoview-vBO61.jar;C:\home\ibm\web\epaCUBE2.ear\ivcdzview-vBO61.jar;C:\home\ibm\web\epaCUBE2.ear\jakarta-tag-standard-v1.0.5.jar;C:\home\ibm\web\epaCUBE2.ear\jaxp-v1.2.jar;C:\home\ibm\web\epaCUBE2.ear\jsp-api-v2.0.jar;C:\home\ibm\web\epaCUBE2.ear\junit-v3.8.1.jar;C:\home\ibm\web\epaCUBE
2.ear\log4j-v1.2.8.jar;C:\home\ibm\web\epaCUBE2.ear\mockobjects-core-0.09.jar;C:\home\ibm\web\epaCUBE2.ear\mockobjects-jdk1.3-j2ee1.3-0.09.jar;C:\home\ibm\web\epaCUBE2.ear\ocrs-v1.2.jar;C:\home\ibm\web\epaCUBE2.ear\odmg-v3.0.jar;C:\home\ibm\web\epaCUBE2.ear\ognl-v2.6.3-webwork-mod.jar;C:\home\ibm\web\epaCUBE2.ear\oracle-classes-v9.2.0.3.jar;C:\home\ibm\web\epaCUBE2.ear\oscore-v2.2.2.jar;C:\home\ibm\web\epaCUBE2.ear\osuser-v1.0-20031230.jar;C:\home\ibm\web\epaCUBE2.ear\osworkflow-v2.7.0.jar;C:\home\ibm\web\epaCUBE2.ear\propertyset-v1.3-20031225.jar;C:\home\ibm\web\epaCUBE2.ear\quartz-v1.4.1.jar;C:\home\ibm\web\epaCUBE2.ear\rowset-vJSR114.jar;C:\home\ibm\web\epaCUBE2.ear\seraph-v0.6-SDI-MOD.jar;C:\home\ibm\web\epaCUBE2.ear\servlet-api-v2.4.jar;C:\home\ibm\web\epaCUBE2.ear\sitemesh-v2.0.jar;C:\home\ibm\web\epaCUBE2.ear\velocity-v1.3.1.jar;C:\home\ibm\web\epaCUBE2.ear\webi-vBO61.jar;C:\home\ibm\web\epaCUBE2.ear\webwork-v2.0-beta2.jar;C:\home\ibm\web\epaCUBE2.ear\wiserv-vBO61.jar;C:\home\ibm\web\epaCUBE2.ear\wito
ols-vBO61.jar;C:\home\ibm\web\epaCUBE2.ear\xalan-v2.5.2.jar;C:\home\ibm\web\epaCUBE2.ear\xerces-v2.4.0.jar;C:\home\ibm\web\epaCUBE2.ear\xwork-v1.0-beta2.jar;C:\home\ibm\AppServer\lib\j2ee.jar;C:\home\ibm\AppServer\lib\naming.jar;C:\home\ibm\AppServer\lib\ras.jar;C:\home\epacube\v2\lib\mockobjects-jdk1.3-j2ee1.3-0.09.jar;C:\home\epacube\v2\lib\mockobjects-core-0.09.jar;C:\home\ibm\web\epaCUBE2.ear\nls_charset12.jar;C:\home\ibm\web\epaCUBE2.ear\appclasses.jar;C:\home\ibm\web\epaCUBE2.ear\activation.jar;C:\home\ibm\web\epaCUBE2.ear\asf-adm-vBO61.jar;C:\home\ibm\web\epaCUBE2.ear\asf-java-vBO61.jar;C:\home\ibm\web\epaCUBE2.ear\aspectjrt-v1.1.1.jar;C:\home\ibm\web\epaCUBE2.ear\bo-orb-vBO61.jar;C:\home\ibm\web\epaCUBE2.ear\bolib.jar;C:\home\ibm\web\epaCUBE2.ear\bsh-v2.0b1.jar;C:\home\ibm\web\epaCUBE2.ear\cactus-ant-v1.5.jar;C:\home\ibm\web\epaCUBE2.ear\cactus-v1.5.jar;C:\home\ibm\web\epaCUBE2.ear\cglib-full-v2.0-RC2.jar;C:\home\ibm\web\epaCUBE2.ear\commons-beanutils-v1.6.jar;C:\home\ibm\web\epaCUBE2.ear\commons-col

lections-v2.1.jar;C:\home\ibm\web\epaCUBE2.ear\commons-httpclient-v2.0-rc2.jar;C:\home\ibm\web\epaCUBE2.ear\commons-lang-v1.0.1.jar;C:\home\ibm\web\epaCUBE2.ear\commons-logging-v1.0.3.jar;C:\home\ibm\web\epaCUBE2.ear\crimson-v1.1.3.jar;C:\home\ibm\web\epaCUBE2.ear\dom4j-core-v1.4.jar;C:\home\ibm\web\epaCUBE2.ear\ehcache-v0.7.jar;C:\home\ibm\web\epaCUBE2.ear\hibernate-v2.1-final.jar;C:\home\ibm\web\epaCUBE2.ear\httpunit-v1.5.3.jar;C:\home\ibm\web\epaCUBE2.ear\infoview-vBO61.jar;C:\home\ibm\web\epaCUBE2.ear\ivcdzview-vBO61.jar;C:\home\ibm\web\epaCUBE2.ear\jakarta-tag-standard-v1.0.5.jar;C:\home\ibm\web\epaCUBE2.ear\jaxp-v1.2.jar;C:\home\ibm\web\epaCUBE2.ear\jsp-api-v2.0.jar;C:\home\ibm\web\epaCUBE2.ear\junit-v3.8.1.jar;C:\home\ibm\web\epaCUBE2.ear\log4j-v1.2.8.jar;C:\home\ibm\web\epaCUBE2.ear\mockobjects-core-0.09.jar;C:\home\ibm\web\epaCUBE2.ear\mockobjects-jdk1.3-j2ee1.3-0.09.jar;C:\home\ibm\web\epaCUBE2.ear\ocrs-v1.2.jar;C:\home\ibm\web\epaCUBE2.ear\odmg-v3.0.jar;C:\home\ibm\web\epaCUBE2.ear\ognl-v2.6.3-web work-mod.jar;C:\home\ibm\web\epaCUBE2.ear\oracle-classes-v9.2.0.3.jar;C:\home\ibm\web\epaCUBE2.ear\oscore-v2.2.2.jar;C:\home\ibm\web\epaCUBE2.ear\osuser-v1.0-20031230.jar;C:\home\ibm\web\epaCUBE2.ear\osworkflow-v2.7.0.jar;C:\home\ibm\web\epaCUBE2.ear\propertyset-v1.3-20031225.jar;C:\home\ibm\web\epaCUBE2.ear\quartz-v1.4.1.jar;C:\home\ibm\web\epaCUBE2.ear\rowset-vJSR114.jar;C:\home\ibm\web\epaCUBE2.ear\seraph-v0.6-SDI-MOD.jar;C:\home\ibm\web\epaCUBE2.ear\servlet-api-v2.4.jar;C:\home\ibm\web\epaCUBE2.ear\sitemesh-v2.0.jar;C:\home\ibm\web\epaCUBE2.ear\velocity-v1.3.1.jar;C:\home\ibm\web\epaCUBE2.ear\webi-vBO61.jar;C:\home\ibm\web\epaCUBE2.ear\webwork-v2.0-beta2.jar;C:\home\ibm\web\epaCUBE2.ear\wiserv-vBO61.jar;C:\home\ibm\web\epaCUBE2.ear\witools-vBO61.jar;C:\home\ibm\web\epaCUBE2.ear\xalan-v2.5.2.jar;C:\home\ibm\web\epaCUBE2.ear\xerces-v2.4.0.jar;C:\home\ibm\web\epaCUBE2.ear\xwork-v1.0-beta2.jar;C:\home\ibm\web\epaCUBE2.ear\epacube.war\WEB-INF\classes;C:\oracle\ora92\sqlj\lib\runtime12.jar;C:\home\ibm\web\epaC UBE2.ear\xdb.jar;C:\home\ibm\web\epaCUBE2.ear\xmlparserv2.jar;C:\IntelliJ\3.0.5\lib\idea_rt.jar

I cannot locate nls_charset12.jar or zip file in the classpath that you have posted.

Regards
/Rauf Received on Sat Feb 12 2005 - 18:29:00 CST