-
15. Re: Missing connector binding type - Oracle
The passage from the beta to the actual release chenged the connector cdk that was posted in this thread, tryed to create something basing on what I found in the current Oracle connector type, but no luck.
Here is the connector I'm trying to use:<ComponentType Name="Oracle 9i JDBC Connector" ComponentTypeCode="2" Deployable="true" Deprecated="false" Monitorable="false" SuperComponentType="Connector" ParentComponentType="Connectors" LastChangedBy="ConfigurationStartup" LastChangedDate="2008-10-31T10:26:19.922-06:00" CreatedBy="ConfigurationStartup" CreationDate="2008-10-31T10:26:19.922-06:00"> <PropertyDefinition Name="SourceConnectionTestInterval" DisplayName="Data Source Test Connect Interval (seconds)" ShortDescription="How often (in seconds) to create test connections to the underlying datasource to see if it is available." DefaultValue="600" Multiplicity="1" PropertyType="Integer" IsExpert="true" /> <PropertyDefinition Name="ExceptionOnMaxRows" DisplayName="Exception on Exceeding Max Rows" ShortDescription="Indicates if an Exception should be thrown if the specified value for Maximum Result Rows is exceeded; else no exception and no more than the maximum will be returned" DefaultValue="true" Multiplicity="1" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="supportsUnionOrderBy" DisplayName="supportsUnionOrderBy" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="supportsSelectLiterals" DisplayName="supportsSelectLiterals" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="supportsLikeCriteriaEscapeCharacter" DisplayName="supportsLikeCriteriaEscapeCharacter" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="supportsCorrelatedSubqueries" DisplayName="supportsCorrelatedSubqueries" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="ResultSetCacheScope" DisplayName="ResultSet Cache Scope" ShortDescription="" DefaultValue="vdb"> <AllowedValue>vdb</AllowedValue> <AllowedValue>session</AllowedValue> </PropertyDefinition> <PropertyDefinition Name="supportsAndCriteria" DisplayName="supportsAndCriteria" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="supportsIsNullCriteria" DisplayName="supportsIsNullCriteria" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="supportsLikeCriteria" DisplayName="supportsLikeCriteria" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="Password" DisplayName="Password" ShortDescription="" Multiplicity="1" IsConstrainedToAllowedValues="false" IsMasked="true" IsPreferred="true" /> <PropertyDefinition Name="supportsAggregatesAvg" DisplayName="supportsAggregatesAvg" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="supportsAggregatesCountStar" DisplayName="supportsAggregatesCountStar" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="supportsCompareCriteria" DisplayName="supportsCompareCriteria" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="ConnectorTypeClassPath" DisplayName="Connector Type Class Path" ShortDescription="Connector Type classpath (defined by system)" IsExpert="true" IsHidden="true" /> <PropertyDefinition Name="supportsOrderBy" DisplayName="supportsOrderBy" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="supportsCaseExpressions" DisplayName="supportsCaseExpressions" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="ServiceMonitoringEnabled" DisplayName="Data Source Monitoring Enabled" ShortDescription="Whether to monitor the underlying data source to see if it is available." DefaultValue="true" Multiplicity="1" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="supportsInCriteria" DisplayName="supportsInCriteria" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="supportsInlineViews" DisplayName="supportsInlineViews" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="supportsAggregatesMin" DisplayName="supportsAggregatesMin" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="supportsInCriteriaSubquery" DisplayName="supportsInCriteriaSubquery" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="supportsExistsCriteria" DisplayName="supportsExistsCriteria" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="supportsQuantifiedCompareCriteria" DisplayName="supportsQuantifiedCompareCriteria" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="supportsQuantifiedCompareCriteriaSome" DisplayName="supportsQuantifiedCompareCriteriaSome" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="UseCommentsInSourceQuery" DisplayName="Use informational comments in Source Queries" ShortDescription="This will embed /*comment*/ style comment with session/request id in source SQL query for informational purposes" DefaultValue="false" PropertyType="Boolean" IsPreferred="true" /> <PropertyDefinition Name="supportsCompareCriteriaGreaterThanOrEqual" DisplayName="supportsCompareCriteriaGreaterThanOrEqual" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="ExtensionCapabilityClass" DisplayName="Extension Capability Class" ShortDescription="" DefaultValue="org.teiid.connector.jdbc.oracle.OracleCapabilities" IsExpert="true" /> <PropertyDefinition Name="supportsCompareCriteriaEquals" DisplayName="supportsCompareCriteriaEquals" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="DatabaseTimeZone" DisplayName="Database time zone" ShortDescription="Time zone of the database, if different than Integration Server" IsExpert="true" /> <PropertyDefinition Name="getSupportedFunctions" DisplayName="getSupportedFunctions" ShortDescription="" IsExpert="true" /> <PropertyDefinition Name="supportsCompareCriteriaGreaterThan" DisplayName="supportsCompareCriteriaGreaterThan" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="TransactionIsolationLevel" DisplayName="Transaction Isolation Level" ShortDescription="Set the data source transaction isolation level" DefaultValue="" IsExpert="true" /> <PropertyDefinition Name="supportsCompareCriteriaNotEquals" DisplayName="supportsCompareCriteriaNotEquals" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="ResultSetCacheEnabled" DisplayName="ResultSet Cache Enabled" ShortDescription="" DefaultValue="false" PropertyType="Boolean" /> <PropertyDefinition Name="URL" DisplayName="JDBC URL" ShortDescription="" DefaultValue="jdbc:oracle:thin:@//<host>:1521:<sid>" Multiplicity="1" IsConstrainedToAllowedValues="false" IsPreferred="true" /> <PropertyDefinition Name="supportsAggregatesCount" DisplayName="supportsAggregatesCount" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="supportsUnions" DisplayName="supportsUnions" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="supportsCriteria" DisplayName="supportsCriteria" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="MaxResultRows" DisplayName="Maximum Result Rows" ShortDescription="" DefaultValue="10000" Multiplicity="1" PropertyType="Integer" IsExpert="true" /> <PropertyDefinition Name="supportsOuterJoins" DisplayName="supportsOuterJoins" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="supportsCompareCriteriaLessThanOrEqual" DisplayName="supportsCompareCriteriaLessThanOrEqual" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="supportsAggregatesSum" DisplayName="supportsAggregatesSum" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="UseBindVariables" DisplayName="Use prepared statements and bind variables" ShortDescription="" DefaultValue="false" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="ResultSetCacheMaxAge" DisplayName="ResultSet Cache Maximum Age (milliseconds)" ShortDescription="" DefaultValue="0" PropertyType="Long" /> <PropertyDefinition Name="supportsCompareCriteriaLessThan" DisplayName="supportsCompareCriteriaLessThan" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="supportsSearchedCaseExpressions" DisplayName="supportsSearchedCaseExpressions" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="supportsAggregatesDistinct" DisplayName="supportsAggregatesDistinct" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="supportsQuantifiedCompareCriteriaAll" DisplayName="supportsQuantifiedCompareCriteriaAll" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="supportsOrCriteria" DisplayName="supportsOrCriteria" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="ResultSetCacheMaxSize" DisplayName="ResultSet Cache Maximum Size (megabytes)" ShortDescription="" DefaultValue="0" PropertyType="Integer" /> <PropertyDefinition Name="Immutable" DisplayName="Is Immutable" ShortDescription="True if the source never changes." DefaultValue="false" Multiplicity="1" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="Driver" DisplayName="Driver Class" ShortDescription="" DefaultValue="oracle.jdbc.OracleDriver" Multiplicity="1" IsConstrainedToAllowedValues="false" /> <PropertyDefinition Name="ServiceClassName" DisplayName="Service Class Name" ShortDescription="" DefaultValue="com.metamatrix.server.connector.service.ConnectorService" Multiplicity="1" IsHidden="true" /> <PropertyDefinition Name="supportsNotCriteria" DisplayName="supportsNotCriteria" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="supportsSelfJoins" DisplayName="supportsSelfJoins" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="supportsBetweenCriteria" DisplayName="supportsBetweenCriteria" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="ConnectorThreadTTL" DisplayName="Thread Time to live (milliseconds)" ShortDescription="" DefaultValue="120000" Multiplicity="1" PropertyType="Integer" IsExpert="true" /> <PropertyDefinition Name="ExtensionTranslationClass" DisplayName="Extension SQL Translation Class" ShortDescription="" DefaultValue="org.teiid.connector.jdbc.oracle.OracleSQLTranslator" IsExpert="true" /> <PropertyDefinition Name="ConnectorClassPath" DisplayName="Class Path" ShortDescription="" DefaultValue="extensionjar:ojdbc14.jar;" Multiplicity="1" /> <PropertyDefinition Name="supportsJoins" DisplayName="supportsJoins" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="MaxSQLLength" DisplayName="Max SQL String Length" ShortDescription="" DefaultValue="16384" PropertyType="Integer" IsExpert="true" /> <PropertyDefinition Name="Standard" DisplayName="Standard Type" ShortDescription="Standard Built-in Connector Type" DefaultValue="true" PropertyType="Boolean" IsExpert="true" IsModifiable="false" /> <PropertyDefinition Name="metamatrix.service.essentialservice" DisplayName="Essential Service" ShortDescription="Indicates if the service is essential to operation of the Integration Server" DefaultValue="false" Multiplicity="1" PropertyType="Boolean" IsExpert="true" IsHidden="true" /> <PropertyDefinition Name="supportsScalarFunctions" DisplayName="supportsScalarFunctions" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="supportsSelectDistinct" DisplayName="supportsSelectDistinct" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="ConnectorClass" DisplayName="Connector Class" ShortDescription="" DefaultValue="org.teiid.connector.jdbc.JDBCConnector" Multiplicity="1" IsExpert="true" /> <PropertyDefinition Name="supportsFullOuterJoins" DisplayName="supportsFullOuterJoins" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="supportsScalarSubqueries" DisplayName="supportsScalarSubqueries" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="SetCriteriaBatchSize" DisplayName="Max Values in IN Predicate" ShortDescription="Max number of values in an IN Predicate. Must be >= 0." DefaultValue="1000" PropertyType="Integer" IsConstrainedToAllowedValues="false" IsExpert="true" /> <PropertyDefinition Name="supportsAggregates" DisplayName="supportsAggregates" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="ConnectorMaxThreads" DisplayName="Connector Maximum Thread Count" ShortDescription="" DefaultValue="20" Multiplicity="1" PropertyType="Integer" IsExpert="true" /> <PropertyDefinition Name="supportsAliasedGroup" DisplayName="supportsAliasedGroup" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="supportsOrderByInInlineViews" DisplayName="supportsOrderByInInlineViews" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="User" DisplayName="User Name" ShortDescription="" Multiplicity="1" IsConstrainedToAllowedValues="false" IsPreferred="true" /> <PropertyDefinition Name="supportsAggregatesMax" DisplayName="supportsAggregatesMax" ShortDescription="" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="TrimStrings" DisplayName="Trim string flag" ShortDescription="" DefaultValue="false" PropertyType="Boolean" IsExpert="true" /> </ComponentType>
This is the error (as before teiid read the tables, but does not save the connector)com.metamatrix.jdbc.MMSQLException: Connector Binding "Anaprod" failed to start, or did not start correctly. Please check the connector binding properties. Check the log file for more information. at com.metamatrix.jdbc.MMSQLException.create(MMSQLException.java:82) at com.metamatrix.jdbc.MMSQLException.create(MMSQLException.java:63) at com.metamatrix.jdbc.MMStatement.executeSql(MMStatement.java:424) at com.metamatrix.jdbc.MMPreparedStatement.executeQuery(MMPreparedStatement.java:192) at com.metamatrix.modeler.dqp.ui.workspace.WorkspaceExecutor.executeSQL(WorkspaceExecutor.java:204) at com.metamatrix.modeler.internal.dqp.ui.actions.PreviewTableDataContextAction$1QueryExecutor.run(PreviewTableDataContextAction.java:279) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121) Caused by: [ComponentNotFoundException]Connector Binding "Anaprod" failed to start, or did not start correctly. Please check the connector binding properties. Check the log file for more information. at com.metamatrix.dqp.embedded.services.EmbeddedDataService.selectConnector(EmbeddedDataService.java:122) at org.teiid.dqp.internal.process.capabilities.ConnectorCapabilitiesFinder.findCapabilities(ConnectorCapabilitiesFinder.java:64) at org.teiid.dqp.internal.process.capabilities.SharedCachedFinder.findCapabilities(SharedCachedFinder.java:64) at com.metamatrix.query.optimizer.relational.rules.CapabilitiesUtil.getCapabilities(CapabilitiesUtil.java:511) at com.metamatrix.query.optimizer.relational.rules.CapabilitiesUtil.requiresCriteria(CapabilitiesUtil.java:522) at com.metamatrix.query.optimizer.relational.rules.RulePlaceAccess.addAccessNode(RulePlaceAccess.java:139) at com.metamatrix.query.optimizer.relational.rules.RulePlaceAccess.execute(RulePlaceAccess.java:77) at com.metamatrix.query.optimizer.relational.RelationalPlanner.executeRules(RelationalPlanner.java:400) at com.metamatrix.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:144) at com.metamatrix.query.optimizer.QueryOptimizer.optimize(QueryOptimizer.java:241) at com.metamatrix.query.optimizer.QueryOptimizer.recursiveOptimize(QueryOptimizer.java:215) at com.metamatrix.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:123) at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:534) at org.teiid.dqp.internal.process.PreparedStatementRequest.generatePlan(PreparedStatementRequest.java:167) at org.teiid.dqp.internal.process.Request.processRequest(Request.java:623) at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:373) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:206) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:44) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source)
-
16. Re: Missing connector binding type - Oracle
This post is tied to the https://jira.jboss.org/jira/browse/TEIIDDES-194.
Are there any chances to have a cdk as in the previous post to use in the 6.0 release (since packages are changed?)
Thanks -
17. Re: Missing connector binding type - Oracle
The best approach will be to get you onto the Teiid 6.1.0 snapshot. If you are using Teiid Designer 6.0, I can walk you through the connector binding changes that are need to run in 6.1. Teiid Designer should be posting a 6.1.0 snapshot soon that will be in synch with Teiid 6.1.0 and will generate bindings that are forward compatible in the 6.x releases.
-
18. Re: Missing connector binding type - Oracle
please walk me through the changes since I'd like to see the results of the work started in the beta and need a working oracle connection.
-
19. Re: Missing connector binding type - Oracle
Path 1 - use the new Designer snapshot at http://sourceforge.net/project/showfiles.php?group_id=253052&package_id=309742. Using your existing model project, just recreate the oracle connector binding for the associated vdb.
Path 2 - use your existing vdb, but extract and edit the ConfigruationInfo.def contained in the vdb, then add it back to the vdb (using whatever zip file tools you're most familiar with). The connector binding for Anaprod Oracle should look like:<Connector Name="Anaprod" ComponentType="Oracle Connector" QueuedService="false" routingUUID="{previous value}"> <Properties> <Property Name="URL">{previous value}</Property> <Property Name="User">{previous value}</Property> <Property Name="Password">{previous value}</Property> <Property Name="ConnectorClassPath">extensionjar:ojdbc6.jar</Property> </Properties> </Connector>
This should be the same end result if you use the new Designer to recreate the connector binding. -
20. Re: Missing connector binding type - Oracle
Nothing works anymore.
Just installed the snapshot 6.1 (eclipse made an update of the plugin and I sincerely hope that this IS the correct way because We should not supposed to make a fresh eclipse installation each time there is an update).
MySQL does not work anymore (not tryed oracle, but have the feeling that it will be even worst).
The connector does not work anymore with this error:[ComponentNotFoundException]Connector Binding "MySQL_excel Connector" failed to start, or did not start correctly. Please check the connector binding properties. Check the log file for more information. at com.metamatrix.dqp.embedded.services.EmbeddedDataService.selectConnector(EmbeddedDataService.java:117) at org.teiid.dqp.internal.process.capabilities.ConnectorCapabilitiesFinder.findCapabilities(ConnectorCapabilitiesFinder.java:64) at org.teiid.dqp.internal.process.capabilities.SharedCachedFinder.findCapabilities(SharedCachedFinder.java:64) at com.metamatrix.query.optimizer.relational.rules.CapabilitiesUtil.getCapabilities(CapabilitiesUtil.java:363) at com.metamatrix.query.optimizer.relational.rules.CapabilitiesUtil.supports(CapabilitiesUtil.java:383) at com.metamatrix.query.optimizer.relational.rules.CapabilitiesUtil.requiresCriteria(CapabilitiesUtil.java:368) at com.metamatrix.query.optimizer.relational.rules.RulePlaceAccess.addAccessNode(RulePlaceAccess.java:141) at com.metamatrix.query.optimizer.relational.rules.RulePlaceAccess.execute(RulePlaceAccess.java:79) at com.metamatrix.query.optimizer.relational.RelationalPlanner.executeRules(RelationalPlanner.java:371) at com.metamatrix.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:142) at com.metamatrix.query.optimizer.QueryOptimizer.optimize(QueryOptimizer.java:244) at com.metamatrix.query.optimizer.QueryOptimizer.recursiveOptimize(QueryOptimizer.java:218) at com.metamatrix.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:126) at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:501) at org.teiid.dqp.internal.process.PreparedStatementRequest.generatePlan(PreparedStatementRequest.java:153) at org.teiid.dqp.internal.process.Request.processRequest(Request.java:593) at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:368) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:203) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:44) at com.metamatrix.common.queue.WorkerPoolFactory$StatsCapturingSharedThreadPoolExecutor$1.run(WorkerPoolFactory.java:211) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source)
So to be sure deleted all the model and created it from scratch:
same thing it connect to MySQL, create the model but the connector does not work
the first error in the message is:com.metamatrix.admin.api.exception.AdminComponentException: Could not find Connector class org.teiid.connector.jdbc.JDBCConnector at com.metamatrix.dqp.embedded.admin.BaseAdmin.accumulateSystemException(BaseAdmin.java:107) at com.metamatrix.dqp.embedded.admin.DQPRuntimeStateAdminImpl.startConnectorBinding(DQPRuntimeStateAdminImpl.java:116) 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 com.metamatrix.core.util.MixinProxy.invoke(MixinProxy.java:48) at com.metamatrix.jdbc.EmbeddedConnection$1.invoke(EmbeddedConnection.java:103) at $Proxy18.startConnectorBinding(Unknown Source) at com.metamatrix.modeler.dqp.ui.workspace.WorkspaceExecutor.startConnectorBinding(WorkspaceExecutor.java:257) at com.metamatrix.modeler.dqp.ui.workspace.WorkspaceExecutor.startConnnectorBindings(WorkspaceExecutor.java:240) at com.metamatrix.modeler.dqp.ui.workspace.WorkspaceExecutor.start(WorkspaceExecutor.java:128) at com.metamatrix.modeler.dqp.ui.DqpUiPlugin.start(DqpUiPlugin.java:189) at org.eclipse.osgi.framework.internal.core.BundleContextImpl$2.run(BundleContextImpl.java:1009) at java.security.AccessController.doPrivileged(Native Method) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:1003) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:984) at org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:346) at org.eclipse.osgi.framework.internal.core.AbstractBundle.start(AbstractBundle.java:265) at org.eclipse.osgi.framework.util.SecureAction.start(SecureAction.java:400) at org.eclipse.core.runtime.internal.adaptor.EclipseLazyStarter.postFindLocalClass(EclipseLazyStarter.java:111) at org.eclipse.osgi.baseadaptor.loader.ClasspathManager.findLocalClass(ClasspathManager.java:427) at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.findLocalClass(DefaultClassLoader.java:193) at org.eclipse.osgi.framework.internal.core.BundleLoader.findLocalClass(BundleLoader.java:368) at org.eclipse.osgi.framework.internal.core.BundleLoader.findClassInternal(BundleLoader.java:444) at org.eclipse.osgi.framework.internal.core.BundleLoader.findClass(BundleLoader.java:397) at org.eclipse.osgi.framework.internal.core.BundleLoader.findClass(BundleLoader.java:385) at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:87) at java.lang.ClassLoader.loadClass(Unknown Source) at org.eclipse.osgi.framework.internal.core.BundleLoader.loadClass(BundleLoader.java:313) at org.eclipse.osgi.framework.internal.core.BundleHost.loadClass(BundleHost.java:227) at org.eclipse.osgi.framework.internal.core.AbstractBundle.loadClass(AbstractBundle.java:1274) at org.eclipse.core.internal.registry.osgi.RegistryStrategyOSGI.createExecutableExtension(RegistryStrategyOSGI.java:160) at org.eclipse.core.internal.registry.ExtensionRegistry.createExecutableExtension(ExtensionRegistry.java:867) at org.eclipse.core.internal.registry.ConfigurationElement.createExecutableExtension(ConfigurationElement.java:243) at org.eclipse.core.internal.registry.ConfigurationElementHandle.createExecutableExtension(ConfigurationElementHandle.java:51) at com.metamatrix.modeler.internal.ui.viewsupport.ExtendedModelObjectLabelProvider.loadProviderList(ExtendedModelObjectLabelProvider.java:53) at com.metamatrix.modeler.internal.ui.viewsupport.ExtendedModelObjectLabelProvider.<init>(ExtendedModelObjectLabelProvider.java:33) at com.metamatrix.modeler.internal.ui.explorer.ModelExplorerLabelProvider.<init>(ModelExplorerLabelProvider.java:117) at com.metamatrix.modeler.internal.ui.editors.ModelEditor.<init>(ModelEditor.java:137) 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.newInstance0(Unknown Source) at java.lang.Class.newInstance(Unknown Source) at org.eclipse.core.internal.registry.osgi.RegistryStrategyOSGI.createExecutableExtension(RegistryStrategyOSGI.java:170) at org.eclipse.core.internal.registry.ExtensionRegistry.createExecutableExtension(ExtensionRegistry.java:867) at org.eclipse.core.internal.registry.ConfigurationElement.createExecutableExtension(ConfigurationElement.java:243) at org.eclipse.core.internal.registry.ConfigurationElementHandle.createExecutableExtension(ConfigurationElementHandle.java:51) at org.eclipse.ui.internal.WorkbenchPlugin$1.run(WorkbenchPlugin.java:267) at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70) at org.eclipse.ui.internal.WorkbenchPlugin.createExtension(WorkbenchPlugin.java:263) at org.eclipse.ui.internal.registry.EditorDescriptor.createEditor(EditorDescriptor.java:233) at org.eclipse.ui.internal.EditorManager.createPart(EditorManager.java:846) at org.eclipse.ui.internal.EditorReference.createPartHelper(EditorReference.java:606) at org.eclipse.ui.internal.EditorReference.createPart(EditorReference.java:428) at org.eclipse.ui.internal.WorkbenchPartReference.getPart(WorkbenchPartReference.java:594) at org.eclipse.ui.internal.EditorAreaHelper.setVisibleEditor(EditorAreaHelper.java:263) at org.eclipse.ui.internal.EditorManager.setVisibleEditor(EditorManager.java:1410) at org.eclipse.ui.internal.EditorManager$5.runWithException(EditorManager.java:944) at org.eclipse.ui.internal.StartupThreading$StartupRunnable.run(StartupThreading.java:31) at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35) at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:133) at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:3800) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3425) at org.eclipse.ui.application.WorkbenchAdvisor.openWindows(WorkbenchAdvisor.java:803) at org.eclipse.ui.internal.Workbench$27.runWithException(Workbench.java:1361) at org.eclipse.ui.internal.StartupThreading$StartupRunnable.run(StartupThreading.java:31) at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35) at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:133) at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:3800) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3425) at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2293) at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2198) at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:493) at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:288) at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:488) at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149) at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:113) at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:193) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:386) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179) 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:549) at org.eclipse.equinox.launcher.Main.basicRun(Main.java:504) at org.eclipse.equinox.launcher.Main.run(Main.java:1236) Caused by: com.metamatrix.common.application.exception.ApplicationLifecycleException: Could not find Connector class org.teiid.connector.jdbc.JDBCConnector at org.teiid.dqp.internal.datamgr.impl.ConnectorManager.initStartConnector(ConnectorManager.java:414) at org.teiid.dqp.internal.datamgr.impl.ConnectorManager.start(ConnectorManager.java:337) at com.metamatrix.dqp.embedded.services.EmbeddedDataService.startConnectorBinding(EmbeddedDataService.java:241) at com.metamatrix.dqp.embedded.admin.DQPRuntimeStateAdminImpl.startConnectorBinding(DQPRuntimeStateAdminImpl.java:114) ... 90 more Caused by: com.metamatrix.core.MetaMatrixCoreException: org.teiid.connector.jdbc.JDBCConnector at com.metamatrix.core.util.ReflectionHelper.create(ReflectionHelper.java:285) at org.teiid.dqp.internal.datamgr.impl.ConnectorManager.initStartConnector(ConnectorManager.java:400) ... 93 more Caused by: com.metamatrix.core.MetaMatrixCoreException: org.teiid.connector.jdbc.JDBCConnector at com.metamatrix.core.util.ReflectionHelper.create(ReflectionHelper.java:299) at com.metamatrix.core.util.ReflectionHelper.create(ReflectionHelper.java:283) ... 94 more Caused by: java.lang.ClassNotFoundException: org.teiid.connector.jdbc.JDBCConnector 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.lang.ClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClassInternal(Unknown Source) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Unknown Source) at com.metamatrix.core.util.ReflectionHelper.loadClass(ReflectionHelper.java:251) at com.metamatrix.core.util.ReflectionHelper.create(ReflectionHelper.java:292) ... 95 more
Starting to loose hope.
Luca -
21. Re: Missing connector binding type - Oracle
Unfortunately, Teiid and Teiid Designer are trying to complete configuration/connector changes that impact .... connectors.
Though we still do recommend a fresh Eclipse install, you could try specifying a New Workspace location on your file system at start-up (insert '-clean' in your eclipse.ini to insure eclipse clears cashes).
This will insure that all new Teiid connector property changes and driver/extension jars are installed for that workspace.
You could move your projects (models) to this new location and add the projects via "File > Add Existing Project..." action to restore them to this new workspace. You'll have to re-create your connectors and drivers, but your models should be ok.
Barry -
22. Re: Missing connector binding type - Oracle
made a new installation of the designer and it works agani ...
Please make the update procedure work because how are we supposed to recover the models we created with the previous versions of the designer?
If the update of the plugin does not work how do we recover the models?
Will look on the Oracle part now. -
23. Re: Missing connector binding type - Oracle
Tested with Oracle, the connector is created, correctly added and the running ma works.
Now will try to undestand how to recover the view models done with the 6.0pre -
24. Re: Missing connector binding type - Oracle
Your Model projects and "models" are recoverable and exist under whatever file system folder (i.e. workspace) you declared at start-up. These projects can be imported into Eclipse, so they are recoverable as long as they exist on your file system.
BTW... this thread is under "Teiid", there is a "Teiid Designer" bucket that would be more appropriate for these discussions/questions.
Barry -