Jump to content
Changes to the Jaspersoft community edition download ×

Param not processed correctly in query via jdbc


Recommended Posts

I defined the query "select * from person where lastName = $P{Name}".

The parameter Name is defined as a string.


If I execute the query agains a MySQL db via JDBC, this doesn't work. The query return no record. If I execute it

against JDBC via ODBC, it work fine. Note, if i remove the filter or replace the paramter by an hardcoded value, it



If I change the query to "select * from person where lastName = '$P!{Name}' ". It works against JDBC to MySQL driver.


This looks to me like a bug.


Thanks for advice,



Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...