You can translate the question and the replies:

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)
DBeaver SQLserver. BYTE
user
12-07-2018 13:18:49 -0400
code

4 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
code
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
Hello! The driver seems to be the culprit based off this error: `vdb.jdbcdriver.conversion.ObjectRowConverter.convertByte` Now, in Denodo, there are two ways (drivers) that can be used to connect to MS SQL SERVER. There is jtds, or there is the Microsoft Driver. We suggest looking at the driver alternative first, then looking at the Denodo values to see how there were mapped would be the next step if the driver does not resolve it. Best Regards!
Denodo Team
26-08-2019 11:31:02 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here