Re: Known issues using SQL Server 2012?

Posted by Ashish Vijaywargiya-5 on
URL: http://ofbiz.116.s1.nabble.com/Known-issues-using-SQL-Server-2012-tp4644269p4644271.html

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.