This is something I am using.
<datasource name="localmssql"
helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
schema-name="dbo"
field-type-name="mssql"
check-on-start="true"
add-missing-on-start="true"
join-style="ansi"
use-fk-initially-deferred="false">
<read-data reader-name="seed"/>
<read-data reader-name="demo"/>
<read-data reader-name="ext"/>
<inline-jdbc
jdbc-driver="com.microsoft.jdbc.sqlserver.SQLServerDriver"
jdbc-uri="jdbc:microsoft:sqlserver://lizard:1433;DatabaseName=pudassets;SelectMethod=Cursor"
jdbc-username="pudassetsowner"
jdbc-password="pudassetsowner"
isolation-level="ReadCommitted"
pool-minsize="2"
pool-maxsize="20"/>
<!-- <jndi-jdbc jndi-server-name="default"
jndi-name="comp/env/jdbc/xa/localmssql" isolation-level="ReadCommitted"/>
--> <!-- Orion Style JNDI name -->
</datasource>
On 1/2/07, rtrujillo <[EMAIL PROTECTED]> wrote:
I am setting up Ofbiz to run with SQL Server 2000 database.
The sql server sample datas source xml (entityengin.xml) only references
SQL
Server 2005.
Does anyone have sample xml for SQL Server 2000?
The file also contains an incorrect statement about the SQL Server jdbc
url.
"Note a." is only valid for a SQL Server 2000 installations. SQL Server
2005 no longer requires the "SelectMethod=Cursor" to open cloned
connection. This property should be avoided at all costs.
entityengine.xml
--
View this message in context:
http://www.nabble.com/SQL-Server-2000-%5C-2005-tf2909761.html#a8129715
Sent from the OFBiz - User mailing list archive at Nabble.com.
