2 Replies Latest reply on Dec 23, 2004 11:23 PM by svdath

UTF Conversion issue

svdath Dec 21, 2004 2:48 AM

Hi I am facing this error when trying to read from the database. The saem piece of code works fine in WebLogic7.0SP2. Please give any suggestions/solutions for this problem
Below is the stack trace:

13:10:55,359 INFO [STDOUT] java.sql.SQLException: Fail to convert between UTF8 and UCS2: failUTF8Conv
13:10:55,359 ERROR [STDERR] java.sql.SQLException: Fail to convert between UTF8 and UCS2: failUTF8Conv
13:10:55,359 ERROR [STDERR] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
13:10:55,359 ERROR [STDERR] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)
13:10:55,359 ERROR [STDERR] at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:775)
13:10:55,359 ERROR [STDERR] at oracle.jdbc.dbaccess.DBConversion.failUTF8Conv(DBConversion.java:1746)
13:10:55,359 ERROR [STDERR] at oracle.jdbc.dbaccess.DBConversion.utf8BytesToJavaChars(DBConversion.java:1585)
13:10:55,359 ERROR [STDERR] at oracle.jdbc.dbaccess.DBConversion.utf8BytesToString(DBConversion.java:1445)
13:10:55,359 ERROR [STDERR] at oracle.jdbc.dbaccess.DBConversion.CharBytesToString(DBConversion.java:384)
13:10:55,359 ERROR [STDERR] at oracle.jdbc.driver.OracleStatement.getStringValue(OracleStatement.java:2466)
13:10:55,359 ERROR [STDERR] at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:285)
13:10:55,421 ERROR [STDERR] at com.itsp.ecrm.infrastructure.persist.CommonCacheDbPeer.setMessageCacheResult(CommonCacheDbPeer.java:2975)
13:10:55,421 ERROR [STDERR] at com.itsp.ecrm.infrastructure.persist.CommonCacheDbPeer.setMessageCacheResult(CommonCacheDbPeer.java:2926)
13:10:55,421 ERROR [STDERR] at com.itsp.ecrm.infrastructure.persist.CommonCacheDbPeer.setMessageComboCache(CommonCacheDbPeer.java:2882)
13:10:55,421 ERROR [STDERR] at com.itsp.ecrm.infrastructure.persist.CommonCacheDbPeer.setComboCache(CommonCacheDbPeer.java:1574)
13:10:55,421 ERROR [STDERR] at com.itsp.ecrm.infrastructure.web.eCRMSuiteDocProxyServlet.createComboCache(eCRMSuiteDocProxyServlet.java:3289)
13:10:55,421 ERROR [STDERR] at com.itsp.ecrm.infrastructure.web.eCRMSuiteDocProxyServlet.init(eCRMSuiteDocProxyServlet.java:273)
13:10:55,421 ERROR [STDERR] at javax.servlet.GenericServlet.init(GenericServlet.java:256)
13:10:55,421 ERROR [STDERR] at org.mortbay.jetty.servlet.ServletHolder.start(ServletHolder.java:219)
13:10:55,421 ERROR [STDERR] at org.mortbay.jetty.servlet.ServletHandler.initializeServlets(ServletHandler.java:436)
13:10:55,421 ERROR [STDERR] at org.mortbay.jetty.servlet.WebApplicationHandler.initializeServlets(WebApplicationHandler.java:150)
13:10:55,421 ERROR [STDERR] at org.mortbay.jetty.servlet.WebApplicationContext.start(WebApplicationContext.java:442)
13:10:55,484 ERROR [STDERR] at org.mortbay.j2ee.J2EEWebApplicationContext.start(J2EEWebApplicationContext.java:85)
13:10:55,484 ERROR [STDERR] at org.jboss.jetty.JBossWebApplicationContext.start(JBossWebApplicationContext.java:89)
13:10:55,484 ERROR [STDERR] at org.jboss.jetty.Jetty.deploy(Jetty.java:331)
13:10:55,484 ERROR [STDERR] at org.jboss.jetty.JettyService.performDeploy(JettyService.java:242)
13:10:55,484 ERROR [STDERR] at org.jboss.web.AbstractWebContainer.start(AbstractWebContainer.java:357)
13:10:55,484 ERROR [STDERR] at org.jboss.deployment.MainDeployer.start(MainDeployer.java:832)
13:10:55,484 ERROR [STDERR] at org.jboss.deployment.MainDeployer.start(MainDeployer.java:824)
13:10:55,484 ERROR [STDERR] at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:640)
13:10:55,484 ERROR [STDERR] at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:613)
13:10:55,484 ERROR [STDERR] at java.lang.reflect.Method.invoke(Native Method)
13:10:55,484 ERROR [STDERR] at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
13:10:55,546 ERROR [STDERR] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
13:10:55,546 ERROR [STDERR] at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
13:10:55,546 ERROR [STDERR] at $Proxy7.deploy(Unknown Source)
13:10:55,546 ERROR [STDERR] at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:302)
13:10:55,546 ERROR [STDERR] at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:476)
13:10:55,546 ERROR [STDERR] at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:200)
13:10:55,546 ERROR [STDERR] at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:273)
13:10:55,546 ERROR [STDERR] at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
13:10:55,546 ERROR [STDERR] at java.lang.reflect.Method.invoke(Native Method)
13:10:55,546 ERROR [STDERR] at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
13:10:55,546 ERROR [STDERR] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
13:10:55,609 ERROR [STDERR] at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:966)
13:10:55,609 ERROR [STDERR] at $Proxy0.start(Unknown Source)
13:10:55,609 ERROR [STDERR] at org.jboss.system.ServiceController.start(ServiceController.java:392)
13:10:55,609 ERROR [STDERR] at java.lang.reflect.Method.invoke(Native Method)
13:10:55,609 ERROR [STDERR] at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
13:10:55,609 ERROR [STDERR] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
13:10:55,609 ERROR [STDERR] at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
13:10:55,609 ERROR [STDERR] at $Proxy5.start(Unknown Source)
13:10:55,609 ERROR [STDERR] at org.jboss.deployment.SARDeployer.start(SARDeployer.java:226)
13:10:55,609 ERROR [STDERR] at org.jboss.deployment.MainDeployer.start(MainDeployer.java:832)
13:10:55,609 ERROR [STDERR] at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:640)
13:10:55,656 ERROR [STDERR] at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:613)
13:10:55,656 ERROR [STDERR] at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:597)
13:10:55,656 ERROR [STDERR] at java.lang.reflect.Method.invoke(Native Method)
13:10:55,656 ERROR [STDERR] at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
13:10:55,656 ERROR [STDERR] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
13:10:55,656 ERROR [STDERR] at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
13:10:55,671 ERROR [STDERR] at $Proxy6.deploy(Unknown Source)
13:10:55,671 ERROR [STDERR] at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:365)
13:10:55,671 ERROR [STDERR] at org.jboss.system.server.ServerImpl.start(ServerImpl.java:272)
13:10:55,671 ERROR [STDERR] at org.jboss.Main.boot(Main.java:150)
13:10:55,671 ERROR [STDERR] at org.jboss.Main$1.run(Main.java:388)
13:10:55,718 ERROR [STDERR] at java.lang.Thread.run(Thread.java:479)
13:10:55,734 INFO [STDOUT] Getting Permissions for Role ID = 108...

1. Re: UTF Conversion issue

adrian.brock Dec 22, 2004 8:51 PM (in response to svdath)

Suggestion: Read your documentation for the jdbc driver and database, in particular the part about character sets.
Actions
2. Re: UTF Conversion issue

svdath Dec 23, 2004 11:23 PM (in response to svdath)

Hi Adrian,
I am using a Oracle 8i Database and Jboss3.2.1. I ahve 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.

-Vinay
Actions

Go to original post