File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Other Open Source Projects and the fly likes JasperReport Mysql Stored Procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Make it so: Java DB Connections & Transactions this week in the JDBC forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "JasperReport Mysql Stored Procedure" Watch "JasperReport Mysql Stored Procedure" New topic

JasperReport Mysql Stored Procedure

Yaddif Medina

Joined: Oct 05, 2005
Posts: 23
Hi all,

I can't execute a mysql's stored procedure from JasperReport. Can you give an example? .... when I type the "call sp()" in iReport it says the following message : "SQL Problem: procedure xxxxx can't return a result set in the given context".

Thanks in advance.
Henry Wong

Joined: Sep 28, 2004
Posts: 20380

Moving to "Open Source Projects"...

Books: Java Threads, 3rd Edition, Jini in a Nutshell, and Java Gems (contributor)
I agree. Here's the link:
subject: JasperReport Mysql Stored Procedure
It's not a secret anymore!