Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SQL Developper 24.3.0.284 - Error can't parse argument number : :SCHEMA

Michel ClaesNov 17 2024

Hello,

I upgraded from SQL Developper 23.1.1.345 to 24.3.0.284 on a mac book pro M3.

The jdbc driver for mysql is version 9.1.0 Platform Independant.

When I select a mysql table it displays the Columns, ,Index Information, Constraints, Model.

But when I click on Data, it works with version 23 but with version 24, I get de following error :

java.lang.IllegalArgumentException: can't parse argument number: :SCHEMA
at java.base/java.text.MessageFormat.makeFormat(Unknown Source)
at java.base/java.text.MessageFormat.applyPattern(Unknown Source)
at java.base/java.text.MessageFormat.<init>(Unknown Source)
at java.base/java.text.MessageFormat.format(Unknown Source)
at oracle.dbtools.db.DBUtil.prepareNonOracleSqlMsgFormat(DBUtil.java:1615)
at oracle.dbtools.db.DBUtil.prepareNonOracleSql(DBUtil.java:1570)
at oracle.dbtools.raptor.controls.grid.TPDBResultSetModel.prepareStatement(TPDBResultSetModel.java:32)
at oracle.dbtools.raptor.controls.grid.ResultSetTableModel.openResultSet(ResultSetTableModel.java:543)
at oracle.dbtools.raptor.controls.grid.ResultSetTableModel.fetchNext(ResultSetTableModel.java:317)
at oracle.dbtools.raptor.controls.grid.ResultSetTableModel$4.doWork(ResultSetTableModel.java:750)
at oracle.dbtools.raptor.controls.grid.ResultSetTableModel$4.doWork(ResultSetTableModel.java:734)
at oracle.dbtools.raptor.backgroundTask.RaptorTask.call(RaptorTask.java:204)
at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask.run(RaptorTaskManager.java:798)
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.base/java.lang.Thread.run(Unknown Source)
Caused by: java.lang.NumberFormatException: For input string: ":SCHEMA"
at java.base/java.lang.NumberFormatException.forInputString(Unknown Source)
at java.base/java.lang.Integer.parseInt(Unknown Source)
at java.base/java.lang.Integer.parseInt(Unknown Source)
... 19 more

Thanks for your help.

Michel.

Comments
Post Details
Added on Nov 17 2024
1 comment
168 views