Eclipse Community Forums: BIRT » How to add a JDBC driver in Eclipse BIRT?

Home » Archived » BIRT » How to add a JDBC driver in Eclipse BIRT?

How to add a JDBC driver in Eclipse BIRT? [message #490204]

Wed, 07 October 2009 15:38

Eclipse User

I have tried this with both Eclipse BIRT 2.3.2 and 2.5.1.

I don't see any instructions on how to add a JDBC driver to BIRT. I did find this: http://www.eclipse.org/birt/phoenix/build/#drivers but it doesn't seem to reflect what shows up in the plugin UI.

The steps I tried:

1. Go into the eclipse/plugins/org.eclipse.birt.report.data.oda.jdbc_2.5.1. v20090821 directory and place the JDBC driver JAR there, as per the readme in that directory.
2. Bring up Eclipse, go into the Database Development perspective, Data Source Expolorer view.
3. Click New Connection Profile. Select Generic JDBC. Observe that the Drivers dropdown is empty.
4. Another route. Double-click an existing db connection e.g. "BIRT Classic Models Sample Database". Select "JDBC Connection Properties". My driver is not in the drivers list. Click the New driver definition button. Select Jar List. Observe that the Add Jar/Zip button is not enabled.

Can someone provide a definitive list of steps which actually work, either for 2.3.2 or 2.5.1?

Thanks.

Re: How to add a JDBC driver in Eclipse BIRT? [message #490443 is a reply to message #490204]

Thu, 08 October 2009 12:16

Eclipse User

Originally posted by: thilo.bruesshaber.gmail.com

Just create a new Data Source and use the "Manage Drivers..." button.
The Driver-JARs can be located anywhere in your file system.
Placing the drivers in
plugins/org.eclipse.birt.report.data.oda.jdbc_2.5.1 is only neccessary
when running BIRT in an application server environment and when you are
not using JNDI provided connections.

--Thilo

D G schrieb:
> I have tried this with both Eclipse BIRT 2.3.2 and 2.5.1.
>
> I don't see any instructions on how to add a JDBC driver to BIRT. I did
> find this: http://www.eclipse.org/birt/phoenix/build/#drivers but it
> doesn't seem to reflect what shows up in the plugin UI.
>
> The steps I tried:
>
> 1. Go into the
> eclipse/plugins/org.eclipse.birt.report.data.oda.jdbc_2.5.1. v20090821
> directory and place the JDBC driver JAR there, as per the readme in that
> directory.
> 2. Bring up Eclipse, go into the Database Development perspective, Data
> Source Expolorer view.
> 3. Click New Connection Profile. Select Generic JDBC. Observe that the
> Drivers dropdown is empty.
> 4. Another route. Double-click an existing db connection e.g. "BIRT
> Classic Models Sample Database". Select "JDBC Connection Properties". My
> driver is not in the drivers list. Click the New driver definition
> button. Select Jar List. Observe that the Add Jar/Zip button is not
> enabled.
>
> Can someone provide a definitive list of steps which actually work,
> either for 2.3.2 or 2.5.1?
>
> Thanks.

Re: How to add a JDBC driver in Eclipse BIRT? [message #490464 is a reply to message #490443]

Thu, 08 October 2009 13:57

Eclipse User

Thilo,

Thanks for your comments, perfect.
I am able to create a new JDBC Data Source under ODA Data Sources.

However, I can't seem to do anything with it. The connection tests fine. The only thing I seem to be able to do is open a new SQL scrapbook. When I try to execute a SELECT statement from a scrap, I get the following error message:

The selection cannot be launched, and there are no recent launches.

I can see that BIRT is enumerating all the tables in my data source and I am returning the list. But I do not see any catalogs or tables displayed.

Any suggestions?

Thanks.

Previous Topic:	Possible Memory Leak in ViewerServlet
Next Topic:	Combining two ore more reports into larger report

Goto Forum:

-=] Back to Top [=-

Current Time: Thu Aug 21 08:48:22 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter