Getting java.sql.SQLException: Non supported character set (add orai18n.jar in your classpath): JA16SJISTILDE with Oracle JDBC Driver on JBoss EAP 7

Solution Verified - Updated -

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.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content