Getting java.sql.SQLException: Non supported character set (add orai18n.jar in your classpath): JA16SJISTILDE with Oracle JDBC Driver on JBoss EAP 7
Issue
The following exception is thrown when executing SQL query on a connection taken from a JBoss EAP data source:
21:10:29,048 ERROR [io.undertow.request] (default task-1) UT005023: Exception handling request to /jdbc-test/query: java.lang.RuntimeException: java.sql.SQLException: Non supported character set (add orai18n.jar in your classpath): JA16SJISTILDE
at deployment.jdbc-test.war//com.redhat.gss.sample.servlet.QueryBookServlet.doGet(QueryBookServlet.java:41)
at javax.servlet.api@2.0.0.Final-redhat-00001//javax.servlet.http.HttpServlet.service(HttpServlet.java:503)
at javax.servlet.api@2.0.0.Final-redhat-00001//javax.servlet.http.HttpServlet.service(HttpServlet.java:590)
...
Caused by: java.sql.SQLException: Non supported character set (add orai18n.jar in your classpath): JA16SJISTILDE
at com.oracle@19.18.0.0.0//oracle.sql.CharacterSetUnknown.failCharsetUnknown(CharacterSetFactoryThin.java:233)
at com.oracle@19.18.0.0.0//oracle.sql.CharacterSetUnknown.convert(CharacterSetFactoryThin.java:194)
at com.oracle@19.18.0.0.0//oracle.jdbc.driver.PhysicalConnection.throughDbCharset(PhysicalConnection.java:10454)
at com.oracle@19.18.0.0.0//oracle.jdbc.driver.PhysicalConnection.enquoteIdentifier(PhysicalConnection.java:10531)
at com.oracle@19.18.0.0.0//oracle.jdbc.driver.OracleStatement.enquoteIdentifier(OracleStatement.java:6452)
at com.oracle@19.18.0.0.0//oracle.jdbc.driver.OracleStatement.getColumnIndex(OracleStatement.java:3853)
at com.oracle@19.18.0.0.0//oracle.jdbc.driver.InsensitiveScrollableResultSet.findColumn(InsensitiveScrollableResultSet.java:270)
at org.jboss.ironjacamar.jdbcadapters@1.5.11.Final-redhat-00001//org.jboss.jca.adapters.jdbc.WrappedResultSet.findColumn(WrappedResultSet.java:377)
at deployment.jdbc-test.war//com.redhat.gss.sample.servlet.QueryBookServlet.doGet(QueryBookServlet.java:38)
... 46 more
The error message for Japanese locales is:
Caused by: java.sql.SQLException: サポートされない文字セットです(orai18n.jarをクラスパスに追加してください): JA16SJISTILDE
Database charset is other than AL32UTF8, such as JA16SJISTILDE and ZHT16MSWIN950:
SQL> select * from nls_database_parameters where parameter='NLS_CHARACTERSET';
PARAMETER
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_CHARACTERSET
JA16SJISTILDE
Environment
- Red Hat JBoss Enterprise Application Platform (EAP)
- 7
- Oracle JDBC
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.