Ankit Pandey [https://community.jboss.org/people/ankit.pandey] created the discussion
"How to fix ERROR [STDERR] (pool-152-thread-1660) com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed. in jboss 6.1" To view the discussion, visit: https://community.jboss.org/message/823389#823389 -------------------------------------------------------------- Hi, I am connecting SQLServer but sometimes I got 2013-06-17 12:56:00,068 ERROR [STDERR] (pool-152-thread-1660) com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed. 2013-06-17 12:56:00,070 ERROR [STDERR] (pool-152-thread-1660) at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:171) 2013-06-17 12:56:00,070 ERROR [STDERR] (pool-152-thread-1660) at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(SQLServerConnection.java:319) 2013-06-17 12:56:00,070 ERROR [STDERR] (pool-152-thread-1660) at com.microsoft.sqlserver.jdbc.SQLServerConnection.prepareStatement(SQLServerConnection.java:1839) 2013-06-17 12:56:00,070 ERROR [STDERR] (pool-152-thread-1660) at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConne.................. My Jboss Configuration is <local-tx-datasource> <jndi-name>jdbc/abc.008</jndi-name> <connection-url>jdbc:sqlserver://ip:2499;databaseName=DB</connection-url> <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class> <user-name>sa</user-name> <password>pass</password> <autoReconnect>true</autoReconnect> <failOverReadOnly>false</failOverReadOnly> <maxReconnects>50</maxReconnects> <initialTimeout>15</initialTimeout> <check-valid-connection-sql>select 1 </check-valid-connection-sql> </local-tx-datasource> I have to restart JBoss for getting working connection again which is not the real possible solution obviously. I want to avoid this Jboss restart everytime.. It's very urgent... Please Help... -------------------------------------------------------------- Reply to this message by going to Community [https://community.jboss.org/message/823389#823389] Start a new discussion in Datasource Configuration at Community [https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077]
_______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
