To get this far I had to more the datasource resource defiition to the
context. I've rasie the debug to 9 but could see no additional loging that
would help. Here is the context ...
<Context className="org.apache.catalina.core.StandardContext"
cachingAllowed="true"
charsetMapperClass="org.apache.catalina.util.CharsetMapper" cookies="true"
crossContext="false" debug="9" displayName="Custom Fares"
docBase="C:/Documents and Settings/pmahoney/My Documents/Travel
2/code/webapps/CustomFares/web"
mapperClass="org.apache.catalina.core.StandardContextMapper"
path="/CustomFares" privileged="false" reloadable="false"
swallowOutput="false" useNaming="true"
wrapperClass="org.apache.catalina.core.StandardWrapper">
<Resource name="jdbc/OscarsDB" scope="Shareable"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/OscarsDB">
<parameter>
<name>validationQuery</name>
<value>select count(*) from systables</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:informix-sqli://oscar1.travel2.com:1420/oscars:INFORMIXSERVER=os
cars_dbsrv</value>
</parameter>
<parameter>
<name>password</name>
<value>1atan1a</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>4</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.informix.jdbc.IfxDriver</value>
</parameter>
<parameter>
<name>username</name>
<value>sy5t3m</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>2</value>
</parameter>
</ResourceParams>
</Context>
The stacktrace is...
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool
exhausted, cause:
java.util.NoSuchElementException: Could not create a validated object
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPoo
l.java:851)
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.ja
va:140)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:5
18)
at com.travel2.customFares.Query.getJdbcConnection(Query.java:95)
at com.travel2.customFares.Query.execute(Query.java:160)
at
com.travel2.customFares.CustomFaresService.GetFares(CustomFaresService.java:
58)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:402
)
at
org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:3
09)
at
org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:333)
at
org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:
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:760)
at
org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:
339)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:256)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:191)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2422)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180
)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:171)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:163
)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:174)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:199)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:828)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
ction(Http11Protocol.java:700)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:584)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:683)
at java.lang.Thread.run(Thread.java:536)
>-----Original Message-----
>From: D'Alessandro, Arthur [mailto:[EMAIL PROTECTED]
>Sent: 17 March 2004 18:07
>To: [EMAIL PROTECTED]; Tomcat Users List; Parsons Technical Services
>Subject: RE: Problem using JNDI/DBCP to get DataSouce
>
>
>Would you include any resource definitions and/or any
resource>links/references.
>
>Also, the full stacktrace of the exception may shed some other potential
problems.
>
>-----Original Message-----
>From: Paul Mahoney [mailto:[EMAIL PROTECTED]
>Sent: Wednesday, March 17, 2004 1:05 PM
>To: D'Alessandro, Arthur; 'Tomcat Users List'; 'Parsons Technical
>Services'
>Subject: RE: Problem using JNDI/DBCP to get DataSouce
>
>I agree, but it looks good and I've tried without one being specified.
>In
>addition, I've never see a connection raised at the database
>server end.
>This makes me think the DataSource is just not working and I'm not
>seeing
>the proper error. But I can find nothing more in the logs :(
>
>>-----Original Message-----
>>From: D'Alessandro, Arthur [mailto:[EMAIL PROTECTED]
>>Sent: 17 March 2004 18:00
>>To: Tomcat Users List; [EMAIL PROTECTED]; Parsons Technical Services
>>Subject: RE: Problem using JNDI/DBCP to get DataSouce
>>
>>
>>Check your validation query in your resource definition.
>>
>>-----Original Message-----
>>From: Paul Mahoney [mailto:[EMAIL PROTECTED]
>>Sent: Wednesday, March 17, 2004 12:57 PM
>>To: 'Parsons Technical Services'; 'Tomcat Users List'
>>Subject: RE: Problem using JNDI/DBCP to get DataSouce
>>
>>Tried
>> dataSource = (DataSource)
>>initContext.lookup("java:comp/jdbc/OscarsDB");
>>But it return null, so tried
>> dataSource = (DataSource)
>>initContext.lookup("java:comp/env/jdbc/OscarsDB");
>>And a datasource instance was return so before, looking good...
>>However, still got the same exception when trying to get a connection
>>instance
>> "Cannot get a connection, pool exhausted"
>>with a nested exception
>> "Could not create a validated object"
>>
>
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
