Repository: drill Updated Branches: refs/heads/gh-pages ee27aea09 -> f416850a0
edit JDBC SQuirreL on Windows doc per MD-1728 Project: http://git-wip-us.apache.org/repos/asf/drill/repo Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/f416850a Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/f416850a Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/f416850a Branch: refs/heads/gh-pages Commit: f416850a0a7f79c2bb498a0dd45bef6ab91c8078 Parents: ee27aea Author: Bridget Bevens <[email protected]> Authored: Thu Jan 18 17:36:02 2018 -0800 Committer: Bridget Bevens <[email protected]> Committed: Thu Jan 18 17:36:02 2018 -0800 ---------------------------------------------------------------------- .../020-using-jdbc-with-squirrel-on-windows.md | 7 +++++-- 1 file changed, 5 insertions(+), 2 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/drill/blob/f416850a/_docs/odbc-jdbc-interfaces/020-using-jdbc-with-squirrel-on-windows.md ---------------------------------------------------------------------- diff --git a/_docs/odbc-jdbc-interfaces/020-using-jdbc-with-squirrel-on-windows.md b/_docs/odbc-jdbc-interfaces/020-using-jdbc-with-squirrel-on-windows.md index c8d187f..0190172 100644 --- a/_docs/odbc-jdbc-interfaces/020-using-jdbc-with-squirrel-on-windows.md +++ b/_docs/odbc-jdbc-interfaces/020-using-jdbc-with-squirrel-on-windows.md @@ -1,9 +1,12 @@ --- title: "Using JDBC with SQuirreL on Windows" -date: 2017-05-09 01:40:53 UTC +date: 2018-01-19 01:36:03 UTC parent: "ODBC/JDBC Interfaces" --- -To use the JDBC Driver to access Drill through SQuirreL, ensure that you meet the prerequisites and follow the steps in this section. +You can use the JDBC driver to connect to Drill from SQuirrel and run SQL queries. Verify that your system meets the prerequisites and then follow the steps listed. + +**Note:** Drill interprets a wildcard in a SQL query as a multiline comment (/.../), which SQuirreL supports. As a result, SQuirreL tries to remove what it interprets as comments and submits an abruptly truncated query. To resolve this issue in SQuirreL, go to the menu and select **File > New Session Properties > Tab SQL** and uncheck the *âRemove multi-line comment (/.../) from SQL before sending to database"* option located in the lower portion of the window. See [https://sourceforge.net/p/squirrel-sql/bugs/1300](https://sourceforge.net/p/squirrel-sql/bugs/1300/)/ for more information. + ## Prerequisites * SQuirreL requires JRE 7
