Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » BIRT-Viewer DB connection error (BIRT doesn't connect to DB when called from a PHP script)
BIRT-Viewer DB connection error [message #985873] Fri, 16 November 2012 14:13 Go to next message
Christian Hilgenstock is currently offline Christian HilgenstockFriend
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.
Re: BIRT-Viewer DB connection error [message #1007002 is a reply to message #985873] Sun, 03 February 2013 18:43 Go to previous messageGo to next message
Nicola Abello is currently offline Nicola AbelloFriend
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
Re: BIRT-Viewer DB connection error [message #1007416 is a reply to message #1007002] Tue, 05 February 2013 18:59 Go to previous message
Christian Hilgenstock is currently offline Christian HilgenstockFriend
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


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


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

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

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

Back to the top