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] <javascript:>>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_**string">
>> 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/**5qrif8kr6s75bkt/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/**
>>>> msg/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.
>>
>> To post to this group, send email to [email protected]<javascript:>
>> .
>> To unsubscribe from this group, send email to
>> [email protected] <javascript:>.
>> 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 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.
