java.sql.SQLException

Invalid column type Query: SELECT (?, ?, ?) FROM schema.table Parameters: [colname1, TO_CHAR(coldate1,'YYYY-MM-DD HH24:MI:SS'), TO_CHAR(colnum1,'99999990.99')]

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

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

Solutions on the web7679

  • via Coderanch by jeff mutonho, 11 months ago
    Invalid column type Query: SELECT (?, ?, ?) FROM schema.table Parameters: [colname1, TO_CHAR(coldate1,'YYYY-MM-DD HH24:MI:SS'), TO_CHAR(colnum1,'99999990.99')]
  • , DECODE(TO_CHAR(event_dt, 'HH24MISS'), '000000', TO_CHAR(event_dt, 'YYYYMMDD') || TO_CHAR(event_tm, 'HH24MISS'), TO_CHAR(event_dt, 'YYYYMMDDHH24MISS'))), 'YYYYMMDDHH24MISS') >= TO_DATE('05-02-2011 01:57:00', 'MM-DD-YYYY HH24:MI:SS') and (event_type='COMPLT' or event_type='CLOSED') Query:ReadAllQuery(com.xxx.office.service.crm.model.RequestEvent)
  • Table not found in statement [SELECT USER_ID FROM UP_USER WHERE LST_CHAN_UPDT_DT=TO_DATE('2001 01 01 00:00', 'YYYY MM DD HH24:MI:SS') AND USER_ID=0]
  • Stack trace

    • java.sql.SQLException: Invalid column type Query: SELECT (?, ?, ?) FROM schema.table Parameters: [colname1, TO_CHAR(coldate1,'YYYY-MM-DD HH24:MI:SS'), TO_CHAR(colnum1,'99999990.99')] at org.apache.commons.dbutils.QueryRunner.rethrow(QueryRunner.java:330) at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:213) at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:279) at co.za.scs.scvpull.SCVDatabaseToMessagingClient.selectRows(SCVDatabaseToMessagingClient.java:192) at co.za.scs.scvpull.SCVDatabaseToMessagingClient.main(SCVDatabaseToMessagingClient.java:60)

    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

    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago