-
1. Re: Exception in Server Log (Remote Connection failed)
rareddy Dec 3, 2014 11:00 AM (in response to tomaat)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 Dec 4, 2014 9:18 AM (in response to rareddy)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 Dec 4, 2014 9:25 AM (in response to tomaat)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.