HI,
we are going to develop an ERP and we decide to Use Nhibernate ... i am new to it
i had a small application in nhibernate configured with sqlserver2000 and downloaede from hibernate.org
it was workign fine and when i configure it with postgresql 8.1
aparently i provide every thing right but it didnt work
and i got this error

Server Error in '/NHibernateExample' Application.
--------------------------------------------------------------------------------

ERROR: 42P01: relation "Customer" does not exist
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: Npgsql.NpgsqlException: ERROR: 42P01: relation "Customer" does not exist

Source Error:


Line 357: if (_mediator.Errors.Count > 0)
Line 358: {
Line 359: throw new NpgsqlException(_mediator.Errors);
Line 360: }
Line 361: }


Source File: c:\Desenvolvimento\Npgsql\src\Npgsql\NpgsqlConnector.cs Line: 359

Stack Trace:


[NpgsqlException: ERROR: 42P01: relation "Customer" does not exist]
Npgsql.NpgsqlConnector.CheckErrors() in c:\Desenvolvimento\Npgsql\src\Npgsql\NpgsqlConnector.cs:359
Npgsql.NpgsqlConnector.CheckErrorsAndNotifications() in c:\Desenvolvimento\Npgsql\src\Npgsql\NpgsqlConnector.cs:410
Npgsql.NpgsqlCommand.ExecuteCommand() in c:\Desenvolvimento\Npgsql\src\Npgsql\NpgsqlCommand.cs:1479
Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb) in c:\Desenvolvimento\Npgsql\src\Npgsql\NpgsqlCommand.cs:633
Npgsql.NpgsqlCommand.ExecuteReader() in c:\Desenvolvimento\Npgsql\src\Npgsql\NpgsqlCommand.cs:614
Npgsql.NpgsqlCommand.System.Data.IDbCommand.ExecuteReader() in c:\Desenvolvimento\Npgsql\src\Npgsql\NpgsqlCommand.cs:586
NHibernate.Impl.BatcherImpl.ExecuteReader(IDbCommand cmd) +68
NHibernate.Loader.Loader.GetResultSet(IDbCommand st, RowSelection selection, ISessionImplementor session) +271
NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +280
NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +83
NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +62

[ADOException: could not execute query
[ SELECT this_."PersonID" as column1_0_0_, this_."Address" as column2_1_0_, this_."City" as column3_1_0_, this_."State" as column4_1_0_, this_."ZipCode" as column5_1_0_, this_1_."FirstName" as column2_0_0_, this_1_."LastName" as column3_0_0_ FROM "Customer" this_ inner join "Person" this_1_ on this_."PersonID"=this_1_."PersonID" ]
[SQL: SELECT this_."PersonID" as column1_0_0_, this_."Address" as column2_1_0_, this_."City" as column3_1_0_, this_."State" as column4_1_0_, this_."ZipCode" as column5_1_0_, this_1_."FirstName" as column2_0_0_, this_1_."LastName" as column3_0_0_ FROM "Customer" this_ inner join "Person" this_1_ on this_."PersonID"=this_1_."PersonID"]]
NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +172
NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) +46
NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet querySpaces, IType[] resultTypes) +152
NHibernate.Loader.Criteria.CriteriaLoader.List(ISessionImplementor session) +67
NHibernate.Impl.SessionImpl.Find(CriteriaImpl criteria, IList results) +492
NHibernate.Impl.CriteriaImpl.List(IList results) +35
Customer.getCustomers() in d:\Asfand\NHibernateExample\App_Code\BusinessObjects\Actions\Customer.cs:37

[TargetInvocationException: Exception has been thrown by the target of an invocation.]
System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +0
System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +72
System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) +308
System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +29
System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters) +17
System.Web.UI.WebControls.ObjectDataSourceView.InvokeMethod(ObjectDataSourceMethod method, Boolean disposeInstance, Object& instance) +676
System.Web.UI.WebControls.ObjectDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +2664
System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +84
System.Web.UI.WebControls.DataBoundControl.PerformSelect() +154
System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +99
System.Web.UI.WebControls.GridView.DataBind() +24
System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +91
System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +101
System.Web.UI.Control.EnsureChildControls() +134
System.Web.UI.Control.PreRenderRecursiveInternal() +109
System.Web.UI.Control.PreRenderRecursiveInternal() +233
System.Web.UI.Control.PreRenderRecursiveInternal() +233
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4421













Its really freaking me out Can any body tell me what could be the problem.
Regards,
Asfand.

does not sound related to any hibernate tools.

Please use the user forum.

Working with Hibernate is very easy and developers enjoy using the APIs and the query language. Even creating mapping metadata is not an overly complex task once you've mastered the basics. Hibernate Tools makes working with Hibernate or EJB 3.0 persistence even more pleasant.


Kristine