Eclipse Community Forums: BIRT » Unable to connect to DB with deployed report

Home » Archived » BIRT » Unable to connect to DB with deployed report

Unable to connect to DB with deployed report [message #901615]

Mon, 13 August 2012 12:27

Eclipse User

Hello,
I am new to BIRT and the BIRT viewer and I am trying to figure out why this is not working. I have a report that works fine in my eclipse BIRT 4.20 environment. When I deploy to a linux/tomcat birt-viewer 4.20 and run the report, it doesn't work and I see this in the logs:
DriverConnectionBase.error.driverDefinitionNotFound: DriverDefn.org.eclipse.datatools.enablement.oracle.10.driverTemplate.Oracle Thin Driver. Using the driver properties defined in database profile instead.

Let me know if you have any ideas.
Thanks!

Re: Unable to connect to DB with deployed report [message #901636 is a reply to message #901615]

Mon, 13 August 2012 13:21

Eclipse User

Roger

Did you copy the jdbc driver jar to the webviewer/web-inf/lib directory?
Also are you using the jdbc driver or did you use a connection
profile. If you are using a connection profile you will need to set an
additional variable:

If your reports use connection profiles supplied by the Data Tools
Platform project (DTP), you will need to add a system or environment
property that specifies a DTP workspace location. The genReport bat or
shell script files show an example of setting this variable. If you are
deploying these reports to the BIRT Viewer you will need to add the
system property or set the environment variable in your application
server. More details on this variable are available in the New and
Noteworthy for DTP version 1.9
http://wiki.eclipse.org/DTP_1.9_M7_New_and_Noteworthy

Jason

On 8/13/2012 12:27 PM, Roger B wrote:
> Hello,
> I am new to BIRT and the BIRT viewer and I am trying to figure out why
> this is not working. I have a report that works fine in my eclipse BIRT
> 4.20 environment. When I deploy to a linux/tomcat birt-viewer 4.20 and
> run the report, it doesn't work and I see this in the logs:
> DriverConnectionBase.error.driverDefinitionNotFound:
> DriverDefn.org.eclipse.datatools.enablement.oracle.10.driverTemplate.Oracle
> Thin Driver. Using the driver properties defined in database profile
> instead.
>
> Let me know if you have any ideas.
> Thanks!

Re: Unable to connect to DB with deployed report [message #901648 is a reply to message #901636]

Mon, 13 August 2012 16:16

Eclipse User

Jason,
Thanks for the reply. Yes, I just confirmed that I did copy the jdbc driver jar file to the WEB_INF/lib directory.
I don't believe I am using a connection profile, because when I go to "edit data source" the connection profile tab is empty. Just in case, I created the DTP workspace location property anyway, however, after restarting everything I am still getting the same error.
Thanks,
Roger

Re: Unable to connect to DB with deployed report [message #901650 is a reply to message #901648]

Mon, 13 August 2012 17:00

Eclipse User

Roger

Can you post the report? BTW if you set the env var for the dtp
workspace, this has to be a directory that the tomcat service has
permission to write to.

Jason

On 8/13/2012 4:16 PM, Roger B wrote:
> Jason,
> Thanks for the reply. Yes, I just confirmed that I did copy the jdbc
> driver jar file to the WEB_INF/lib directory.
> I don't believe I am using a connection profile, because when I go to
> "edit data source" the connection profile tab is empty. Just in case, I
> created the DTP workspace location property anyway, however, after
> restarting everything I am still getting the same error.
> Thanks,
> Roger
>

Previous Topic:	BIRT Engine cannot find ODA dataSource
Next Topic:	Colours of dataseries in radarchart

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 23 00:11:47 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter