[jira] [Resolved] (GUACAMOLE-870) Connection history query fails against SQL Server

["Nick Couchman (Jira)" <ji...@apache.org>]

     [ 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)