Hi, Tomcat itself contains no Oracle-proprietary bits, nor any special handling of GBL files.
Where is orai18n.jar located? It should be alongside the ojdbc14.jar (assuming that's what you're using) so it's loaded by the same classloader. 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. 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. 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(CharacterSetFactoryTh i >n.java:178) > at >oracle.sql.CharacterSetUnknown.convert(CharacterSetFactoryThin.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(MutableStruct.java: 2 >92) > at >oracle.jpub.runtime.MutableStruct.getDatumAttributes(MutableStruct.java : >311) > at >oracle.jpub.runtime.MutableStruct.toDatum(MutableStruct.java:109) > at >org.glite.data.catalog.service.database.principalTokenFAS.toDatum(princ i >palTokenFAS.java:43) > at >oracle.jdbc.driver.OraclePreparedStatement.setORADataInternal(OraclePre p >aredStatement.java:7112) > at >oracle.jdbc.driver.OracleCallableStatement.setORAData(OracleCallableSta t >ement.java:4522) > at >org.glite.data.catalog.service.database.OraReplicaCatalog.setdefaultuse r >permission(OraReplicaCatalog.java:791) > at >org.glite.data.catalog.service.replica.ReplicaCatalogSoapBindingImpl.se t >DefaultUserPermission(ReplicaCatalogSoapBindingImpl.java:628) > at >org.glite.data.catalog.service.replica.ReplicaCatalogSoapBindingSkeleto n >.setDefaultUserPermission(ReplicaCatalogSoapBindingSkeleton.java:493) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at >sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.ja v >a:39) > at >sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccesso r >Impl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at >org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.jav a >:402) > at >org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.j a >va:309) > at >org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:33 3 >) > at >org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy. 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(AxisServletBase. j >ava:339) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > at >org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applic a >tionFilterChain.java:237) > at >org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFil t >erChain.java:157) > at >org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperVal v >e.java:214) > at >org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveC o >ntext.java:104) > at >org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java: 5 >20) > at >org.apache.catalina.core.StandardContextValve.invokeInternal(StandardCo n >textValve.java:198) > at >org.apache.catalina.core.StandardContextValve.invoke(StandardContextVal v >e.java:152) > at >org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveC o >ntext.java:104) > at >org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java: 5 >20) > at >org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.jav a >:137) > at >org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveC o >ntext.java:104) > at >org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.jav a >:118) > at >org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveC o >ntext.java:102) > at >org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java: 5 >20) > at >org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve . >java:109) > at >org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveC o >ntext.java:104) > at >org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.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(Http11Processor.java:7 9 >9) > at >org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process C >onnection(Http11Protocol.java:705) > at >org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.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]
