ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From BJ Freeman <bjfr33...@yahoo.com.INVALID>
Subject Re: OFBiz MySQL installation: Caused by: java.sql.SQLException: Unknown system variable 'OPTION'
Date Wed, 26 Aug 2015 18:13:28 GMT
it seems to originate in com.mysql.jdbc. which is a supplied driver for mysql.hopefully someone
that uses mysql has run into this or you might try the mysql forums
 


     On Wednesday, August 26, 2015 6:41 AM, Vyom Jain <vyom0213@gmail.com> wrote:
   

 ./ant download-mySQL-JDBC is downloading mysql-connector-java-5.1.6.jar
which is not compatible with your MySQL 5.6.25-0ubuntu0.15.04.1 (Ubuntu).
You should instead -
1. Stop OFBiz
2. Remove framework/entity/lib/jdbc/mysql-connector-java-5.1.6.jar
3. Download latest one (or one version prior) from
http://dev.mysql.com/downloads/connector/j/
4. Extract the jar file and place it in framework/entity/lib/jdbc/
5. Start OFBiz

Let me know if that helps.

--
Vyom

On 26 August 2015 at 18:37, Morten Jensen <morten@citizenme.com> wrote:

> Hi again,
>
> Ok, I bit the bullet and wiped MariaDB and instead installed MySQL server
> ("Server version: 5.6.25-0ubuntu0.15.04.1 (Ubuntu)") - also from standard
> Ubuntu packaging (apt-get). A very similar issue occurs for some SQL
> statements - 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. But
> then I probably don't have full source as I downloaded the "binary"
> distribution of OFBiz.
>
> Btw. for reference, I installed the mysql JDBC drivers as per the build
> documentation: ./ant download-mySQL-JDBC.
>
> 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
>
> Thanks in advance for your assistance.
>
> Best regards,
> Morten Jensen
>
>
>
> On Wed, Aug 26, 2015 at 8:42 AM, Morten Jensen <morten@citizenme.com>
> wrote:
>
> > Hi,
> >
> > I'm an OFBiz newbie but have managed to get through installation of OFBiz
> > version 13.07.02 with MySQL (MariaDB "Server version:
> > 10.0.20-MariaDB-0ubuntu0.15.04.1 (Ubuntu)"). However, I notice in the
> logs
> > errors for some queries:
> >
> > Caused by: java.sql.SQLException: Unknown system variable 'OPTION'
> >
> > I have included an example of the rather extensive logging that follows
> at
> > the bottom of this email. The problems have so far not directly caused
> > OFBiz to fail at frontend but I do see the errors occuring when I browse
> > some areas of the app (or even of its own in the background jobs) - for
> > instance when I enter Accounts Chart in Accounts.
> >
> > Does anyone know what is causing this problem? (At list in MariaDB) there
> > doesn't appear to be a system variable 'OPTION' but I'm not entirely
> > convinced that this error message isn't misleading?
> >
> > Thanks in advance for your assistance.
> >
> > Best regards,
> > Morten
> >
> >
> >
> > 2015-08-26 00:00:23,370 |OFBiz-JobQueue-0
> > |TransactionUtil              |W| [TransactionUtil.begin] active
> > transaction marked for rollback in place, so no transaction begun; this
> > stack trace shows when the exception began:
> > java.lang.Exception: Tx Stack Placeholder
> >    at
> >
> org.ofbiz.entity.transaction.TransactionUtil.setTransactionBeginStack(TransactionUtil.java:743)
> > ~[ofbiz-entity-test.jar:?]
> >    at
> >
> org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:169)
> > ~[ofbiz-entity-test.jar:?]
> >    at
> > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:314)
> > [ofbiz-service.jar:?]
> >    at
> > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:232)
> > [ofbiz-service.jar:?]
> >    at
> >
> org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:83)
> > [ofbiz-service.jar:?]
> >    at
> > org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:69)
> > [ofbiz-service.jar:?]
> >    at org.ofbiz.service.job.AbstractJob.run(AbstractJob.java:87)
> > [ofbiz-service.jar:?]
> >    at
> >
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> > [?:1.7.0_79]
> >    at
> >
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> > [?:1.7.0_79]
> >    at java.lang.Thread.run(Thread.java:745) [?:1.7.0_79]
> > 2015-08-26 00:00:23,370 |OFBiz-JobQueue-0
> > |GenericDelegator              |E| Failure in findOne operation for
> entity
> > [OrderHeader]: org.ofbiz.entity.transaction.GenericTransactionException:
> > The current transaction is marked for rollback, not beginning a new
> > transaction and aborting current operation; the rollbackOnly was caused
> by:
> > Failure in findByCondition operation for entity [JobSandbox]:
> > 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
> > (Unknown system variable 'OPTION'). Rolling back
> > transaction.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 (Unknown system variable 'OPTION') (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 (Unknown system variable 'OPTION')). Rolling back
> > transaction.
> > org.ofbiz.entity.transaction.GenericTransactionException: The current
> > transaction is marked for rollback, not beginning a new transaction and
> > aborting current operation; the rollbackOnly was caused by: Failure in
> > findByCondition operation for entity [JobSandbox]:
> > 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
> > (Unknown system variable 'OPTION'). Rolling back
> > transaction.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 (Unknown system variable 'OPTION') (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 (Unknown system variable 'OPTION'))
> >    at
> >
> org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:156)
> > ~[ofbiz-entity-test.jar:?]
> >    at
> >
> org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:124)
> > ~[ofbiz-entity-test.jar:?]
> >    at
> > org.ofbiz.entity.GenericDelegator.findOne(GenericDelegator.java:1500)
> > [ofbiz-entity-test.jar:?]
> >    at
> > org.ofbiz.order.order.OrderReadHelper.<init>(OrderReadHelper.java:132)
> > [ofbiz-order.jar:?]
> >    at
> >
> org.ofbiz.order.order.OrderServices.createAlsoBoughtProductAssocsForOrder(OrderServices.java:5800)
> > [ofbiz-order.jar:?]
> >    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > ~[?:1.7.0_79]
> >    at
> >
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> > ~[?:1.7.0_79]
> >    at
> >
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> > ~[?:1.7.0_79]
> >    at java.lang.reflect.Method.invoke(Method.java:606) ~[?:1.7.0_79]
> >    at
> >
> org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100)
> > [ofbiz-service.jar:?]
> >    at
> >
> org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57)
> > [ofbiz-service.jar:?]
> >    at
> > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:400)
> > [ofbiz-service.jar:?]
> >    at
> > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:232)
> > [ofbiz-service.jar:?]
> >    at
> >
> org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:83)
> > [ofbiz-service.jar:?]
> >    at
> >
> org.ofbiz.order.order.OrderServices.createAlsoBoughtProductAssocs(OrderServices.java:5788)
> > [ofbiz-order.jar:?]
> >    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > ~[?:1.7.0_79]
> >    at
> >
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> > ~[?:1.7.0_79]
> >    at
> >
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> > ~[?:1.7.0_79]
> >    at java.lang.reflect.Method.invoke(Method.java:606) ~[?:1.7.0_79]
> >    at
> >
> org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100)
> > [ofbiz-service.jar:?]
> >    at
> >
> org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57)
> > [ofbiz-service.jar:?]
> >    at
> > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:400)
> > [ofbiz-service.jar:?]
> >    at
> > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:232)
> > [ofbiz-service.jar:?]
> >    at
> >
> org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:83)
> > [ofbiz-service.jar:?]
> >    at
> > org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:69)
> > [ofbiz-service.jar:?]
> >    at org.ofbiz.service.job.AbstractJob.run(AbstractJob.java:87)
> > [ofbiz-service.jar:?]
> >    at
> >
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> > [?:1.7.0_79]
> >    at
> >
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> > [?:1.7.0_79]
> >    at java.lang.Thread.run(Thread.java:745) [?:1.7.0_79]
> > Caused by: 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 (Unknown system variable 'OPTION')
> >    at
> > org.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:391)
> > ~[ofbiz-entity-test.jar:?]
> >    at
> >
> org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:797)
> > ~[ofbiz-entity-test.jar:?]
> >    at
> >
> org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:145)
> > ~[ofbiz-entity-test.jar:?]
> >    at org.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1688)
> > ~[ofbiz-entity-test.jar:?]
> >    at
> > org.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1723)
> > ~[ofbiz-entity-test.jar:?]
> >    at
> >
> org.ofbiz.order.order.OrderServices.createAlsoBoughtProductAssocs(OrderServices.java:5728)
> > ~[ofbiz-order.jar:?]
> >    ... 14 more
> > Caused by: java.sql.SQLException: Unknown system variable 'OPTION'
> >    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
> > ~[mysql-connector-java-5.1.6.jar:?]
> >    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
> > ~[mysql-connector-java-5.1.6.jar:?]
> >    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
> > ~[mysql-connector-java-5.1.6.jar:?]
> >    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
> > ~[mysql-connector-java-5.1.6.jar:?]
> >    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
> > ~[mysql-connector-java-5.1.6.jar:?]
> >    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
> > ~[mysql-connector-java-5.1.6.jar:?]
> >    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)
> > ~[mysql-connector-java-5.1.6.jar:?]
> >    at
> >
> com.mysql.jdbc.StatementImpl.executeSimpleNonQuery(StatementImpl.java:1463)
> > ~[mysql-connector-java-5.1.6.jar:?]
> >    at
> >
> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1872)
> > ~[mysql-connector-java-5.1.6.jar:?]
> >    at
> >
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
> > ~[commons-dbcp-1.4.jar:1.4]
> >    at
> >
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
> > ~[commons-dbcp-1.4.jar:1.4]
> >    at
> > org.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:388)
> > ~[ofbiz-entity-test.jar:?]
> >    at
> >
> org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:797)
> > ~[ofbiz-entity-test.jar:?]
> >    at
> >
> org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:145)
> > ~[ofbiz-entity-test.jar:?]
> >    at org.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1688)
> > ~[ofbiz-entity-test.jar:?]
> >    at
> > org.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1723)
> > ~[ofbiz-entity-test.jar:?]
> >    at
> >
> org.ofbiz.order.order.OrderServices.createAlsoBoughtProductAssocs(OrderServices.java:5728)
> > ~[ofbiz-order.jar:?]
> >    ... 14 more
> > 2015-08-26 00:00:23,372 |OFBiz-JobQueue-0
> > |TransactionUtil              |I| [TransactionUtil.setRollbackOnly]
> > transaction rollback only not set, rollback only is already set.
> > 2015-08-26 00:00:23,372 |OFBiz-JobQueue-0
> > |OrderReadHelper              |E| Error finding order with ID
> [DEMO10090]:
> > org.ofbiz.entity.GenericEntityException:
> > org.ofbiz.entity.transaction.GenericTransactionException: The current
> > transaction is marked for rollback, not beginning a new transaction and
> > aborting current operation; the rollbackOnly was caused by: Failure in
> > findByCondition operation for entity [JobSandbox]:
> > 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
> > (Unknown system variable 'OPTION'). Rolling back
> > transaction.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 (Unknown system variable 'OPTION') (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 (Unknown system variable 'OPTION')) (The current
> > transaction is marked for rollback, not beginning a new transaction and
> > aborting current operation; the rollbackOnly was caused by: Failure in
> > findByCondition operation for entity [JobSandbox]:
> > 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
> > (Unknown system variable 'OPTION'). Rolling back
> > transaction.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 (Unknown system variable 'OPTION') (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 (Unknown system variable 'OPTION')))
> > org.ofbiz.entity.GenericEntityException:
> > org.ofbiz.entity.transaction.GenericTransactionException: The current
> > transaction is marked for rollback, not beginning a new transaction and
> > aborting current operation; the rollbackOnly was caused by: Failure in
> > findByCondition operation for entity [JobSandbox]:
> > 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
> > (Unknown system variable 'OPTION'). Rolling back
> > transaction.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 (Unknown system variable 'OPTION') (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 (Unknown system variable 'OPTION')) (The current
> > transaction is marked for rollback, not beginning a new transaction and
> > aborting current operation; the rollbackOnly was caused by: Failure in
> > findByCondition operation for entity [JobSandbox]:
> > 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
> > (Unknown system variable 'OPTION'). Rolling back
> > transaction.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 (Unknown system variable 'OPTION') (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 (Unknown system variable 'OPTION')))
> >    at
> > org.ofbiz.entity.GenericDelegator.findOne(GenericDelegator.java:1534)
> > ~[ofbiz-entity-test.jar:?]
> >    at
> > org.ofbiz.order.order.OrderReadHelper.<init>(OrderReadHelper.java:132)
> > [ofbiz-order.jar:?]
> >    at
> >
> org.ofbiz.order.order.OrderServices.createAlsoBoughtProductAssocsForOrder(OrderServices.java:5800)
> > [ofbiz-order.jar:?]
> >    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > ~[?:1.7.0_79]
> >    at
> >
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> > ~[?:1.7.0_79]
> >    at
> >
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> > ~[?:1.7.0_79]
> >    at java.lang.reflect.Method.invoke(Method.java:606) ~[?:1.7.0_79]
> >    at
> >
> org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100)
> > [ofbiz-service.jar:?]
> >    at
> >
> org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57)
> > [ofbiz-service.jar:?]
> >    at
> > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:400)
> > [ofbiz-service.jar:?]
> >    at
> > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:232)
> > [ofbiz-service.jar:?]
> >    at
> >
> org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:83)
> > [ofbiz-service.jar:?]
> >    at
> >
> org.ofbiz.order.order.OrderServices.createAlsoBoughtProductAssocs(OrderServices.java:5788)
> > [ofbiz-order.jar:?]
> >    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > ~[?:1.7.0_79]
> >    at
> >
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> > ~[?:1.7.0_79]
> >    at
> >
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> > ~[?:1.7.0_79]
> >    at java.lang.reflect.Method.invoke(Method.java:606) ~[?:1.7.0_79]
> >    at
> >
> org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100)
> > [ofbiz-service.jar:?]
> >    at
> >
> org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57)
> > [ofbiz-service.jar:?]
> >    at
> > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:400)
> > [ofbiz-service.jar:?]
> >    at
> > org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:232)
> > [ofbiz-service.jar:?]
> >    at
> >
> org.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:83)
> > [ofbiz-service.jar:?]
> >    at
> > org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:69)
> > [ofbiz-service.jar:?]
> >    at org.ofbiz.service.job.AbstractJob.run(AbstractJob.java:87)
> > [ofbiz-service.jar:?]
> >    at
> >
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> > [?:1.7.0_79]
> >    at
> >
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> > [?:1.7.0_79]
> >    at java.lang.Thread.run(Thread.java:745) [?:1.7.0_79]
> > Caused by: org.ofbiz.entity.transaction.GenericTransactionException: The
> > current transaction is marked for rollback, not beginning a new
> transaction
> > and aborting current operation; the rollbackOnly was caused by: Failure
> in
> > findByCondition operation for entity [JobSandbox]:
> > 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
> > (Unknown system variable 'OPTION'). Rolling back
> > transaction.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 (Unknown system variable 'OPTION') (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 (Unknown system variable 'OPTION'))
> >    at
> >
> org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:156)
> > ~[ofbiz-entity-test.jar:?]
> >    at
> >
> org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:124)
> > ~[ofbiz-entity-test.jar:?]
> >    at
> > org.ofbiz.entity.GenericDelegator.findOne(GenericDelegator.java:1500)
> > ~[ofbiz-entity-test.jar:?]
> >    ... 26 more
> > Caused by: 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 (Unknown system variable 'OPTION')
> >    at
> > org.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:391)
> > ~[ofbiz-entity-test.jar:?]
> >    at
> >
> org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:797)
> > ~[ofbiz-entity-test.jar:?]
> >    at
> >
> org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:145)
> > ~[ofbiz-entity-test.jar:?]
> >    at org.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1688)
> > ~[ofbiz-entity-test.jar:?]
> >    at
> > org.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1723)
> > ~[ofbiz-entity-test.jar:?]
> >    at
> >
> org.ofbiz.order.order.OrderServices.createAlsoBoughtProductAssocs(OrderServices.java:5728)
> > ~[ofbiz-order.jar:?]
> >    ... 14 more
> > Caused by: java.sql.SQLException: Unknown system variable 'OPTION'
> >    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
> > ~[mysql-connector-java-5.1.6.jar:?]
> >    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
> > ~[mysql-connector-java-5.1.6.jar:?]
> >    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
> > ~[mysql-connector-java-5.1.6.jar:?]
> >    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
> > ~[mysql-connector-java-5.1.6.jar:?]
> >    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
> > ~[mysql-connector-java-5.1.6.jar:?]
> >    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
> > ~[mysql-connector-java-5.1.6.jar:?]
> >    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)
> > ~[mysql-connector-java-5.1.6.jar:?]
> >    at
> >
> com.mysql.jdbc.StatementImpl.executeSimpleNonQuery(StatementImpl.java:1463)
> > ~[mysql-connector-java-5.1.6.jar:?]
> >    at
> >
> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1872)
> > ~[mysql-connector-java-5.1.6.jar:?]
> >    at
> >
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
> > ~[commons-dbcp-1.4.jar:1.4]
> >    at
> >
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
> > ~[commons-dbcp-1.4.jar:1.4]
> >    at
> > org.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:388)
> > ~[ofbiz-entity-test.jar:?]
> >    at
> >
> org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:797)
> > ~[ofbiz-entity-test.jar:?]
> >    at
> >
> org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:145)
> > ~[ofbiz-entity-test.jar:?]
> >    at org.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1688)
> > ~[ofbiz-entity-test.jar:?]
> >    at
> > org.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1723)
> > ~[ofbiz-entity-test.jar:?]
> >    at
> >
> org.ofbiz.order.order.OrderServices.createAlsoBoughtProductAssocs(OrderServices.java:5728)
> > ~[ofbiz-order.jar:?]
> >    ... 14 more
> > 2015-08-26 00:00:23,373 |OFBiz-JobQueue-0
> > |ServiceDispatcher            |T| [[Sync service failed...-
> > total:0.0,since last(Begin):0.0]] - 'default /
> > createAlsoBoughtProductAssocsForOrder'
> > 2015-08-26 00:00:23,373 |OFBiz-JobQueue-0
> > |TransactionUtil              |I| [TransactionUtil.setRollbackOnly]
> > transaction rollback only not set, rollback only is already set.
> > 2015-08-26 00:00:23,373 |OFBiz-JobQueue-0
> > |OrderServices                |E| null
> >
> >
> >
> >
>


  
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message