[teiid-issues] [JBoss JIRA] (TEIID-5949) SQLServer DateTimeOffset datatype is read as object(34)

[Steven Hawkins (Jira)]

     [ https://issues.redhat.com/browse/TEIID-5949?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-5949.
-----------------------------------
    Fix Version/s: 14.0.1
       Resolution: Done


Updated the mapping to string based upon the comments here.  We'll need to consider adding first class support for timestamp with timezone (although we'd need arbitrary offsets here) to better handle situations like this.

> 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: 15.0, 14.0.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.
> Also the datetimeoffset datatype is read as "object(34)" while fetching the schema using Teiid and Microsoft JDBC driver.
> Please suggest any ways to overcome this issue.



--
This message was sent by Atlassian Jira
(v7.13.8#713008)