Use SQL ALTER TABLE Statement

0

Hello all,

 

is it possible to use a sql alter table statement in a report?

Have to change a View before receiving Input through another query in a subreport.

 

Cheers

sascha.haeusler's picture
Joined: Jan 22 2013 - 2:34am
Last seen: 6 years 6 months ago

2 Answers:

0

JasperServer has a security setting that will only allow select statements to be sent trough the JDBC connection. That can be configured or disabled (Not Recomended) in webapps/jasperserver/WEB-INF/classes/esapi/security-config.properties/validation.properties 

Still I do not think that sending an 'Alter table' in a report is a good practice, and must be avoided, this is a Reporting Tool :) Imaging somebody ading a DROP Table or TRUNCATE in your report :P.  I will strongly encourage you to rethink the problem you are trying to solve.

marianol's picture
4555
Joined: Sep 13 2011 - 8:04am
Last seen: 10 months 3 weeks ago
0

I'm the only one who can change the reports on the jasperserver. So there is no problem with it ;) You have to know that I use mysql-Views to simplify my queries. Also the Report depends then only on the view and not on many other tables which can change.

My Solution: I wrote a Scriptlet with an alter-querie :)

But thanks for your help!

sascha.haeusler's picture
Joined: Jan 22 2013 - 2:34am
Last seen: 6 years 6 months ago
Feedback