tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michal Kwiatek" <Michal.Kwia...@cern.ch>
Subject RE: Classloader / oracle JDBC
Date Wed, 13 Oct 2004 17:47:16 GMT
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:Michal.Kwiatek@cern.ch]
> >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: tomcat-user-unsubscribe@jakarta.apache.org
> >For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> 
> 
> 
> 
> 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: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> 
> 
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message