NHibernateProvider

New Post: NHibernate V2

lvildosola — Mon, 01 Dec 2008 15:45:39 GMT

This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.

Created Issue: Update NHibernateProvider to support NHibernate V2

lvildosola — Mon, 01 Dec 2008 15:45:38 GMT

The current version is 2.0.1GA http://sourceforge.net/projects/nhibernate/

New Post: NHibernate V2

lvildosola — Mon, 01 Dec 2008 15:44:22 GMT

I have been out of touch with some of these projects. I apologize for that. I did not have any plans to perform the port. However, I will see what I can do to spend a few hours to see what the effort would be. Frankly, since I have not used NHibernate for a long time, I have lost track of what changes have been made. So, I would have to get back into it to make the transition. If you go through the effort, please share it and I would be happy to make the necessary updates. If you prefer, I would be happy to give you access to make the changes and check them in. I can also review the changes if you prefer before updating the project. It's up to you.

New Post: NHibernate V2

fishern — Fri, 21 Nov 2008 02:07:01 GMT

Any chance of a updating this to the latest release of NHibernate?
The current version is 2.0.1GA http://sourceforge.net/projects/nhibernate/

New Post: User creation problem using Nhibernate membership provider and Oracle10g

mdsamim — Wed, 12 Nov 2008 05:06:30 GMT

Thanks a lot! thank you very much.
Yes,Password is a reserved word for Oracle.I just renamed(alter table membershipuser rename column Password to "Password") the Password column within a quote as "Password".And everything is running fine.Thank you again.

New Post: User creation problem using Nhibernate membership provider and Oracle10g

dschilling — Tue, 11 Nov 2008 13:38:16 GMT

I believe the Password column has quotes in the mapping file because for some databases "Password" is a reserved word. So the quotes need to stay. The problem here is that Oracle interprets a double-quoted identifier as a case-sensitive identifier, but the column has been created as PASSWORD, so Password and PASSWORD do not match.

Modify the database create script like so...:

create table MEMBERSHIPUSER (
   ID NUMBER(38,0) not null,
   NAME VARCHAR2(255) not null,
   LOWEREDNAME VARCHAR2(255) not null,
   DESCRIPTION VARCHAR2(255) null,
    "Password" VARCHAR2(128) not null,
...

Now the column names should match.

New Post: User creation problem using Nhibernate membership provider and Oracle10g

mdsamim — Mon, 10 Nov 2008 05:38:48 GMT

Hi EverybodY

I tried to implement the asp.net user and role management feature using nhibernatemembership provider and Oracle10g,there is a problem
in user creation.
The problem is as follow....

NHibernateProvider: unable to get user; operation failed with error "could not execute query
[ select user0_.Id as Id1_, user0_.Name as Name1_, user0_.LoweredName as LoweredN3_1_, user0_.Description as Descript4_1_, user0_."Password" as Password5_1_, user0_.PasswordFormat as Password6_1_, user0_.PasswordSalt as Password7_1_, user0_.Email as Email1_, user0_.LoweredEmail as LoweredE9_1_, user0_.PasswordQuestion as Passwor10_1_, user0_.PasswordAnswer as Passwor11_1_, user0_.Comments as Comments1_, user0_.IsApproved as IsApproved1_, user0_.IsLockedOut as IsLocke14_1_, user0_.CreationDate as Creatio15_1_, user0_.LastActivityDate as LastAct16_1_, user0_.LastLoginDate as LastLog17_1_, user0_.LastLockedOutDate as LastLoc18_1_, user0_.LastPasswordChangeDate as LastPas19_1_, user0_.FailedPwdAttemptCnt as FailedP20_1_, user0_.FailedPwdAttemptWndStart as FailedP21_1_, user0_.FailedPwdAnsAttemptCnt as FailedP22_1_, user0_.FailedPwdAnsAttemptWndStart as FailedP23_1_ from MembershipUser user0_ where (user0_.LoweredName=? ) ]
Positional parameters: 0 sdfd
[SQL: select user0_.Id as Id1_, user0_.Name as Name1_, user0_.LoweredName as LoweredN3_1_, user0_.Description as Descript4_1_, user0_."Password" as Password5_1_, user0_.PasswordFormat as Password6_1_, user0_.PasswordSalt as Password7_1_, user0_.Email as Email1_, user0_.LoweredEmail as LoweredE9_1_, user0_.PasswordQuestion as Passwor10_1_, user0_.PasswordAnswer as Passwor11_1_, user0_.Comments as Comments1_, user0_.IsApproved as IsApproved1_, user0_.IsLockedOut as IsLocke14_1_, user0_.CreationDate as Creatio15_1_, user0_.LastActivityDate as LastAct16_1_, user0_.LastLoginDate as LastLog17_1_, user0_.LastLockedOutDate as LastLoc18_1_, user0_.LastPasswordChangeDate as LastPas19_1_, user0_.FailedPwdAttemptCnt as FailedP20_1_, user0_.FailedPwdAttemptWndStart as FailedP21_1_, user0_.FailedPwdAnsAttemptCnt as FailedP22_1_, user0_.FailedPwdAnsAttemptWndStart as FailedP23_1_ from MembershipUser user0_ where (user0_.LoweredName=? )]".<br><br><i>Base Exception Message</i>: "ORA-00904: "USER0_"."Password": invalid identifier.

Here in the QUERY the password field has been taken in double quotes(") as user0_."Password" which is wrong.It should be as user0_.Password.
I have tried to remove the "Password" field from the "User.hbm.xml" and "User.cs".But still the same problem arises.

Can any body please help me!
Thanks in advance....

New Post: Multiple project that use nhibernate

eric65 — Tue, 07 Oct 2008 02:56:24 GMT

Hi,
I already have a web application that use nhibernate with a class library named Model that hold my HBM mapping files.
In my web config I have <mapping assembly="Model"/>.

Now I want to use NHibernateProvider. This dll have all the mapping files embedded in is assembly and to use it we need to add this tag in the web.config
<mapping assembly="NHibernateProvider"/>

How can I make two assemblies that use NHibernate mappings files in two distinct place to coexist ?

Thank you !

Created Issue: NHibernate 2.0.0 Beta 1 - No overload for method 'DeepCopy' takes '1' arguments

Gradiation — Tue, 19 Aug 2008 09:55:39 GMT

Hi Guys,

I'm trying to get NHibernateProvider to work with NHibernate 2.0.0 Beta 1, and the only problem there seems to be is is that the NHibernateUtils.Boolean.DeepCopy method now requires 3 parameters, as used in OneZeroType.cs line 111.

The methods signature is now.

NHibernateUtils.Boolean.DeepCopy(Object value, EntityMode entityMode, ISessionFactoryImplementor factory)

Does anybody know what I need to set the other parameters to?

Many thanks

Matt

New Post: Windows Authentification and NHibernateProvider role provide

lvildosola — Mon, 14 Jul 2008 17:35:02 GMT

I apologize for taking so long to respond. I have been away from these projects for a while and I hope to get back into them as time permits.

I hope that you already got an answer to your question. If not, let me see if I can help you.

The NHibernateProvider is based on the fact that all relationships are maintained in the database. That is, the mapping of application, user, and role are in the database. This is only required for the RoleProvider to find the corresponding role assignment given a "user name" (whatever that is). Authentication is done independently using the MembershipProvider model, but it is not required to use the NHibernameProvider Membership Provider, you can use Windows Authentication for this.

In order to get the two to work together you have to

Comment out the MembershipProvider reference in your Web.config,
Configure your web app to use Windows Authentication, and
Configure the user names in the database.

When using Windows Authentication the user names are those corresponding to the NT user name. For example, domain\first.last. If you configure such user names and map them to your roles, it will all come together. The link between authentication and authorization is therefore done via the NT user name.

NEW POST: Windows Authentification and NHibernateProvider role provide

gauthierd — Fri, 06 Jun 2008 15:49:12 GMT

Hi,

I want to use windows authentification to login the users accessing my application. (avoiding them having to manually login). However, because the roles I want to define are specific to my application, I do not want to define or store them within your network’s Windows Active Directory. Instead, I want to define and store these roles within a database. I want to map Windows user accounts stored within Active Directory to these roles, and grant/deny access within the application based on them.

Basically, I want to do something similar to this Recipe: Implementing Role Based Security with ASP.NET using Windows Authentication and SQL Server
http://weblogs.asp.net/scottgu/archive/2006/07/23/Recipe_3A00_-Implementing-Role-Based-Security-with-ASP.NET-using-Windows-Authentication-and-SQL-Server.aspx

but I want to use NHibernateProvider instead of SQL Server provider. So my question will be : it is possible to do that? I am getting a error when I am adding a role (probably because the user is not in the membershipuser table).

Thanks

David Gauthier

COMMENTED ISSUE: Spring.NET Integration

pcting — Fri, 14 Mar 2008 21:07:52 GMT

It would be really great if this library played well with Spring.NET found at http://www.springframework.net/. This is a .NET adaptation of java's Spring library. This library is also integrated with NHibernate. NHibernateProvider currently doesn't play well with Spring.NET. The only thing I see that needs to change are the NHibernateHelper and NHibernateProviderEntityHelper classes. Attached are my changes.

I changed all the NHibernateHelper and NHibernateProviderEntityHelper calls to utilize my new classes. With these changes, you should be able to use Spring.NET's dependency injection to configure the helper classes.
Comments: ** Comment from web user: pcting **

I've realized this integration could be paired up with the other issue at http://www.codeplex.com/nhibernateprovider/WorkItem/View.aspx?WorkItemId=5562. Lets close this work item out and merge it into that other one regarding the custom session factory.

COMMENTED FEATURE: Add ability to provide custom session factory object

pcting — Fri, 14 Mar 2008 21:06:06 GMT

// This message is addressed to the product developer //

Hi,

I find this job extreemly useful for everybody. However, I have faced an integration problelms. It is difficult to integrate it with other technologies based on NH due to configuration. It's easy to drop these constraints allowing the user to provide own session factory object. I have prepared an HTTP module implementation that allows such modification:

using System;
using System.Collections.Generic;
using System.Text;
using System.Web;
using NHibernateProvider.Helper;

namespace NHibernateProvider
{
public class NHibernateProviderModule : IHttpModule
{
#region IHttpModule Members

public void Dispose()
{
// ...
}

public void Init(HttpApplication context)
{
context.BeginRequest += new EventHandler(OnBeginRequest);
}

protected virtual void OnBeginRequest(object sender, EventArgs e)
{
NHibernateHelper.Initialize();
}

#endregion
}
}

This module requires to provide following methods in the NHibernateHelper class _instead_ of the static constructor:

public static void Initialize()
{
sessionFactory = new Configuration().Configure().BuildSessionFactory();
}
public static void Initialize(ISessionFactory extSessionFactory)
{
sessionFactory = extSessionFactory;
}

and to drop readonly constraint on the sessionFactory member.

These modification allow the user to derive from the module and overload OnBeginRequest method where custom session factory can be injected. Actualy I would like to use this mechanism for integration with Spring.Net. So, the question is whether it is possible to put it to the base code of NHibernateProvider.
Comments: ** Comment from web user: pcting **

I've also had the need for this feature so I went ahead and altered the code. I removed the NHibernateHelper and NHibernateProviderEntityHelper classes and replaced them with Spring.NET's HibernateDaoSupport version of them to be able to do DI for spring.net through IoC. Attached is a zip of the binaries and a diff patch. I haven't tested it fully, but I am using it in my code right now; it does seem to work well.

So although this isn't a "custom" session factory, this implementation will help tot pave the way to developing a totally customizable session factory. Using my code changes with the current trunk code, we could figure out what a custom session factory would resemble.

COMMENTED ISSUE: Spring.NET Integration

pcting — Wed, 12 Mar 2008 08:46:16 GMT

Attached is spring-integration.patch. This is my generated patch from the current code in the repository. I used the TF to SVN bridge to grab the code and it read "last commit revision: 936" and "revision / author: 10259".

COMMENTED ISSUE: Spring.NET Integration

pcting — Wed, 12 Mar 2008 08:37:03 GMT

I also had to alter the domain model classes to be public.

COMMENTED ISSUE: Spring.NET Integration

pcting — Wed, 12 Mar 2008 08:35:21 GMT

NHibernateProviderEntityHelperDao.cs

COMMENTED ISSUE: Spring.NET Integration

pcting — Wed, 12 Mar 2008 08:35:00 GMT

NHibernateHelperDao.cs

COMMENTED ISSUE: Spring.NET Integration

pcting — Wed, 12 Mar 2008 08:34:28 GMT

Here's another file: IProviderEntityHelperDao.cs

CREATED ISSUE: Spring.NET Integration

pcting — Wed, 12 Mar 2008 08:33:21 GMT

NEW POST: User hbm.xml, boolean/UserType

lvildosola — Tue, 04 Mar 2008 01:40:12 GMT

Thanks for your feedback. The original implementation was done when NHibernate did not handle this nicely. It may no longer be required. However, for backward compatibility the user type will be kept. I'll make sure that it is mentioned as a comment in the sample code that this may not be required. Can you please tell me which version of the Oracle drivers you are using and which version of NHibernate?