| BIRT-Viewer DB connection error [message #985873] |
Fri, 16 November 2012 09:13  |
Eclipse User |
|
|
|
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 #1007416 is a reply to message #1007002] |
Tue, 05 February 2013 13:59  |
| Eclipse User |
|
|
|
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
|
|
|
Powered by
FUDForum. Page generated in 0.02587 seconds
Home