[jira] [Resolved] (SQOOP-2928) Sqoop2: Fix MySQL repository creation

["Szabolcs Vasas (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/SQOOP-2928?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Szabolcs Vasas resolved SQOOP-2928.
-----------------------------------
    Resolution: Not A Problem

The database create and upgrade scripts work fine on MySQL you just have to specify the Database Hostname field in CM the following way:

mysql.server?sessionVariables=sql_mode='ANSI_QUOTES'

> Sqoop2: Fix MySQL repository creation
> -------------------------------------
>
>                 Key: SQOOP-2928
>                 URL: https://issues.apache.org/jira/browse/SQOOP-2928
>             Project: Sqoop
>          Issue Type: Bug
>    Affects Versions: 1.99.6
>            Reporter: Szabolcs Vasas
>            Assignee: Szabolcs Vasas
>              Labels: newbie
>
> Currently the MySQL repository creation/update fails with the following error:
> Can't execute query: CREATE DATABASE IF NOT EXISTS"SQOOP"
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"SQOOP"' at line 1
> MySQL uses the nonstandard ` (backtick) character instead of " to quote system identifiers so the database creation command constant has to be fixed.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)