Use SQL ALTER TABLE Statement

Jaspersoft Community 'Read-Only' as of July 8, 2022

Transition to New TIBCO Community Just Weeks Away

You can still search, review wiki content, and review discussions in read-only mode. Please email community@tibco.com with questions or issues requiring TIBCO review or response.

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: 9 years 5 months ago

2 Answers:

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
12146
Joined: Sep 13 2011 - 8:04am
Last seen: 3 years 9 months ago

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: 9 years 5 months ago
Feedback
randomness