Openreports error while running query reports

Error on Query reports

I am getting the following errors while opening a report which contains a simple query.
(database is mysql and its jdbc driver is already added)
 
javax.servlet.ServletException: /QueryReport.jsp(36,59) Attribute value report.getName() + ".pdf" is quoted with " which must be escaped when used within the value
 
My system specifications
 
OS- RHEL 5
Java - 1.6 jdk
apache- tomcat 5.5

The same openreports work on my centos 5 distribution without any troubles.
 
Please help me to fix it as soon as possible.
 
 
Regards,
 
Alias
crapidontwantAsked:
Who is Participating?
 
UmeshConnect With a Mentor MySQL Principle Technical Support EngineerCommented:
Set the value of org.apache.jasper.compiler. Parser.STRICT_QUOTE_ESCAPING to false in Apache Tomcat configuration.

Thanks,
Umesh
0
 
crapidontwantAuthor Commented:
Thanks for your steps.

Can u give the file name on which this should be done?

I check my server.xml file and didn't find a keywork you mentioned.


Regards,

Alias
0
 
UmeshMySQL Principle Technical Support EngineerCommented:
I'm not 100% sure where to add.. locate setenv.sh and see if they are any settings then add accordingly

-Dorg.apache.jasper.compiler.Parser.STRICT_QUOTE_ESCAPING=false
to setenv.sh

or

org.apache.jasper.compiler.Parser.STRICT_QUOTE_ESCAPING=false
to setenv.sh.
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
crapidontwantAuthor Commented:
yes, I add
CATALINA_OPTS=-Dorg.apache.jasper.compiler.Parser.STRICT_QUOTE_ESCAPING=false variable on catalina.sh file and openreports can now query the output.

Thanks for your valuable input.

Regards,

Alias
0
 
UmeshMySQL Principle Technical Support EngineerCommented:
Anytime..

Thanks,
Umesh
0
 
UmeshMySQL Principle Technical Support EngineerCommented:
From the author comments it seems my comments helped him(11.18.2008 at 05:01PM IST, ID: 22983569)

Thanks,
Umesh
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.