[
https://issues.apache.org/jira/browse/GUACAMOLE-870?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Nick Couchman resolved GUACAMOLE-870.
-------------------------------------
Resolution: Fixed
> Connection history query fails against SQL Server
> -------------------------------------------------
>
> Key: GUACAMOLE-870
> URL: https://issues.apache.org/jira/browse/GUACAMOLE-870
> Project: Guacamole
> Issue Type: Bug
> Components: guacamole-auth-jdbc-sqlserver
> Reporter: Michael Jumper
> Assignee: Nick Couchman
> Priority: Major
> Fix For: 1.2.0
>
>
> While the connection history initially displays correctly, any queries
> against the history fail with the following error:
> {code:none}
> com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near
> 'username'.
> {code}
> This is due to the use of the {{POSITION()}} function within the query and is
> presumably a holdover from the initial creation of SQL Server support for
> Guacamole. This function is present in both the MySQL and PostgreSQL flavors
> of the Guacamole history query, which predate SQL Server support and would
> have been used as its basis.
> Unlike MySQL and PostgreSQL, SQL Server does not support the {{POSITION()}}
> function. The {{CHARINDEX()}} function should be used instead.
--
This message was sent by Atlassian Jira
(v8.3.2#803003)
