CODEWITHSUNDEEP
javasql-serverspring-bootteiid
SamanthPadala
SamanthPadala

Reputation: 41

TEIID Spring boot integration with two sql server. QueryParserException

I am getting below error when trying to fetch data from two different mssql servers:

TEIID31100 Parsing error: Encountered "SELECT id, [*]parameter[*], value" at line 9, column 12. Was expecting: "char" | "date" | "time" | "timestamp" | "cast" | "convert" | "any" | "array" | "array_agg" | "case" ... at org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:231) ~[teiid-engine-16.0.0.jar:16.0.0] ... 28 common frames omitted

My Class:

 @SelectQuery("SELECT id, parameter, value, created_date FROM database63.DAC_SYS_MEMORY"
         + " UNION ALL"
         + " SELECT id, parameter, value, created_date FROM database54.DAC_SYS_MEMORY")
 public class CustomRecord {

    @Id
    @Column(name="ID")
    private int id;
    @Column(name="Parameter")
    private String parameter;
    @Column(name="Value")
    private String value;
    @Column(name="created_date")
    private Date createdDate;

I have integrated Teiid spring boot and been trying to fetch data from two diff sqlservers

Upvotes: 0

Views: 69

Answers (0)

Related Questions