Wildfly intgration with HBase integration using Teiid Importer.

[srinath0533]

Hello All,

This morning i was trying to connect my Teiid with HBase and i read couple of blogs on how to use the HBase Translator with Phoenix Data Source to access the data in HBase. Below is the .jar file im using.

phoenix-core-4.4.0-HBase-1.1

Class = org.apache.phoenix.jdbc.PhoenixDriver / org.apache.phoenix.jdbc.PhoenixEmbeddedDriver

Tried using Teiid Importer and JDBC Connection with the above jar file and none of them worked.  Below is the error.

java.lang.NoClassDefFoundError: Could not initialize class org.apache.phoenix.jdbc.PhoenixDriver

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

at java.lang.reflect.Constructor.newInstance(Unknown Source)

at java.lang.Class.newInstance(Unknown Source)

at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.createConnection(JDBCConnection.java:327)

at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:105)

at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:54)

at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:96)

at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnectionFactory.createConnection(JDBCConnectionFactory.java:53)

at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)

at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359)

at org.eclipse.datatools.connectivity.internal.ManagedConnection.createConnection(ManagedConnection.java:166)

at org.eclipse.datatools.connectivity.internal.CreateConnectionJob.run(CreateConnectionJob.java:56)

at org.eclipse.core.internal.jobs.Worker.run(Worker.java:56)

Please let me know if this is even right way to establish the connection or is there any other way. I couldn't find enough information online.

Thanks

Srinath

[rareddy]

This is very similar to what we suggested for Hive. Read and follow instructions at <teiid/docs/datasources/phoenix" directory in obtaining the JDBC Jar file and creating a datasource. Then come back to "Teiid Designer" and use Teiid Connection Importer to import the metadata.

[srinath0533]

I have tried the similar steps thati followed for Hive for MapR DB and HBase as well but i see the below error. I was able to connect through JDBC Connection and import the metadata but not through Teiid Importer.  I don't see any Translator for MapR and Hbase as well. Is that the issue or can i use Default JDBC Translator for these connections?

[rareddy]

You need to use "phoenix" as translator type, and that is JDBC driver Teiid supports for Hbase too. So, using the Phoenix JDBC driver create the modules and connection etc, then use "phoenix" translator on the Teiid Connection Importer.

[srinath0533]

I have Wildfly 10X.  Which version of phoenix jdbc jar file i should use. If in case you have the jar files or link can you please help me with it.  I tried with multiple jar files but i see error saying driver could not load the URL. I have access and i confirmed it using putty. So basically jar file issues.  Any help is much appreciated.

[srinath0533]

Below are the list of jar files i used. I tried all, i tried few but did not work.

[srinath0533]

1. Stopped the server

2. Added phoenix database JDBC driver jar files under Teiid//modules/org/apache/phoenix/main.

3. Edit the standalone-teiid.xml and added the new datasource under "datasources" under subsystem.(added the connection details(url, username, password)).

4. Started the server. I can see new Phoenix datasource under Import<TeiidConnection>>SourceModel.

5. Selected the translator to Phoenix

6. Gave the Location and Model Name.

Error

VDB DEPLOYMENT ERRORS:

TEIID31097 Metadata load requires a connection factory: TEIID30481 Failed to find the Connection Factory with JNDI name java:jboss/datasources/PhoenixDS. Please check the name or deploy the Connection Factory with specified name.

Error deploying "importVDB" - please check the server log for more details.

The deployment timeout can be increased on the previous page (Advanced tab), or check the server log for other errors. 

[rareddy]

Attach your module.xml and standalone-teiid.xml

[srinath0533]

Below is the log file

2018-05-22 15:36:13,503 INFO  [org.jboss.as.repository] (management-handler-thread - 1)  WFLYDR0001: Content added at location /opt/teiid-10.1.1/standalone/data/content/2c/20f6d88f5c277da179bc689c3eade38b291274/content

2018-05-22 15:36:13,508 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-3)  WFLYSRV0027: Starting deployment of "importVDB-vdb.xml" (runtime-name: "importVDB-vdb.xml")

2018-05-22 15:36:13,517 DEBUG [org.teiid.RUNTIME] (MSC service thread 1-3)  VDB importVDB-vdb.xml has been parsed.

2018-05-22 15:36:13,538 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-3)  TEIID40118 VDB importVDB.1 added to the repository

2018-05-22 15:36:13,538 INFO  [org.teiid.RUNTIME] (MSC service thread 1-3)  TEIID50029 VDB importVDB.1 model "importVDBSrcModel" metadata is currently being loaded. Start Time: 5/22/18 3:36 PM

2018-05-22 15:36:13,539 TRACE [org.teiid.RUNTIME] (MSC service thread 1-3)  Model  importVDBSrcModel in VDB  importVDB  was being loaded from its repository

2018-05-22 15:36:13,557 TRACE [org.teiid.RUNTIME] (Worker10_async-teiid-threads10)  Beginning work with virtual worker Worker10_async-teiid-threads10

2018-05-22 15:36:13,558 DEBUG [org.teiid.RUNTIME] (Worker10_async-teiid-threads10)  org.teiid.translator.TranslatorException: TEIID30481 Failed to find the Connection Factory with JNDI name java:jboss/datasources/PhoenixDS. Please check the name or deploy the Connection Factory with specified name. Failed to get a connection factory for metadata load.

2018-05-22 15:36:13,558 DEBUG [org.teiid.RUNTIME] (Worker10_async-teiid-threads10)  TEIID50104 VDB importVDB.1 model "importVDBSrcModel" Using translator phoenix and connection java:jboss/datasources/PhoenixDS to load metadata.

2018-05-22 15:36:13,558 WARN  [org.teiid.RUNTIME] (Worker10_async-teiid-threads10)  TEIID50036 VDB importVDB.1 model "importVDBSrcModel" metadata failed to load. Reason:TEIID31097 Metadata load requires a connection factory: TEIID30481 Failed to find the Connection Factory with JNDI name java:jboss/datasources/PhoenixDS. Please check the name or deploy the Connection Factory with specified name.: org.teiid.translator.TranslatorException: TEIID31097 Metadata load requires a connection factory

at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:53)

at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:51)

at org.teiid.jboss.VDBService$6.run(VDBService.java:337)

at org.teiid.jboss.VDBService$7.run(VDBService.java:388)

at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:280)

at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:115)

at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:206)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1160)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)

at java.lang.Thread.run(Thread.java:811)

2018-05-22 15:36:13,561 INFO  [org.jboss.as.server] (management-handler-thread - 1)  WFLYSRV0010: Deployed "importVDB-vdb.xml" (runtime-name : "importVDB-vdb.xml")

2018-05-22 15:36:15,109 ERROR [org.jboss.jca.core.tx.jbossts.XAResourceRecoveryImpl] (Periodic Recovery)  IJ000906: Error during crash recovery: java:/TravelClickXADS (IJ031084: Unable to create connection): javax.resource.ResourceException: IJ031084: Unable to create connection

at org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory.getXAManagedConnection(XAManagedConnectionFactory.java:509)

at org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory$1$1.run(XAManagedConnectionFactory.java:395)

at org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory$1$1.run(XAManagedConnectionFactory.java:392)

at java.security.AccessController.doPrivileged(AccessController.java:730)

at javax.security.auth.Subject.doAs(Subject.java:570)

at org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory$1.run(XAManagedConnectionFactory.java:391)

at org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory$1.run(XAManagedConnectionFactory.java:388)

at java.security.AccessController.doPrivileged(AccessController.java:694)

at org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory.createManagedConnection(XAManagedConnectionFactory.java:387)

at org.jboss.jca.core.tx.jbossts.XAResourceRecoveryImpl.open(XAResourceRecoveryImpl.java:355)

at org.jboss.jca.core.tx.jbossts.XAResourceRecoveryImpl.getXAResources(XAResourceRecoveryImpl.java:193)

at com.arjuna.ats.internal.jbossatx.jta.XAResourceRecoveryHelperWrapper.getXAResources(XAResourceRecoveryHelperWrapper.java:51)

at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.resourceInitiatedRecoveryForRecoveryHelpers(XARecoveryModule.java:566)

at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.periodicWorkFirstPass(XARecoveryModule.java:189)

at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.periodicWorkFirstPass(XARecoveryModule.java:140)

at com.arjuna.ats.internal.arjuna.recovery.PeriodicRecovery.doWorkInternal(PeriodicRecovery.java:765)

at com.arjuna.ats.internal.arjuna.recovery.PeriodicRecovery.run(PeriodicRecovery.java:377)

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host DSQL-01.xxxx.xxxxxxxx.local, port 1433 has failed. Error: "null. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:171)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1033)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:817)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:700)

at com.microsoft.sqlserver.jdbc.SQLServerDataSource.getConnectionInternal(SQLServerDataSource.java:593)

at com.microsoft.sqlserver.jdbc.SQLServerPooledConnection.createNewConnection(SQLServerPooledConnection.java:60)

at com.microsoft.sqlserver.jdbc.SQLServerPooledConnection.<init>(SQLServerPooledConnection.java:42)

at com.microsoft.sqlserver.jdbc.SQLServerXAConnection.<init>(SQLServerXAConnection.java:27)

at com.microsoft.sqlserver.jdbc.SQLServerXADataSource.getXAConnection(SQLServerXADataSource.java:51)

at org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory.getXAManagedConnection(XAManagedConnectionFactory.java:493)

... 16 more

2018-05-22 15:36:18,341 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-1)  TEIID40120 VDB importVDB.1 will be removed from the repository

2018-05-22 15:36:18,341 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-1)  TEIID40119 VDB importVDB.1 removed from the repository

2018-05-22 15:36:18,344 INFO  [org.teiid.RUNTIME] (MSC service thread 1-1)  TEIID50026 VDB "importVDB.1[importVDBSrcModel{importVDBSrcModel=importVDBSrcModel, phoenix, java:jboss/datasources/PhoenixDS}]" undeployed.

2018-05-22 15:36:18,346 TRACE [org.teiid.RUNTIME] (MSC service thread 1-3)  VDB importVDB metadata removed

2018-05-22 15:36:18,346 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-3)  TEIID40120 VDB importVDB.1 will be removed from the repository

2018-05-22 15:36:18,350 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-2)  WFLYSRV0028: Stopped deployment importVDB-vdb.xml (runtime-name: importVDB-vdb.xml) in 11ms

2018-05-22 15:36:18,367 INFO  [org.jboss.as.repository] (management-handler-thread - 4)  WFLYDR0002: Content removed from location /opt/teiid-10.1.1/standalone/data/content/2c/20f6d88f5c277da179bc689c3eade38b291274/content

2018-05-22 15:36:18,367 INFO  [org.jboss.as.server] (management-handler-thread - 4)  WFLYSRV0009: Undeployed "importVDB-vdb.xml" (runtime-name: "importVDB-vdb.xml")

2018-05-22 15:36:18,591 INFO  [org.jboss.as.repository] (management-handler-thread - 3)  WFLYDR0001: Content added at location /opt/teiid-10.1.1/standalone/data/content/2c/20f6d88f5c277da179bc689c3eade38b291274/content

2018-05-22 15:36:18,596 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-1)  WFLYSRV0027: Starting deployment of "importVDB-vdb.xml" (runtime-name: "importVDB-vdb.xml")

2018-05-22 15:36:18,605 DEBUG [org.teiid.RUNTIME] (MSC service thread 1-4)  VDB importVDB-vdb.xml has been parsed.

2018-05-22 15:36:18,622 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-4)  TEIID40118 VDB importVDB.1 added to the repository

2018-05-22 15:36:18,622 INFO  [org.teiid.RUNTIME] (MSC service thread 1-4)  TEIID50029 VDB importVDB.1 model "importVDBSrcModel" metadata is currently being loaded. Start Time: 5/22/18 3:36 PM

2018-05-22 15:36:18,622 TRACE [org.teiid.RUNTIME] (MSC service thread 1-4)  Model  importVDBSrcModel in VDB  importVDB  was being loaded from its repository

2018-05-22 15:36:18,622 TRACE [org.teiid.RUNTIME] (Worker10_async-teiid-threads11)  Beginning work with virtual worker Worker10_async-teiid-threads11

2018-05-22 15:36:18,623 DEBUG [org.teiid.RUNTIME] (Worker10_async-teiid-threads11)  org.teiid.translator.TranslatorException: TEIID30481 Failed to find the Connection Factory with JNDI name java:jboss/datasources/PhoenixDS. Please check the name or deploy the Connection Factory with specified name. Failed to get a connection factory for metadata load.

2018-05-22 15:36:18,623 DEBUG [org.teiid.RUNTIME] (Worker10_async-teiid-threads11)  TEIID50104 VDB importVDB.1 model "importVDBSrcModel" Using translator phoenix and connection java:jboss/datasources/PhoenixDS to load metadata.

2018-05-22 15:36:18,623 WARN  [org.teiid.RUNTIME] (Worker10_async-teiid-threads11)  TEIID50036 VDB importVDB.1 model "importVDBSrcModel" metadata failed to load. Reason:TEIID31097 Metadata load requires a connection factory: TEIID30481 Failed to find the Connection Factory with JNDI name java:jboss/datasources/PhoenixDS. Please check the name or deploy the Connection Factory with specified name.: org.teiid.translator.TranslatorException: TEIID31097 Metadata load requires a connection factory

at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:53)

at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:51)

at org.teiid.jboss.VDBService$6.run(VDBService.java:337)

at org.teiid.jboss.VDBService$7.run(VDBService.java:388)

at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:280)

at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:115)

at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:206)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1160)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)

at java.lang.Thread.run(Thread.java:811)

2018-05-22 15:36:18,639 INFO  [org.jboss.as.server] (management-handler-thread - 3)  WFLYSRV0010: Deployed "importVDB-vdb.xml" (runtime-name : "importVDB-vdb.xml")

2018-05-22 15:36:39,106 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-1)  TEIID40120 VDB importVDB.1 will be removed from the repository

2018-05-22 15:36:39,106 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-1)  TEIID40119 VDB importVDB.1 removed from the repository

2018-05-22 15:36:39,107 INFO  [org.teiid.RUNTIME] (MSC service thread 1-1)  TEIID50026 VDB "importVDB.1[importVDBSrcModel{importVDBSrcModel=importVDBSrcModel, phoenix, java:jboss/datasources/PhoenixDS}]" undeployed.

2018-05-22 15:36:39,107 TRACE [org.teiid.RUNTIME] (MSC service thread 1-1)  VDB importVDB metadata removed

2018-05-22 15:36:39,107 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-1)  TEIID40120 VDB importVDB.1 will be removed from the repository

2018-05-22 15:36:39,109 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-1)  WFLYSRV0028: Stopped deployment importVDB-vdb.xml (runtime-name: importVDB-vdb.xml) in 4ms

2018-05-22 15:36:39,129 INFO  [org.jboss.as.repository] (management-handler-thread - 2)  WFLYDR0002: Content removed from location /opt/teiid-10.1.1/standalone/data/content/2c/20f6d88f5c277da179bc689c3eade38b291274/content

2018-05-22 15:36:39,129 INFO  [org.jboss.as.server] (management-handler-thread - 2)  WFLYSRV0009: Undeployed "importVDB-vdb.xml" (runtime-name: "importVDB-vdb.xml")

2018-05-22 15:36:39,193 INFO  [org.jboss.as.repository] (management-handler-thread - 1)  WFLYDR0001: Content added at location /opt/teiid-10.1.1/standalone/data/content/2c/20f6d88f5c277da179bc689c3eade38b291274/content

