[jira] [Closed] (OFBIZ-6582) SQL Exceptions (OPTION) occuring when running OFBiz 13.07.02 against MySQL

["Jacques Le Roux (JIRA)" <ji...@apache.org>]

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

Jacques Le Roux closed OFBIZ-6582.
----------------------------------
       Resolution: Fixed
    Fix Version/s: Upcoming Branch
                   13.07.03
                   12.04.06
                   14.12.01

Thanks Pierre, Morten for the report and Vyom Jain for the fix

Fixed in 
trunk r1697993  
R14.12 r1697994
R13.07 r1697995
R12.04 r1697996

This updates the "MySQL Connector/J" from 5.1.6 to 5.1.36 
This follows OFBIZ-4800 where the "MySQL Connector/J 5.1.6" was used. See 
    http://mvnrepository.com/artifact/mysql/mysql-connector-java/5.1.6 
and 
    https://dev.mysql.com/doc/relnotes/connector-j/en/news-5-1.html
for details


> SQL Exceptions (OPTION) occuring when running OFBiz 13.07.02 against MySQL
> --------------------------------------------------------------------------
>
>                 Key: OFBIZ-6582
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-6582
>             Project: OFBiz
>          Issue Type: Bug
>          Components: ALL COMPONENTS
>    Affects Versions: 13.07.02
>         Environment: Ubuntu 15.04 LTS Server x86_64
> Server version: 5.6.25-0ubuntu0.15.04.1 (Ubuntu)
> OFBiz 13.07.02
>            Reporter: Morten Jensen
>            Assignee: Pierre Smits
>             Fix For: 14.12.01, 12.04.06, 13.07.03, Upcoming Branch
>
>         Attachments: OFBIZ-6582-ivy.xml.patch, error.log, ofbiz.log
>
>
> Standard installation from installation documentation - before installing schema/data I reconfigured OFBiz to run against MySQL.
> Issue occurs for some SQL 
> statements during load of data and after start-up - but in this case the specific OPTION invoked is revealed as
> "SQL_SELECT_LIMIT=1" (or default - or whatever).
> A quick grep through the enclosed java code the only location I see the
> string "SQL_SELECT_LIMIT" is in an array in
> framework/entity/src/org/ofbiz/entity/model/ModelEntityChecker.java.
> Btw. for reference, I installed the mysql JDBC drivers as per the build
> documentation: ./ant download-mySQL-JDBC.
> Similar issue also occurs against MariaDB although error message is slightly different.
> More information on the issue here: http://ofbiz.135035.n4.nabble.com/OFBiz-MySQL-installation-Caused-by-java-sql-SQLException-Unknown-system-variable-OPTION-td4671579.html
> org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing
> the following:SELECT JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID,
> PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY,
> CURRENT_RETRY_COUNT, AUTH_USER_LOGIN_ID, RUN_AS_USER, RUNTIME_DATA_ID,
> RECURRENCE_INFO_ID, TEMP_EXPR_ID, CURRENT_RECURRENCE_COUNT,
> MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID, START_DATE_TIME,
> FINISH_DATE_TIME, CANCEL_DATE_TIME, JOB_RESULT, LAST_UPDATED_STAMP,
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM JOB_SANDBOX
> WHERE ((STATUS_ID = ? AND SERVICE_NAME = ?)) ORDER BY START_DATE_TIME DESC
> (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 'OPTION
> SQL_SELECT_LIMIT=1' at line 1)
> runtime/logs/error.log:Caused by:
> 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 'OPTION SQL_SELECT_LIMIT=1'
> at line 1



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