6 Replies Latest reply on Oct 23, 2013 4:38 PM by rareddy

Teiid Designer: Java exception in last step of creating source model for JDBC data source

delta2038 Oct 23, 2013 3:12 PM

Hello. I'm creating a simple prototype that demonstrates a typical data integration user case using MySQL data sources. So first step I'm using Teiid Designer to create a source model against this JDBC data source. From within Teiid Designer, I am able to get to the point where I can connect to the data source and browse the schema just fine, but when I try to hit Finish in the last step of the Import Database via JDBC dialog, I encounter the following Java exception:

java.lang.RuntimeException: java.lang.Exception: No ExecutionAdmin factory registered for teiid instance version 8.5.0.Final.

at org.teiid.designer.core.ModelerCore.getTeiidQueryService(ModelerCore.java:2191)

at org.teiid.designer.metamodels.relational.util.RelationalTypeMappingImpl.getDatatype(RelationalTypeMappingImpl.java:156)

at org.teiid.designer.jdbc.relational.impl.RelationalModelProcessorImpl.findType(RelationalModelProcessorImpl.java:1471)

at org.teiid.designer.jdbc.relational.impl.RelationalModelProcessorImpl.findType(RelationalModelProcessorImpl.java:1450)

at org.teiid.designer.jdbc.relational.impl.RelationalModelProcessorImpl.setColumnInfo(RelationalModelProcessorImpl.java:1322)

at org.teiid.designer.jdbc.relational.impl.RelationalModelProcessorImpl.createColumns(RelationalModelProcessorImpl.java:1273)

at org.teiid.designer.jdbc.relational.impl.RelationalModelProcessorImpl.createNewObject(RelationalModelProcessorImpl.java:1175)

at org.teiid.designer.jdbc.relational.impl.RelationalModelProcessorImpl.createNewObject(RelationalModelProcessorImpl.java:1222)

at org.teiid.designer.jdbc.relational.impl.RelationalModelProcessorImpl.performExecute(RelationalModelProcessorImpl.java:845)

at org.teiid.designer.jdbc.relational.impl.RelationalModelProcessorImpl$1.run(RelationalModelProcessorImpl.java:343)

at org.teiid.designer.core.ModelEditorImpl.executeAsTransaction(ModelEditorImpl.java:567)

at org.teiid.designer.core.ModelEditorImpl.executeAsTransaction(ModelEditorImpl.java:611)

at org.teiid.designer.jdbc.relational.impl.RelationalModelProcessorImpl.executeWithinTransaction(RelationalModelProcessorImpl.java:350)

at org.teiid.designer.jdbc.relational.impl.RelationalModelProcessorImpl.executeWithinTransaction(RelationalModelProcessorImpl.java:325)

at org.teiid.designer.jdbc.relational.impl.RelationalModelProcessorImpl.execute(RelationalModelProcessorImpl.java:315)

at org.teiid.designer.jdbc.ui.wizards.JdbcImportWizard.runFinish(JdbcImportWizard.java:752)

at org.teiid.designer.jdbc.ui.wizards.JdbcImportWizard$1.run(JdbcImportWizard.java:292)

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

Caused by: java.lang.Exception: No ExecutionAdmin factory registered for teiid instance version 8.5.0.Final.

at org.teiid.designer.runtime.registry.TeiidRuntimeRegistry.getQueryService(TeiidRuntimeRegistry.java:148)

at org.teiid.designer.core.ModelerCore.getTeiidQueryService(ModelerCore.java:2189)

... 17 more

This error happens regardless of whether the EAP server is running or not. I assume this is happening because I missed a step in the installation/setup of something somewhere. Below are details about my setup. Can anybody help?

Eclipse: Kepler Service Release 1

Teiid Designer plugin: 8.2.0.Final-v20130817-0508-B2400

Teiid: teiid-8.5.0.Final

JBoss: eap-6.1.0.Alpha

MySQL: mysql Ver 14.14 Distrib 5.6.13, for osx10.8 (x86_64) using EditLine wrapper

MySQL JDBC driver: mysql-connector-java-5.1.26-bin.jar

Mac OS X Mountain Lion

java version "1.6.0_51"

Java(TM) SE Runtime Environment (build 1.6.0_51-b11-456-11M4508)

Java HotSpot(TM) 64-Bit Server VM (build 20.51-b01-456, mixed mode)

Please let me know if you need more information.

1. Re: Teiid Designer: Java exception in last step of creating source model for JDBC data source

rareddy Oct 23, 2013 3:33 PM (in response to delta2038)

What is your "Default Teiid Instance" set to? Look on right hand side, below the "model explorer" window. If is not selected any JBoss AS server, click the link and select a default instance.
Actions
2. Re: Teiid Designer: Java exception in last step of creating source model for JDBC data source

delta2038 Oct 23, 2013 3:37 PM (in response to rareddy)

Server: mm://localhost:9999
Targeted Version: 8.5.0.Final
Actions
3. Re: Teiid Designer: Java exception in last step of creating source model for JDBC data source

delta2038 Oct 23, 2013 3:59 PM (in response to delta2038)

Should I try Teiid 8.4? Does Teiid Designer 8.2.0 Final work with Teiid 8.5.Final? The versioning is a bit confusing here.
Actions
4. Re: Teiid Designer: Java exception in last step of creating source model for JDBC data source

blafond Oct 23, 2013 4:16 PM (in response to delta2038)

8.2 Teiid Designer is compatible with 8.4 Teiid. See our downloads page for release compatibility info: Download & Install - JBoss Community

Our upcoming 8.3 Teiid Designer release will still be targeted for 8.4 Teiid.

Teiid 8.5/8.6 will be supported by an 8.4 Designer release after that.

Barry
Teiid Designer Team
Actions
5. Re: Teiid Designer: Java exception in last step of creating source model for JDBC data source

delta2038 Oct 23, 2013 4:31 PM (in response to blafond)

Thanks! I'll revert to 8.4 Teiid and report back if I continue to have issues.
Actions
6. Re: Teiid Designer: Java exception in last step of creating source model for JDBC data source

rareddy Oct 23, 2013 4:38 PM (in response to blafond)

@Barry: The Admin API has not changed between 8.4 and 8.5, what causes Teiid Designer to be sticky with particular version for execution? I understand for query validation stuff. May be there should be two different modules in Designer side as to remote server for execution purpose, and in built library for validation to de-couple. comments?
Actions

Go to original post