java.lang.RuntimeException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • RE: LENS UI
    via by Santiago Gimenez,
  • cant get it working [#1428232] | Drupal.org
    via by Unknown author,
  • GitHub comment 25#52516950
    via GitHub by StigLau
    ,
  • [mule-dev] MSSQL with JDBC Transport
    via by Juan Guzman,
  • I'm trying to perform an insert on an Oracle Database. The problem I have is with null parameters to be passed to the statement. The jdbc dispatcher performs a: int nbRows = new QueryRunner().update(con, writeStmt, paramValues); Looking at the QueryRunner code I can see that the update method invokes the fillStatement operation: protected void fillStatement(PreparedStatement stmt, Object[] params) throws SQLException { if (params == null) { return; } for (int i = 0; i < params.length; i++) { if (params[i] != null) { stmt.setObject(i + 1, params[i]); } else { stmt.setNull(i + 1, Types.OTHER); } } } When a null value is found, the stmt.setNull(i + 1, Types.OTHER); is called and the following exception is thrown: java.sql.SQLException: Invalid column type Query: INSERT INTO FPA.ESPECIES (rest of the query here)... at org.apache.commons.dbutils.QueryRunner.rethrow(QueryRunner.java:330) at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:399) at org.mule.providers.jdbc.JdbcMessageDispatcher.doDispatch(JdbcMessageDispatcher.java:98) at com.lumina.integration.mule.providers.jdbc.JdbcMessageDispatcher.doSend(JdbcMessageDispatcher.java:61) at org.mule.providers.AbstractMessageDispatcher.send(AbstractMessageDispatcher.java:196) Apparently the error is because of the Types.OTHER sql type. I know that this is an issue involving Jakarta dbutils package but maybe someone has already got this problem and found a workaround to this. At the Jakarta mailing list a workaround is mentioned by subclassing the QueryRunner class. In order to do that, I'll need to subclass the JDBC provider completely (the dispatcher and factory at least). Perhaps a custom QueryRunner could be injected to the JdbcMessageDispatcher in a future version. Regards, Juan Manuel
    via by Juan Manuel Sanmarco,
  • I'm trying to perform an insert on an Oracle Database. The problem I have is with null parameters to be passed to the statement. The jdbc dispatcher performs a: int nbRows = new QueryRunner().update(con, writeStmt, paramValues); Looking at the QueryRunner code I can see that the update method invokes the fillStatement operation: protected void fillStatement(PreparedStatement stmt, Object[] params) throws SQLException { if (params == null) { return; } for (int i = 0; i < params.length; i++) { if (params[i] != null) { stmt.setObject(i + 1, params[i]); } else { stmt.setNull(i + 1, Types.OTHER); } } } When a null value is found, the stmt.setNull(i + 1, Types.OTHER); is called and the following exception is thrown: java.sql.SQLException: Invalid column type Query: INSERT INTO FPA.ESPECIES (rest of the query here)... at org.apache.commons.dbutils.QueryRunner.rethrow(QueryRunner.java:330) at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:399) at org.mule.providers.jdbc.JdbcMessageDispatcher.doDispatch(JdbcMessageDispatcher.java:98) at com.lumina.integration.mule.providers.jdbc.JdbcMessageDispatcher.doSend(JdbcMessageDispatcher.java:61) at org.mule.providers.AbstractMessageDispatcher.send(AbstractMessageDispatcher.java:196) Apparently the error is because of the Types.OTHER sql type. I know that this is an issue involving Jakarta dbutils package but maybe someone has already got this problem and found a workaround to this. At the Jakarta mailing list a workaround is mentioned by subclassing the QueryRunner class. In order to do that, I'll need to subclass the JDBC provider completely (the dispatcher and factory at least). Perhaps a custom QueryRunner could be injected to the JdbcMessageDispatcher in a future version. Regards, Juan Manuel
    via by Juan Manuel Sanmarco,
  • Invalid parameter index 3 - Mirth Community
    via by Unknown author,
    • java.lang.RuntimeException: Cannot initialize saved query service at org.apache.lens.server.query.save.SavedQueryServiceImpl.init(SavedQueryServiceImpl.java:75)[classes/:na] at org.apache.hive.service.CompositeService.init(CompositeService.java:59)[hive-service-0.13.4-inm.jar:0.13.4-inm] at org.apache.lens.server.LensServices.init(LensServices.java:235)[classes/:na] at org.apache.lens.server.LensServer.startServices(LensServer.java:134)[classes/:na] at org.apache.lens.server.LensServer.<init>(LensServer.java:85)[classes/:na] at org.apache.lens.server.LensServer.createLensServer(LensServer.java:74)[classes/:na] at org.apache.lens.server.LensServer.main(LensServer.java:190)[classes/:na] Caused by: org.apache.lens.server.api.error.LensException: Error initializing saved query dao at org.apache.lens.server.query.save.SavedQueryDao.<init>(SavedQueryDao.java:72)[classes/:na] at org.apache.lens.server.query.save.SavedQueryServiceImpl.init(SavedQueryServiceImpl.java:70)[classes/:na] ... 6 more Caused by: org.apache.lens.server.api.error.LensException: Cannot create saved query table! at org.apache.lens.server.query.save.SavedQueryDao.createSavedQueryTableIfNotExists(SavedQueryDao.java:85)[classes/:na] at org.apache.lens.server.query.save.SavedQueryDao.<init>(SavedQueryDao.java:70)[classes/:na] ... 7 more Caused by: java.sql.SQLException: palabra no esperado: ( Query: CREATE TABLE IF NOT EXISTS saved_query (id int(11) NOT NULL AUTO_INCREMENT,name varchar(255) NOT NULL,description varchar(255) DEFAULT NULL,query longtext,params_json longtext,created_at timestamp,updated_at timestamp, PRIMARY KEY (id)) Parameters: [] at org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:363)[commons-dbutils-1.5.jar:1.5] at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:490)[commons-dbutils-1.5.jar:1.5] at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:420)[commons-dbutils-1.5.jar:1.5] at org.apache.lens.server.query.save.SavedQueryDao.createSavedQueryTableIfNotExists(SavedQueryDao.java:83)[classes/:na] ... 8 more

    Users with the same issue

    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,