> Some reason NH 2.1 doesn't like "hibernate.cache.use_second_level_cache", but it takes without hibernate infront, i.e., cache.use_second_level_cache
That's right. Just remove "hibernate" prefix when using newer NH versions. > NH 1.2 shows two connection string properties, but NH 2.1 deosn't. Also, I noticed lot difference in properties. Please refer below for the diff bet 1.2 vs 2.1 properites. Now, I understand, why NH 2.1 fails to open another mdb input file. What do you mean by two "connection string" properties? "connection.connection_string" and "connection.provider" are different. > Is there a way to enable two connection string properties? How should I handld in this case? I think the easiest way would be creating two different session factories with different names. It would mean to create two separate session factory configuration, with each pointing to a different database, or in this case separate .MDB files. On Sun, Aug 12, 2012 at 6:12 AM, Rdi <[email protected]> wrote: > Max, > > Thank you very much for reply. > > <property name="hibernate.cache.use_second_level_cache">false</property> > > Some reason NH 2.1 doesn't like "hibernate.cache.use_second_level_cache", > but it takes without hibernate infront, i.e., cache.use_second_level_cache > > NH 1.2 shows two connection string properties, but NH 2.1 deosn't. Also, > I noticed lot difference in properties. Please refer below for the diff bet > 1.2 vs 2.1 properites. Now, I understand, why NH 2.1 fails to open another > mdb input file. > > ["hibernate.connection.connection_string"] > ["hibernate.connection.provider"] > > > NH 1.2 > --------------- > ["hibernate.session_factory_name"] "nhibernator" > ["hibernate.connection.driver_class"] "NHibernate.JetDriver.JetDriver, > NHibernate.JetDriver" > ["hibernate.use_reflection_optimizer"] "true" > ["show_sql"] "true" > ["hibernate.connection.connection_string"] > "Provider=Microsoft.Jet.OLEDB.4.0;Data > Source=C:\\Projects\\MSD Projects\\CADeTWin\\CADeTWin_3\\Exports\\mydb.mdb" > ["connection.driver_class"] "NHibernate.JetDriver.JetDriver, > NHibernate.JetDriver" > ["hibernate.cache.use_second_level_cache"] "false" > ["hibernate.query.substitutions"] "true 1, false 0, yes 'Y', no 'N'" > ["connection.connection_string"] "\r\n > Provider=Microsoft.Jet.OLEDB.4.0;Data Source=.\\mydb.mdb" > ["hibernate.show_sql"] "true" > ["query.substitutions"] "true 1, false 0, yes 'Y', no 'N'" > ["use_outer_join"] "false" > ["hibernate.use_outer_join"] "false" > ["dialect"] "NHibernate.JetDriver.JetDialect, NHibernate.JetDriver" > > ["hibernate.connection.provider"] > "NHibernate.Connection.DriverConnectionProvider" > ["hibernate.dialect"] "NHibernate.JetDriver.JetDialect, > NHibernate.JetDriver" > ["connection.provider"] "NHibernate.Connection.DriverConnectionProvider" > > NH 2.1 > ----------- > [use_reflection_optimizer, > True]} > System.Collections.Generic.KeyValuePair<string,string> > [session_factory_name, > nhibernator]} > System.Collections.Generic.KeyValuePair<string,string> > [connection.provider, > NHibernate.Connection.DriverConnectionProvider]} > System.Collections.Generic.KeyValuePair<string,string> > [connection.driver_class, NHibernate.JetDriver.JetDriver, > NHibernate.JetDriver]} System.Collections.Generic.KeyValuePair<string,string> > [dialect, NHibernate.JetDriver.JetDialect, > NHibernate.JetDriver]} > System.Collections.Generic.KeyValuePair<string,string> > [connection.connection_string, Provider=Microsoft.Jet.OLEDB.4.0;Data > Source=C:\Users\gundas1\Desktop\VS.Net\CADeTWin_3\Exports\mydb.mdb]} > System.Collections.Generic.KeyValuePair<string,string> > [show_sql, > true]} > System.Collections.Generic.KeyValuePair<string,string> > [use_outer_join, > false]} > System.Collections.Generic.KeyValuePair<string,string> > [query.substitutions, true 1, false 0, yes 'Y', no > 'N']} > System.Collections.Generic.KeyValuePair<string,string> > [cache.use_second_level_cache, > false]} > System.Collections.Generic.KeyValuePair<string,string> > [proxyfactory.factory_class, > NHibernate.ByteCode.Castle.ProxyFactoryFactory, > NHibernate.ByteCode.Castle]} > System.Collections.Generic.KeyValuePair<string,string> > > > Is there a way to enable two connection string properties? How should I > handld in this case? > > Any suggestions are appreciated. Thank you for your time in helping me. > > > Thank you, > Rdi > > > > On Saturday, August 11, 2012 4:37:38 PM UTC-5, Maximilian Haru Raditya > wrote: > >> You call me Max... :D >> >> >> > *What are the dlls that goes along with the Jet drivers that you >> provided for NH 3.3.1. Do I have a Castle Dynamic Proxy dll for NH 3.3 or >> just use Caste Core dlls only. * >> >> You only need two assemblies: *Iesi.Collections.dll *and *NHibernate.dll >> *3.3.1 GA (versioned as 3.3.1.4000). >> You don't need *Antlr.Runtime.dll *as it's been internalized in >> NHibernate assembly. >> You don't need *Castle.Core.dll*/*Castle.DynamicProxy*.dll *as well as >> NHibernate already uses its own proxy factory. >> >> About your issue after upgrading to 2.1, sorry I can't help you. I'm not >> really familiar with these MS Jet DB stuffs, but when I ran the tests suite >> from the source, they all passed, so I think there should be no problem. >> After you upgrade to 3.3.1, I think you can see whether the issue still >> exists. Just look at what the exception thrown is. >> >> You're welcome. >> >> >> >> >> On Sun, Aug 12, 2012 at 2:17 AM, Rdi <[email protected]> wrote: >> >>> Maximilian Haru Raditya >>> Thank you very much for your reply. >>> >>> I'm trying to convert my project NH 1.2 to 2.1. I endup adding >>> additional dlls to run project fine and those weren't used in NH 1.2. I >>> don't why antlr runtime needs to be used for NH 2.1 either. >>> >>> NHibernate dll - 2.1.0.4000 >>> NHibernate.ByteCode.Castle dll 2.1.0.4000 - new in 2.1 >>> Iesi.Collections dll 2.1.0.4000 >>> Castle.DynamicProxy2 dll 2.1.0.0 - new in 2.1 >>> >>> Castle.DynamicProxy dll 1.1.5.0 >>> Castle.Core dll 2.5.0. >>> Antlr3.Runtime **** 3.1.0 - new in 2.1 >>> >>> *What are the dlls that goes along with the Jet drivers that you >>> provided for NH 3.3.1. Do I have a Castle Dynamic Proxy dll for NH 3.3 or >>> just use Caste Core dlls only. * >>> >>> >>> >>> *I have another issue after upgrading to NH 2.1 and I described in >>> previous post. * >>> >>> *Issue after upgrading to 2.1:* >>> Software uses MS Access mdf files as input files and store all the data >>> in different tables. Once after I converted the project and try to open an >>> mdb file other than defult file linked in Data Source, software fails to >>> switch profile to open different mdb file until I place default source file >>> specified in data source to open file directory. It use to work fine in the >>> previous version NH 1.x. >>> >>> <property name="connection.connection_**st**ring"> >>> Provider=Microsoft.Jet.OLEDB.**4**.0;Data >>> Source=.\mydb.mdb</property> >>> software failing at below line with the error, can not find mydb.mdb >>> file. >>> this._nhibernateFactory = this._nhibernateConfiguration.**** >>> BuildSessionFactory(); >>> >>> *my code looks like below:* >>> public bool InitDatabase(String strDatabasePath) >>> { >>> if (!File.Exists(strDatabasePath)****) >>> { >>> MessageBox.Show("File: " + strDatabasePath + " does >>> not exist"); >>> return false; >>> } >>> try >>> { >>> SessionFactory sf = SessionFactory.GetInstance(); >>> if (!SessionFactory.**SwitchProfile**(strDatabasePath)** >>> ) >>> { >>> MessageBox.Show("Error opening File: " + >>> strDatabasePath); >>> return false; >>> } >>> } >>> return true; >>> } >>> >>> >>> SessionFactory.GetInstance();**** make call to SessionFactory >>> >>> private SessionFactory() >>> { >>> log4net.Config.**XmlConfigurator**.Configure(); >>> RegisterCoreClasses(null); >>> } >>> >>> private void RegisterCoreClasses(string profilePath) >>> { >>> try >>> { >>> Configuration config = new Configuration(); >>> this._nhibernateConfiguration = config.Configure(); >>> //read NHibernate settings from hibernate.cfg.xml >>> config.Properties = UpdateCfgProperty(profilePath, >>> config.Properties); >>> this._nhibernateFactory = this._nhibernateConfiguration. >>> ****BuildSessionFactory(); //getting error at this line can't find >>> file mydb.mdb. If this default file exists in file open directory, software >>> switches to opened file with no issues. >>> CloseSession(); >>> } >>> } >>> >>> >>> Appreciate your help. Thanks. >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> On Saturday, August 11, 2012 7:46:18 AM UTC-5, Maximilian Haru Raditya >>> wrote: >>> >>>> It's the one from NHContrib, right? If so, grab it here: >>>> https://www.dropbox.com/sh/**5qr**if8kr6s75bkt/yQC0h8kMCP<https://www.dropbox.com/sh/5qrif8kr6s75bkt/yQC0h8kMCP> >>>> It's compiled against NH 3.3.1 GA (on x86 platform, instead of AnyCPU >>>> one). >>>> >>>> Though I only test it using the its internal tests suite, I think it >>>> should work just fine. If it didn't, then you might have to build it >>>> yourself from the source. >>>> >>>> >>>> >>>> >>>> On Sat, Aug 11, 2012 at 11:18 AM, Rdi <[email protected]> wrote: >>>> >>>>> Hi, >>>>> >>>>> Thank for your reply and hlep. >>>>> >>>>> I couldn't find NHibernate Jet drivers for NH 3.3. The latest Jet >>>>> driver that I found on Richard's blog is compiled for NH 2.1. If there is >>>>> a >>>>> latest Jet driver for NH 3.3, please point me to web link or downloads. >>>>> >>>>> http://coderead.wordpress.com/******2010/10/20/nhibernate-jet-**driv** >>>>> **er/<http://coderead.wordpress.com/2010/10/20/nhibernate-jet-driver/> >>>>> >>>>> Thank you, >>>>> Rdi >>>>> >>>>> >>>>> On Friday, August 10, 2012 5:27:19 PM UTC-5, SexualChocolate wrote: >>>>> >>>>>> Just curious, but is there a reason you're choosing to only upgrade >>>>>> to the 2.x version? The latest is 3.3, I believe, and a number of your >>>>>> questions are not applicable for the 3.x versions. >>>>>> >>>>>> On Aug 10, 2012 6:19 PM, "Rdi" <[email protected]> wrote: >>>>>> > >>>>>> > I'm trying to convert my project from vs.net 2005 to 2010. My >>>>>> project uses NHibernate 1.x dll and it has been running fine 2005 >>>>>> compiled >>>>>> version. However, when I convert to 2010, HQL failed to return internal >>>>>> subclass / mapping class object values. I googled around on the web and >>>>>> found 2.x Nhibernate dlls. >>>>>> > >>>>>> > Currently, my project is referenced to below dlls. >>>>>> > NHibernate Jet driver dll 1.2.0.4000 >>>>>> > Castle.DynamicProxy dll 1.1.5.0 >>>>>> > Iesi.Collections dll 1.2.0.4000 >>>>>> > log4net dll 1.2.10.0 >>>>>> > I replaced my project dlls with below dlls along with some >>>>>> additional dlls. Because I didn't any article on how to upgrade from >>>>>> NHibaernate 1.x to some NHibernate x version. I try to play around with >>>>>> the >>>>>> info that I found on the web. >>>>>> > >>>>>> > NHibernate Jet driver dll: >>>>>> > http://coderead.wordpress.com/******2010/10/20/nhibernate-jet-** >>>>>> driv****er/<http://coderead.wordpress.com/2010/10/20/nhibernate-jet-driver/> >>>>>> > >>>>>> > NHibernate dll - 2.1.0.4000 >>>>>> > NHibernate.ByteCode.Castle dll 2.1.0.4000 >>>>>> > Iesi.Collections dll 2.1.0.4000 >>>>>> > Castle.DynamicProxy2 dll 2.1.0.0 >>>>>> > Castle.DynamicProxy dll 1.1.5.0 >>>>>> > Castle.Core dll 2.5.0. >>>>>> > Antlr3.Runtime ****** 3.1.0 >>>>>> > >>>>>> > Once after adding reference to above dlls and compiled okay with >>>>>> little changes in the code. However, I have an issues when switch >>>>>> database >>>>>> profile, also some of the objects retuning null. I'm wondering, whether >>>>>> the >>>>>> upgrade has done is correct or not. Because I have to add additional dlls >>>>>> like antlr runtime, dynmic proxy2, and castle core etc. >>>>>> > >>>>>> > I know for sure, lot of them been through this process and they are >>>>>> NHibernate expers in this forum. I appreciate if anybody direct me to >>>>>> right >>>>>> path. >>>>>> > >>>>>> > >>>>>> > Thanks. >>>>>> > >>>>>> > -- >>>>>> > You received this message because you are subscribed to the Google >>>>>> Groups "nhusers" group. >>>>>> > To view this discussion on the web visit >>>>>> https://groups.google.com/d/**ms****g/nhusers/-/9TC7bSQpEbEJ<https://groups.google.com/d/msg/nhusers/-/9TC7bSQpEbEJ> >>>>>> . >>>>>> > To post to this group, send email to [email protected]. >>>>>> > To unsubscribe from this group, send email to nhusers+u...@** >>>>>> googlegroups.com. >>>>>> >>>>>> > For more options, visit this group at http://groups.google.com/** >>>>>> group****/nhusers?hl=en<http://groups.google.com/group/nhusers?hl=en> >>>>>> . >>>>>> >>>>>> -- >>>>> You received this message because you are subscribed to the Google >>>>> Groups "nhusers" group. >>>>> To view this discussion on the web visit https://groups.google.com/d/* >>>>> *ms**g/nhusers/-/9B27Y_wvRR8J<https://groups.google.com/d/msg/nhusers/-/9B27Y_wvRR8J>. >>>>> >>>>> >>>>> To post to this group, send email to [email protected]. >>>>> To unsubscribe from this group, send email to nhusers+u...@** >>>>> googlegroups.com. >>>>> For more options, visit this group at http://groups.google.com/**group >>>>> **/nhusers?hl=en <http://groups.google.com/group/nhusers?hl=en>. >>>>> >>>> >>>> >>>> >>>> -- >>>> Regards, >>>> >>>> Maximilian Haru Raditya >>>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "nhusers" group. >>> To view this discussion on the web visit https://groups.google.com/d/** >>> msg/nhusers/-/DEqxogdEV34J<https://groups.google.com/d/msg/nhusers/-/DEqxogdEV34J>. >>> >>> >>> To post to this group, send email to [email protected]. >>> To unsubscribe from this group, send email to nhusers+u...@** >>> googlegroups.com. >>> For more options, visit this group at http://groups.google.com/** >>> group/nhusers?hl=en <http://groups.google.com/group/nhusers?hl=en>. >>> >> >> >> >> -- >> Regards, >> >> Maximilian Haru Raditya >> > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/nhusers/-/xXzT9z6zc0wJ. > > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > -- Regards, Maximilian Haru Raditya -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
