java.sql.SQLException: ERROR: function idx(integer[], integer) does not exist 18:01:40,517 ERROR [stderr] (default task-13) Hint: No function matches the given name and argument types. You might need to add explicit type casts. 18:01:40,520 ERROR [stderr] (default task-13) Position: 73 Query: SELECT planner.udf_desc.* FROM planner.udf_desc WHERE id IN(2) ORDER BY idx(array[2], id) Parameters: []

Stack Overflow | afzalex | 2 weeks ago
  1. 0

    postgresql function "idx" is found in some machine but not in other

    Stack Overflow | 2 weeks ago | afzalex
    java.sql.SQLException: ERROR: function idx(integer[], integer) does not exist 18:01:40,517 ERROR [stderr] (default task-13) Hint: No function matches the given name and argument types. You might need to add explicit type casts. 18:01:40,520 ERROR [stderr] (default task-13) Position: 73 Query: SELECT planner.udf_desc.* FROM planner.udf_desc WHERE id IN(2) ORDER BY idx(array[2], id) Parameters: []
  2. 0

    How to solve "java.sql.SQLException: Feature not implemented Query"?

    Stack Overflow | 3 years ago | Ruhi Singh
    java.sql.SQLException: Feature not implemented Query: SELECT id, name, active, modified_time, create_time, version, last_modified_by, description, enc_type, settings_blob FROM projects WHERE active=true Parameters: []
  3. 0

    java commons dbutils: multi-part identifier could not be bound

    Stack Overflow | 3 years ago | bradvido
    java.sql.SQLException: com.microsoft.sqlserver.jdbc.SQLServerException: The multi-part identifier "zz.ps_id" could not be bound. Query: SELECT psq_id, question_text FROM presales_question WHERE psq_id IN(SELECT zz.psq_id FROM productservice_psq as zz WHERE zz.ps_id = ?) Parameters: [1]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    JDBC Persistence: Error on startup with SQLite

    GitHub | 4 months ago | juelicher
    java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such function: DATABASE) Query: SELECT DATABASE() Parameters: []
  6. 0

    Apache DBUtils queryRunner - where in clause

    Stack Overflow | 9 months ago | dmachop
    java.sql.SQLException: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ','. Query: SELECT ID from Document where Id IN (?, ?, ?) Parameters: [015190000000vojAAA, 015190000000vokAAA, 015190000000volAAA]

    4 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      ERROR: function idx(integer[], integer) does not exist 18:01:40,517 ERROR [stderr] (default task-13) Hint: No function matches the given name and argument types. You might need to add explicit type casts. 18:01:40,520 ERROR [stderr] (default task-13) Position: 73 Query: SELECT planner.udf_desc.* FROM planner.udf_desc WHERE id IN(2) ORDER BY idx(array[2], id) Parameters: []

      at org.apache.commons.dbutils.AbstractQueryRunner.rethrow()
    2. Apache Commons DbUtils
      QueryRunner.query
      1. org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:392)
      2. org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:351)
      3. org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:289)
      3 frames