SOLVED: How to create a JNDI service to call a mysql stored procedure

[jvway]

Hi,

I'm actually battling this whole calling a MYSQL stored procedure thing. I see suggestions to make a JNDI service that then calls the MySQL db but I'm having a hard time finding exactly how to create the JNDI service.

In terms of the MySQL SP it does only accept input parameters and returns a sql query.  I've also tried using $P! for string parameters the others are dates.

It works fine in iReport but when run agains the jasper server (v4.7) I get back the wonderfully cryptic "there's a problem contact your administrator" I'd love to but I'm the administrator :).

Attached is the jrxml

Any ideas?

Thanks,

Jerry

[jvway]

Turns out it was the security settings that were implemented in JasperServer 4.5

 

http://community.jaspersoft.com/wiki/jaspersoft-450-security-changes-and-configuration#Editing_Input_Validation_Rules