DBeaver, SQLserver. java.sql.SQLException: Invalid mapping to BYTE

I'm trying to access data from SQLserver via Denodo (I think version 6), using latest Dbeaver (on Win7). I'm not an adminstrator so have no visibility of Denodo setup etc. nor the database itself. I'm getting warnings when viewing data from views of DB tables that have one or more BIT columns. (see error below). Is this error likely to be with Denodo setup, or with some DBeaver setting/incompatibility? Error as follows: org.jkiss.dbeaver.model.exec.DBCException: SQL Error: Invalid mapping to BYTE. at org.jkiss.dbeaver.model.impl.jdbc.data.handlers.JDBCAbstractValueHandler.fetchValueObject(JDBCAbstractValueHandler.java:55) at org.jkiss.dbeaver.ui.controls.resultset.ResultSetDataReceiver.fetchRow(ResultSetDataReceiver.java:118) at org.jkiss.dbeaver.model.impl.jdbc.struct.JDBCTable.readData(JDBCTable.java:204) at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.lambda$0(ResultSetJobDataRead.java:93) at org.jkiss.dbeaver.model.DBUtils.tryExecuteRecover(DBUtils.java:1539) at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.run(ResultSetJobDataRead.java:91) at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:95) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:56) Caused by: java.sql.SQLException: Invalid mapping to BYTE. at com.denodo.vdb.jdbcdriver.conversion.ObjectRowConverter.convertByte(ObjectRowConverter.java:218) at com.denodo.vdb.jdbcdriver.VDBJDBCAsyncResultSet.getByte(VDBJDBCAsyncResultSet.java:632) at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCResultSetImpl.getByte(JDBCResultSetImpl.java:355) at org.jkiss.dbeaver.model.impl.jdbc.data.handlers.JDBCNumberValueHandler.fetchColumnValue(JDBCNumberValueHandler.java:131)
user
12-07-2018 13:18:49 -0400

3 Answers

It was a Denodo issue. Fixed by adminstrators this morning. Many thanks!
user
13-07-2018 07:41:53 -0400
Hello, Good to hear that it was fixed. Feel free to reach out if there is anything else we can answer. Best Regards!
Denodo Team
13-07-2018 11:22:35 -0400
May we ask how you solved this issue? We experience the same with DBeaver 6.1.2 (on Win10) - Denodo 7 - SQL Server 2016.
user
13-08-2019 06:17:02 -0400
You must sign in to add an answer. If you do not have an account, you can register here