svn commit: r451294 - /incubator/ofbiz/trunk/framework/entity/config/entityengine.xml

Author: jleroux
Date: Fri Sep 29 06:53:14 2006
New Revision: 451294

URL: http://svn.apache.org/viewvc?view=rev&rev=451294
Log:
A patch from Cameron Smith : Entity Engine: entityengine.xml: Default MSSQL JDBC settings incorrect (http://issues.apache.org/jira/browse/OFBIZ-332)

Modified:
    incubator/ofbiz/trunk/framework/entity/config/entityengine.xml

Modified: incubator/ofbiz/trunk/framework/entity/config/entityengine.xml
URL: http://svn.apache.org/viewvc/incubator/ofbiz/trunk/framework/entity/config/entityengine.xml?view=diff&rev=451294&r1=451293&r2=451294
==============================================================================
--- incubator/ofbiz/trunk/framework/entity/config/entityengine.xml (original)
+++ incubator/ofbiz/trunk/framework/entity/config/entityengine.xml Fri Sep 29 06:53:14 2006
@@ -416,6 +416,22 @@
         <!-- <tyrex-dataSource dataSource-name="firebird" isolation-level="ReadCommitted"/>  -->
     </datasource>
 
+    <!--
+     The following has been tested with SQL Server 2005 + MS SQL Server JDBC Driver 1.1
+     Tips:
+      1. Make sure your SQL Server has mixed mode authentication as per this post:
+       http://aspadvice.com/blogs/plitwin/archive/2006/09/10/Login-failed-_2E002E002E00_-not-associated-with-a-trusted-SQL-server-connection.aspx
+      2. Make sure you have copied JDBC driver jar to entity/lib/jdbc
+      3. Make sure you have installed JDBC Driver XA support as per MSSQL_JDBC_HOME/enu/xa/xa_install.sql
+      4. Make sure that you have created and authorized the ofbiz database and login
+      5. Make sure that schema-name, jdbc-username, jdbc-password and databaseName are all correct!
+    
+     Notes:
+     a. The reason for putting SelectMethod=cursor property in URL is explained here:
+      http://forum.java.sun.com/thread.jspa?forumID=48&threadID=184797
+     b. If using an old version of the driver, beware of this resource leak:
+      http://support.microsoft.com/kb/820773/
+    -->
     <datasource name="localmssql"
             helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
             schema-name="dbo"
@@ -428,8 +444,8 @@
         <read-data reader-name="demo"/>
         <read-data reader-name="ext"/>
         <inline-jdbc
-                jdbc-driver="com.microsoft.jdbc.sqlserver.SQLServerDriver"
-                jdbc-uri="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=ofbiz;SelectMethod=Cursor"
+                jdbc-driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
+                jdbc-uri="jdbc:sqlserver://localhost:1791;databaseName=ofbiz;SelectMethod=cursor;"
                 jdbc-username="ofbiz"
                 jdbc-password="ofbiz"
                 isolation-level="ReadCommitted"