11 Replies Latest reply on May 25, 2018 9:35 AM by rareddy

    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

        • 1. Re: Teiid Importer for HBase integration
          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.

          • 2. Re: Teiid Importer for HBase integration
            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?

             

             

            • 3. Re: Teiid Importer for HBase integration
              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.

              • 4. Re: Teiid Importer for HBase integration
                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.

                • 5. Re: Teiid Importer for HBase integration
                  srinath0533

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

                   

                  • 6. Re: Teiid Importer for HBase integration
                    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. 

                    • 7. Re: Teiid Importer for HBase integration
                      rareddy

                      Attach your module.xml and standalone-teiid.xml

                      • 8. Re: Teiid Importer for HBase integration
                        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

                        • 9. Re: Teiid Importer for HBase integration
                          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.

                          • 10. Re: Teiid Importer for HBase integration
                            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)

                            • 11. Re: Teiid Importer for HBase integration
                              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.