"Null statement" error while counting record count

[alexvulpe]

System information:

• Windows 10
• 7.2.5.202011152110

Connection specification:

• Custom JDBC driver

Describe the problem you're observing:

Getting "Null statement" error when clicking "Calculate total row count" button

Steps to reproduce, if exist:

Run any select, ex. SELECT * FROM F_ACCOUNT
200 records are returned
Click "Calculate total row count" button

Include any warning/errors/backtraces from the logs

eclipse.buildId=unknown
java.version=11.0.5
java.vendor=AdoptOpenJDK
BootLoader constants: OS=win32, ARCH=x86_64, WS=win32, NL=en_GB
Command-line arguments: -os win32 -ws win32 -arch x86_64

org.jkiss.dbeaver.model
Error
Sat Nov 21 11:55:22 EET 2020
Null statement

java.lang.IllegalArgumentException: Null statement
at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCConnectionImpl.createPreparedStatementImpl(JDBCConnectionImpl.java:719)
at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCConnectionImpl.prepareStatement(JDBCConnectionImpl.java:405)
at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCConnectionImpl.prepareStatement(JDBCConnectionImpl.java:178)
at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCConnectionImpl.prepareStatement(JDBCConnectionImpl.java:1)
at org.jkiss.dbeaver.model.DBUtils.makeStatement(DBUtils.java:1374)
at org.jkiss.dbeaver.model.DBUtils.makeStatement(DBUtils.java:1321)
at org.jkiss.dbeaver.ui.editors.sql.SQLEditor$QueryResultsContainer.countData(SQLEditor.java:3137)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetViewer.lambda$37(ResultSetViewer.java:3564)
at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:168)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetViewer.readRowCount(ResultSetViewer.java:3559)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetViewer.access$27(ResultSetViewer.java:3552)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetViewer$9$1.evaluate(ResultSetViewer.java:1668)
at org.jkiss.dbeaver.ui.controls.resultset.ResultSetViewer$9$1.evaluate(ResultSetViewer.java:1)
at org.jkiss.dbeaver.ui.LoadingJob.run(LoadingJob.java:88)
at org.jkiss.dbeaver.ui.LoadingJob.run(LoadingJob.java:72)
at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:105)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)

[LonwoLonwo]

Can't reproduce in Oracle, PostgreSQL, SQLite and MySQL in SQLEditor. "Calculate total row count" calculate correctly
Need more information.
What database you use? Connection type?
May be, you can make video?

[alexvulpe]

I have developed a custom JDBC driver of Temenos T24 banking system. And because my source code is not a part of callstack, I was is wondering what is requested (and apparently missing) in line JDBCConnectionImpl.java:719, which causes "Null statement".

[LonwoLonwo]

Usually, it's just SELECT COUNT(*) FROM tableName

Can you take a look at your Query Manager?

[alexvulpe]

No extra calls in Query Manager after clicking "Calculate total row count"

[alexvulpe]

Is it possible to let me know what is missing in line JDBCConnectionImpl.java:719?
Perhaps my initial SELECT did not provide all requested data, so I can fix by jdbc driver.

[LonwoLonwo]

Oh, I'm afraid it's not that easy, unfortunately. The conversion of the counting expression occurs first in this method. Perhaps this will help you.

dbeaver/plugins/org.jkiss.dbeaver.ui.editors.sql/src/org/jkiss/dbeaver/ui/editors/sql/SQLEditor.java

Line 3123 in 9156d46

public long countData(@NotNull DBCExecutionSource source, @NotNull DBCSession session, DBDDataFilter dataFilter, long flags)