Jump to content
Changes to the Jaspersoft community edition download ×

Param not processed correctly in query via jdbc


jfdepoit

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

works.

 

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,

 

Jeff

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...