jasper report and MySql DB

[rshankar]

I am using mysql db and tried to associate a report query to a stored proc in the db and it didn't work.

 

For example, in the associate query i simply put

 

call sp_something ($P!{1}, $P!{2})

 

The SP run fine and the parameter were fine too. However, the results threw Jasper exception in the log window.

 

Any clues folks?

 

Thanks in advance,

 

Shankar