| Problem opening report on Tomcat using php [message #491394] |
Wed, 14 October 2009 08:40  |
Eclipse User |
|
|
|
I apologize for the cross post with the Newcomers forum, but after a couple of days without answer I think that one wasn't the right forum for this question.
I'm installed Birt on Eclipse in a Windows XP environment and I've done a report based on a mysql data source using the JDBC driver.
The preview is correct and all seems to go well, so I attempt to execute the report from the site using the solution in
http://www.theserverside.com/tt/articles/article.tss?l=Integ ratingBIRTwithPHP
for a pdf output (using Tomcat and Php/Java Bridge).
Then I have an error like this "The design file <path/file_name.rptdesign> has error and can not be run".
All the components seems to be correctly installed, in fact I can view the birt test reports in the WebViewerExample using the Tomcat manager page and if I copy the problematic report in birt-viewer/report directory, I can see it in the Tomcat manager page.
So probably the problem isn't in the report itself.
Then, after various attempts, I've found a strange behaviour: following various post dealing with the different version of the design and the viewer module I've modified manually the report tag:
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.20" id="1">
substituting the version number (3.2.20) with a lower one (I've used various number from 3.2.6 to 3.2.15), in this case the report is showed but without data, only the header and footer sections appear.
I've attempted with and without JNDI connection with the same result.
What can cause the problem?
Please help!
Tonio
|
|
|
| Re: Problem opening report on Tomcat using php [message #491513 is a reply to message #491394] |
Wed, 14 October 2009 16:47  |
| Eclipse User |
|
|
|
Tonio,
What version of the designer did you use to create the report and where
did you put the JDBC driver?
Jason
Tonio wrote:
> I apologize for the cross post with the Newcomers forum, but after a
> couple of days without answer I think that one wasn't the right forum
> for this question.
>
> I'm installed Birt on Eclipse in a Windows XP environment and I've done
> a report based on a mysql data source using the JDBC driver.
> The preview is correct and all seems to go well, so I attempt to execute
> the report from the site using the solution in
>
> http://www.theserverside.com/tt/articles/article.tss?l=Integ
> ratingBIRTwithPHP
>
> for a pdf output (using Tomcat and Php/Java Bridge).
> Then I have an error like this "The design file
> <path/file_name.rptdesign> has error and can not be run".
>
> All the components seems to be correctly installed, in fact I can view
> the birt test reports in the WebViewerExample using the Tomcat manager
> page and if I copy the problematic report in birt-viewer/report
> directory, I can see it in the Tomcat manager page.
> So probably the problem isn't in the report itself.
>
> Then, after various attempts, I've found a strange behaviour: following
> various post dealing with the different version of the design and the
> viewer module I've modified manually the report tag:
>
> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.20"
> id="1">
>
> substituting the version number (3.2.20) with a lower one (I've used
> various number from 3.2.6 to 3.2.15), in this case the report is showed
> but without data, only the header and footer sections appear.
>
> I've attempted with and without JNDI connection with the same result.
>
> What can cause the problem?
> Please help!
>
> Tonio
>
|
|
|
| Re: Problem opening report on Tomcat using php [message #491514 is a reply to message #491513] |
Wed, 14 October 2009 16:48 |
| Eclipse User |
|
|
|
Tonio,
Also take a look at this post on Birt Exchange.
http://www.birt-exchange.org/devshare/deploying-birt-reports /743-calling-birt-from-php/#description
I believe the version of BIRT in the integration is 2.2.2. The post
above has a download for 2.3.2
2.5 is not available yet.
Jason
Jason Weathersby wrote:
> Tonio,
>
> What version of the designer did you use to create the report and where
> did you put the JDBC driver?
>
> Jason
>
> Tonio wrote:
>> I apologize for the cross post with the Newcomers forum, but after a
>> couple of days without answer I think that one wasn't the right forum
>> for this question.
>>
>> I'm installed Birt on Eclipse in a Windows XP environment and I've
>> done a report based on a mysql data source using the JDBC driver.
>> The preview is correct and all seems to go well, so I attempt to
>> execute the report from the site using the solution in
>>
>> http://www.theserverside.com/tt/articles/article.tss?l=Integ
>> ratingBIRTwithPHP
>>
>> for a pdf output (using Tomcat and Php/Java Bridge).
>> Then I have an error like this "The design file
>> <path/file_name.rptdesign> has error and can not be run".
>>
>> All the components seems to be correctly installed, in fact I can view
>> the birt test reports in the WebViewerExample using the Tomcat manager
>> page and if I copy the problematic report in birt-viewer/report
>> directory, I can see it in the Tomcat manager page.
>> So probably the problem isn't in the report itself.
>>
>> Then, after various attempts, I've found a strange behaviour:
>> following various post dealing with the different version of the
>> design and the viewer module I've modified manually the report tag:
>>
>> <report xmlns="http://www.eclipse.org/birt/2005/design"
>> version="3.2.20" id="1">
>>
>> substituting the version number (3.2.20) with a lower one (I've used
>> various number from 3.2.6 to 3.2.15), in this case the report is
>> showed but without data, only the header and footer sections appear.
>>
>> I've attempted with and without JNDI connection with the same result.
>>
>> What can cause the problem?
>> Please help!
>>
>> Tonio
>>
|
|
|
|
|
| Re: Problem opening report on Tomcat using php [message #491857 is a reply to message #491758] |
Fri, 16 October 2009 04:44 |
| Eclipse User |
|
|
|
I've followed the instructions for the update of birt, but I have the error reported at the end of this message.
I've done the following steps:
1. unzipped the files JavaBridge.war and birt-runtime-2_5_1.zip
2. removed configuration and plugins directories from WEB-INF\platform in JavaBridge and substituted with the correspondent ones in birt-runtime-2_5_1\ReportEngine directory
3. added the file mysql-connector-java-5.1.10-bin.jar in the directory JavaBridge\WEB-INF\platform\plugins\org.eclipse.birt.report. data.oda.jdbc_2.5.1.v20090821\drivers
4. copied all the jars from birt-runtime-2_5_1\ReportEngine\lib into JavaBridge\WEB-INF\lib, leaving the others jars in this directory
5. zipped the new JavaBridge.war, copied it in $CATALINA_HOME\webapps and started Tomcat
Where is the mistake?
I have doubt on the step 4:
Have I to copy all the jars or only some of them? In this case which ones?
Have I to leave the others jars in JavaBridge\WEB-INF\lib (I think so) or have I to delete them?
Thanks for the help Jason
Tonio
-- Error --
[[o:Exception]:"java.lang.Exception: Invoke failed: [[o:RunAndRenderTask]]->run.
Cause: org.eclipse.birt.report.engine.api.EngineException: Error happened while running the report VM: 1.6.0_13@http://java.sun.com/" at:
#-11 org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doR un(RunAndRenderTask.java:186)
#-10 org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:75)
#-9 sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
#-8 sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
#-7 sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
#-6 java.lang.reflect.Method.invoke(Unknown Source)
#-5 php.java.bridge.JavaBridge.Invoke(JavaBridge.java:1054)
#-4 php.java.bridge.Request.handleRequest(Request.java:415)
#-3 php.java.bridge.Request.handleRequests(Request.java:491)
#-2 php.java.bridge.http.ContextRunner.run(ContextRunner.java:15 1)
#-1 php.java.bridge.ThreadPool$Delegate.run(ThreadPool.java:60)
#0 E:\web\xampp\htdocs\dbpor\dbpor2\java\Java.inc(145): java_ThrowExceptionProxyFactory->getProxy(10, '@V', 'T', true)
#1 E:\web\xampp\htdocs\dbpor\dbpor2\java\Java.inc(231): java_Arg->getResult(true)
#2 E:\web\xampp\htdocs\dbpor\dbpor2\java\Java.inc(233): java_Client->getWrappedResult(true)
#3 E:\web\xampp\htdocs\dbpor\dbpor2\java\Java.inc(361): java_Client->getResult()
#4 E:\web\xampp\htdocs\dbpor\dbpor2\java\Java.inc(1039): java_Client->invokeMethod(7, 'run', Array)
#5 E:\web\xampp\htdocs\dbpor\dbpor2\java\Java.inc(1087): java_JavaProxy->__call('run', Array)
#6 E:\web\xampp\htdocs\dbpor\dbpor2\java\Java.inc(1190): java_AbstractJava->__call('run', Array)
#7 [internal function]: Java->__call('run', Array)
#8 E:\web\xampp\htdocs\dbpor\dbpor2\birt.php(25): java_InternalJava->run()
#9 {main}]
[Updated on: Fri, 16 October 2009 04:49] by Moderator |
|
|
| Re: Problem opening report on Tomcat using php [message #491911 is a reply to message #491857] |
Fri, 16 October 2009 09:55 |
| Eclipse User |
|
|
|
Tonio,
Delete all the jars in WEB-INF\lib with the exception of these
birtEngine.jar
JavaBridge.jar
jaxrpc.jar
lucene.jar
php-script.jar
php-servlet.jar
script-api.jar
then copy all 23 jars from the birt runtime ReportEngine\lib directory.
I just tried this and put
http://localhost:8080/JavaBridge/PhpRunAndRenderHTML.php
and all worked well.
Jason
Tonio wrote:
> I've followed the instruction for the update of birt, but I have the
> error reported at the end of this message.
> I've done the following steps:
> 1. unzipped the files JavaBridge.war and the birt-runtime-2_5_1.zip
>
> 2. removed the configuration and plugins directory from WEB-INF\platform
> directory of JavaBridge and substituted with the correspondent ones in
> birt-runtime-2_5_1\ReportEngine directory
>
> 3. added the file mysql-connector-java-5.1.10-bin.jar in the directory
> JavaBridge\WEB-INF\platform\plugins\org.eclipse.birt.report.
> data.oda.jdbc_2.5.1.v20090821\drivers
>
> 4. copied all the jars from birt-runtime-2_5_1\ReportEngine\lib into
> JavaBridge\WEB-INF\lib leaving the others jars in this directory
>
> 5. zipped the new JavaBridge.war and copied in $CATALINA_HOME\webapps
> and then started Tomcat
>
> Where is the mistake?
> I have doubt on the step 4:
> Have I to copy all the jars or only some of them? In this case which ones?
> Have I to leave the others jars in JavaBridge\WEB-INF\lib (I think so)
> or have I to delete them?
>
> Thanks for the help Jason
> Tonio
>
> -- Error --
> [[o:Exception]:"java.lang.Exception: Invoke failed:
> [[o:RunAndRenderTask]]->run.
> Cause: org.eclipse.birt.report.engine.api.EngineException: Error
> happened while running the report VM: 1.6.0_13@http://java.sun.com/" at:
> #-11 org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doR
> un(RunAndRenderTask.java:186)
> #-10 org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run
> (RunAndRenderTask.java:75)
> #-9 sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> #-8 sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> #-7 sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> #-6 java.lang.reflect.Method.invoke(Unknown Source)
> #-5 php.java.bridge.JavaBridge.Invoke(JavaBridge.java:1054)
> #-4 php.java.bridge.Request.handleRequest(Request.java:415)
> #-3 php.java.bridge.Request.handleRequests(Request.java:491)
> #-2 php.java.bridge.http.ContextRunner.run(ContextRunner.java:15 1)
> #-1 php.java.bridge.ThreadPool$Delegate.run(ThreadPool.java:60)
> #0 E:\web\xampp\htdocs\dbpor\dbpor2\java\Java.inc(145):
> java_ThrowExceptionProxyFactory->getProxy(10, mailto:'@V', 'T', true)
> #1 E:\web\xampp\htdocs\dbpor\dbpor2\java\Java.inc(231):
> java_Arg->getResult(true)
> #2 E:\web\xampp\htdocs\dbpor\dbpor2\java\Java.inc(233):
> java_Client->getWrappedResult(true)
> #3 E:\web\xampp\htdocs\dbpor\dbpor2\java\Java.inc(361):
> java_Client->getResult()
> #4 E:\web\xampp\htdocs\dbpor\dbpor2\java\Java.inc(1039):
> java_Client->invokeMethod(7, 'run', Array)
> #5 E:\web\xampp\htdocs\dbpor\dbpor2\java\Java.inc(1087):
> java_JavaProxy->__call('run', Array)
> #6 E:\web\xampp\htdocs\dbpor\dbpor2\java\Java.inc(1190):
> java_AbstractJava->__call('run', Array)
> #7 [internal function]: Java->__call('run', Array)
> #8 E:\web\xampp\htdocs\dbpor\dbpor2\birt.php(25): java_InternalJava->run()
> #9 {main}]
>
>
|
|
|
|
Powered by
FUDForum. Page generated in 0.25547 seconds
Home