12 Replies Latest reply on Aug 20, 2019 8:48 AM by mtawk

    Teiid standalone - SQL Server insert into error

    mtawk Apprentice

      We are encountering an error when using insert into select under SQL Server.

      The source table and the destination table are from 2 different databases under the same SQL Server.

      The exception is reproduced in the method org.teiid.translator.jdbc.JDBCBaseExecution.getPreparedStatement(String sql)

      Attached is a simple test query along with exception stack.

      Note that this issue is only reproduced with Teiid standalone, the same query executes successfully using Teiid embedded.