Support For Stored Procedure

[wesleywj2]

Dear everyone,

 

hello everyone, i've looked through posted sp(stored porcedure )topic and found out that majority stated that the current ireport does not fully support sp by calling it from within iReport's query window. I've attempt to test it by using postgres db's (simple)sp and ireport call it successfully. As opposed by majority said it's not fully supported yet, i'm confused by comparing it with my test result. so my questions are:

 

1. which db's sp not support/support by ireport?

 

2. if not supported on current version, when likely will it be available?

 

thanks in advance and wish to hear from anyone who can provide me an answer and this will be very appreciated.

 

regards, Wesley

[Giulio Toffoli]

JasperReports uses a PreparedStatement to execute the query (StoreProcedure). This normally returns a ResultSet (you can not access output parameters because the use of a PreparedStatement instead of a CallableStatement).

 

In Oracle a similar call does not return a ResultSet, so you need to write your own QueryExecuter to make it works.

 

MS SQLServer and Postgres work great.

 

Giulio

[wesleywj2]

thks for the reply giulio, on the oracle stored procedure, will the upcoming version include the query executor as well? again thks

[wesleywj2]

thks for the reply giulio, on the oracle stored procedure, will the upcoming version include the query executor as well? again thks