Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
JDBC ODBC issue
JulienC
<p>Hi,</p>
<p> </p>
<p>I'm trying to add the JDBC-ODBC Driver.</p>
<p> </p>
<p>I've created the Data Source in my Windows Administrative tool and added the rt.jar file in my driver list in BIRT (Version 4.4.0).</p>
<p> </p>
<p>But when i enter the URL ("jdbc:odbc:Comptoir") and test the connection i get the following error : </p>
<p> </p>
<p>org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, null</p>
<div>at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:336)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:209)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.tryCreateConnection(JDBCDriverManager.java:824)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.testConnection(JDBCDriverManager.java:745)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.ui.util.DriverLoader.testConnection(DriverLoader.java:147)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.ui.util.DriverLoader.testConnection(DriverLoader.java:175)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.ui.profile.JDBCSelectionPageHelper.testConnection(JDBCSelectionPageHelper.java:998)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.ui.profile.JDBCSelectionPageHelper.access$11(JDBCSelectionPageHelper.java:960)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.ui.profile.JDBCSelectionPageHelper$8.widgetSelected(JDBCSelectionPageHelper.java:883)</div>
<div>at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:248)</div>
<div>at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)</div>
<div>at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)</div>
<div>at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4169)</div>
<div>at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3758)</div>
<div>at org.eclipse.jface.window.Window.runEventLoop(Window.java:825)</div>
<div>at org.eclipse.jface.window.Window.open(Window.java:801)</div>
<div>at org.eclipse.birt.report.designer.ui.dialogs.BaseDialog.open(BaseDialog.java:117)</div>
<div>at org.eclipse.birt.report.designer.data.ui.providers.EditableDataSourceNodeProvider.performEdit(EditableDataSourceNodeProvider.java:73)</div>
<div>at org.eclipse.birt.report.designer.internal.ui.views.DefaultNodeProvider.performRequest(DefaultNodeProvider.java:472)</div>
<div>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</div>
<div>at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)</div>
<div>at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)</div>
<div>at java.lang.reflect.Method.invoke(Method.java:483)</div>
<div>at org.eclipse.birt.report.designer.ui.views.ElementAdapterInvocationHandler.invoke(ElementAdapterInvocationHandler.java:89)</div>
<div>at com.sun.proxy.$Proxy41.performRequest(Unknown Source)</div>
<div>at org.eclipse.birt.report.designer.internal.ui.views.actions.EditAction.doAction(EditAction.java:85)</div>
<div>at org.eclipse.birt.report.designer.internal.ui.views.actions.AbstractElementAction.run(AbstractElementAction.java:70)</div>
<div>at org.eclipse.birt.report.designer.internal.ui.views.RenameListener.doubleClick(RenameListener.java:214)</div>
<div>at org.eclipse.jface.viewers.StructuredViewer$1.run(StructuredViewer.java:845)</div>
<div>at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)</div>
<div>at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:49)</div>
<div>at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:175)</div>
<div>at org.eclipse.jface.viewers.StructuredViewer.fireDoubleClick(StructuredViewer.java:843)</div>
<div>at org.eclipse.jface.viewers.AbstractTreeViewer.handleDoubleSelect(AbstractTreeViewer.java:1477)</div>
<div>at org.eclipse.jface.viewers.StructuredViewer$4.widgetDefaultSelected(StructuredViewer.java:1246)</div>
<div>at org.eclipse.jface.util.OpenStrategy.fireDefaultSelectionEvent(OpenStrategy.java:249)</div>
<div>at org.eclipse.jface.util.OpenStrategy.access$0(OpenStrategy.java:246)</div>
<div>at org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrategy.java:307)</div>
<div>at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)</div>
<div>at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)</div>
<div>at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4169)</div>
<div>at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3758)</div>
<div>at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$9.run(PartRenderingEngine.java:1053)</div>
<div>at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)</div>
<div>at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:942)</div>
<div>at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:86)</div>
<div>at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:588)</div>
<div>at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)</div>
<div>at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:543)</div>
<div>at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)</div>
<div>at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:124)</div>
<div>at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)</div>
<div>at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)</div>
<div>at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)</div>
<div>at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:353)</div>
<div>at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:180)</div>
<div>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</div>
<div>at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)</div>
<div>at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)</div>
<div>at java.lang.reflect.Method.invoke(Method.java:483)</div>
<div>at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:629)</div>
<div>at org.eclipse.equinox.launcher.Main.basicRun(Main.java:584)</div>
<div>at org.eclipse.equinox.launcher.Main.run(Main.java:1438)</div>
<div> </div>
<div> </div>
<div>It used to work 2 month ago but since then i've updated to the latest BIRT version and hadn't try since.</div>
<div>Any hints ?</div>
<div> </div>
<div>Julien</div>
Find more posts tagged with
Comments
malaythecool
<p>had you set your driver and than tested the connection or not?</p>
<p> </p>
<p>Malay</p>
JulienC
<p>Yes, i've set the 'rt.jar' driver from the JRE directory and then tested my connection.</p>
<p> </p>
<p>I also tested with others Access files, same result.</p>
<p> </p>
<p>Julien</p>
Clement Wong
<p>I'm not sure what Java version you are using, but it was removed from JDK 8.</p>
<p><a data-ipb='nomediaparse' href='
https://docs.oracle.com/javase/7/docs/technotes/guides/jdbc/bridge.html'>https://docs.oracle.com/javase/7/docs/technotes/guides/jdbc/bridge.html</a></p>
;
<p><a data-ipb='nomediaparse' href='
https://blogs.oracle.com/Lance/entry/removal_of_the_jdbc_odbc'>https://blogs.oracle.com/Lance/entry/removal_of_the_jdbc_odbc</a></p>
;
<p> </p>
<p style="margin-left:40px;"><em>"The JDBC-ODBC Bridge should be considered a transitional solution..."</em></p>
<p style="margin-left:40px;"><em>"Oracle recommends that you use JDBC drivers provided by the vendor of your database instead of the JDBC-ODBC Bridge."</em></p>
<p> </p>
<p><a data-ipb='nomediaparse' href='
https://en.wikipedia.org/wiki/Open_Database_Connectivity#JDBC-to-ODBC_.28or_simply_JDBC-ODBC.29_bridges'>https://en.wikipedia.org/wiki/Open_Database_Connectivity#JDBC-to-ODBC_.28or_simply_JDBC-ODBC.29_bridges</a></p>
;
<p><em>"Sun never intended its bridge for production environments, and generally recommended against its use."</em></p>
<p> </p>
<p> </p>
<p>What is the backend datasource/database that needs to use ODBC?</p>
JulienC
<p>Hi,</p>
<p> </p>
<p>I managed to find a solution trying multiple others drivers.</p>
<p>I found that <a data-ipb='nomediaparse' href='
http://www.hxtt.com/'>http://www.hxtt.com/</a>has
a working one. </p>
<p> </p>
<p>Thanks for the help anyway.</p>
<p> </p>
<p>Regards,</p>
<p> </p>
<p>Julien.</p>