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: []


Solutions on the web21103

Solution icon of stackoverflow
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

Solution icon of web
via nabble.com by Unknown author, 1 year ago
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 ''WHERE ID=\'2\''' at line 1 Query: SELECT * FROM Customer ? Parameters: [WHERE ID='2']

Solution icon of stackoverflow
Operand should contain 1 column(s) Error Code: 1241 Call: SELECT .... FROM webcontent_type WHERE (ID IN (?,?,?,?,?,?,?)) ORDER BY FIELD(ID, (?,?,?,?,?,?,?)) bind => [14 parameters bound] Query: ReadAllQuery(referenceClass=WebContentType sql="SELECT .... FROM webcontent_type WHERE (ID IN ?) ORDER BY FIELD(ID, ?)")

Solution icon of oraclecommunity
via Oracle Community by 621260, 1 year ago
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2. Error Code: -3010 Call: SELECT ID, TYPE, QUANTITY, CUSTOMER_ID FROM ORDERINFO WHERE (CUSTOMER_ID = ?) bind => [252] Query: ReadAllQuery(customerrelation.OrderInfo)

Solution icon of googlegroups
via Google Groups by sige, 1 month ago
ERROR: syntax error at or near "$" Query: SELECT id,name, address, age from user where id= ${jxpath:/user/id}"Parameters: []

Solution icon of web
via nabble.com by Unknown author, 1 year ago
error in script file line: 2 invalid schema name: SYSTEM_SCHEMA in statement [CREATE MEMORY TABLE FILM_MOVIETITLE(ID INTEGER NOT NULL PRIMARY KEY,TITLE VARCHAR_IGNORECASE(120) NOT NULL,ORIGINAL_TITLE VARCHAR_IGNORECASE(120) DEFAULT NULL,IMDB VARCHAR_IGNORECASE(7) NOT NULL,YEAR INTEGER NOT NULL,DURATION INTEGER NOT NULL)]

Solution icon of web
via nabble.com by Unknown author, 1 year ago
error in script file line: 2 invalid schema name: SYSTEM_SCHEMA in statement [CREATE MEMORY TABLE FILM_MOVIETITLE(ID INTEGER NOT NULL PRIMARY KEY,TITLE VARCHAR_IGNORECASE(120) NOT NULL,ORIGINAL_TITLE VARCHAR_IGNORECASE(120) DEFAULT NULL,IMDB VARCHAR_IGNORECASE(7) NOT NULL,YEAR INTEGER NOT NULL,DURATION INTEGER NOT NULL)]

Solution icon of googlegroups
via Google Groups by Donny Tjandra, 2 weeks ago
ERROR: function get_property_list2(character varying, date, integer, bigint) does not exist

Solution icon of oraclecommunity
A lock could not be obtained within the time requested Error Code: -1 Call: SELECT ID FROM IMAGESOWNER WHERE (ID = ?) bind => [2] Query: DoesExistQuery()

Solution icon of mirthcorp
via Mirth Project by john voigt, 1 year ago
I/O Error: Connection reset by peer: socket write error Query: SELECT top 1 [ID] as mid ,[RECEIVED_DATE] ,CAST(HL7_Transaction as varchar(MAX)) AS SOURCE_HL7 FROM [INTEGRATION_NEW_TRANSACTIONS] where PROCESSED_DATE is NULL ORDER BY [RECEIVED_DATE] asc Parameters: []

Stack trace

  • 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(AbstractQueryRunner.java:392) at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:351) at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:289)

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

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago