Eclipse Community Forums: BIRT » BIRT-Viewer DB connection error

Home » Eclipse Projects » BIRT » BIRT-Viewer DB connection error (BIRT doesn't connect to DB when called from a PHP script)

Show: Today's Messages :: Show Polls :: Message Navigator

BIRT-Viewer DB connection error [message #985873]

Fri, 16 November 2012 14:13

Christian Hilgenstock

Messages: 3
Registered: November 2012

Junior Member

Hi,

I 'designed' a BIRT-Report under Eclipse (a modified 'test.rptdesign' from the BIRT Runtime download). DB access is directly by MYSQL JDBC driver, which is located in the BIRT-Viewer directory. The report is running well when called from Eclipse. Calling the BIRT-Viewer from a PHP script works as well, however DB access fails (see message and catalina log entry below).

Modifications to the report were including a parameter and a data-field which creates the '200' in the output (see below) and a table with a simple 'SELECT * FROM tablename' statement.

The environment is:

BIRT-Runtime 4.2.1
Tomcat 7.0
Eclipse: Helios Service Release 2, Build id: 20110218-0911 (today's download)

Can you help me?

PS.: I am aware that this problem is not really new, there are some postings in forums. But I didn't find a solution by now, so I try again.
_____________________________________________________________________________________
Title
Congratulations!

If you can see this report, it means that the BIRT viewer is installed correctly.

Sample Parameter:

200

15.11.2012 19:33

1
The following items have errors:

Table (id = 47):
+ An exception occurred during processing. Please see the following message for details:
Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.dbprofile.
org.eclipse.datatools.connectivity.oda.OdaException ;
java.lang.IllegalStateException: Unable to determine the default workspace location. Check your OSGi-less platform configuration of the plugin or datatools workspace path. (Element ID:47)

_________________________________

catalina log:

Nov 15, 2012 7:33:17 PM org.eclipse.datatools.connectivity.internal.ConnectivityPlugin log
SEVERE: Unable to determine the default workspace location. Check your OSGi-less platform configuration of the plugin or datatools workspace path.

Report message to a moderator

Re: BIRT-Viewer DB connection error [message #1007002 is a reply to message #985873]

Sun, 03 February 2013 18:43

Nicola Abello

Messages: 1
Registered: February 2013

Junior Member

Hey Christian !

Have you ever found a solution to your problem, I have the same problem too ?

MY CONFIG

OS : Windows XP
Web Server : Tomcat 7.0
Mysql : Mysql version 5.5
JDBC : Mysql connector version 5.1.22
JRE version: 1.6.0_20

BIRT :
* BIRT Runtime 4_2_1
* Viewer Version : 4.2.1
* Engine Version: 4.2.1

Eclipse BIRT Plugins :
* BIRT Framework 2.6.2.r262_v20101008-9iF7A9JGHMBCRz-R8tbxRel8kQrI
* Eclipse BIRT Chart Context Sensitive Help Documentation 2.6.2.r262_v20101008-3507w31211924
* Eclipse BIRT Context Sensitive Help Documentation 2.6.2.r262_v20101008-3517s373aw31221317
* Eclipse BIRT Documentation 2.6.2.r262_v20101008-3507w31211924
* Eclipse BIRT Example 2.6.2.r262_v20101008-7F7e7CDBRmTc_XEMHBHMm
* Eclipse BIRT Source Feature 2.6.2.r262_v20101008-9iF7A9JGHMBCRz-R8tbxRel8kQrI

Report message to a moderator

Re: BIRT-Viewer DB connection error [message #1007416 is a reply to message #1007002]

Tue, 05 February 2013 18:59

Christian Hilgenstock

Messages: 3
Registered: November 2012

Junior Member

Hi Nicola,

yes, I found a solution and the setting works. However, as I am really not skilled in the Java environment I did'nt really understand what I did. The simple solution was to follow exactly the checklist in message #644333 at the end of thread #644132 (osuwariboy vs. Jason Weathersby).

Again: I have no idea what they were talking about, but the checklist describes clear and comprehensively what to do.

Good luck

Christian

I am running:

Tomcat 7.0 under Windows 7
mysql-connector 5.0.8
Eclipse BIRT project 2.6.2.r262
MySQL 5.1.41

Report message to a moderator

Previous Topic:	library to display graphs
Next Topic:	How do I do a count on a list of items?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Oct 24 08:45:23 GMT 2021

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter