NLS Charecter set issue

[svdath]

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

[anil.saldhana]

Vinay,
this looks like an issue in the database (Localization issues). Your best bet is to look for information in the oracle world.

A google query gave me a url which has a direction from a DBA:
http://www.lazydba.com/oracledba.pl?0::52149

On a flip side (not related to your problem), you shud try to upgrade your JBoss instance to newer versions (3.2.1 is quite old).

Cheers,
Anil