Eclipse Community Forums: BIRT » Cannot open the connection for the driver Oracle DB

Home » Archived » BIRT » Cannot open the connection for the driver Oracle DB

Cannot open the connection for the driver Oracle DB [message #1499626]

Fri, 05 December 2014 04:21

Eclipse User

I created report project in Eclipse Birt with some reports (Version: 4.3.0., Windows 7)
The data source is an Oracle database . In the WEB viewer, the reports display with data ok.
Runtime for Birt is Tomcat server 7, Oracle DB is the same.
I copied ojdbc14.jar (with its directory) from pc to the directory:
/home/apache-tomcat-7.0.42/webapps/BIRT-Viewer/WEB-INF/lib/org.eclipse.birt.report.data.oda.jdbc_4.3.0.v201306041519/drivers,
I installed BIRT viewer, sample report displays ok,
But my reports do not display for error:
Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, ORA-01017: invalid username/password; logon denied
I am a newbie in Birt, please help.

Re: Cannot open the connection for the driver Oracle DB [message #1500325 is a reply to message #1499626]

Fri, 05 December 2014 17:00

Eclipse User

This jar file should be put just under WEB-INF/lib folder: the subfolder you mentionned is OK with Eclipse designer, but not with a Tomcat server.

Furthermore with Tomcat it is highly recommended to use a "Connection Pool" rather than a direct JDBC access. If you setup a such pool, you won't have to deal with Oracle logins / passwords of the server in birt reports, among other huge benefits.

[Updated on: Fri, 05 December 2014 17:01] by Moderator

Re: Cannot open the connection for the driver Oracle DB [message #1500667 is a reply to message #1500325]

Sat, 06 December 2014 00:02

Eclipse User

Thanks for the help Donino

Can you please provide the steps for creating "Connection Pool" in Tomcat and the way to use it in birt .

Thanks in Advance

Re: Cannot open the connection for the driver Oracle DB [message #1501046 is a reply to message #1500667]

Sat, 06 December 2014 07:47

Eclipse User

There are a couple of Google links describing how to do this in Tomcat , please be more specific about which problems you encounter. By the way you should download and install PSI probe in Tomcat, this is useful beyond measure to test connections pools and diagnose issues.

Previous Topic:	No Euro Symbol
Next Topic:	BIRT 371 report running fine on BIRT Designer but running on taking long time to run

Goto Forum:

-=] Back to Top [=-

Current Time: Tue Mar 25 12:47:43 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter