Ofbiz with MS SQL

[Katie Qiu-2]

Hi,

 

I'm trying to connect MS SQL server to Ofbiz.  Below is the
entityengine.xml. I have followed the Export/Import steps as indicated in
the instructions. I can see the exported files, which I saved on my PC (so I
think that works fine), but I after I imported them, I don't see any tables
being created in MSSQL (I assume that is what would happen).

 

When running OfBiz Application, I got the following error message below
(below the entityengine.xml). Since it indicates trying to insert records,
so I assume at this point the database connection is good, but I don't see
any tables created under database ofbiz, ofbizolap, and ofbiztenant.

 

Thank you in advance

Katie

 

<entity-config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

 
xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/entity-config.xs
d">

    <resource-loader name="fieldfile"
class="org.apache.ofbiz.base.config.FileLoader"

            prepend-env="ofbiz.home" prefix="/framework/entity/fieldtype/"/>

 

    <!-- the transaction factory class to use, one is needed for each way of
getting JTA interfaces -->

    <!-- Use this one for Geronimo -->

    <transaction-factory
class="org.apache.ofbiz.entity.transaction.GeronimoTransactionFactory"/>

 

    <!-- the connection factory class to use, one is needed for obtaining
connections/pools for defined resources -->

    <connection-factory
class="org.apache.ofbiz.entity.connection.DBCPConnectionFactory"/>

 

    <debug-xa-resources value="false" />  <!-- see
https://issues.apache.org/jira/browse/OFBIZ-4282 for more -->

   

    <delegator name="default" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main"
distributed-cache-clear-enabled="false">

        <group-map group-name="org.apache.ofbiz"
datasource-name="localmssql"/>

        <group-map group-name="org.apache.ofbiz.olap"
datasource-name="localmssqlolap"/>

        <group-map group-name="org.apache.ofbiz.tenant"
datasource-name="localmssqltenant"/>

    </delegator>

    <!-- May be used when you create a service that manages many data for
massive imports, this for performance reason or to escape functional cases
-->

    <delegator name="default-no-eca" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main"
entity-eca-enabled="false" distributed-cache-clear-enabled="false">

        <group-map group-name="org.apache.ofbiz"
datasource-name="localmssql"/>

        <group-map group-name="org.apache.ofbiz.olap"
datasource-name="localmssqlolap"/>

        <group-map group-name="org.apache.ofbiz.tenant"
datasource-name="localmssqltenant"/>

    </delegator>

 

    <!-- Be sure that your default delegator (or the one you use) uses the
same datasource for test. You must run "gradlew loadAll" before running
"gradlew testIntegration" -->

    <delegator name="test" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main">

        <group-map group-name="org.apache.ofbiz"
datasource-name="localmssql"/>

        <group-map group-name="org.apache.ofbiz.olap"
datasource-name="localmssqlolap"/>

        <group-map group-name="org.apache.ofbiz.tenant"
datasource-name="localmssqltenant"/>

    </delegator>

   

    <!-- need to at least define a name for each component to use -->

    <entity-model-reader name="main"/>

 

    <!-- need to at least define a name for each component to use -->

    <entity-group-reader name="main"/>

 

    <!-- need to at least define a name for each component to use -->

    <entity-eca-reader name="main"/>

 

   

    <entity-data-reader name="tenant"/>

    <entity-data-reader name="seed"/>

    <entity-data-reader name="seed-initial"/>

    <entity-data-reader name="demo"/>

    <entity-data-reader name="ext"/>

    <entity-data-reader name="ext-test"/>

    <entity-data-reader name="ext-demo"/>

 

    <field-type name="hsql" loader="fieldfile"
location="fieldtypehsql.xml"/>

    <field-type name="derby" loader="fieldfile"
location="fieldtypederby.xml"/>

    <field-type name="daffodil" loader="fieldfile"
location="fieldtypedaffodil.xml"/>

    <field-type name="axion" loader="fieldfile"
location="fieldtypeaxion.xml"/>

    <field-type name="mysql" loader="fieldfile"
location="fieldtypemysql.xml"/>

    <field-type name="postgres" loader="fieldfile"
location="fieldtypepostgres.xml"/>

    <field-type name="oracle" loader="fieldfile"
location="fieldtypeoracle.xml"/>

    <field-type name="sapdb" loader="fieldfile"
location="fieldtypesapdb.xml"/>

    <field-type name="sybase" loader="fieldfile"
location="fieldtypesybase.xml"/>

    <field-type name="firebird" loader="fieldfile"
location="fieldtypefirebird.xml"/>

    <field-type name="mssql" loader="fieldfile"
location="fieldtypemssql.xml"/>

    <field-type name="advantage" loader="fieldfile"
location="fieldtypeadvantage.xml"/>

   

   

   

    <datasource name="localmssql"

 
helper-class="org.apache.ofbiz.entity.datasource.GenericHelperDAO"

            schema-name="dbo"

            field-type-name="mssql"

            check-on-start="true"

            add-missing-on-start="true"

            join-style="ansi"

            alias-view-columns="false"

            use-fk-initially-deferred="false">

        <read-data reader-name="tenant"/>

        <read-data reader-name="seed"/>

        <read-data reader-name="seed-initial"/>

        <read-data reader-name="demo"/>

        <read-data reader-name="ext"/>

        <read-data reader-name="ext-test"/>

        <read-data reader-name="ext-demo"/>

        <inline-jdbc

                jdbc-driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"

 
jdbc-uri="jdbc:sqlserver://localhost:1433;databaseName=ofbiz;SelectMethod=cu
rsor;"

                jdbc-username="ofbiz"

                jdbc-password="ofbiz"

                isolation-level="ReadCommitted"

                pool-minsize="2"

                pool-maxsize="250"

                time-between-eviction-runs-millis="600000"/>

        <!-- <jndi-jdbc jndi-server-name="default"
jndi-name="comp/env/jdbc/xa/localmssql" isolation-level="ReadCommitted"/>
--> <!-- Orion Style JNDI name -->

    </datasource>

 

    <datasource name="localmssqlolap"

 
helper-class="org.apache.ofbiz.entity.datasource.GenericHelperDAO"

            schema-name="dbo"

            field-type-name="mssql"

            check-on-start="true"

            add-missing-on-start="true"

            join-style="ansi"

            alias-view-columns="false"

            use-fk-initially-deferred="false">

        <read-data reader-name="tenant"/>

        <read-data reader-name="seed"/>

        <read-data reader-name="seed-initial"/>

        <read-data reader-name="demo"/>

        <read-data reader-name="ext"/>

        <read-data reader-name="ext-test"/>

        <read-data reader-name="ext-demo"/>

        <inline-jdbc

                jdbc-driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"

 
jdbc-uri="jdbc:sqlserver://localhost:1791;databaseName=ofbizolap;SelectMetho
d=cursor;"

                jdbc-username="ofbiz"

                jdbc-password="ofbiz"

                isolation-level="ReadCommitted"

                pool-minsize="2"

                pool-maxsize="250"

                time-between-eviction-runs-millis="600000"/>

        <!-- <jndi-jdbc jndi-server-name="default"
jndi-name="comp/env/jdbc/xa/localmssql" isolation-level="ReadCommitted"/>
--> <!-- Orion Style JNDI name -->

    </datasource>

   

    <datasource name="localmssqltenant"

 
helper-class="org.apache.ofbiz.entity.datasource.GenericHelperDAO"

            schema-name="dbo"

            field-type-name="mssql"

            check-on-start="true"

            add-missing-on-start="true"

            join-style="ansi"

            alias-view-columns="false"

            use-fk-initially-deferred="false">

        <read-data reader-name="tenant"/>

        <read-data reader-name="seed"/>

        <read-data reader-name="seed-initial"/>

        <read-data reader-name="demo"/>

        <read-data reader-name="ext"/>

        <read-data reader-name="ext-test"/>

        <read-data reader-name="ext-demo"/>

        <inline-jdbc

                jdbc-driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"

 
jdbc-uri="jdbc:sqlserver://localhost:1791;databaseName=ofbiztenant;SelectMet
hod=cursor;"

                jdbc-username="ofbiz"

                jdbc-password="ofbiz"

                isolation-level="ReadCommitted"

                pool-minsize="2"

                pool-maxsize="250"

                time-between-eviction-runs-millis="600000"/>

        <!-- <jndi-jdbc jndi-server-name="default"
jndi-name="comp/env/jdbc/xa/localmssql" isolation-level="ReadCommitted"/>
--> <!-- Orion Style JNDI name -->

    </datasource>

   

</entity-config>

 

 

 

 

 

java.lang.Exception: rollback called in Entity Engine SQLProcessor

       at
org.apache.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(Transact
ionUtil.java:359) [main/:?]

       at
org.apache.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:185)
[main/:?]

       at
org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:112)
[main/:?]

       at
org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.
java:65) [main/:?]

       at
org.apache.ofbiz.entity.GenericDelegator.createSetNextSeqId(GenericDelegator
.java:792) [main/:?]

       at
org.apache.ofbiz.service.job.JobManager.reloadCrashedJobs(JobManager.java:33
8) [main/:?]

       at
org.apache.ofbiz.service.job.JobPoller$JobManagerPoller.run(JobPoller.java:2
29) [main/:?]

       at java.lang.Thread.run(Thread.java:844) [?:?]

2021-04-20 18:42:48,734 |OFBiz-JobPoller      |hile enrolled in a
transaction|E| null

java.sql.SQLException: Commit can not be set while enrolled in a transaction

       at
org.apache.commons.dbcp2.managed.ManagedConnection.commit(ManagedConnection.
java:232) ~[commons-dbcp2-2.1.1.jar:2.1.1]

       at
org.apache.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:155)
[main/:?]

       at
org.apache.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:207)
[main/:?]

       at
org.apache.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:467)
[main/:?]

       at
org.apache.ofbiz.entity.datasource.GenericHelperDAO.findByPrimaryKey(Generic
HelperDAO.java:80) [main/:?]

       at
org.apache.ofbiz.entity.GenericDelegator.createSetNextSeqId(GenericDelegator
.java:803) [main/:?]

       at
org.apache.ofbiz.service.job.JobManager.reloadCrashedJobs(JobManager.java:33
8) [main/:?]

       at
org.apache.ofbiz.service.job.JobPoller$JobManagerPoller.run(JobPoller.java:2
29) [main/:?]

       at java.lang.Thread.run(Thread.java:844) [?:?]

2021-04-20 18:42:48,735 |OFBiz-JobPoller      |SQLProcessor
|W| [SQLProcessor.rollback]: SQL Exception while rolling back insert. Error
was:java.sql.SQLException: Commit can not be set while enrolled in a
transaction

2021-04-20 18:42:48,735 |OFBiz-JobPoller      |SQLProcessor
|W| null

java.sql.SQLException: Commit can not be set while enrolled in a transaction

       at
org.apache.commons.dbcp2.managed.ManagedConnection.rollback(ManagedConnectio
n.java:240) ~[commons-dbcp2-2.1.1.jar:2.1.1]

       at
org.apache.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:181)
[main/:?]

       at
org.apache.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:160)
[main/:?]

       at
org.apache.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:207)
[main/:?]

       at
org.apache.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:467)
[main/:?]

       at
org.apache.ofbiz.entity.datasource.GenericHelperDAO.findByPrimaryKey(Generic
HelperDAO.java:80) [main/:?]

       at
org.apache.ofbiz.entity.GenericDelegator.createSetNextSeqId(GenericDelegator
.java:803) [main/:?]

       at
org.apache.ofbiz.service.job.JobManager.reloadCrashedJobs(JobManager.java:33
8) [main/:?]

       at
org.apache.ofbiz.service.job.JobPoller$JobManagerPoller.run(JobPoller.java:2
29) [main/:?]

       at java.lang.Thread.run(Thread.java:844) [?:?]

2021-04-20 18:42:48,738 |OFBiz-JobPoller      |GenericDelegator
|E| Failure in createSetNextSeqId operation for entity [JobSandbox]:
org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:JobSandbox][authUserLoginId,null()][cancelDateTime,2021-04-18
13:53:02.103(java.sql.Timestamp)][createdStamp,2021-04-20
18:42:48.176(java.sql.Timestamp)][createdTxStamp,2021-04-20
18:42:48.176(java.sql.Timestamp)][currentRecurrenceCount,null()][currentRetr
yCount,0(java.lang.Long)][finishDateTime,2021-04-17
23:29:09.898(java.sql.Timestamp)][jobId,10300(java.lang.String)][jobName,Sen
d Email(java.lang.String)][jobResult,null()][lastUpdatedStamp,2021-04-20
18:42:48.176(java.sql.Timestamp)][lastUpdatedTxStamp,2021-04-20
18:42:48.176(java.sql.Timestamp)][loaderName,null()][maxRecurrenceCount,-1(j
ava.lang.Long)][maxRetry,null()][parentJobId,SENDEMAIL(java.lang.String)][po
olId,pool(java.lang.String)][previousJobId,10123(java.lang.String)][recurren
ceInfoId,null()][runAsUser,system(java.lang.String)][runByInstanceId,null()]
[runTime,2021-04-20
18:42:47.995(java.sql.Timestamp)][runtimeDataId,null()][serviceName,sendEmai
lDated(java.lang.String)][startDateTime,null()][statusId,SERVICE_PENDING(jav
a.lang.String)][tempExprId,null()] (SQL Exception while executing the
following:INSERT INTO OFBIZ.JOB_SANDBOX (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)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?) (The statement was aborted because it would have caused a
duplicate key value in a unique or primary key constraint or unique index
identified by 'SQL210415135036970' defined on 'JOB_SANDBOX'.)). Rolling back
transaction.

org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:JobSandbox][authUserLoginId,null()][cancelDateTime,2021-04-18
13:53:02.103(java.sql.Timestamp)][createdStamp,2021-04-20
18:42:48.176(java.sql.Timestamp)][createdTxStamp,2021-04-20
18:42:48.176(java.sql.Timestamp)][currentRecurrenceCount,null()][currentRetr
yCount,0(java.lang.Long)][finishDateTime,2021-04-17
23:29:09.898(java.sql.Timestamp)][jobId,10300(java.lang.String)][jobName,Sen
d Email(java.lang.String)][jobResult,null()][lastUpdatedStamp,2021-04-20
18:42:48.176(java.sql.Timestamp)][lastUpdatedTxStamp,2021-04-20
18:42:48.176(java.sql.Timestamp)][loaderName,null()][maxRecurrenceCount,-1(j
ava.lang.Long)][maxRetry,null()][parentJobId,SENDEMAIL(java.lang.String)][po
olId,pool(java.lang.String)][previousJobId,10123(java.lang.String)][recurren
ceInfoId,null()][runAsUser,system(java.lang.String)][runByInstanceId,null()]
[runTime,2021-04-20
18:42:47.995(java.sql.Timestamp)][runtimeDataId,null()][serviceName,sendEmai
lDated(java.lang.String)][startDateTime,null()][statusId,SERVICE_PENDING(jav
a.lang.String)][tempExprId,null()] (SQL Exception while executing the
following:INSERT INTO OFBIZ.JOB_SANDBOX (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)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?) (The statement was aborted because it would have caused a
duplicate key value in a unique or primary key constraint or unique index
identified by 'SQL210415135036970' defined on 'JOB_SANDBOX'.))

       at
org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:1
72) ~[main/:?]

       at
org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:110)
~[main/:?]

       at
org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.
java:65) ~[main/:?]

       at
org.apache.ofbiz.entity.GenericDelegator.createSetNextSeqId(GenericDelegator
.java:792) [main/:?]

       at
org.apache.ofbiz.service.job.JobManager.reloadCrashedJobs(JobManager.java:33
8) [main/:?]

       at
org.apache.ofbiz.service.job.JobPoller$JobManagerPoller.run(JobPoller.java:2
29) [main/:?]

       at java.lang.Thread.run(Thread.java:844) [?:?]

Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception
while executing the following:INSERT INTO OFBIZ.JOB_SANDBOX (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) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (The statement was aborted because it would
have caused a duplicate key value in a unique or primary key constraint or
unique index identified by 'SQL210415135036970' defined on 'JOB_SANDBOX'.)

       at
org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:43
5) ~[main/:?]

       at
org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:1
67) ~[main/:?]

       ... 6 more

Caused by:
org.apache.derby.shared.common.error.DerbySQLIntegrityConstraintViolationExc
eption: The statement was aborted because it would have caused a duplicate
key value in a unique or primary key constraint or unique index identified
by 'SQL210415135036970' defined on 'JOB_SANDBOX'.

       at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknow
n Source) ~[derby-10.14.1.0.jar:?]

       at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(Delegatin
gPreparedStatement.java:98) ~[commons-dbcp2-2.1.1.jar:2.1.1]

       at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(Delegatin
gPreparedStatement.java:98) ~[commons-dbcp2-2.1.1.jar:2.1.1]

       at
org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:43
1) ~[main/:?]

       at
org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:1
67) ~[main/:?]

       ... 6 more

Caused by: org.apache.derby.iapi.error.StandardException: The statement was
aborted because it would have caused a duplicate key value in a unique or
primary key constraint or unique index identified by 'SQL210415135036970'
defined on 'JOB_SANDBOX'.

       at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at
org.apache.derby.impl.sql.execute.IndexChanger.insertAndCheckDups(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at org.apache.derby.impl.sql.execute.IndexChanger.doInsert(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at org.apache.derby.impl.sql.execute.IndexChanger.insert(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at org.apache.derby.impl.sql.execute.IndexSetChanger.insert(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at
org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at
org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(Delegatin
gPreparedStatement.java:98) ~[commons-dbcp2-2.1.1.jar:2.1.1]

       at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(Delegatin
gPreparedStatement.java:98) ~[commons-dbcp2-2.1.1.jar:2.1.1]

       at
org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:43
1) ~[main/:?]

       at
org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:1
67) ~[main/:?]

       ... 6 more

[Katie Qiu-2]

Hi,

An update on the issue: I have finally figured out the problem and are able
to connect ofbiz with mssql now. I basically changed the following 2 things:

1. I changed the db connection link from what's indicated in my previous
email to
uri="jdbc:sqlserver://127.0.0.1:1433;databaseName=ofbiz;SelectMethod=cursor;

2. I deleted the users I had created earlier and recreated them in SQL
Server Management Studio


Thanks
Katie

-----Original Message-----
From: Katie Qiu [mailto:[hidden email]]
Sent: Tuesday, April 20, 2021 7:50 PM
To: [hidden email]
Subject: Ofbiz with MS SQL

Hi,

 

I'm trying to connect MS SQL server to Ofbiz.  Below is the
entityengine.xml. I have followed the Export/Import steps as indicated in
the instructions. I can see the exported files, which I saved on my PC (so I
think that works fine), but I after I imported them, I don't see any tables
being created in MSSQL (I assume that is what would happen).

 

When running OfBiz Application, I got the following error message below
(below the entityengine.xml). Since it indicates trying to insert records,
so I assume at this point the database connection is good, but I don't see
any tables created under database ofbiz, ofbizolap, and ofbiztenant.

 

Thank you in advance

Katie

 

<entity-config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

 
xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/entity-config.xs
d">

    <resource-loader name="fieldfile"
class="org.apache.ofbiz.base.config.FileLoader"

            prepend-env="ofbiz.home" prefix="/framework/entity/fieldtype/"/>

 

    <!-- the transaction factory class to use, one is needed for each way of
getting JTA interfaces -->

    <!-- Use this one for Geronimo -->

    <transaction-factory
class="org.apache.ofbiz.entity.transaction.GeronimoTransactionFactory"/>

 

    <!-- the connection factory class to use, one is needed for obtaining
connections/pools for defined resources -->

    <connection-factory
class="org.apache.ofbiz.entity.connection.DBCPConnectionFactory"/>

 

    <debug-xa-resources value="false" />  <!-- see
https://issues.apache.org/jira/browse/OFBIZ-4282 for more -->

   

    <delegator name="default" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main"
distributed-cache-clear-enabled="false">

        <group-map group-name="org.apache.ofbiz"
datasource-name="localmssql"/>

        <group-map group-name="org.apache.ofbiz.olap"
datasource-name="localmssqlolap"/>

        <group-map group-name="org.apache.ofbiz.tenant"
datasource-name="localmssqltenant"/>

    </delegator>

    <!-- May be used when you create a service that manages many data for
massive imports, this for performance reason or to escape functional cases
-->

    <delegator name="default-no-eca" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main"
entity-eca-enabled="false" distributed-cache-clear-enabled="false">

        <group-map group-name="org.apache.ofbiz"
datasource-name="localmssql"/>

        <group-map group-name="org.apache.ofbiz.olap"
datasource-name="localmssqlolap"/>

        <group-map group-name="org.apache.ofbiz.tenant"
datasource-name="localmssqltenant"/>

    </delegator>

 

    <!-- Be sure that your default delegator (or the one you use) uses the
same datasource for test. You must run "gradlew loadAll" before running
"gradlew testIntegration" -->

    <delegator name="test" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main">

        <group-map group-name="org.apache.ofbiz"
datasource-name="localmssql"/>

        <group-map group-name="org.apache.ofbiz.olap"
datasource-name="localmssqlolap"/>

        <group-map group-name="org.apache.ofbiz.tenant"
datasource-name="localmssqltenant"/>

    </delegator>

   

    <!-- need to at least define a name for each component to use -->

    <entity-model-reader name="main"/>

 

    <!-- need to at least define a name for each component to use -->

    <entity-group-reader name="main"/>

 

    <!-- need to at least define a name for each component to use -->

    <entity-eca-reader name="main"/>

 

   

    <entity-data-reader name="tenant"/>

    <entity-data-reader name="seed"/>

    <entity-data-reader name="seed-initial"/>

    <entity-data-reader name="demo"/>

    <entity-data-reader name="ext"/>

    <entity-data-reader name="ext-test"/>

    <entity-data-reader name="ext-demo"/>

 

    <field-type name="hsql" loader="fieldfile"
location="fieldtypehsql.xml"/>

    <field-type name="derby" loader="fieldfile"
location="fieldtypederby.xml"/>

    <field-type name="daffodil" loader="fieldfile"
location="fieldtypedaffodil.xml"/>

    <field-type name="axion" loader="fieldfile"
location="fieldtypeaxion.xml"/>

    <field-type name="mysql" loader="fieldfile"
location="fieldtypemysql.xml"/>

    <field-type name="postgres" loader="fieldfile"
location="fieldtypepostgres.xml"/>

    <field-type name="oracle" loader="fieldfile"
location="fieldtypeoracle.xml"/>

    <field-type name="sapdb" loader="fieldfile"
location="fieldtypesapdb.xml"/>

    <field-type name="sybase" loader="fieldfile"
location="fieldtypesybase.xml"/>

    <field-type name="firebird" loader="fieldfile"
location="fieldtypefirebird.xml"/>

    <field-type name="mssql" loader="fieldfile"
location="fieldtypemssql.xml"/>

    <field-type name="advantage" loader="fieldfile"
location="fieldtypeadvantage.xml"/>

   

   

   

    <datasource name="localmssql"

 
helper-class="org.apache.ofbiz.entity.datasource.GenericHelperDAO"

            schema-name="dbo"

            field-type-name="mssql"

            check-on-start="true"

            add-missing-on-start="true"

            join-style="ansi"

            alias-view-columns="false"

            use-fk-initially-deferred="false">

        <read-data reader-name="tenant"/>

        <read-data reader-name="seed"/>

        <read-data reader-name="seed-initial"/>

        <read-data reader-name="demo"/>

        <read-data reader-name="ext"/>

        <read-data reader-name="ext-test"/>

        <read-data reader-name="ext-demo"/>

        <inline-jdbc

                jdbc-driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"

 
jdbc-uri="jdbc:sqlserver://localhost:1433;databaseName=ofbiz;SelectMethod=cu
rsor;"

                jdbc-username="ofbiz"

                jdbc-password="ofbiz"

                isolation-level="ReadCommitted"

                pool-minsize="2"

                pool-maxsize="250"

                time-between-eviction-runs-millis="600000"/>

        <!-- <jndi-jdbc jndi-server-name="default"
jndi-name="comp/env/jdbc/xa/localmssql" isolation-level="ReadCommitted"/>
--> <!-- Orion Style JNDI name -->

    </datasource>

 

    <datasource name="localmssqlolap"

 
helper-class="org.apache.ofbiz.entity.datasource.GenericHelperDAO"

            schema-name="dbo"

            field-type-name="mssql"

            check-on-start="true"

            add-missing-on-start="true"

            join-style="ansi"

            alias-view-columns="false"

            use-fk-initially-deferred="false">

        <read-data reader-name="tenant"/>

        <read-data reader-name="seed"/>

        <read-data reader-name="seed-initial"/>

        <read-data reader-name="demo"/>

        <read-data reader-name="ext"/>

        <read-data reader-name="ext-test"/>

        <read-data reader-name="ext-demo"/>

        <inline-jdbc

                jdbc-driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"

 
jdbc-uri="jdbc:sqlserver://localhost:1791;databaseName=ofbizolap;SelectMetho
d=cursor;"

                jdbc-username="ofbiz"

                jdbc-password="ofbiz"

                isolation-level="ReadCommitted"

                pool-minsize="2"

                pool-maxsize="250"

                time-between-eviction-runs-millis="600000"/>

        <!-- <jndi-jdbc jndi-server-name="default"
jndi-name="comp/env/jdbc/xa/localmssql" isolation-level="ReadCommitted"/>
--> <!-- Orion Style JNDI name -->

    </datasource>

   

    <datasource name="localmssqltenant"

 
helper-class="org.apache.ofbiz.entity.datasource.GenericHelperDAO"

            schema-name="dbo"

            field-type-name="mssql"

            check-on-start="true"

            add-missing-on-start="true"

            join-style="ansi"

            alias-view-columns="false"

            use-fk-initially-deferred="false">

        <read-data reader-name="tenant"/>

        <read-data reader-name="seed"/>

        <read-data reader-name="seed-initial"/>

        <read-data reader-name="demo"/>

        <read-data reader-name="ext"/>

        <read-data reader-name="ext-test"/>

        <read-data reader-name="ext-demo"/>

        <inline-jdbc

                jdbc-driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"

 
jdbc-uri="jdbc:sqlserver://localhost:1791;databaseName=ofbiztenant;SelectMet
hod=cursor;"

                jdbc-username="ofbiz"

                jdbc-password="ofbiz"

                isolation-level="ReadCommitted"

                pool-minsize="2"

                pool-maxsize="250"

                time-between-eviction-runs-millis="600000"/>

        <!-- <jndi-jdbc jndi-server-name="default"
jndi-name="comp/env/jdbc/xa/localmssql" isolation-level="ReadCommitted"/>
--> <!-- Orion Style JNDI name -->

    </datasource>

   

</entity-config>

 

 

 

 

 

java.lang.Exception: rollback called in Entity Engine SQLProcessor

       at
org.apache.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(Transact
ionUtil.java:359) [main/:?]

       at
org.apache.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:185)
[main/:?]

       at
org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:112)
[main/:?]

       at
org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.
java:65) [main/:?]

       at
org.apache.ofbiz.entity.GenericDelegator.createSetNextSeqId(GenericDelegator
.java:792) [main/:?]

       at
org.apache.ofbiz.service.job.JobManager.reloadCrashedJobs(JobManager.java:33
8) [main/:?]

       at
org.apache.ofbiz.service.job.JobPoller$JobManagerPoller.run(JobPoller.java:2
29) [main/:?]

       at java.lang.Thread.run(Thread.java:844) [?:?]

2021-04-20 18:42:48,734 |OFBiz-JobPoller      |hile enrolled in a
transaction|E| null

java.sql.SQLException: Commit can not be set while enrolled in a transaction

       at
org.apache.commons.dbcp2.managed.ManagedConnection.commit(ManagedConnection.
java:232) ~[commons-dbcp2-2.1.1.jar:2.1.1]

       at
org.apache.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:155)
[main/:?]

       at
org.apache.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:207)
[main/:?]

       at
org.apache.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:467)
[main/:?]

       at
org.apache.ofbiz.entity.datasource.GenericHelperDAO.findByPrimaryKey(Generic
HelperDAO.java:80) [main/:?]

       at
org.apache.ofbiz.entity.GenericDelegator.createSetNextSeqId(GenericDelegator
.java:803) [main/:?]

       at
org.apache.ofbiz.service.job.JobManager.reloadCrashedJobs(JobManager.java:33
8) [main/:?]

       at
org.apache.ofbiz.service.job.JobPoller$JobManagerPoller.run(JobPoller.java:2
29) [main/:?]

       at java.lang.Thread.run(Thread.java:844) [?:?]

2021-04-20 18:42:48,735 |OFBiz-JobPoller      |SQLProcessor
|W| [SQLProcessor.rollback]: SQL Exception while rolling back insert.
|W| Error
was:java.sql.SQLException: Commit can not be set while enrolled in a
transaction

2021-04-20 18:42:48,735 |OFBiz-JobPoller      |SQLProcessor
|W| null

java.sql.SQLException: Commit can not be set while enrolled in a transaction

       at
org.apache.commons.dbcp2.managed.ManagedConnection.rollback(ManagedConnectio
n.java:240) ~[commons-dbcp2-2.1.1.jar:2.1.1]

       at
org.apache.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:181)
[main/:?]

       at
org.apache.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:160)
[main/:?]

       at
org.apache.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:207)
[main/:?]

       at
org.apache.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:467)
[main/:?]

       at
org.apache.ofbiz.entity.datasource.GenericHelperDAO.findByPrimaryKey(Generic
HelperDAO.java:80) [main/:?]

       at
org.apache.ofbiz.entity.GenericDelegator.createSetNextSeqId(GenericDelegator
.java:803) [main/:?]

       at
org.apache.ofbiz.service.job.JobManager.reloadCrashedJobs(JobManager.java:33
8) [main/:?]

       at
org.apache.ofbiz.service.job.JobPoller$JobManagerPoller.run(JobPoller.java:2
29) [main/:?]

       at java.lang.Thread.run(Thread.java:844) [?:?]

2021-04-20 18:42:48,738 |OFBiz-JobPoller      |GenericDelegator
|E| Failure in createSetNextSeqId operation for entity [JobSandbox]:
org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:JobSandbox][authUserLoginId,null()][cancelDateTime,2021-04-18
13:53:02.103(java.sql.Timestamp)][createdStamp,2021-04-20
18:42:48.176(java.sql.Timestamp)][createdTxStamp,2021-04-20
18:42:48.176(java.sql.Timestamp)][currentRecurrenceCount,null()][currentRetr
yCount,0(java.lang.Long)][finishDateTime,2021-04-17
23:29:09.898(java.sql.Timestamp)][jobId,10300(java.lang.String)][jobName,Sen
d Email(java.lang.String)][jobResult,null()][lastUpdatedStamp,2021-04-20
18:42:48.176(java.sql.Timestamp)][lastUpdatedTxStamp,2021-04-20
18:42:48.176(java.sql.Timestamp)][loaderName,null()][maxRecurrenceCount,-1(j
ava.lang.Long)][maxRetry,null()][parentJobId,SENDEMAIL(java.lang.String)][po
olId,pool(java.lang.String)][previousJobId,10123(java.lang.String)][recurren
ceInfoId,null()][runAsUser,system(java.lang.String)][runByInstanceId,null()]
[runTime,2021-04-20
18:42:47.995(java.sql.Timestamp)][runtimeDataId,null()][serviceName,sendEmai
lDated(java.lang.String)][startDateTime,null()][statusId,SERVICE_PENDING(jav
a.lang.String)][tempExprId,null()] (SQL Exception while executing the
following:INSERT INTO OFBIZ.JOB_SANDBOX (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)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?) (The statement was aborted because it would have caused a
duplicate key value in a unique or primary key constraint or unique index
identified by 'SQL210415135036970' defined on 'JOB_SANDBOX'.)). Rolling back
transaction.

org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:JobSandbox][authUserLoginId,null()][cancelDateTime,2021-04-18
13:53:02.103(java.sql.Timestamp)][createdStamp,2021-04-20
18:42:48.176(java.sql.Timestamp)][createdTxStamp,2021-04-20
18:42:48.176(java.sql.Timestamp)][currentRecurrenceCount,null()][currentRetr
yCount,0(java.lang.Long)][finishDateTime,2021-04-17
23:29:09.898(java.sql.Timestamp)][jobId,10300(java.lang.String)][jobName,Sen
d Email(java.lang.String)][jobResult,null()][lastUpdatedStamp,2021-04-20
18:42:48.176(java.sql.Timestamp)][lastUpdatedTxStamp,2021-04-20
18:42:48.176(java.sql.Timestamp)][loaderName,null()][maxRecurrenceCount,-1(j
ava.lang.Long)][maxRetry,null()][parentJobId,SENDEMAIL(java.lang.String)][po
olId,pool(java.lang.String)][previousJobId,10123(java.lang.String)][recurren
ceInfoId,null()][runAsUser,system(java.lang.String)][runByInstanceId,null()]
[runTime,2021-04-20
18:42:47.995(java.sql.Timestamp)][runtimeDataId,null()][serviceName,sendEmai
lDated(java.lang.String)][startDateTime,null()][statusId,SERVICE_PENDING(jav
a.lang.String)][tempExprId,null()] (SQL Exception while executing the
following:INSERT INTO OFBIZ.JOB_SANDBOX (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)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?) (The statement was aborted because it would have caused a
duplicate key value in a unique or primary key constraint or unique index
identified by 'SQL210415135036970' defined on 'JOB_SANDBOX'.))

       at
org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:1
72) ~[main/:?]

       at
org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:110)
~[main/:?]

       at
org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.
java:65) ~[main/:?]

       at
org.apache.ofbiz.entity.GenericDelegator.createSetNextSeqId(GenericDelegator
.java:792) [main/:?]

       at
org.apache.ofbiz.service.job.JobManager.reloadCrashedJobs(JobManager.java:33
8) [main/:?]

       at
org.apache.ofbiz.service.job.JobPoller$JobManagerPoller.run(JobPoller.java:2
29) [main/:?]

       at java.lang.Thread.run(Thread.java:844) [?:?]

Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception
while executing the following:INSERT INTO OFBIZ.JOB_SANDBOX (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) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (The statement was aborted because it would
have caused a duplicate key value in a unique or primary key constraint or
unique index identified by 'SQL210415135036970' defined on 'JOB_SANDBOX'.)

       at
org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:43
5) ~[main/:?]

       at
org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:1
67) ~[main/:?]

       ... 6 more

Caused by:
org.apache.derby.shared.common.error.DerbySQLIntegrityConstraintViolationExc
eption: The statement was aborted because it would have caused a duplicate
key value in a unique or primary key constraint or unique index identified
by 'SQL210415135036970' defined on 'JOB_SANDBOX'.

       at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknow
n Source) ~[derby-10.14.1.0.jar:?]

       at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(Delegatin
gPreparedStatement.java:98) ~[commons-dbcp2-2.1.1.jar:2.1.1]

       at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(Delegatin
gPreparedStatement.java:98) ~[commons-dbcp2-2.1.1.jar:2.1.1]

       at
org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:43
1) ~[main/:?]

       at
org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:1
67) ~[main/:?]

       ... 6 more

Caused by: org.apache.derby.iapi.error.StandardException: The statement was
aborted because it would have caused a duplicate key value in a unique or
primary key constraint or unique index identified by 'SQL210415135036970'
defined on 'JOB_SANDBOX'.

       at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at
org.apache.derby.impl.sql.execute.IndexChanger.insertAndCheckDups(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at org.apache.derby.impl.sql.execute.IndexChanger.doInsert(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at org.apache.derby.impl.sql.execute.IndexChanger.insert(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at org.apache.derby.impl.sql.execute.IndexSetChanger.insert(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at
org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at
org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown
Source) ~[derby-10.14.1.0.jar:?]

       at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(Delegatin
gPreparedStatement.java:98) ~[commons-dbcp2-2.1.1.jar:2.1.1]

       at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(Delegatin
gPreparedStatement.java:98) ~[commons-dbcp2-2.1.1.jar:2.1.1]

       at
org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:43
1) ~[main/:?]

       at
org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:1
67) ~[main/:?]

       ... 6 more