I'm trying to exact resultset from Microsoft SQL Server using JDBC but i have stumbled upon an issue.
Here's the config:
The query looks like this:
> select * from :database.dbo.table
Logstash is unable to retreive any result, due to an error with the query. In the log i can see that's it's trying to execute the following:
> select * from N'ABC'.dbo.table
Any idea how to get rid of N'' in table name? I know it's a matter of using National language character set but I would like to overcome this.
I'd appreciate the help, thanks!
I tried using quotes, double quotes but the outcome is exactly the same.