Param not processed correctly in query via jdbc

[jfdepoit]

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