-
1. Re: Missing connector binding type - Oracle
There are couple of issues going on here, let me see I can explain
Connector Type - This defines a source and all its required and default properties. However, currently in this release we only have templates set up to work with DataDirect drivers. That is why you are seeing the issue. In next releases, we will be coming up with templates for vendor supplied drivers like oracle, db2 etc in next release.
However, there is generic type called "JDBC Connector", you can use that and fill in the "driver" property and "ConnectorClasspath" properties to what you are using to create a connector of your choice. by doing this way you would need to manually create a connector each time you import from source.
or
Copy the below code fragment into a file called "Oracle9i.cdk" and import the file in the Designer, using the Connectors tab's import button.<?xml version="1.0" encoding="UTF-8"?> <ConfigurationDocument> <Header> <ConfigurationVersion>4.2</ConfigurationVersion> <ApplicationCreatedBy>Designer</ApplicationCreatedBy> <ApplicationVersion>5.5.3</ApplicationVersion> <UserCreatedBy>designer</UserCreatedBy> <MetaMatrixSystemVersion>6.0</MetaMatrixSystemVersion> <Time>2009-03-24T09:47:37.288-06:00</Time> </Header> <ComponentTypes> <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="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="ResultSetCacheScope" DisplayName="ResultSet Cache Scope" ShortDescription="" DefaultValue="vdb"> <AllowedValue>vdb</AllowedValue> <AllowedValue>session</AllowedValue> </PropertyDefinition> <PropertyDefinition Name="Password" DisplayName="Password" ShortDescription="" Multiplicity="1" IsConstrainedToAllowedValues="false" IsMasked="true" IsPreferred="true" /> <PropertyDefinition Name="ExtensionResultsTranslationClass" DisplayName="Extension Results Translation Class" ShortDescription="" DefaultValue="com.metamatrix.connector.jdbc.oracle.OracleResultsTranslator" IsExpert="true" /> <PropertyDefinition Name="com.metamatrix.data.pool.wait_for_source_time" DisplayName="Pool Connection Waiting Time (milliseconds)" ShortDescription="Set the time to wait if the connection is not available" DefaultValue="120000" PropertyType="Integer" IsExpert="true" /> <PropertyDefinition Name="ResultSetCacheMaxSize" DisplayName="ResultSet Cache Maximum Size (megabytes)" ShortDescription="" DefaultValue="0" PropertyType="Integer" /> <PropertyDefinition Name="Driver" DisplayName="Driver Class" ShortDescription="" DefaultValue="oracle.jdbc.driver.OracleDriver " Multiplicity="1" IsConstrainedToAllowedValues="false" /> <PropertyDefinition Name="ConnectorClassPath" DisplayName="Class Path" ShortDescription="" DefaultValue="extensionjar:ojdbc14.jar;" Multiplicity="1" /> <PropertyDefinition Name="MaxSQLLength" DisplayName="Max SQL String Length" ShortDescription="" DefaultValue="16384" PropertyType="Integer" 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="com.metamatrix.data.pool.cleaning_interval" DisplayName="Pool cleaning Interval (seconds)" ShortDescription="Set the interval to cleaning the pool" DefaultValue="60" 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="com.metamatrix.data.pool.max_connections_for_each_id" DisplayName="Pool Maximum Connections for Each ID" ShortDescription="Set the maximum number of connections for each connector ID for the connection pool" DefaultValue="20" Multiplicity="1" PropertyType="Integer" IsExpert="true" /> <PropertyDefinition Name="ConnectorClass" DisplayName="Connector Class" ShortDescription="" DefaultValue="com.metamatrix.connector.jdbc.JDBCConnector" Multiplicity="1" IsExpert="true" /> <PropertyDefinition Name="ExtensionCapabilityClass" DisplayName="Extension Capability Class" ShortDescription="" DefaultValue="com.metamatrix.connector.jdbc.oracle.OracleCapabilities" IsExpert="true" /> <PropertyDefinition Name="DatabaseTimeZone" DisplayName="Database time zone" ShortDescription="Time zone of the database, if different than Integration Server" IsExpert="true" /> <PropertyDefinition Name="TransactionIsolationLevel" DisplayName="Transaction Isolation Level" ShortDescription="Set the data source transaction isolation level" DefaultValue="" 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="ExtensionSQLTranslationClass" DisplayName="Extension SQL Translation Class" ShortDescription="" DefaultValue="com.metamatrix.connector.jdbc.oracle.OracleSQLTranslator" 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="com.metamatrix.data.pool.max_connections" DisplayName="Pool Maximum Connections" ShortDescription="Set the maximum number of connections for the connection pool" DefaultValue="20" Multiplicity="1" PropertyType="Integer" IsExpert="true" /> <PropertyDefinition Name="com.metamatrix.data.pool.live_and_unused_time" DisplayName="Pool Connection Idle Time (seconds)" ShortDescription="Set the idle time of the connection before it should be closed if pool shrinking is enabled" DefaultValue="60" PropertyType="Integer" IsExpert="true" /> <PropertyDefinition Name="User" DisplayName="User Name" ShortDescription="" Multiplicity="1" IsConstrainedToAllowedValues="false" IsPreferred="true" /> <PropertyDefinition Name="com.metamatrix.data.pool.enable_shrinking" DisplayName="Pool Shrinking Enabled" ShortDescription="Set whether to enable the pool shrinking" DefaultValue="true" PropertyType="Boolean" IsExpert="true" /> <PropertyDefinition Name="ExtensionConnectionFactoryClass" DisplayName="Extension Connection Factory Class" ShortDescription="" DefaultValue="com.metamatrix.connector.jdbc.oracle.OracleSingleIdentityConnectionFactory" IsExpert="true" /> <PropertyDefinition Name="TrimStrings" DisplayName="Trim string flag" ShortDescription="" DefaultValue="false" PropertyType="Boolean" IsExpert="true" /> </ComponentType> </ComponentTypes> </ConfigurationDocument>
[please note the above xml is only valid in pre-6.0 release]
Follow through the wizard, and supply the oracle driver file. Now next time you import from Oracle using the driver you imported that will create a Connector for it automatically.
You can change the "Driver" and "ConnectorClasspath" properties in the above xml and customize it for any Oracle driver version you may be using.
As per the synonyms is concerned, I think it is the capability of the driver it self, whether driver can support it providing the metadata, I will let some body else answer it if they know more about it.
Hope this helps.
Ramesh.. -
2. Re: Missing connector binding type - Oracle
Ummmm ...
no luck
Here is the error when I try to create a new binding:
Could not start Connector ConnectorID<31>. Unable to load the JDBC driver class "oracle.jdbc.driver.OracleDriver ".
Stacktrace.com.metamatrix.admin.api.exception.AdminComponentException: Could not start Connector ConnectorID<31>. Unable to load the JDBC driver class "oracle.jdbc.driver.OracleDriver ". at com.metamatrix.dqp.embedded.admin.BaseAdmin.accumulateSystemException(BaseAdmin.java:113) at com.metamatrix.dqp.embedded.admin.DQPRuntimeStateAdminImpl.startConnectorBinding(DQPRuntimeStateAdminImpl.java:114) 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.jdbc.EmbeddedConnection$1.invoke(EmbeddedConnection.java:119) at $Proxy12.startConnectorBinding(Unknown Source) at com.metamatrix.modeler.dqp.ui.workspace.WorkspaceExecutor.addConnectorBinding(WorkspaceExecutor.java:345) at com.metamatrix.modeler.dqp.ui.workspace.WorkspaceExecutor$BindingListener.handleConnectorBindingEvent(WorkspaceExecutor.java:493) at com.metamatrix.modeler.dqp.ui.workspace.WorkspaceExecutor$BindingListener.stateChanged(WorkspaceExecutor.java:472) at com.metamatrix.modeler.dqp.internal.config.ConfigurationManagerImpl.fireChangeEvent(ConfigurationManagerImpl.java:469) at com.metamatrix.modeler.dqp.internal.config.ConfigurationManagerImpl.saveConfigLocal(ConfigurationManagerImpl.java:142) at com.metamatrix.modeler.dqp.internal.config.ConfigurationManagerImpl.addBinding(ConfigurationManagerImpl.java:220) at com.metamatrix.modeler.dqp.internal.config.ConfigurationManagerImpl.createConnectorBinding(ConfigurationManagerImpl.java:508) at com.metamatrix.modeler.internal.dqp.ui.workspace.dialogs.NewConnectorBindingPanel.getConnectorBinding(NewConnectorBindingPanel.java:359) at com.metamatrix.modeler.internal.dqp.ui.workspace.dialogs.NewConnectorBindingPanel.internalDispose(NewConnectorBindingPanel.java:600) at com.metamatrix.modeler.internal.dqp.ui.workspace.dialogs.NewConnectorBindingDialog.okPressed(NewConnectorBindingDialog.java:141) at org.eclipse.jface.dialogs.Dialog.buttonPressed(Dialog.java:472) at org.eclipse.jface.dialogs.Dialog$2.widgetSelected(Dialog.java:624) at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:228) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1003) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3823) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3422) at org.eclipse.jface.window.Window.runEventLoop(Window.java:825) at org.eclipse.jface.window.Window.open(Window.java:801) at com.metamatrix.modeler.internal.dqp.ui.workspace.actions.NewConnectorBindingAction.run(NewConnectorBindingAction.java:54) at org.eclipse.jface.action.Action.runWithEvent(Action.java:498) at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:583) at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:500) at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:411) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1003) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3823) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3422) at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2382) at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2346) 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 start Connector ConnectorID<31>. Unable to load the JDBC driver class "oracle.jdbc.driver.OracleDriver ". at com.metamatrix.dqp.internal.datamgr.impl.ConnectorManager.initStartConnector(ConnectorManager.java:389) at com.metamatrix.dqp.internal.datamgr.impl.ConnectorManager.start(ConnectorManager.java:310) at com.metamatrix.dqp.embedded.services.EmbeddedDataService.startConnectorBinding(EmbeddedDataService.java:244) at com.metamatrix.dqp.embedded.admin.DQPRuntimeStateAdminImpl.startConnectorBinding(DQPRuntimeStateAdminImpl.java:112) ... 54 more Caused by: com.metamatrix.data.exception.ConnectorException: Unable to load the JDBC driver class "oracle.jdbc.driver.OracleDriver ". at com.metamatrix.connector.jdbc.JDBCSourceConnectionFactory.createDriver(JDBCSourceConnectionFactory.java:80) at com.metamatrix.connector.jdbc.JDBCSingleIdentityConnectionFactory.verifyConnectionProperties(JDBCSingleIdentityConnectionFactory.java:73) at com.metamatrix.connector.jdbc.JDBCSingleIdentityConnectionFactory.initialize(JDBCSingleIdentityConnectionFactory.java:59) at com.metamatrix.connector.jdbc.JDBCConnector.start(JDBCConnector.java:132) at com.metamatrix.dqp.internal.datamgr.impl.ConnectorManager.initStartConnector(ConnectorManager.java:387) ... 57 more Caused by: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver at org.eclipse.osgi.framework.internal.core.BundleLoader.findClassInternal(BundleLoader.java:481) 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 com.metamatrix.common.classloader.NonDelegatingClassLoader.loadClass(NonDelegatingClassLoader.java:90) at com.metamatrix.connector.jdbc.JDBCSourceConnectionFactory.createDriver(JDBCSourceConnectionFactory.java:77) ... 61 more
the jar is present in the UDF jars (when I imported the connector it stated that it was going to use that one).
Also the import from DB does not work.
By the way how can I remove the imported connector? -
3. Re: Missing connector binding type - Oracle
There is GUI way to delete the type yet, but if you want do it manually, look for a file called "configuration.xml" in your eclipse workspace (under .metadata directory) and edit it and remove that section of the XML fragment. Make sure you keep a backup copy before you edit it.
The stack trace shows that "oracle.jdbc.driver.OracleDriver" class not found, are you sure you added the right jar? can you make sure the above class in that jar file? Is the driver class is not the right class for Oracle? -
4. Re: Missing connector binding type - Oracle
Verified and ... :
the jar is present in:
D:\eclipse\eclipse-teiid\workspace\.metadata\.plugins\com.metamatrix.modeler.dqp\extensions
This should the place where it places the jar to work after one add to the UDF mapping (right??)
The jar contain the specified class
The class is used with other sql tool (SquirrelSQL) and works (the tool get also data from synonyms ;-) )
Will try to delete the connector and reimport it to see if there is something I missed.
Luca -
5. Re: Missing connector binding type - Oracle
also I'm trying to find the connector_patch.jar to understand where is the root for "extensionjar" but I'm not able to find it no jar with this name around in the eclipse installation
-
6. Re: Missing connector binding type - Oracle
another strange thing.
The driver MUST be correct and used correctly because it connect to the DB read the synonyms and creates tables (with empty columns, but this should be another problem).
I believe that there is something between the connector classes from metamatrix .. ops teiid and the oracle driver.
Is it possible that the stuff that does the connection is not the same stuff that look after the connector bindings? -
7. Re: Missing connector binding type - Oracle
Here some more update.
- Removed the connector from config file.
all went well (a good new)
- imported again choosing a folder (that is d:\instantclient_10_2) to find the ojdbc14.jar
apparently all wen well, but in the property stiil present "extensionjar:ojdbc14.jar" ... ummm strange shouldn't be saved the absolute path I choose?
- made the import of a model from DB
oracle connects, read the syn, table etc. (I just have those horrible syn), made the import, generate the empty tables (so it talks with Oracle since it cannot infer or guess the correct syn names ;-) ).
end up with complaintd that it cannot create the binding:
Missing connector binding type (model=Oracle_INTPDWH.xmi, driver=oracle)
An exception stack trace is not available.
OK an exception trace could be usefull, but ... ok I will help, let's create the connector by hand.
NO WAY!!
created and stilll cannot find the class.
OK still have that extensionjar around so let's try to make it read the file.
since it's an URL asubstituted with:
file:///D:/instantclient_10_2/ojdbc14.jar
still no luck no class and this is the stack trace:
com.metamatrix.common.application.exception.ApplicationLifecycleException: Could not start Connector ConnectorID<181>. Unable to load the JDBC driver class "oracle.jdbc.OracleDriver ".
at com.metamatrix.dqp.internal.datamgr.impl.ConnectorManager.initStartConnector(ConnectorManager.java:389)
at com.metamatrix.dqp.internal.datamgr.impl.ConnectorManager.start(ConnectorManager.java:310)
at com.metamatrix.dqp.embedded.services.EmbeddedDataService.startConnectorBinding(EmbeddedDataService.java:244)
at com.metamatrix.dqp.embedded.services.EmbeddedDataService$1.loaded(EmbeddedDataService.java:328)
at com.metamatrix.dqp.embedded.services.EmbeddedConfigurationService.notifyConnectorBindingLoad(EmbeddedConfigurationService.java:1416)
at com.metamatrix.dqp.embedded.services.EmbeddedConfigurationService.deployConnectorBinding(EmbeddedConfigurationService.java:1166)
at com.metamatrix.dqp.embedded.services.EmbeddedConfigurationService.saveConnectorBinding(EmbeddedConfigurationService.java:753)
at com.metamatrix.dqp.embedded.services.EmbeddedConfigurationService.addConnectorBinding(EmbeddedConfigurationService.java:727)
at com.metamatrix.dqp.embedded.admin.DQPConfigAdminImpl.addConnectorBinding(DQPConfigAdminImpl.java:404)
at com.metamatrix.dqp.embedded.admin.DQPConfigAdminImpl.addConnectorBinding(DQPConfigAdminImpl.java:296)
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.jdbc.EmbeddedConnection$1.invoke(EmbeddedConnection.java:119)
at $Proxy12.addConnectorBinding(Unknown Source)
at com.metamatrix.modeler.dqp.ui.workspace.WorkspaceExecutor.addConnectorBinding(WorkspaceExecutor.java:339)
at com.metamatrix.modeler.dqp.ui.workspace.WorkspaceExecutor$BindingListener.handleConnectorBindingEvent(WorkspaceExecutor.java:498)
at com.metamatrix.modeler.dqp.ui.workspace.WorkspaceExecutor$BindingListener.stateChanged(WorkspaceExecutor.java:472)
at com.metamatrix.modeler.dqp.internal.config.ConfigurationManagerImpl.fireChangeEvent(ConfigurationManagerImpl.java:469)
at com.metamatrix.modeler.dqp.internal.config.ConfigurationManagerImpl.saveConfigLocal(ConfigurationManagerImpl.java:142)
at com.metamatrix.modeler.dqp.internal.config.ConfigurationManagerImpl.setConnectorPropertyValue(ConfigurationManagerImpl.java:621)
at com.metamatrix.modeler.dqp.util.ModelerDqpUtils.setPropertyValue(ModelerDqpUtils.java:508)
at com.metamatrix.modeler.internal.dqp.ui.workspace.ConnectorBindingPropertySource.setPropertyValue(ConnectorBindingPropertySource.java:243)
at org.eclipse.ui.views.properties.PropertySheetEntry.valueChanged(PropertySheetEntry.java:782)
at org.eclipse.ui.views.properties.PropertySheetEntry.setValue(PropertySheetEntry.java:723)
at org.eclipse.ui.views.properties.PropertySheetEntry.applyEditorValue(PropertySheetEntry.java:146)
at org.eclipse.ui.views.properties.PropertySheetViewer.applyEditorValue(PropertySheetViewer.java:258)
at org.eclipse.ui.views.properties.PropertySheetViewer.handleSelect(PropertySheetViewer.java:710)
at org.eclipse.ui.views.properties.PropertySheetViewer.access$8(PropertySheetViewer.java:707)
at org.eclipse.ui.views.properties.PropertySheetViewer$6.mouseDown(PropertySheetViewer.java:817)
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:179)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1003)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3823)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3422)
at org.eclipse.jface.window.Window.runEventLoop(Window.java:825)
at org.eclipse.jface.window.Window.open(Window.java:801)
at org.eclipse.jface.dialogs.MessageDialog.openError(MessageDialog.java:322)
at com.metamatrix.modeler.dqp.ui.DqpUiPlugin.showErrorDialog(DqpUiPlugin.java:57)
at com.metamatrix.modeler.internal.dqp.ui.workspace.ConnectorBindingPropertySource$1.run(ConnectorBindingPropertySource.java:250)
at com.metamatrix.ui.internal.util.UiUtil.runInSwtThread(UiUtil.java:420)
at com.metamatrix.modeler.internal.dqp.ui.workspace.ConnectorBindingPropertySource.setPropertyValue(ConnectorBindingPropertySource.java:247)
at org.eclipse.ui.views.properties.PropertySheetEntry.valueChanged(PropertySheetEntry.java:782)
at org.eclipse.ui.views.properties.PropertySheetEntry.setValue(PropertySheetEntry.java:723)
at org.eclipse.ui.views.properties.PropertySheetEntry.applyEditorValue(PropertySheetEntry.java:146)
at org.eclipse.ui.views.properties.PropertySheetEntry$1.applyEditorValue(PropertySheetEntry.java:103)
at org.eclipse.jface.viewers.CellEditor$1.run(CellEditor.java:333)
at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:37)
at org.eclipse.core.runtime.Platform.run(Platform.java:880)
at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:48)
at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:175)
at org.eclipse.jface.viewers.CellEditor.fireApplyEditorValue(CellEditor.java:331)
at org.eclipse.jface.viewers.CellEditor.focusLost(CellEditor.java:716)
at org.eclipse.jface.viewers.TextCellEditor$5.focusLost(TextCellEditor.java:186)
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:137)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1003)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1027)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1008)
at org.eclipse.swt.widgets.Control.sendFocusEvent(Control.java:2429)
at org.eclipse.swt.widgets.Widget.wmKillFocus(Widget.java:1765)
at org.eclipse.swt.widgets.Control.WM_KILLFOCUS(Control.java:4130)
at org.eclipse.swt.widgets.Control.windowProc(Control.java:3820)
at org.eclipse.swt.widgets.Text.windowProc(Text.java:2078)
at org.eclipse.swt.widgets.Display.windowProc(Display.java:4541)
at org.eclipse.swt.internal.win32.OS.CallWindowProcW(Native Method)
at org.eclipse.swt.internal.win32.OS.CallWindowProc(OS.java:2274)
at org.eclipse.swt.widgets.Tree.callWindowProc(Tree.java:1529)
at org.eclipse.swt.widgets.Tree.WM_LBUTTONDOWN(Tree.java:6446)
at org.eclipse.swt.widgets.Control.windowProc(Control.java:3822)
at org.eclipse.swt.widgets.Tree.windowProc(Tree.java:5791)
at org.eclipse.swt.widgets.Display.windowProc(Display.java:4541)
at org.eclipse.swt.internal.win32.OS.DispatchMessageW(Native Method)
at org.eclipse.swt.internal.win32.OS.DispatchMessage(OS.java:2371)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3420)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2382)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2346)
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.data.exception.ConnectorException: Unable to load the JDBC driver class "oracle.jdbc.OracleDriver ".
at com.metamatrix.connector.jdbc.JDBCSourceConnectionFactory.createDriver(JDBCSourceConnectionFactory.java:80)
at com.metamatrix.connector.jdbc.JDBCSingleIdentityConnectionFactory.verifyConnectionProperties(JDBCSingleIdentityConnectionFactory.java:73)
at com.metamatrix.connector.jdbc.JDBCSingleIdentityConnectionFactory.initialize(JDBCSingleIdentityConnectionFactory.java:59)
at com.metamatrix.connector.jdbc.JDBCConnector.start(JDBCConnector.java:132)
at com.metamatrix.dqp.internal.datamgr.impl.ConnectorManager.initStartConnector(ConnectorManager.java:387)
... 95 more
Caused by: java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver
at org.eclipse.osgi.framework.internal.core.BundleLoader.findClassInternal(BundleLoader.java:481)
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 com.metamatrix.common.classloader.NonDelegatingClassLoader.loadClass(NonDelegatingClassLoader.java:90)
at com.metamatrix.connector.jdbc.JDBCSourceConnectionFactory.createDriver(JDBCSourceConnectionFactory.java:77)
... 99 more
Since the class is in the jar there is just one solution (at least is rthe only one it came to my mind) it must ignore the settings and look around in some place he likes.If you know where please tell me so that I can try it out -
8. Re: Missing connector binding type - Oracle
Looks like there is "space" at the end of the class name "oracle.jdbc.OracleDriver ", thus the issues.
- Correct the name of the driver, and re-import the connector.
"extensionjar:" is Teiid's internal protocol for defining a source location url for all the dynamic modules, so that we can load from variety of sources.
We are working towards bridging the gap between the import time driver creation and connector time creation, to make them as single source, but is not available right now. -
9. Re: Missing connector binding type - Oracle
WOW.
I really need a new pair of glasses.
This problem seems to be set (I edited the config.xml file withoput importing the connector again, it seems to work, just to let you know).
Now for the synonym part ... ?
Any idea?
Can I get the colums and see the data?
For some application this is blocking.
Luca -
10. Re: Missing connector binding type - Oracle
I have tried to include the "synonyms" in my test import model from Oracle and I have seen the same behaviour with Oracle native (thin) drivers. So, the Oracle driver is not providing the metadata required through this driver for Teiid designer.
In the supported (metamatrix) product it uses "data direct" drivers, those seem to work correctly, so if you have access to them I would recommend using them.
As a work around, you could download the tables, but change their "NameInSource" property to reflect to that of "Synonym" name, so that Teiid will use synonym name at the runtime. But, I do not know if this is a recommend practise, but surely will work IMO. -
11. Re: Missing connector binding type - Oracle
Ok I'm following up this post since I'm trying now to use a VDB that uses the Oracle connector created with the previous instruction plus a MYSql connector with jasper iReport.
I get this error:Session mag 19, 2009 12:00:09.813 ---------------------------------------------- java.version=1.6.0_04 java.vendor=Sun Microsystems Inc. BootLoader constants: OS=Windows XP, ARCH=x86 mag 19, 2009 12:00:11.188 [Thread-10|0] WARNING <DQP|0> Service "dqp.authorization" is null. Can not install it in DQP. mag 19, 2009 12:00:12.344 [Thread-10|0] ERROR <DQP|0> Connector Binding superInfodir_1.AnaProd Connector failed to start, check the properties and start again. com.metamatrix.common.application.exception.ApplicationLifecycleException: Could not find Connector class com.metamatrix.connector.jdbc.JDBCConnector at org.teiid.dqp.internal.datamgr.impl.ConnectorManager.initStartConnector(ConnectorManager.java:385) at org.teiid.dqp.internal.datamgr.impl.ConnectorManager.start(ConnectorManager.java:336) at com.metamatrix.dqp.embedded.services.EmbeddedDataService.startConnectorBinding(EmbeddedDataService.java:231) at com.metamatrix.dqp.embedded.services.EmbeddedDataService.startService(EmbeddedDataService.java:345) at com.metamatrix.dqp.embedded.services.EmbeddedBaseDQPService.start(EmbeddedBaseDQPService.java:73) at com.metamatrix.common.application.Application.installService(Application.java:78) at com.metamatrix.common.application.Application.start(Application.java:63) at org.teiid.dqp.internal.process.DQPCore.start(DQPCore.java:563) at com.metamatrix.jdbc.EmbeddedConnectionFactoryImpl.initialize(EmbeddedConnectionFactoryImpl.java:113) at com.metamatrix.jdbc.EmbeddedConnectionFactoryImpl.createConnection(EmbeddedConnectionFactoryImpl.java:79) at com.metamatrix.jdbc.EmbeddedDriver$EmbeddedTransport.createConnection(EmbeddedDriver.java:502) at com.metamatrix.jdbc.EmbeddedDriver.createConnection(EmbeddedDriver.java:134) at com.metamatrix.jdbc.EmbeddedDriver.connect(EmbeddedDriver.java:114) at com.jaspersoft.ireport.designer.connection.JDBCConnection.getConnection(JDBCConnection.java:149) at com.jaspersoft.ireport.designer.data.fieldsproviders.SQLFieldsProvider.getFields(SQLFieldsProvider.java:165) at com.jaspersoft.ireport.designer.data.ReportQueryDialog$FieldReader.run(ReportQueryDialog.java:560) Caused by: com.metamatrix.core.MetaMatrixCoreException: com.metamatrix.connector.jdbc.JDBCConnector at com.metamatrix.core.util.ReflectionHelper.create(ReflectionHelper.java:285) at org.teiid.dqp.internal.datamgr.impl.ConnectorManager.initStartConnector(ConnectorManager.java:371) ... 15 more Caused by: com.metamatrix.core.MetaMatrixCoreException: com.metamatrix.connector.jdbc.JDBCConnector at com.metamatrix.core.util.ReflectionHelper.create(ReflectionHelper.java:299) at com.metamatrix.core.util.ReflectionHelper.create(ReflectionHelper.java:283) ... 16 more Caused by: java.lang.ClassNotFoundException: com.metamatrix.connector.jdbc.JDBCConnector at java.net.URLClassLoader$1.run(URLClassLoader.java:200) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:188) at java.lang.ClassLoader.loadClass(ClassLoader.java:306) at java.lang.ClassLoader.loadClass(ClassLoader.java:251) at com.metamatrix.common.classloader.NonDelegatingClassLoader.loadClass(NonDelegatingClassLoader.java:88) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:247) at com.metamatrix.core.util.ReflectionHelper.loadClass(ReflectionHelper.java:251) at com.metamatrix.core.util.ReflectionHelper.create(ReflectionHelper.java:292) ... 17 more mag 19, 2009 12:00:12.360 [Thread-10|0] ERROR <DQP|0> Connector Binding superInfodir_1.Infodir_prod Connector failed to start, check the properties and start again. com.metamatrix.common.application.exception.ApplicationLifecycleException: Could not find Connector class com.metamatrix.connector.jdbc.JDBCConnector at org.teiid.dqp.internal.datamgr.impl.ConnectorManager.initStartConnector(ConnectorManager.java:385) at org.teiid.dqp.internal.datamgr.impl.ConnectorManager.start(ConnectorManager.java:336) at com.metamatrix.dqp.embedded.services.EmbeddedDataService.startConnectorBinding(EmbeddedDataService.java:231) at com.metamatrix.dqp.embedded.services.EmbeddedDataService.startService(EmbeddedDataService.java:345) at com.metamatrix.dqp.embedded.services.EmbeddedBaseDQPService.start(EmbeddedBaseDQPService.java:73) at com.metamatrix.common.application.Application.installService(Application.java:78) at com.metamatrix.common.application.Application.start(Application.java:63) at org.teiid.dqp.internal.process.DQPCore.start(DQPCore.java:563) at com.metamatrix.jdbc.EmbeddedConnectionFactoryImpl.initialize(EmbeddedConnectionFactoryImpl.java:113) at com.metamatrix.jdbc.EmbeddedConnectionFactoryImpl.createConnection(EmbeddedConnectionFactoryImpl.java:79) at com.metamatrix.jdbc.EmbeddedDriver$EmbeddedTransport.createConnection(EmbeddedDriver.java:502) at com.metamatrix.jdbc.EmbeddedDriver.createConnection(EmbeddedDriver.java:134) at com.metamatrix.jdbc.EmbeddedDriver.connect(EmbeddedDriver.java:114) at com.jaspersoft.ireport.designer.connection.JDBCConnection.getConnection(JDBCConnection.java:149) at com.jaspersoft.ireport.designer.data.fieldsproviders.SQLFieldsProvider.getFields(SQLFieldsProvider.java:165) at com.jaspersoft.ireport.designer.data.ReportQueryDialog$FieldReader.run(ReportQueryDialog.java:560) Caused by: com.metamatrix.core.MetaMatrixCoreException: com.metamatrix.connector.jdbc.JDBCConnector at com.metamatrix.core.util.ReflectionHelper.create(ReflectionHelper.java:285) at org.teiid.dqp.internal.datamgr.impl.ConnectorManager.initStartConnector(ConnectorManager.java:371) ... 15 more Caused by: com.metamatrix.core.MetaMatrixCoreException: com.metamatrix.connector.jdbc.JDBCConnector at com.metamatrix.core.util.ReflectionHelper.create(ReflectionHelper.java:299) at com.metamatrix.core.util.ReflectionHelper.create(ReflectionHelper.java:283) ... 16 more Caused by: java.lang.ClassNotFoundException: com.metamatrix.connector.jdbc.JDBCConnector at java.net.URLClassLoader$1.run(URLClassLoader.java:200) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:188) at java.lang.ClassLoader.loadClass(ClassLoader.java:306) at java.lang.ClassLoader.loadClass(ClassLoader.java:251) at com.metamatrix.common.classloader.NonDelegatingClassLoader.loadClass(NonDelegatingClassLoader.java:88) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:247) at com.metamatrix.core.util.ReflectionHelper.loadClass(ReflectionHelper.java:251) at com.metamatrix.core.util.ReflectionHelper.create(ReflectionHelper.java:292) ... 17 more mag 19, 2009 12:00:12.360 [Thread-10|0] ERROR <DQP|0> Connector Binding superInfodir_1.excelMY Connector failed to start, check the properties and start again. com.metamatrix.common.application.exception.ApplicationLifecycleException: Could not find Connector class com.metamatrix.connector.jdbc.JDBCConnector at org.teiid.dqp.internal.datamgr.impl.ConnectorManager.initStartConnector(ConnectorManager.java:385) at org.teiid.dqp.internal.datamgr.impl.ConnectorManager.start(ConnectorManager.java:336) at com.metamatrix.dqp.embedded.services.EmbeddedDataService.startConnectorBinding(EmbeddedDataService.java:231) at com.metamatrix.dqp.embedded.services.EmbeddedDataService.startService(EmbeddedDataService.java:345) at com.metamatrix.dqp.embedded.services.EmbeddedBaseDQPService.start(EmbeddedBaseDQPService.java:73) at com.metamatrix.common.application.Application.installService(Application.java:78) at com.metamatrix.common.application.Application.start(Application.java:63) at org.teiid.dqp.internal.process.DQPCore.start(DQPCore.java:563) at com.metamatrix.jdbc.EmbeddedConnectionFactoryImpl.initialize(EmbeddedConnectionFactoryImpl.java:113) at com.metamatrix.jdbc.EmbeddedConnectionFactoryImpl.createConnection(EmbeddedConnectionFactoryImpl.java:79) at com.metamatrix.jdbc.EmbeddedDriver$EmbeddedTransport.createConnection(EmbeddedDriver.java:502) at com.metamatrix.jdbc.EmbeddedDriver.createConnection(EmbeddedDriver.java:134) at com.metamatrix.jdbc.EmbeddedDriver.connect(EmbeddedDriver.java:114) at com.jaspersoft.ireport.designer.connection.JDBCConnection.getConnection(JDBCConnection.java:149) at com.jaspersoft.ireport.designer.data.fieldsproviders.SQLFieldsProvider.getFields(SQLFieldsProvider.java:165) at com.jaspersoft.ireport.designer.data.ReportQueryDialog$FieldReader.run(ReportQueryDialog.java:560) Caused by: com.metamatrix.core.MetaMatrixCoreException: com.metamatrix.connector.jdbc.JDBCConnector at com.metamatrix.core.util.ReflectionHelper.create(ReflectionHelper.java:285) at org.teiid.dqp.internal.datamgr.impl.ConnectorManager.initStartConnector(ConnectorManager.java:371) ... 15 more Caused by: com.metamatrix.core.MetaMatrixCoreException: com.metamatrix.connector.jdbc.JDBCConnector at com.metamatrix.core.util.ReflectionHelper.create(ReflectionHelper.java:299) at com.metamatrix.core.util.ReflectionHelper.create(ReflectionHelper.java:283) ... 16 more Caused by: java.lang.ClassNotFoundException: com.metamatrix.connector.jdbc.JDBCConnector at java.net.URLClassLoader$1.run(URLClassLoader.java:200) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:188) at java.lang.ClassLoader.loadClass(ClassLoader.java:306) at java.lang.ClassLoader.loadClass(ClassLoader.java:251) at com.metamatrix.common.classloader.NonDelegatingClassLoader.loadClass(NonDelegatingClassLoader.java:88) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:247) at com.metamatrix.core.util.ReflectionHelper.loadClass(ReflectionHelper.java:251) at com.metamatrix.core.util.ReflectionHelper.create(ReflectionHelper.java:292) ... 17 more mag 19, 2009 12:00:14.266 [QueryProcessorQueue0|0] ERROR <DQP|0> ############# PW EXITING on 00000000-0000-0001-0000-000000000001.0 - error occurred ########### [ComponentNotFoundException]Connector Binding "superInfodir_1.Infodir_prod 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: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(ThreadPoolExecutor.java:885) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907) at java.lang.Thread.run(Thread.java:619)
I've managed to connect to the VDB from iReport, but the problem seems in the deploy of the VDB.
I've deployed using the export to file and placed the "superInfodir" VDB in the deploy and I'm using the file path connection string.
I've missed something in the export?
I do not understand the connection problems.
It doesn't connect nor to Oracle nor to MySQL.
Where can be the problem?
Thanks -
12. Re: Missing connector binding type - Oracle
Are you using a VDB from a recent version of Teiid Designer? The stacktrace shows the connector binding has com.metamatrix.connector.jdbc.JDBCConnection, which would be from the MetaMatrix product line. The upcoming platform release will provide backwards compatibility with MetaMatrix connectors/connector bindings, but that is not part of the initial community release. You should be able to switch to the appropriate new JDBC Connector type using Teiid Designer.
-
13. Re: Missing connector binding type - Oracle
I was using the beta version of the designer, since I started working at that time.
It seems that the new embedded distribution changed the package names (which is reasonable, but unexpected).
So now I'm installing a new version of eclipse with the most recent designer and I'm giving a quick try to see if everithing goes well in that case the question is since I do not want to loose all the work:
1) I update the eclipse plugin and can just make the export (do I have to change the class definitions in the custom Oracle connector do I? Please confirm it)
2) copy all the folder from the beta version of the designer to the new one.
Which is the best?
Thanks -
14. Re: Missing connector binding type - Oracle
No it doesn't work but the errors seems caused by something different so I'll post a new thread.
Luca