0 Replies Latest reply on Dec 24, 2004 12:21 AM by Vinaydath Shivaprasad

    NLS Charecter set issue

    Vinaydath Shivaprasad Newbie

      I am using a Oracle 8i Database and Jboss3.2.1. I have put the classes12.zip in my application lib folder. But still i am getting the same problem.
      The same classes.zip with the same application works fine on a Weblogic 7.0 SP2.

      Is there any specific driver change that i need to make.

      The error message is :


      java.sql.SQLException: Fail to convert between UTF8 and UCS2: failUTF8Conv
      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)
      at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:775)
      at oracle.jdbc.dbaccess.DBConversion.failUTF8Conv(DBConversion.java:1746)
      at oracle.jdbc.dbaccess.DBConversion.utf8BytesToJavaChars(DBConversion.java:1585)
      at oracle.jdbc.dbaccess.DBConversion.utf8BytesToString(DBConversion.java:1445)
      at oracle.jdbc.dbaccess.DBConversion.CharBytesToString(DBConversion.java:384)
      at oracle.jdbc.driver.OracleStatement.getStringValue(OracleStatement.java:2466)
      at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:285)
      at com.itsp.ecrm.infrastructure.persist.CommonCacheDbPeer.setMessageCacheResult(CommonCacheDbPeer.java:2975)
      at com.itsp.ecrm.infrastructure.persist.CommonCacheDbPeer.setMessageCacheResult(CommonCacheDbPeer.java:2926)
      at com.itsp.ecrm.infrastructure.persist.CommonCacheDbPeer.setMessageComboCache(CommonCacheDbPeer.java:2882)
      at com.itsp.ecrm.infrastructure.persist.CommonCacheDbPeer.setComboCache(CommonCacheDbPeer.java:1574)
      at com.itsp.ecrm.infrastructure.web.eCRMSuiteDocProxyServlet.createComboCache(eCRMSuiteDocProxyServlet.java:3289)
      at com.itsp.ecrm.infrastructure.web.eCRMSuiteDocProxyServlet.init(eCRMSuiteDocProxyServlet.java:273)
      at javax.servlet.GenericServlet.init(GenericServlet.java:256)
      at org.mortbay.jetty.servlet.ServletHolder.start(ServletHolder.java:219)
      at org.mortbay.jetty.servlet.ServletHandler.initializeServlets(ServletHandler.java:436)
      at org.mortbay.jetty.servlet.WebApplicationHandler.initializeServlets(WebApplicationHandler.java:150)
      at org.mortbay.jetty.servlet.WebApplicationContext.start(WebApplicationContext.java:442)

      -Vinay