using CallableStatement when needed

[2006 JR Open Discussion]

By: Lutz Mueller - lutz_mueller

using CallableStatement when needed

2006-03-16 04:14

Hello,

 

We are using Jasperreports since version 0.4. it is a great product and serves

our reporting needs quite well.

However , recently we switched our main product to use DB2 as a database

backend. i had to call a stored proc inside a report. This did not work

because the JRJdbcQueryExecuter always uses

connection.prepareStatement(String), and the db2 jdbc driver insists on

stored procedures being called by a CallableStatement. So i patched the

JRJdbcQueryExceuter to use connection.prepareCall(String) when appropriate (i

just use contains("call") on the query string, to determine if its an

procedure call).

Now my questions are: is there a way to force jasper to use a

callableStatement without patching the sourcecode? and, if not, could this

patch please be applied to the jasperreports source-tree, so i do not have to

"customize" every new version for my needs?

 

lutz mueller