3 Replies Latest reply on Dec 4, 2014 9:25 AM by rareddy

    Exception in Server Log (Remote Connection failed)

    tomaat

      In Teiid designer when i create connection to an external SQL server, following exception is thrown in the log:

       

      12:22:21,486 ERROR [org.jboss.remoting.remote.connection] (Remoting "external_server:MANAGEMENT" read-1)  JBREM000200: Remote connection failed: java.io.IOException: An established connection was aborted by the software in your host machine

       

      How to check which software is aborting the connection.

       

      Thanks

      Ahmad

        • 1. Re: Exception in Server Log (Remote Connection failed)
          rareddy

          There should be additional exception messages in the Teiid server log, take look at them then that may point in the right direction to look for who is terminating the connection.

          • 2. Re: Exception in Server Log (Remote Connection failed)
            tomaat

            Hi Ramesh,

             

            The error details in the log are:

             

            Stack Trace:

            java.lang.Exception: JDBC Source for Driver class com.microsoft.sqlserver.jdbc.SQLServerDriver was not found on server mm://localhost:9999::admin (New jboss-eap Runtime Server)

                at org.teiid84.runtime.ExecutionAdmin.getOrCreateDataSource(ExecutionAdmin.java:318)

                at org.teiid.designer.runtime.TeiidServer.getOrCreateDataSource(TeiidServer.java:560)

                at org.teiid.designer.runtime.TeiidDataSourceFactory.createDataSource(TeiidDataSourceFactory.java:161)

                at org.teiid.designer.runtime.preview.PreviewManager.ensureConnectionInfoIsValid(PreviewManager.java:511)

                at org.teiid.designer.runtime.preview.PreviewManager.previewSetup(PreviewManager.java:1241)

                at org.teiid.designer.runtime.ui.preview.PreviewDataWorker$1.run(PreviewDataWorker.java:232)

                at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)

             

             

            Message:

            JDBC Source for Driver class com.microsoft.sqlserver.jdbc.SQLServerDriver was not found on server mm://localhost:9999::admin (New jboss-eap Runtime Server)

             

            I have placed JDBC driver in a folder on C drive C:\JDBC4. Shall i copy it to installation directory of JBoss? If so, at what path?

             

            Thanks

            Ahmad

            • 3. Re: Exception in Server Log (Remote Connection failed)
              rareddy

              You can not just place the driver in a folder with JBoss EAP. It has module system, you need to create a module for it. General directions for adding any data source can be found here Data Source Configuration in AS 7

               

              However, if you added the jdbc jar file for SQL server in Designer, it would have added a module for you automatically.