JDBC Error at runtime - for subreport only

Hello Everyone, 
 
I have a master report (summary) that I have created and uses a hyperlink to link to a subreport (detail). In development it runs flawlessly, but when I push it up to my JBoss server, the master report runs fine, but when I try to click one of the hyperlinks to view the subreport, I get the following error: 
 
org.eclipse.birt.report.engine.api.EngineException: 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. Missing properties in Connection.open(Properties). 
 
Im really confused by this error since the master report works just fine. Originally it kept telling me that the report didn't exist, and then I found that even tho the two reports are in the same directory (birt-viewer.war/report/), when I click the link it will try to run it from the parent directory. Ok, so then I created a subfolder called report in my dev environment so that the hyperlink points to report/call_detail_report.rptdesign. This appears to work fine since it is hitting the report, but now I have this odbc error. 
 
I have double-checked and I do have the mysql jdbc file loaded in the plugins folder for the class referenced in the error. 
 
Any help would be greatly appreciated! 
 
Thanks, 
Amanda

Find more posts tagged with

Comments

mwilliams

Hi Amanda,

If you create a main report and a drill-down report with the sample database, can you recreate this issue? Or is it only happening with your database?

DreamCoder

<blockquote class='ipsBlockquote' data-author="mwilliams">Hi Amanda, 
 
If you create a main report and a drill-down report with the sample database, can you recreate this issue? Or is it only happening with your database?</blockquote>
 
Hi Michael, 
 
I created a master report and drill-down subreport using the sample database and it works fine. I'm baffled. Any ideas? 
 
Thanks, 
Amanda

DreamCoder

Ok so I have been playing around with this further and found that if I do not use a datasource from my library resource, and instead manually create it for each report, the report runs just fine. So one more step in the right direction!

Any ideas why datasources pulled from shared resources would work locally for me when I test (connecting to a database on my local machine), but not when I push them to my JBOSS installation also on my local machine (but in a VMWare session?).

Thanks in advance!
Amanda

mwilliams

Amanda,

Is this only an issue when you're using a dataSource from a library? Where are you putting your library in the viewer deployed in JBoss?

DreamCoder

<blockquote class='ipsBlockquote' data-author="mwilliams">Amanda, 
 
Is this only an issue when you're using a dataSource from a library? Where are you putting your driver in JBoss?</blockquote>
 
Sorry Michael, didn't realize you had posted a response to this one. My whole issue was I wasn't copying the library.rptlibrary up to the server to be available for the reports, so of course they didn't have access to the datasource. I figured it out and fixed it. 
 
Thanks for all your help. You've been wonderful. 
Amanda