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

    SQL Server connection closed problem in ESB

    muralidharan a Newbie

      Hi,

       

         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?