-
1. Re: Teiid Importer for HBase integration
rareddy May 14, 2018 1:58 PM (in response to srinath0533)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 May 17, 2018 2:35 PM (in response to rareddy)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 May 17, 2018 2:44 PM (in response to srinath0533)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 May 22, 2018 2:16 PM (in response to rareddy)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 May 22, 2018 2:20 PM (in response to srinath0533) -
6. Re: Teiid Importer for HBase integration
srinath0533 May 22, 2018 3:40 PM (in response to 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 May 22, 2018 3:43 PM (in response to srinath0533)Attach your module.xml and standalone-teiid.xml
-
8. Re: Teiid Importer for HBase integration
srinath0533 May 24, 2018 4:27 PM (in response to rareddy)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
-
module.xml.zip 348 bytes
-
standalone-teiid.xml.zip 6.4 KB
-
-
9. Re: Teiid Importer for HBase integration
rareddy May 23, 2018 3:52 PM (in response to srinath0533)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 May 24, 2018 5:20 PM (in response to rareddy)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 May 25, 2018 9:35 AM (in response to srinath0533)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.