[ https://issues.redhat.com/browse/TEIID-5949?page=com.atlassian.jira.plugi... ] Steven Hawkins commented on TEIID-5949: --------------------------------------- For now the workaround would be to alter the source metadata so that it's a Teiid timestamp type. The bigger fix is to update the translator to assign a better type on import. > SQLServer DateTimeOffset datatype is read as object(34) > ------------------------------------------------------- > > Key: TEIID-5949 > URL: https://issues.redhat.com/browse/TEIID-5949 > Project: Teiid > Issue Type: Bug > Components: JDBC Driver > Affects Versions: 11.1.2 > Reporter: Manoj Majumdar > Assignee: Steven Hawkins > Priority: Major > Labels: TEIID30504, sqlserver2012 > Fix For: 14.1 > > > Hi, > I am trying to set null in datetimeoffset datatype of SQLSERVER using Teiid , but it is giving the error as: > org.teiid.jdbc.TeiidSQLException: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 B_MSSQL1: S0003 Implicit conversion from data type varbinary to datetimeoffset is not allowed. Use the CONVERT function to run this query. > at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:131) > at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:67) > at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:752) > at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:62) > at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:562) > at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:131) > at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:36) > at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:75) > at org.teiid.net.socket.SocketServerInstanceImpl.receivedMessage(SocketServerInstanceImpl.java:281) > at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:333) > at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:423) > at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:571) > at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:420) > at org.teiid.jdbc.PreparedStatementImpl.executeBatch(PreparedStatementImpl.java:296) > I am just using a table, with only one column "datetimeoffset" and when I an using Preparedstatement.setNull(1, Types.TIMESTAMP), it is throwing this error. > Please suggest any ways to overcome this issue. -- This message was sent by Atlassian Jira (v7.13.8#713008)