Please Help Me with Spring .NET + NHibernate To MS Access DB Integration

[Fagoter]

Hello Friends

I trying to use Spring .NET + NHibernate for connect to MS Access DB, I have a much trouble with that, because don't not how to configure SessionFactory in spring context correctly, Please help Me with that, maybe some example of Spring configuaration of similar situation....

[Fagoter]

<objects xmlns="http://www.springframework.net">

<object id="mySessionFactory" type="Spring.Orm.Hibernate.LocalSessionFactoryObject, Spring.Orm">
<property name="MappingResources">
<list>
<value>SpringClient.Utility.Product.User, SpringClient</value>
</list>
</property>
<property name="ExportSchema" value="false"/>
</object>

<object id="myTransactionManager" type="Spring.Orm.Hibernate.HibernateTransactionManager, Spring.Orm">
<property name="SessionFactory">
<ref object="mySessionFactory"/>
</property>
</object>


<object id="UserTarget" type="SpringClient.Utility.Product.UserServiceImp, SpringClient">
<property name="UserDAO">
<ref object="UserDAO"/>
</property>
</object>

<!--
<object id="UProductService" type="Spring.Transaction.Interceptor.TransactionProxyFac toryObject, Spring.Orm">
<property name="TransactionManager">
<ref object="myTransactionManager"/>
</property>
<property name="Target">
<ref object="UProductTarget"/>
</property>
<property name="TransactionAttributes">
<name-values>
<add key="Save*" value="PROPAGATION_REQUIRES_NEW"/>
<add key="Update*" value="PROPAGATION_REQUIRED"/>
<add key="Delete*" value="PROPAGATION_REQUIRED"/>
</name-values>
</property>
</object>
-->

<!--
<object id="UserService" type="Spring.Transaction.Interceptor.TransactionProxyFac toryObject, Spring.Orm">
<property name="TransactionManager">
<ref object="myTransactionManager"/>
</property>
<property name="Target">
<ref object="UserTarget"/>
</property>
<property name="TransactionAttributes">
<name-values>
<add key="Save*" value="PROPAGATION_REQUIRES_NEW"/>
<add key="Update*" value="PROPAGATION_REQUIRED"/>
<add key="Delete*" value="PROPAGATION_REQUIRED"/>
</name-values>
</property>
</object>
-->



<object id="UserDAO" type="SpringClient.Utility.Product.UserDao, SpringClient">
<property name="SessionFactory">
<ref object="mySessionFactory"/>
</property>
</object>

</objects>
-------------------------------------------------------------------------------------------------------------
<nhibernate>
<add key="hibernate.show_sql" value="true"/>
<add key="hibernate.connection.provider" value="NHibernate.Connection.DriverConnectionProvider" />

<add key="hibernate.dialect" value="NHibernate.JetDriver.JetDialect, NHibernate.JetDriver" />
<add key="hibernate.connection.driver_class" value="NHibernate.JetDriver.JetDriver, NHibernate.JetDriver" />
<add key="hibernate.connection.connection_string" value="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:/Test.mdb" />
</nhibernate>

[swalters]

Hi,

We use this to connect to MSAccess. I set the connectionstring directly in the Hibernate settings.

Note that I'm using NHibernate 1.2 Beta2

<object id="mySessionFactory" type="Spring.Data.NHibernate.LocalSessionFactoryObject, Spring.Data.NHibernate12">

<property name="MappingAssemblies">
<list>
<!--List the assemblies where the hbm.XML files exists
The hbm.XML files must be marked in VS.Net as Embedded Resources-->
<value>Singletree.Biz</value>
</list>
</property>

<property name="HibernateProperties">
<dictionary>
<entry key="hibernate.connection.provider" value="NHibernate.Connection.DriverConnectionProvider"/>
<entry key="hibernate.connection.connection_string" value="
Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\projects\CustomProjects\Carhartt\I nterfaces\testdb.mdb;Uid=Admin;Pwd=;"
/>
<entry key="hibernate.dialect" value="NHibernate.JetDriver.JetDialect, NHibernate.JetDriver"/>
<entry key="hibernate.connection.driver_class" value="NHibernate.Driver.OdbcDriver"/>

<entry key="hibernate.show_sql" value="true" />

<entry key="hibernate.connection.isolation" value="ReadCommitted" />
</dictionary>
</property>
</object>



-Shane