Both ojdbc14.jar and orai18n.jar are in commons/lib/ Any ideas? > I see you have a fairly complex deployment, with Axis running > and relying on the Oracle data catalog. So naturally, my > next question is if you can reproduce the error under simpler > circumstances, e.g. in a command-line program or a simple servlet.
It work's fine from a command-line tool. > Finally, although you've already done this probably, I'd > suggest looking online: there are a number of good Oracle configuration references. > Chances are you're missing a simple configuration step > somewhere along the way. Can you point me to some specific howtos? Thanks, Michal. > > Yoav Shapira http://www.yoavshapira.com > > > >-----Original Message----- > >From: Michal Kwiatek [mailto:[EMAIL PROTECTED] > >Sent: Wednesday, October 13, 2004 1:30 PM > >To: Tomcat Users List > >Subject: Classloader / oracle JDBC > > > >Hello All, > > > >I have a problem using oracle jdbc in tomcat. > > > >JDBC call fails with "java.sql.SQLException: Non supported character > >set: oracle-character-set-46" (see full stack trace below). > > > >After some investigation, I came to the conlusion that translation > >tables that are in the *.gbl files in orai18n.jar are not read > properly. > > > > > >Is it possible that tomcat classloader does not allow reading *.gbl > >files from orai18n.jar? > > > >Or perhaps there is some other reason jdbc crashes on tomcat? > > > >Versions: > >Tomcat 5.0.28 > >Oracle jdbc 10.1.0.2.0, both OCI and thin Oracle 9.2.0.5.0 > database in > >WE8ISO8859P15 characterset > > > >Thank you in advance, > >Michal. > > > >------------------------- > >java.sql.SQLException: Non supported character set: > >oracle-character-set-46 > > at > oracle.gss.util.NLSError.throwSQLException(NLSError.java:65) > > at > >oracle.sql.CharacterSetUnknown.failCharsetUnknown(CharacterSe > tFactoryTh > i > >n.java:178) > > at > >oracle.sql.CharacterSetUnknown.convert(CharacterSetFactoryThi > n.java:145 > ) > > at oracle.sql.CHAR.<init>(CHAR.java:147) > > at oracle.jpub.runtime.Util._convertToOracle(Util.java:166) > > at oracle.jpub.runtime.Util.convertToOracle(Util.java:138) > > at > >oracle.jpub.runtime.MutableStruct.getDatumAttribute(MutableSt > ruct.java: > 2 > >92) > > at > >oracle.jpub.runtime.MutableStruct.getDatumAttributes(MutableS > truct.java > : > >311) > > at > >oracle.jpub.runtime.MutableStruct.toDatum(MutableStruct.java:109) > > at > >org.glite.data.catalog.service.database.principalTokenFAS.toD > atum(princ > i > >palTokenFAS.java:43) > > at > >oracle.jdbc.driver.OraclePreparedStatement.setORADataInternal > (OraclePre > p > >aredStatement.java:7112) > > at > >oracle.jdbc.driver.OracleCallableStatement.setORAData(OracleC > allableSta > t > >ement.java:4522) > > at > >org.glite.data.catalog.service.database.OraReplicaCatalog.set > defaultuse > r > >permission(OraReplicaCatalog.java:791) > > at > >org.glite.data.catalog.service.replica.ReplicaCatalogSoapBind > ingImpl.se > t > >DefaultUserPermission(ReplicaCatalogSoapBindingImpl.java:628) > > at > >org.glite.data.catalog.service.replica.ReplicaCatalogSoapBind > ingSkeleto > n > >.setDefaultUserPermission(ReplicaCatalogSoapBindingSkeleton.java:493) > > at > sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at > >sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcces > sorImpl.ja > v > >a:39) > > at > >sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMet > hodAccesso > r > >Impl.java:25) > > at java.lang.reflect.Method.invoke(Method.java:324) > > at > >org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCPr > ovider.jav > a > >:402) > > at > >org.apache.axis.providers.java.RPCProvider.processMessage(RPC > Provider.j > a > >va:309) > > at > >org.apache.axis.providers.java.JavaProvider.invoke(JavaProvid > er.java:33 > 3 > >) > > at > >org.apache.axis.strategies.InvocationStrategy.visit(Invocatio > nStrategy. > j > >ava:71) > > at > org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:150) > > at org.apache.axis.SimpleChain.invoke(SimpleChain.java:120) > > at > >org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService. > java:481) > > at > org.apache.axis.server.AxisServer.invoke(AxisServer.java:323) > > at > >org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet > .java:854) > > at > javax.servlet.http.HttpServlet.service(HttpServlet.java:709) > > at > >org.apache.axis.transport.http.AxisServletBase.service(AxisSe > rvletBase. > j > >ava:339) > > at > javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > > at > >org.apache.catalina.core.ApplicationFilterChain.internalDoFil > ter(Applic > a > >tionFilterChain.java:237) > > at > >org.apache.catalina.core.ApplicationFilterChain.doFilter(Appl > icationFil > t > >erChain.java:157) > > at > >org.apache.catalina.core.StandardWrapperValve.invoke(Standard > WrapperVal > v > >e.java:214) > > at > >org.apache.catalina.core.StandardValveContext.invokeNext(Stan > dardValveC > o > >ntext.java:104) > > at > >org.apache.catalina.core.StandardPipeline.invoke(StandardPipe > line.java: > 5 > >20) > > at > >org.apache.catalina.core.StandardContextValve.invokeInternal( > StandardCo > n > >textValve.java:198) > > at > >org.apache.catalina.core.StandardContextValve.invoke(Standard > ContextVal > v > >e.java:152) > > at > >org.apache.catalina.core.StandardValveContext.invokeNext(Stan > dardValveC > o > >ntext.java:104) > > at > >org.apache.catalina.core.StandardPipeline.invoke(StandardPipe > line.java: > 5 > >20) > > at > >org.apache.catalina.core.StandardHostValve.invoke(StandardHos > tValve.jav > a > >:137) > > at > >org.apache.catalina.core.StandardValveContext.invokeNext(Stan > dardValveC > o > >ntext.java:104) > > at > >org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepor > tValve.jav > a > >:118) > > at > >org.apache.catalina.core.StandardValveContext.invokeNext(Stan > dardValveC > o > >ntext.java:102) > > at > >org.apache.catalina.core.StandardPipeline.invoke(StandardPipe > line.java: > 5 > >20) > > at > >org.apache.catalina.core.StandardEngineValve.invoke(StandardE > ngineValve > . > >java:109) > > at > >org.apache.catalina.core.StandardValveContext.invokeNext(Stan > dardValveC > o > >ntext.java:104) > > at > >org.apache.catalina.core.StandardPipeline.invoke(StandardPipe > line.java: > 5 > >20) > > at > >org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) > > at > >org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter > .java:160) > > at > >org.apache.coyote.http11.Http11Processor.process(Http11Proces > sor.java:7 > 9 > >9) > > at > >org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandl > er.process > C > >onnection(Http11Protocol.java:705) > > at > >org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpo > int.java:5 > 7 > >7) > > at > >org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run > (ThreadPoo > l > >.java:683) > > at java.lang.Thread.run(Thread.java:534) > > > >--------------------------------------------------------------------- > >To unsubscribe, e-mail: [EMAIL PROTECTED] > >For additional commands, e-mail: [EMAIL PROTECTED] > > > > > This e-mail, including any attachments, is a confidential > business communication, and may contain information that is > confidential, proprietary and/or privileged. This e-mail is > intended only for the individual(s) to whom it is addressed, > and may not be saved, copied, printed, disclosed or used by > anyone else. If you are not the(an) intended recipient, > please immediately delete this e-mail from your computer > system and notify the sender. Thank you. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
