I am using sql server in my esb application. I just connect database using the below code. SQL Server is in network sharing.
Context ctx = new InitialContext();
DataSource ds = (DataSource)ctx.lookup( dataSourceName );
application is working fine. But when the network connection was dropped, it throws the following error
Error :com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
server log returns
DEBUG [org.jnp.interfaces.NamingContext] Failed to connect to user1:1099
javax.naming.CommunicationException: Failed to connect to server user1:1099 [Root exception is javax.naming.ServiceUnavailableException: Failed to connect to server user1:1099 [Root exception is java.net.UnknownHostException: user1]]
after the network connection resumes the same error will continue until I restart the Jboss Server.
How to resolve this problem?
How does this involve JBoss ESB? I'm confused - are you doing this in an action?