1 Reply Latest reply on Sep 12, 2012 1:15 PM by Tom Cunningham

    SQL Server connection closed problem in ESB

    muralidharan a Newbie



         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 );

        return ds.getConnection();


        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?