2018-05-22 15:36:39,196 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-1)  WFLYSRV0027: Starting deployment of "importVDB-vdb.xml" (runtime-name: "importVDB-vdb.xml")

2018-05-22 15:36:39,205 DEBUG [org.teiid.RUNTIME] (MSC service thread 1-1)  VDB importVDB-vdb.xml has been parsed.

2018-05-22 15:36:39,222 INFO  [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-1)  TEIID40118 VDB importVDB.1 added to the repository

2018-05-22 15:36:39,222 INFO  [org.teiid.RUNTIME] (MSC service thread 1-1)  TEIID50029 VDB importVDB.1 model "importVDBSrcModel" metadata is currently being loaded. Start Time: 5/22/18 3:36 PM

2018-05-22 15:36:39,222 TRACE [org.teiid.RUNTIME] (MSC service thread 1-1)  Model  importVDBSrcModel in VDB  importVDB  was being loaded from its repository

2018-05-22 15:36:39,223 TRACE [org.teiid.RUNTIME] (Worker10_async-teiid-threads12)  Beginning work with virtual worker Worker10_async-teiid-threads12

2018-05-22 15:36:39,223 DEBUG [org.teiid.RUNTIME] (Worker10_async-teiid-threads12)  org.teiid.translator.TranslatorException: TEIID30481 Failed to find the Connection Factory with JNDI name java:jboss/datasources/PhoenixDS. Please check the name or deploy the Connection Factory with specified name. Failed to get a connection factory for metadata load.

2018-05-22 15:36:39,223 DEBUG [org.teiid.RUNTIME] (Worker10_async-teiid-threads12)  TEIID50104 VDB importVDB.1 model "importVDBSrcModel" Using translator phoenix and connection java:jboss/datasources/PhoenixDS to load metadata.

2018-05-22 15:36:39,223 WARN  [org.teiid.RUNTIME] (Worker10_async-teiid-threads12)  TEIID50036 VDB importVDB.1 model "importVDBSrcModel" metadata failed to load. Reason:TEIID31097 Metadata load requires a connection factory: TEIID30481 Failed to find the Connection Factory with JNDI name java:jboss/datasources/PhoenixDS. Please check the name or deploy the Connection Factory with specified name.: org.teiid.translator.TranslatorException: TEIID31097 Metadata load requires a connection factory

at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:53)

at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:51)

at org.teiid.jboss.VDBService$6.run(VDBService.java:337)

at org.teiid.jboss.VDBService$7.run(VDBService.java:388)

at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:280)

at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:115)

at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:206)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1160)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)

at java.lang.Thread.run(Thread.java:811)

2018-05-22 15:36:39,243 INFO  [org.jboss.as.server] (management-handler-thread - 1)  WFLYSRV0010: Deployed "importVDB-vdb.xml" (runtime-name : "importVDB-vdb.xml")

2018-05-22 15:36:48,660 DEBUG [org.teiid.TRANSPORT] (NIO1)  processing message:MessageHolder: key=564 contents=Invoke interface org.teiid.client.security.ILogon.ping

2018-05-22 15:36:48,661 TRACE [org.teiid.SECURITY] (NIO1)  Ping null

2018-05-22 15:36:48,661 DEBUG [org.teiid.TRANSPORT] (NIO1)  send message: MessageHolder: key=564 contents=null

2018-05-22 15:36:48,693 DEBUG [org.teiid.TRANSPORT] (NIO1)  processing message:MessageHolder: key=565 contents=Invoke interface org.teiid.client.security.ILogon.ping

2018-05-22 15:36:48,694 DEBUG [org.teiid.TRANSPORT] (NIO1)  send message: MessageHolder: key=565 contents=null

[rareddy]

What you showed above in log with error messge

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host DSQL-01.nasa.bcdtravel.local, port 1433 has failed. Error: "null. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".

with what is in the standalone-teiid.xml do not match up. You are not using same Teiid instance looks like or something wrong.

[srinath0533]

Im not sure why SQLServer is interfering here.  I tried JDBC connection using same jar files and i discovered Devstudio is not able read phoenix-4.13.1-HBase-1.1-client jar file.  It isthrowing the below error.

java.lang.reflect.InvocationTargetException

at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:398)

at org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDialog.java:483)

at org.eclipse.datatools.connectivity.internal.ui.drivers.DriverClassEditDialog.getClassList(DriverClassEditDialog.java:282)

at org.eclipse.datatools.connectivity.internal.ui.drivers.DriverClassEditDialog.populateClassList(DriverClassEditDialog.java:359)

at org.eclipse.datatools.connectivity.internal.ui.drivers.DriverClassEditDialog.handleOptionSelection(DriverClassEditDialog.java:228)

at org.eclipse.datatools.connectivity.internal.ui.drivers.DriverClassEditDialog.access$0(DriverClassEditDialog.java:218)

at org.eclipse.datatools.connectivity.internal.ui.drivers.DriverClassEditDialog$3.widgetDefaultSelected(DriverClassEditDialog.java:166)

at org.eclipse.datatools.connectivity.internal.ui.drivers.DriverClassEditDialog$3.widgetSelected(DriverClassEditDialog.java:170)

at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:249)

at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:86)

at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4428)

at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1079)

at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4238)

at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3817)

at org.eclipse.jface.operation.ModalContext$ModalContextThread.block(ModalContext.java:165)

at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:369)

at org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDialog.java:483)

at org.eclipse.datatools.connectivity.internal.ui.drivers.DriverClassEditDialog.getClassList(DriverClassEditDialog.java:282)

at org.eclipse.datatools.connectivity.internal.ui.drivers.DriverClassEditDialog.populateClassList(DriverClassEditDialog.java:359)

at org.eclipse.datatools.connectivity.internal.ui.drivers.DriverClassEditDialog.handleOptionSelection(DriverClassEditDialog.java:228)

at org.eclipse.datatools.connectivity.internal.ui.drivers.DriverClassEditDialog.access$0(DriverClassEditDialog.java:218)

at org.eclipse.datatools.connectivity.internal.ui.drivers.DriverClassEditDialog$1.widgetDefaultSelected(DriverClassEditDialog.java:137)

at org.eclipse.datatools.connectivity.internal.ui.drivers.DriverClassEditDialog$1.widgetSelected(DriverClassEditDialog.java:141)

at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:249)

at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:86)

at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4428)

at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1079)

at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4238)

at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3817)

at org.eclipse.jface.window.Window.runEventLoop(Window.java:818)

at org.eclipse.jface.window.Window.open(Window.java:794)

at org.eclipse.datatools.connectivity.ui.DriverClassBrowsePropertyDescriptor$DriverClassDialogCellEditor.openDialogBox(DriverClassBrowsePropertyDescriptor.java:100)

at org.eclipse.jface.viewers.DialogCellEditor.lambda$0(DialogCellEditor.java:240)

at org.eclipse.swt.events.SelectionListener$1.widgetSelected(SelectionListener.java:81)

at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:249)

at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:86)

at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4428)

at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1079)

at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4238)

at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3817)

at org.eclipse.jface.window.Window.runEventLoop(Window.java:818)

at org.eclipse.jface.window.Window.open(Window.java:794)

at org.eclipse.datatools.connectivity.internal.ui.DriverListCombo$NewButtonSelectionChangedListener.widgetSelected(DriverListCombo.java:813)

at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:249)

at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:86)

at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4428)

at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1079)

at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4238)

at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3817)

at org.eclipse.jface.window.Window.runEventLoop(Window.java:818)

at org.eclipse.jface.window.Window.open(Window.java:794)

at org.teiid.designer.ui.viewsupport.ModelerUiViewUtils$7.run(ModelerUiViewUtils.java:262)

