Known issues using SQL Server 2012?

[MegaDave1]

I'm trying to use OFBiz with SQL Server 2012 and running in to a couple of problems.  Are there known compatibility issues?

I modified framework\entity\config\entityengine.xml to use my SQL Server database.

I put the SQL Server JDBC driver (sqljdbc4.jar) in the correct place.

OFBiz creates all the tables and it generally works.  The problems I have are

1) When I try to access /ecommerce application I get this: "A Product Store has not been defined for this ecommerce site. A Product Store can be created using the ofbizsetup wizard."

2) Several issues happen when trying to do order entry.

Note everything works great when I use the default derby database.  Any guidance would be appreciated.

Thanks,
Dave

[Ashish Vijaywargiya-5]

Hello Dave,

Are you using trunk code or either of the branch(13.07, 12.04 or 11.04) code? I suspect that demo data doesn't get loaded for you. Did you get any error on the console window when you ran "ant run-install"?  

Following two points will be helpful:

1) Are you using jtds driver or the one provided by Microsoft? As such there is no issue with the driver provided by Microsoft but to get better performance you should try jtds driver. Here is direct link to get jtds driver - http://sourceforge.net/projects/jtds/files/

2) You may need to apply one patch, Mailing list doesn't accept patch files so sharing the contents here in this email.

********************************************************************************************************************************
Index: applications/party/entitydef/entitymodel.xml
===================================================================
--- applications/party/entitydef/entitymodel.xml    (revision 1385013)
+++ applications/party/entitydef/entitymodel.xml    (working copy)
@@ -711,7 +711,7 @@
         <relation type="one" fk-name="COM_EVNT_RESENUM" rel-entity-name="Enumeration">
             <key-map field-name="reasonEnumId" rel-field-name="enumId"/>
         </relation>
-        <index name="COMMEVT_MSG_ID" unique="true">
+        <index name="COMMEVT_MSG_ID" unique="false">
             <index-field name="messageId"/>
         </index>
     </entity>
@@ -1004,7 +1004,7 @@
         <field name="verifyHash" type="value"></field>
         <field name="expireDate" type="date-time"></field>
         <prim-key field="emailAddress"/>
-        <index name="EMAIL_VERIFY_HASH" unique="true">
+        <index name="EMAIL_VERIFY_HASH" unique="false">
             <index-field name="verifyHash"/>
         </index>
     </entity>
@@ -2756,7 +2756,7 @@
       <index name="LAST_NAME_IDX">
         <index-field name="lastName"/>
       </index>
-      <index name="CARD_ID_IDX" unique="true">
+      <index name="CARD_ID_IDX" unique="false">
         <index-field name="cardId"/>
       </index>
     </entity>
Index: applications/product/entitydef/entitymodel.xml
===================================================================
--- applications/product/entitydef/entitymodel.xml    (revision 1385013)
+++ applications/product/entitydef/entitymodel.xml    (working copy)
@@ -1914,10 +1914,10 @@
       <relation type="one" fk-name="INV_ITEM_CUOM" title="Currency" rel-entity-name="Uom">
         <key-map field-name="currencyUomId" rel-field-name="uomId"/>
       </relation>
-      <index name="INVITEM_SOFID" unique="true">
+      <index name="INVITEM_SOFID" unique="false">
         <index-field name="softIdentifier"/>
       </index>
-      <index name="INVITEM_ACTNM" unique="true">
+      <index name="INVITEM_ACTNM" unique="false">
         <index-field name="activationNumber"/>
       </index>
       <index name="INV_ITEM_SN">
Index: applications/marketing/entitydef/entitymodel.xml
===================================================================
--- applications/marketing/entitydef/entitymodel.xml    (revision 1385013)
+++ applications/marketing/entitydef/entitymodel.xml    (working copy)
@@ -211,7 +211,7 @@
       <relation type="one" fk-name="CNCT_LST_CST_ST" rel-entity-name="StatusItem">
         <key-map field-name="statusId"/>
       </relation>
-      <index name="CNTLSTCST_MSG_ID" unique="true">
+      <index name="CNTLSTCST_MSG_ID" unique="false">
         <index-field name="messageId"/>
       </index>
     </entity>
Index: applications/accounting/entitydef/entitymodel.xml
===================================================================
--- applications/accounting/entitydef/entitymodel.xml    (revision 1385013)
+++ applications/accounting/entitydef/entitymodel.xml    (working copy)
@@ -1970,7 +1970,7 @@
       <relation type="one" fk-name="GLACCT_PAR" title="Parent" rel-entity-name="GlAccount">
         <key-map field-name="parentGlAccountId" rel-field-name="glAccountId"/>
       </relation>
-      <index name="GLACCT_UNQCD" unique="true">
+      <index name="GLACCT_UNQCD" unique="false">
         <index-field name="accountCode"/>
       </index>
     </entity>
=======================================================================
********************************************************************************************************************************

Thanks!
On Saturday 28 September 2013 04:53 AM, MegaDave1 wrote:

I'm trying to use OFBiz with SQL Server 2012 and running in to a couple of
problems.  Are there known compatibility issues?

I modified framework\entity\config\entityengine.xml to use my SQL Server
database.

I put the SQL Server JDBC driver (sqljdbc4.jar) in the correct place.

OFBiz creates all the tables and it generally works.  The problems I have
are

1) When I try to access /ecommerce application I get this: "A Product Store
has not been defined for this ecommerce site. A Product Store can be created
using the ofbizsetup wizard."

2) Several issues happen when trying to do order entry.

Note everything works great when I use the default derby database.  Any
guidance would be appreciated.

Thanks,
Dave




--
View this message in context: http://ofbiz.135035.n4.nabble.com/Known-issues-using-SQL-Server-2012-tp4644269.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

[MegaDave1]

Thank you Ashish!

I'm currently running 12.04.  I changed my driver to jtds and manually applied the patches.  It's working great now!  

Thanks again,
Dave