java.sql.SQLException

No parameters defined during prepareCall() No parameters defined during prepareCall()


Samebug tips1

MySQL doesn't support some types of characters (such as emojis) with the utf8 encoding. You need to be on MySQL 5.5+ and force utf8mb4 (everywhere, client and server). You can do this sending the query "SET NAMES utf8mb4". Check this https://goo.gl/3E2qzg

Don't give up yet. Our experts can help. Paste your full stack trace to get a solution.


Solutions on the web4453

Solution icon of web
via pentaho.com by Unknown author, 11 months ago
No parameters defined during prepareCall() No parameters defined during prepareCall()

Solution icon of web
No parameters defined during prepareCall()

Solution icon of github
No parameters defined during prepareCall()

Solution icon of oraclecommunity
prepareCall, Exception = 14

Solution icon of oraclecommunity
prepareCall, Exception = 14

Solution icon of googlegroups
via Google Groups by ros, 1 year ago
No output parameters registered.

Solution icon of stackoverflow
No input parameters.

Solution icon of stackoverflow
No input parameters.

Solution icon of googlegroups
via Google Groups by ros, 1 year ago
No output parameters registered.

Solution icon of sourceforge
via jtds by agility
, 1 year ago
Procedure ADaPTLog_SelectUnchecked has no parameters and arguments were supplied.

Stack trace

  • java.sql.SQLException: No parameters defined during prepareCall() No parameters defined during prepareCall() at org.pentaho.di.core.database.Database.setValue(Database.java:1107) at org.pentaho.di.core.database.Database.setValues(Database.java:1130) Caused by: java.sql.SQLException: No parameters defined during prepareCall() at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927) at com.mysql.jdbc.ServerPreparedStatement.getBinding(ServerPreparedStatement.java:905) at com.mysql.jdbc.ServerPreparedStatement.setNull(ServerPreparedStatement.java:2048) at org.pentaho.di.core.database.Database.setValue(Database.java:986) ... 2 more

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

703 times, 2 days ago
85 times, 4 days ago
Once, 6 days ago
101 times, 1 week ago
152 more bugmates