Can't run IBM iSeries (AS400) Stored Procedure calls in DBeaver 22.1.0 but can run them in 6.2.0

[EricWagnerJr]

Description

Doing a proof of concept for DBeaver Lite - I can run stored procedures in 6.2.0 using the jtopen (jt400.jar) driver. I can also run select statements against it using 22.1.0, but I can't run stored procedures.

Example Call: "CALL SOMESCHEMA.SOMEPROCEDURE('EA', ?, ?);"

Configs:

Logs:

!ENTRY org.jkiss.dbeaver.model 4 0 2022-08-18 14:27:22.000
!MESSAGE Error executing query
!SUBENTRY 1 org.jkiss.dbeaver.model 4 0 2022-08-18 14:27:22.000
!MESSAGE 
!SUBENTRY 2 org.jkiss.dbeaver.model 4 0 2022-08-18 14:27:22.000
!MESSAGE DBException
!STACK 0
org.jkiss.dbeaver.DBException
	at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:231)
	at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeSingleQuery(SQLQueryJob.java:491)
	at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.extractData(SQLQueryJob.java:878)
	at org.jkiss.dbeaver.ui.editors.sql.SQLEditor$QueryResultsContainer.readData(SQLEditor.java:3526)
	at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.lambda$0(ResultSetJobDataRead.java:118)
	at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:172)
	at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.run(ResultSetJobDataRead.java:116)
	at org.jkiss.dbeaver.ui.controls.resultset.ResultSetViewer$ResultSetDataPumpJob.run(ResultSetViewer.java:4868)
	at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:105)
	at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)
Caused by: java.lang.NullPointerException
	at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCCallableStatementImpl.getOutputParametersFromMeta(JDBCCallableStatementImpl.java:288)
	at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCCallableStatementImpl.<init>(JDBCCallableStatementImpl.java:114)
	at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCFactoryDefault.createCallableStatement(JDBCFactoryDefault.java:48)
	at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCConnectionImpl.createCallableStatementImpl(JDBCConnectionImpl.java:730)
	at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCConnectionImpl.prepareCall(JDBCConnectionImpl.java:415)
	at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCConnectionImpl.prepareStatement(JDBCConnectionImpl.java:102)
	at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCConnectionImpl.prepareStatement(JDBCConnectionImpl.java:1)
	at org.jkiss.dbeaver.model.DBUtils.createStatement(DBUtils.java:1330)
	at org.jkiss.dbeaver.model.DBUtils.makeStatement(DBUtils.java:1298)
	at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeStatement(SQLQueryJob.java:551)
	at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.lambda$1(SQLQueryJob.java:484)
	at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:172)
	... 9 more
!SUBENTRY 3 org.jkiss.dbeaver.model 4 0 2022-08-18 14:27:22.000
!MESSAGE NullPointerException
!STACK 0
java.lang.NullPointerException
	at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCCallableStatementImpl.getOutputParametersFromMeta(JDBCCallableStatementImpl.java:288)
	at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCCallableStatementImpl.<init>(JDBCCallableStatementImpl.java:114)
	at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCFactoryDefault.createCallableStatement(JDBCFactoryDefault.java:48)
	at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCConnectionImpl.createCallableStatementImpl(JDBCConnectionImpl.java:730)
	at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCConnectionImpl.prepareCall(JDBCConnectionImpl.java:415)
	at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCConnectionImpl.prepareStatement(JDBCConnectionImpl.java:102)
	at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCConnectionImpl.prepareStatement(JDBCConnectionImpl.java:1)
	at org.jkiss.dbeaver.model.DBUtils.createStatement(DBUtils.java:1330)
	at org.jkiss.dbeaver.model.DBUtils.makeStatement(DBUtils.java:1298)
	at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeStatement(SQLQueryJob.java:551)
	at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.lambda$1(SQLQueryJob.java:484)
	at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:172)
	at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeSingleQuery(SQLQueryJob.java:491)
	at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.extractData(SQLQueryJob.java:878)
	at org.jkiss.dbeaver.ui.editors.sql.SQLEditor$QueryResultsContainer.readData(SQLEditor.java:3526)
	at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.lambda$0(ResultSetJobDataRead.java:118)
	at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:172)
	at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.run(ResultSetJobDataRead.java:116)
	at org.jkiss.dbeaver.ui.controls.resultset.ResultSetViewer$ResultSetDataPumpJob.run(ResultSetViewer.java:4868)
	at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:105)
	at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)

DBeaver Version

DBeaver Lite (Trial) 22.1.0

Operating System

Windows 10

Database and driver

IBM iSeries (AS400) - using jt400.jar driver.

Steps to reproduce

No response

Additional context

No response

[LonwoLonwo]

Hello @EricWagnerJr

Can you provide a procedure example DDL, please?

[EricWagnerJr]

I'm not sure I am able to share that in this forum. I'm realizing you have a different portal on your site for submitting tech support requests. I think I may need to pivot to there.

Update: I did submit a ticket separately there so we could possibly schedule a call.

[LonwoLonwo]

So it means that only one stored procedure doesn't work? Not all? Or maybe you can find a sample procedure?

[EricWagnerJr]

No, it is all stored procedures failing. I can't share my companies SPs in a public forum I'm realizing so we will have to take this private over the internal ticketing system.

[n5a5]

@EricWagnerJr Please check out my message on our ticket system, thanks

[EricWagnerJr]

This fixed the issue @n5a5, thank you.

[n5a5]

@EricWagnerJr My pleasure!