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

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

    Ning Tan Newbie

      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.