2 Replies Latest reply on Mar 12, 2014 12:23 PM by oruiz

DefaultDS

oruiz Mar 11, 2014 1:11 PM

No sé porque se me acaban las conexiones disponibles.... se supone que tengo habilitado un pool con 50 y no existe tal numero de conexiones nunca durante el funcionamiento del servidor de webservices... pero dice que ya no puede obtener una mas.... y después ya no responde ninguna solicitud.

Aqui la salida de la consola..

y la confiuracion en el archivo standalone.xml referente a la conexion DefaultDS

Bueno la verdad es que necesito algun apoyo para empezar a buscar porque pasa esto...

Gracias de antemano

java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/DefaultDS

23:48:21,944 ERROR [stderr] (http--172.20.250.76-8080-3) at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:137)

23:48:21,944 ERROR [stderr] (http--172.20.250.76-8080-3) at org.toks.pkfe.connection.ConnectDBMain.getConnection(ConnectDBMain.java:25)

23:48:21,944 ERROR [stderr] (http--172.20.250.76-8080-3) at org.toks.pkfe.connection.ConnectDBMain.getInstance(ConnectDBMain.java:16)

23:48:21,944 ERROR [stderr] (http--172.20.250.76-8080-3) at org.toks.pkfe.dao.ErrorDAO.setErrorHandler(ErrorDAO.java:46)

23:48:21,944 ERROR [stderr] (http--172.20.250.76-8080-3) at org.toks.pkfe.ws.FECreate.createFE(FECreate.java:503)

23:48:21,944 ERROR [stderr] (http--172.20.250.76-8080-3) at sun.reflect.GeneratedMethodAccessor997.invoke(Unknown Source)

23:48:21,944 ERROR [stderr] (http--172.20.250.76-8080-3) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

23:48:21,944 ERROR [stderr] (http--172.20.250.76-8080-3) at java.lang.reflect.Method.invoke(Unknown Source)

23:48:21,944 ERROR [stderr] (http--172.20.250.76-8080-3) at org.jboss.ws.common.invocation.AbstractInvocationHandlerJSE.invoke(AbstractInvocationHandlerJSE.java:111)

23:48:21,944 ERROR [stderr] (http--172.20.250.76-8080-3) at org.jboss.wsf.stack.cxf.JBossWSInvoker._invokeInternal(JBossWSInvoker.java:181)

23:48:21,944 ERROR [stderr] (http--172.20.250.76-8080-3) at org.jboss.wsf.stack.cxf.JBossWSInvoker.invoke(JBossWSInvoker.java:127)

23:48:21,944 ERROR [stderr] (http--172.20.250.76-8080-3) at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58)

23:48:21,944 ERROR [stderr] (http--172.20.250.76-8080-3) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

23:48:21,944 ERROR [stderr] (http--172.20.250.76-8080-3) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

23:48:21,944 ERROR [stderr] (http--172.20.250.76-8080-3) at java.util.concurrent.FutureTask.run(Unknown Source)

23:48:21,944 ERROR [stderr] (http--172.20.250.76-8080-3) at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37)

23:48:21,944 ERROR [stderr] (http--172.20.250.76-8080-3) at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:106)

23:48:21,944 ERROR [stderr] (http--172.20.250.76-8080-3) at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:263)

23:48:21,944 ERROR [stderr] (http--172.20.250.76-8080-3) at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)

23:48:21,944 ERROR [stderr] (http--172.20.250.76-8080-3) at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:207)

23:48:21,944 ERROR [stderr] (http--172.20.250.76-8080-3) at org.jboss.wsf.stack.cxf.RequestHandlerImpl.handleHttpRequest(RequestHandlerImpl.java:91)

23:48:21,944 ERROR [stderr] (http--172.20.250.76-8080-3) at org.jboss.wsf.stack.cxf.transport.ServletHelper.callRequestHandler(ServletHelper.java:169)

23:48:21,944 ERROR [stderr] (http--172.20.250.76-8080-3) at org.jboss.wsf.stack.cxf.CXFServletExt.invoke(CXFServletExt.java:87)

23:48:21,944 ERROR [stderr] (http--172.20.250.76-8080-3) at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:185)

23:48:21,944 ERROR [stderr] (http--172.20.250.76-8080-3) at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:108)

23:48:21,944 ERROR [stderr] (http--172.20.250.76-8080-3) at javax.servlet.http.HttpServlet.service(HttpServlet.java:754)

23:48:21,944 ERROR [stderr] (http--172.20.250.76-8080-3) at org.jboss.wsf.stack.cxf.CXFServletExt.service(CXFServletExt.java:135)

23:48:21,944 ERROR [stderr] (http--172.20.250.76-8080-3) at org.jboss.wsf.spi.deployment.WSFServlet.service(WSFServlet.java:140)

23:48:21,944 ERROR [stderr] (http--172.20.250.76-8080-3) at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)

