Hello,
I was getting a very similar error to this thread:
https://forum.hibernate.org/viewtopic.php?f=25&t=999953
NHibernate.ADOException was unhandled
Message=could not execute query
[ SELECT this_.id as id0_0_, this_.name as name0_0_ FROM
hibernate.colorlibrary this_ limit :p0 ]
[SQL: SELECT this_.id as id0_0_, this_.name as name0_0_ FROM
hibernate.colorlibrary this_ limit :p0]
Source=NHibernate
SqlString=SELECT this_.id as id0_0_, this_.name as name0_0_ FROM
hibernate.colorlibrary this_ limit :p0
StackTrace:
at NHibernate.Loader.Loader.DoList(ISessionImplementor session,
QueryParameters queryParameters)
at
NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor
session, QueryParameters queryParameters)
at NHibernate.Loader.Loader.List(ISessionImplementor session,
QueryParameters queryParameters, ISet`1 querySpaces, IType[]
resultTypes)
at
NHibernate.Loader.Criteria.CriteriaLoader.List(ISessionImplementor
session)
at NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria,
IList results)
at NHibernate.Impl.CriteriaImpl.List(IList results)
at NHibernate.Impl.CriteriaImpl.List[T]()
at Intersystem.Base.ManagerBase`2.GetByCriteria(Int32
maxResults, ICriterion[] criterionList) in c:\users\test\documents
\visual studio 2010\Projects\temp\Base\ManagerBase.cs:line 96
at Intersystem.Base.ManagerBase`2.GetAll() in c:\users\test
\documents\visual studio 2010\Projects\temp\Base\ManagerBase.cs:line
78
at Demo.Program.Main(String[] args) in c:\users\test\documents
\visual studio 2010\Projects\temp\Program.cs:line 17
at System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly,
String[] args)
at System.AppDomain.ExecuteAssembly(String assemblyFile,
Evidence assemblySecurity, String[] args)
at
Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
at System.Threading.ThreadHelper.ThreadStart_Context(Object
state)
at System.Threading.ExecutionContext.Run(ExecutionContext
executionContext, ContextCallback callback, Object state, Boolean
ignoreSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext
executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
InnerException: Npgsql.NpgsqlException
Message=ERROR: 3F000: schema "hibernate" does not exist
Source=Npgsql
ErrorCode=-2147467259
BaseMessage=schema "hibernate" does not exist
Code=3F000
Detail=""
ErrorSql=SELECT this_.id as id0_0_, this_.name as name0_0_ FROM
hibernate.colorlibrary this_ limit ((100)::int4)
File=.\src\backend\catalog\namespace.c
Hint=""
Line=2307
Position=56
Routine=LookupExplicitNamespace
Severity=ERROR
Where=""
StackTrace:
at
Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
at Npgsql.ForwardsOnlyDataReader.NextResult()
at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1
dataEnumeration, CommandBehavior behavior, NpgsqlCommand command,
NotificationThreadBlock threadBlock, Boolean synchOnReadError)
at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
at
Npgsql.NpgsqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at
NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd)
at NHibernate.Loader.Loader.GetResultSet(IDbCommand st,
Boolean autoDiscoverTypes, Boolean callable, RowSelection selection,
ISessionImplementor session)
at NHibernate.Loader.Loader.DoQuery(ISessionImplementor
session, QueryParameters queryParameters, Boolean returnProxies)
at
NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor
session, QueryParameters queryParameters, Boolean returnProxies)
at NHibernate.Loader.Loader.DoList(ISessionImplementor
session, QueryParameters queryParameters)
InnerException:
I have tracked this error down to the hbm mapping file. The table
attribute was being set to table="hibernate.colorlibrary"
lazy="true">. After changing this to table="colorlibrary" lazy="true">
the error went away. Does anyone have any ideas on why this error
occurred. When I look in pgAdmin I see that the owner is indeed
hibernate and the table name is colorlibrary.
This is what my app.config looks like:
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>
<section name="hibernate-configuration"
type="NHibernate.Cfg.ConfigurationSectionHandler, NHibernate" />
</configSections>
<hibernate-configuration xmlns="urn:nhibernate-configuration-2.2">
<session-factory>
<property
name="connection.provider">NHibernate.Connection.DriverConnectionProvider</
property>
<property
name="proxyfactory.factory_class">NHibernate.ByteCode.Castle.ProxyFactoryFactory,
NHibernate.ByteCode.Castle</property>
<property name="dialect">NHibernate.Dialect.PostgreSQL82Dialect</
property>
<property
name="connection.driver_class">NHibernate.Driver.NpgsqlDriver</
property>
<property
name="connection.connection_string">Server=127.0.0.1;Port=5432;Database=hibernate;User
Id=postgres;Password=xxxx; Preload Reader=true;</property>
<property name="show_sql">true</property>
<mapping assembly="Intersystem"/>
</session-factory>
</hibernate-configuration>
</configuration>
--
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.
