[jboss-user] [Datasource Configuration] - How to fix ERROR [STDERR] (pool-152-thread-1660) com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed. in jboss 6.1
Ankit Pandey
do-not-reply at jboss.com
Mon Jun 17 03:47:09 EDT 2013
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]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20130617/30adcadd/attachment.html
More information about the jboss-user
mailing list