23:48:21,944 ERROR [stderr] (http--172.20.250.76-8080-3) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)

23:48:21,944 ERROR [stderr] (http--172.20.250.76-8080-3) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)

23:48:21,944 ERROR [stderr] (http--172.20.250.76-8080-3) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)

23:48:21,944 ERROR [stderr] (http--172.20.250.76-8080-3) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)

23:48:21,944 ERROR [stderr] (http--172.20.250.76-8080-3) at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:154)

23:48:21,944 ERROR [stderr] (http--172.20.250.76-8080-3) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155)

23:48:21,944 ERROR [stderr] (http--172.20.250.76-8080-3) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

23:48:21,944 ERROR [stderr] (http--172.20.250.76-8080-3) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

23:48:21,944 ERROR [stderr] (http--172.20.250.76-8080-3) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368)

23:48:21,944 ERROR [stderr] (http--172.20.250.76-8080-3) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877)

23:48:21,960 ERROR [stderr] (http--172.20.250.76-8080-3) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671)

23:48:21,960 ERROR [stderr] (http--172.20.250.76-8080-3) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930)

23:48:21,960 ERROR [stderr] (http--172.20.250.76-8080-3) at java.lang.Thread.run(Unknown Source)

23:48:21,960 ERROR [stderr] (http--172.20.250.76-8080-3) Caused by: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/DefaultDS

23:48:21,960 ERROR [stderr] (http--172.20.250.76-8080-3) at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:390)

23:48:21,960 ERROR [stderr] (http--172.20.250.76-8080-3) at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:368)

23:48:21,960 ERROR [stderr] (http--172.20.250.76-8080-3) at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:464)

23:48:21,960 ERROR [stderr] (http--172.20.250.76-8080-3) at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:129)

23:48:21,960 ERROR [stderr] (http--172.20.250.76-8080-3) ... 41 more

23:48:21,960 ERROR [stderr] (http--172.20.250.76-8080-3) Caused by: javax.resource.ResourceException: IJ000655: No managed connections available within configured blocking timeout (5000 [ms])

23:48:21,960 ERROR [stderr] (http--172.20.250.76-8080-3) at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:377)

23:48:21,960 ERROR [stderr] (http--172.20.250.76-8080-3) at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:400)

23:48:21,960 ERROR [stderr] (http--172.20.250.76-8080-3) at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:365)

23:48:21,960 ERROR [stderr] (http--172.20.250.76-8080-3) at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:329)

23:48:21,960 ERROR [stderr] (http--172.20.250.76-8080-3) ... 44 more

EN el archivo de configuración Standalone.xml tengo

	<datasource jta="true" jndi-name="java:jboss/datasources/DefaultDS" pool-name="DefaultDS" enabled="true" use-ccm="false">
	<connection-url>jdbc:sqlserver:MIDIRECCIONIP;DatabaseName=NOMBREDELABASEDEDATOS</connection-url>
	<driver>mssql</driver>
	<new-connection-sql>select 1</new-connection-sql>
	<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
	<pool>
	<min-pool-size>5</min-pool-size>
	<max-pool-size>50</max-pool-size>
	</pool>
	<security>
	<user-name>USUARIO</user-name>
	<password>CONTRASEÑA</password>
	</security>
	<validation>
	<check-valid-connection-sql>select 1</check-valid-connection-sql>
	<validate-on-match>false</validate-on-match>
	<background-validation>false</background-validation>
	<background-validation-millis>0</background-validation-millis>
	</validation>
	<timeout>
	<set-tx-query-timeout>true</set-tx-query-timeout>
	<blocking-timeout-millis>5000</blocking-timeout-millis>
	<idle-timeout-minutes>15</idle-timeout-minutes>
	</timeout>
	<statement>
	<prepared-statement-cache-size>0</prepared-statement-cache-size>
	<share-prepared-statements>false</share-prepared-statements>
	</statement>
	</datasource>

1. Re: Jboss 7.1 Caused by: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/DefaultDS

maxandersen Mar 12, 2014 8:50 AM (in response to oruiz)

Hi Orlando,

I used google translate since I unfortunately does not read/speak your language. Can you answer in English ?

If the google translate is correct you are sounding like you are running out of connections or some error is occurring. I think your question is better asked in JBoss server related forum - this forum is for the eclipse based developer tools.
Actions
2. Re: Jboss 7.1 Caused by: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/DefaultDS

oruiz Mar 12, 2014 12:23 PM (in response to maxandersen)

Hi Max,
Thank you for response. My English is very poor please receive my apologies.
The question is about the pool of connections.
In a determinate dot of the execution to Jboss one exception is thrown about there are no more connections are available.
My configuration in Standalone.xml is whith 50 connections at the pool but... I do not know what is happened. The exit to console is here and the segment of .XML is here too.

Regards

and a lot of thanks
Actions

Go to original post