Skip to main content



      Home
Home » Archived » BIRT » error loading JDBC drivers on creating Data Source
error loading JDBC drivers on creating Data Source [message #257002] Thu, 04 October 2007 02:55 Go to next message
Eclipse UserFriend
Originally posted by: matthew.kerle+birt.dha.gov.au

Hi all,

Windows XPSP2
Eclipse version: 3.2.0 (Jre 1.6.0_02) (installed to D:\programs\eclipse\)
BIRT : 2.1.1 & 2.1.2 (v20070205-1728)
EMF 2.2.0.v200606271057
GEF 3.2.0.v20060626

We're having some troubles getting started with BIRT, we've installed the
BIRT plugins into our existing eclipse IDE's, and run "eclipse -clean". we
can open the report perspective and create a business report no worries,
but we can't create any Data Sources.

first we tried to create a datasource according to the online tutorial
(link #1) using the embedded derby sampledb, but on clicking the 'Test
Connection' button we get an error box that only has the name of the derby
driver (see link #2)

We tried using an oracle driver as well, and got a slightly more
informative error (#3). It seems like for some reason our BIRT install
can't load JDBC drivers, well, the embedded derby and an oracle one
anyway...

Just wondering if anyone has any idea's what could be causing this?

thanks!

matt.


#1 - online tutorial we used.
http://download.eclipse.org/birt/downloads/examples/reports/ 2.1/tutorial/tutorial.html

#2 - this is trying to use the embedded BIRT derby driver:
http://hotimg3.fotki.com/p/a/152_91/61_209/birt_error_msg.jp g

#3 - this is trying to use Oracle 10G driver
http://hotimg5.fotki.com/p/a/152_91/61_209/birt_error_msg2.j pg
Re: error loading JDBC drivers on creating Data Source [message #257028 is a reply to message #257002] Thu, 04 October 2007 06:43 Go to previous messageGo to next message
Eclipse UserFriend
Did you add your jdbc drivers to the
org.eclipse.birt.report.data.oda.jdbc_2.2.x plugin in drivers folder?


--
Cristinel Angheluta
Software Engineer

Bucharest Stock Exchange
34 - 36 Carol I Boulevard 020922, 14th Floor,
Bucharest 2, Romania

Phone: +40-21-3079512/166
Fax: +40-21-3079519
email: cristinel.angheluta@bvb.ro
web: http://www.bvb.ro/
Re: error loading JDBC drivers on creating Data Source [message #257227 is a reply to message #257028] Thu, 04 October 2007 19:28 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: matthew.kerle+birt.dha.gov.au

No we hadn't, we just used the "Manage Drivers" button provided by the
interface. checking the folder on disk now the Oracle JDBC driver is
present (I assume it gets copied there by BIRT), but the error persists.

Most of my team is experiencing this error. We had one cowboy who
developed a lot of reporting functionality in BIRT, then left. We're now
trying to carry on but are finding we can't connect to any data sources in
eclipse due to this error. One team member has managed to work around it
by deleting and reinstalling a number of times, but he doesn't know what
actually fixed the problem, as copying a working eclipse install from one
machine to another results in the error again, so maybe it's some kind of
environmental mis-configuration????

we're pretty stumped...
Re: error loading JDBC drivers on creating Data Source [message #257231 is a reply to message #257028] Thu, 04 October 2007 20:13 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: matthew.kerle+birt.dha.gov.au

just installed the SQL Explorer plugin to test loading a jdbc driver in
eclipse and connecting to target database, and it was able to load the
oracle thin driver and connect Ok, so not sure what the issue is, but it
seems to be specific to the BIRT plugin...
Re: error loading JDBC drivers on creating Data Source [message #257236 is a reply to message #257028] Thu, 04 October 2007 21:47 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: matthew.kerle+birt.dha.gov.au

Is there a way to turn on extra logging so we can get extra information?
the problem at the moment is that we just have no idea where in the chain
things are breaking as there's not enough info supplied in the error
message (just the driver name, and the fact that an error window pops up).

If we could enable debug level logging or something and get extra info out
of the failure, like the root exception then that would be fantastic.

thanks!

matt.
Re: error loading JDBC drivers on creating Data Source [message #257728 is a reply to message #257236] Tue, 09 October 2007 22:51 Go to previous messageGo to next message
Eclipse UserFriend
Matt,
JRE 1.6 is not yet officially supported by BIRT. So the first thing I would
suggest is to use JRE 1.5. If you are not doing this already, try
downloading the BIRT all-in-one package from the BIRT download page, which
includes the Eclipse SDK and supported versions of dependent plugins. It's
also worth trying a more recent release of BIRT (such as 2.1.3 or 2.2.1) and
see if your problem is resovled.

regards,
--
Gary Xue [Actuate Corporation | BIRT Committer]


"matt" <matthew.kerle+birt@dha.gov.au> wrote in message
news:bb2e550b047ff4887098c2550e36a865$1@www.eclipse.org...
> Is there a way to turn on extra logging so we can get extra information?
> the problem at the moment is that we just have no idea where in the chain
> things are breaking as there's not enough info supplied in the error
> message (just the driver name, and the fact that an error window pops up).
>
> If we could enable debug level logging or something and get extra info out
> of the failure, like the root exception then that would be fantastic.
>
> thanks!
>
> matt.
>
Re: error loading JDBC drivers on creating Data Source [message #257883 is a reply to message #257728] Wed, 10 October 2007 20:16 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: matthew.kerle+birt.dha.gov.au

thanks for your reply Gary.

Ok, I downloaded the birt-report-designer-all-in-one-2_2_1, and changed my
PATH so that eclipse runs on JDK 1.5.0_11.

I still get the same exception (below). anything else we can try?


org.eclipse.birt.report.data.oda.jdbc.JDBCException:
org.apache.derby.jdbc.EmbeddedDriver
at
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.test Connection(JDBCDriverManager.java:522)
at
org.eclipse.birt.report.data.oda.jdbc.ui.util.DriverLoader.t estConnection(DriverLoader.java:108)
at
org.eclipse.birt.report.data.oda.jdbc.ui.profile.JDBCSelecti onPageHelper.testConnection(JDBCSelectionPageHelper.java:622 )
at
org.eclipse.birt.report.data.oda.jdbc.ui.profile.JDBCSelecti onPageHelper.access$7(JDBCSelectionPageHelper.java:606)
at
org.eclipse.birt.report.data.oda.jdbc.ui.profile.JDBCSelecti onPageHelper$6.widgetSelected(JDBCSelectionPageHelper.java:5 28)
at
org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListe ner.java:227)
(34 lines elided for clarity)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java: 508)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:447)
at org.eclipse.equinox.launcher.Main.run(Main.java:1173)


java version:
*** Date: Thursday, 11 October 2007 10:15:05 AM Sydney (Australia)

*** Platform Details:

*** System properties:
awt.toolkit=sun.awt.windows.WToolkit
birt.viewer.working.path=C:\Documents and
Settings\mkerle\workspace\.metadata\.plugins\org.eclipse.bir t.report.viewer
eclipse.buildId=M20070921-1145
eclipse.commands=-os
win32
-ws
win32
-arch
x86
-showsplash
C:\Program
Files\eclipse\\plugins\org.eclipse.platform_3.3.1.M20070725\ splash.bmp
-launcher
C:\Program Files\eclipse\eclipse.exe
-name
Eclipse
--launcher.library
C:\Program
Files\eclipse\plugins\org.eclipse.equinox.launcher.win32.win 32.x86_1.0.1.R33x_v20070828\eclipse_1020.dll
-startup
C:\Program
Files\eclipse\plugins\org.eclipse.equinox.launcher_1.0.1.R33 x_v20070828.jar
-vm
D:\programs\java\jdk1.5.0_11\bin\..\jre\bin\client\jvm.dll
eclipse.ee.install.verify=false
eclipse.product=org.eclipse.sdk.ide
eclipse.startTime=1192061507878
eclipse.vm=D:\programs\java\jdk1.5.0_11\bin\..\jre\bin\clien t\jvm.dll
eclipse.vmargs=-Xms40m
-Xmx256m
-Djava.class.path=C:\Program
Files\eclipse\plugins\org.eclipse.equinox.launcher_1.0.1.R33 x_v20070828.jar
eof=eof
file.encoding=Cp1252
file.encoding.pkg=sun.io
file.separator=\
java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment
java.awt.printerjob=sun.awt.windows.WPrinterJob
java.class.path=C:\Program
Files\eclipse\plugins\org.eclipse.equinox.launcher_1.0.1.R33 x_v20070828.jar
java.class.version=49.0
java.endorsed.dirs=D:\programs\java\jdk1.5.0_11\jre\lib\endo rsed
java.ext.dirs=D:\programs\java\jdk1.5.0_11\jre\lib\ext
java.home=D:\programs\java\jdk1.5.0_11\jre
java.io.tmpdir=C:\DOCUME~1\mkerle\Local Settings\Temp\
java.library.path=C:\Program
Files\eclipse;.;C:\WINDOWS\system32;C:\WINDOWS;D:\programs\j ava\jdk1.5.0_11\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOW S\System32\Wbem;C:\Program
Files\Common
Files\GTK\2.0\bin;d:\programs\bea\weblogic700\server\bin;D:\ programs\svn-win32-1.4.3\bin;D:\oracle\ora92\bin;d:\Programs \ATI
Technologies\ATI.ACE\Core-Static
java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition
java.runtime.version=1.5.0_11-b03
java.specification.name=Java Platform API Specification
java.specification.vendor=Sun Microsystems Inc.
java.specification.version=1.5
java.vendor=Sun Microsystems Inc.
java.vendor.url=http://java.sun.com/
java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi
java.version=1.5.0_11
java.vm.info=mixed mode
java.vm.name=Java HotSpot(TM) Client VM
java.vm.specification.name=Java Virtual Machine Specification
java.vm.specification.vendor=Sun Microsystems Inc.
java.vm.specification.version=1.0
java.vm.vendor=Sun Microsystems Inc.
java.vm.version=1.5.0_11-b03
line.separator=
Re: error loading JDBC drivers on creating Data Source [message #258012 is a reply to message #257883] Fri, 12 October 2007 03:14 Go to previous message
Eclipse UserFriend
Hi,

Have you tried a clean workspace when you make your test under new
birt-report-designer-all-in one?

Thanks.
Lin
"matt" <matthew.kerle+birt@dha.gov.au> wrote in message
news:b1fd04ffccb58cf18498c04ba7e39f8f$1@www.eclipse.org...
> thanks for your reply Gary.
> Ok, I downloaded the birt-report-designer-all-in-one-2_2_1, and changed my
> PATH so that eclipse runs on JDK 1.5.0_11.
>
> I still get the same exception (below). anything else we can try?
>
>
> org.eclipse.birt.report.data.oda.jdbc.JDBCException:
> org.apache.derby.jdbc.EmbeddedDriver
> at
> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.test Connection(JDBCDriverManager.java:522)
> at
> org.eclipse.birt.report.data.oda.jdbc.ui.util.DriverLoader.t estConnection(DriverLoader.java:108)
> at
> org.eclipse.birt.report.data.oda.jdbc.ui.profile.JDBCSelecti onPageHelper.testConnection(JDBCSelectionPageHelper.java:622 )
> at
> org.eclipse.birt.report.data.oda.jdbc.ui.profile.JDBCSelecti onPageHelper.access$7(JDBCSelectionPageHelper.java:606)
> at
> org.eclipse.birt.report.data.oda.jdbc.ui.profile.JDBCSelecti onPageHelper$6.widgetSelected(JDBCSelectionPageHelper.java:5 28)
> at
> org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListe ner.java:227)
> (34 lines elided for clarity)
> at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java: 508)
> at org.eclipse.equinox.launcher.Main.basicRun(Main.java:447)
> at org.eclipse.equinox.launcher.Main.run(Main.java:1173)
>
>
> java version:
> *** Date: Thursday, 11 October 2007 10:15:05 AM Sydney (Australia)
>
> *** Platform Details:
>
> *** System properties:
> awt.toolkit=sun.awt.windows.WToolkit
> birt.viewer.working.path=C:\Documents and
> Settings\mkerle\workspace\.metadata\.plugins\org.eclipse.bir t.report.viewer
> eclipse.buildId=M20070921-1145
> eclipse.commands=-os
> win32
> -ws
> win32
> -arch
> x86
> -showsplash
> C:\Program
> Files\eclipse\\plugins\org.eclipse.platform_3.3.1.M20070725\ splash.bmp
> -launcher
> C:\Program Files\eclipse\eclipse.exe
> -name
> Eclipse
> --launcher.library
> C:\Program
> Files\eclipse\plugins\org.eclipse.equinox.launcher.win32.win 32.x86_1.0.1.R33x_v20070828\eclipse_1020.dll
> -startup
> C:\Program
> Files\eclipse\plugins\org.eclipse.equinox.launcher_1.0.1.R33 x_v20070828.jar
> -vm
> D:\programs\java\jdk1.5.0_11\bin\..\jre\bin\client\jvm.dll
> eclipse.ee.install.verify=false
> eclipse.product=org.eclipse.sdk.ide
> eclipse.startTime=1192061507878
> eclipse.vm=D:\programs\java\jdk1.5.0_11\bin\..\jre\bin\clien t\jvm.dll
> eclipse.vmargs=-Xms40m
> -Xmx256m
> -Djava.class.path=C:\Program
> Files\eclipse\plugins\org.eclipse.equinox.launcher_1.0.1.R33 x_v20070828.jar
> eof=eof
> file.encoding=Cp1252
> file.encoding.pkg=sun.io
> file.separator=\
> java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment
> java.awt.printerjob=sun.awt.windows.WPrinterJob
> java.class.path=C:\Program
> Files\eclipse\plugins\org.eclipse.equinox.launcher_1.0.1.R33 x_v20070828.jar
> java.class.version=49.0
> java.endorsed.dirs=D:\programs\java\jdk1.5.0_11\jre\lib\endo rsed
> java.ext.dirs=D:\programs\java\jdk1.5.0_11\jre\lib\ext
> java.home=D:\programs\java\jdk1.5.0_11\jre
> java.io.tmpdir=C:\DOCUME~1\mkerle\Local Settings\Temp\
> java.library.path=C:\Program
> Files\eclipse;.;C:\WINDOWS\system32;C:\WINDOWS;D:\programs\j ava\jdk1.5.0_11\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOW S\System32\Wbem;C:\Program
> Files\Common
> Files\GTK\2.0\bin;d:\programs\bea\weblogic700\server\bin;D:\ programs\svn-win32-1.4.3\bin;D:\oracle\ora92\bin;d:\Programs \ATI
> Technologies\ATI.ACE\Core-Static
> java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition
> java.runtime.version=1.5.0_11-b03
> java.specification.name=Java Platform API Specification
> java.specification.vendor=Sun Microsystems Inc.
> java.specification.version=1.5
> java.vendor=Sun Microsystems Inc.
> java.vendor.url=http://java.sun.com/
> java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi
> java.version=1.5.0_11
> java.vm.info=mixed mode
> java.vm.name=Java HotSpot(TM) Client VM
> java.vm.specification.name=Java Virtual Machine Specification
> java.vm.specification.vendor=Sun Microsystems Inc.
> java.vm.specification.version=1.0
> java.vm.vendor=Sun Microsystems Inc.
> java.vm.version=1.5.0_11-b03
> line.separator=
>
Previous Topic:User Defined Aggregations
Next Topic:CrossTab Header
Goto Forum:
  


Current Time: Sun Jun 08 20:06:17 EDT 2025

Powered by FUDForum. Page generated in 0.03845 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top