Error when trying to use the parameter value "Emeritus"
Posted by: Kamaraj Jawahar
Date: May 17, 2016 05:39PM

I am using mysql with BIRT with JDBC connection.

Database encoding is utf-8

When I try to call a stored procedure with parameter value "Emeritus"
it fails.

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BIPy+' at line 4 (Element ID:24180)

Here is the stored procedure that is being called:

call sp_vol_performance_report_test_upd(?,0,?,0,?,?,?)

Question marks are parameters and passed at run time..
Whenever I pass Emeritus or Provisional it fails with the above error.

The value Active works fine..

Some times I get the following error

Caused by: java.sql.SQLException: Invalid utf8 character string: '¯EPy'

Any one seen this problem. If yes, please let me know the solution.

Thank you

Options: ReplyQuote

Written By
Error when trying to use the parameter value "Emeritus"
May 17, 2016 05:39PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.