Error in connection pool

[mdachi]

Hello all,

I have been running the dataservice server successfully in my test
area until recently when I wanted to ,move it to the production
environment when I started getting errors. The errors are like the
excerpt below:

[2010-12-06 20:42:32,875] ERROR - Error in in-out message receiver
DS Fault Message: Error in pre-fetching data
Nested Exception:-
javax.xml.stream.XMLStreamException: DS Fault Message: Error in
opening DBMS con
nection.
Source Data Service:-
Name: T24Test1
Location: C:\wsoa\WSO2DA~1.2\bin\..\repository\deployment\server
\dataservices\T2
4Test1.dbs
Description: Test service
Default Namespace: http://my.namespace
Current Request Name: doSalaryPosting
Current Params: {debitCurrency=TZS, creditAccountNumber=030613586692,
orderingCu
stomer=EFT/SALARY DATA CAPTURE INTER TZS, creditTheirRef=SEP.SALARY,
creditValue
Date=20100901, id=LMSEKENA, transactionType=AC, commissionCode=WAIVE,
batchNumbe
r=9072, passcode=123456, debitAmount=323400, chargeCode=WAIVE,
debitValueDate=20
100901, debitAccountNumber=TZS1484100020100}
Nested Exception:-
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection,
pool error
Timeout waiting for idle object


at
org.wso2.carbon.dataservices.core.engine.DSOMDataSource.prefetchData(
DSOMDataSource.java:97)
at
org.wso2.carbon.dataservices.core.DBUtils.executeSingleRequest(DBUtil
s.java:483)
at
org.wso2.carbon.dataservices.core.DBUtils.dispatchSingleRequest(DBUti
ls.java:363)
at
org.wso2.carbon.dataservices.core.DBUtils.invoke(DBUtils.java:298)
at
org.wso2.carbon.dataservices.core.DBInOutMessageReceiver.invokeBusine
ssLogic(DBInOutMessageReceiver.java:52)
at
org.apache.axis2.receivers.AbstractInOutSyncMessageReceiver.invokeBus
inessLogic(AbstractInOutSyncMessageReceiver.java:42)
at
org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMe
ssageReceiver.java:114)
at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:
178)
at
org.apache.axis2.transport.http.util.RESTUtil.invokeAxisEngine(RESTUt
il.java:144)
at
org.apache.axis2.transport.http.util.RESTUtil.processURLRequest(RESTU
til.java:139)
at org.apache.axis2.transport.http.AxisServlet
$RestRequestProcessor.proc
essURLRequest(AxisServlet.java:816)
at
org.wso2.carbon.core.transports.CarbonServlet.handleRestRequest(Carbo
nServlet.java:149)
at
org.wso2.carbon.core.transports.CarbonServlet.doGet(CarbonServlet.jav
a:138)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:
689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:
802)
at
org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleR
equest(ServletRegistration.java:90)
at
org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(P
roxyServlet.java:111)
at
org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyS
ervlet.java:67)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:
802)
at
org.wso2.carbon.bridge.BridgeServlet.service(BridgeServlet.java:154)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:
802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:269)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:188)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:210)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:174)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:117)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:108)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:151)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:870)
at org.apache.coyote.http11.Http11BaseProtocol
$Http11ConnectionHandler.p
rocessConnection(Http11BaseProtocol.java:665)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo
int.java:528)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFol
lowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool
$ControlRunnable.run(ThreadP
ool.java:685)
at java.lang.Thread.run(Thread.java:619)
Caused by: javax.xml.stream.XMLStreamException: DS Fault Message:
Error in openi
ng DBMS connection.
Source Data Service:-
Name: T24Test1
Location: C:\wsoa\WSO2DA~1.2\bin\..\repository\deployment\server
\dataservices\T2
4Test1.dbs
Description: Test service
Default Namespace: http://my.namespace
Current Request Name: doSalaryPosting
Current Params: {debitCurrency=TZS, creditAccountNumber=030613586692,
orderingCu
stomer=EFT/SALARY DATA CAPTURE INTER TZS, creditTheirRef=SEP.SALARY,
creditValue
Date=20100901, id=LMSEKENA, transactionType=AC, commissionCode=WAIVE,
batchNumbe
r=9072, passcode=123456, debitAmount=323400, chargeCode=WAIVE,
debitValueDate=20
100901, debitAccountNumber=TZS1484100020100}
Nested Exception:-
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection,
pool error
Timeout waiting for idle object

at
org.wso2.carbon.dataservices.core.engine.DSOMDataSource.execute(DSOMD
ataSource.java:158)
at
org.wso2.carbon.dataservices.core.engine.DSOMDataSource.prefetchData(
DSOMDataSource.java:95)
... 34 more

Seems there is an issue with the data receiver and that the thing is
failing to get a connection from connection pool. What could be the
result of this behavior? I am running my test in Windows.

Please help

Hamisi
---------

[Dmitry.]

Could you stop server, remove the logs, restart server,
then reproduce error, and send me the logs.

Sure that the problem in connection to T24,
but I can't see it in error that you sent me.

Regards,
Dmitry