at org.eclipse.swt.widgets.Synchronizer.syncExec(Synchronizer.java:233)

at org.eclipse.ui.internal.UISynchronizer.syncExec(UISynchronizer.java:144)

at org.eclipse.swt.widgets.Display.syncExec(Display.java:4889)

at org.teiid.designer.ui.viewsupport.ModelerUiViewUtils.launchWizard(ModelerUiViewUtils.java:240)

at org.teiid.designer.advisor.ui.actions.AdvisorActionFactory.createConnection(AdvisorActionFactory.java:914)

at org.teiid.designer.advisor.ui.actions.AdvisorActionFactory.executeAction(AdvisorActionFactory.java:505)

at org.teiid.designer.advisor.ui.views.guides.TeiidGuidesSection.launchGuidesAction(TeiidGuidesSection.java:281)

at org.teiid.designer.advisor.ui.views.guides.TeiidGuidesSection.access$1(TeiidGuidesSection.java:271)

at org.teiid.designer.advisor.ui.views.guides.TeiidGuidesSection$4.doubleClick(TeiidGuidesSection.java:174)

at org.eclipse.jface.viewers.StructuredViewer$1.run(StructuredViewer.java:831)

at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)

at org.eclipse.ui.internal.JFaceUtil.lambda$0(JFaceUtil.java:44)

at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:173)

at org.eclipse.jface.viewers.StructuredViewer.fireDoubleClick(StructuredViewer.java:828)

at org.eclipse.jface.viewers.AbstractTreeViewer.handleDoubleSelect(AbstractTreeViewer.java:1459)

at org.eclipse.jface.viewers.StructuredViewer$4.widgetDefaultSelected(StructuredViewer.java:1258)

at org.eclipse.jface.util.OpenStrategy.fireDefaultSelectionEvent(OpenStrategy.java:249)

at org.eclipse.jface.util.OpenStrategy.access$0(OpenStrategy.java:247)

at org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrategy.java:306)

at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:86)

at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4428)

at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1079)

at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4238)

at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3817)

at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$5.run(PartRenderingEngine.java:1150)

at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:336)

at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1039)

at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:153)

at org.eclipse.ui.internal.Workbench.lambda$3(Workbench.java:680)

at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:336)

at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:594)

at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:148)

at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:151)

at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)

at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)

at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)

at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:388)

at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:243)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:653)

at org.eclipse.equinox.launcher.Main.basicRun(Main.java:590)

at org.eclipse.equinox.launcher.Main.run(Main.java:1499)

at org.eclipse.equinox.launcher.Main.main(Main.java:1472)

Caused by: java.lang.IncompatibleClassChangeError: Implementing class

at java.lang.ClassLoader.defineClass1(Native Method)

at java.lang.ClassLoader.defineClass(Unknown Source)

at java.security.SecureClassLoader.defineClass(Unknown Source)

at java.net.URLClassLoader.defineClass(Unknown Source)

at java.net.URLClassLoader.access$100(Unknown Source)

at java.net.URLClassLoader$1.run(Unknown Source)

at java.net.URLClassLoader$1.run(Unknown Source)

at java.security.AccessController.doPrivileged(Native Method)

at java.net.URLClassLoader.findClass(Unknown Source)

at java.lang.ClassLoader.loadClass(Unknown Source)

at java.net.FactoryURLClassLoader.loadClass(Unknown Source)

at java.lang.ClassLoader.loadClass(Unknown Source)

at org.eclipse.datatools.connectivity.internal.DriverUtil.getDriverClassesFromJar2(DriverUtil.java:121)

at org.eclipse.datatools.connectivity.internal.DriverUtil.getDriverClassesFromJar(DriverUtil.java:84)

at org.eclipse.datatools.connectivity.internal.ui.drivers.DriverClassEditDialog$5.run(DriverClassEditDialog.java:286)

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

[rareddy]

First try to connect with tools like SQuirrel Or DBVisalizer and make sure you can connect and query, then come back to Teiid Designer to weed out any JAR or connection issues.