I'm running NHibernate 1.2 and getting the following error when trying to use CreateSQL:
Here is my code:
ISQLQuery query = NHibernateSession.CreateSQLQuery("SELECT * FROM [Plan]").AddEntity(typeof(Plan));
IList<Plan> x = query.List<Plan>();
Here is my mapping file:
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" assembly="UHG.MAPS.Core" namespace="UHG.MAPS.Core.Domain">
<class name="Plan" table="[Plan]">
<id name="ID" column="PlanID">
<generator class="identity" />
</id>
<property name="PBPNumber" column="[PBPNumber]" type="System.String" not-null="false" length="3"/>
</class>
</hibernate-mapping>
Here is the error stack:
2008-04-17 15:24:34,513 [10] INFO NHibernate.Loader.Loader [(null)] - SELECT * FROM dbo.[Plan]
2008-04-17 15:24:34,732 [10] WARN NHibernate.Util.ADOExceptionReporter [(null)] - System.IndexOutOfRangeException: [PBPNumber]
at System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName)
at System.Data.SqlClient.SqlDataReader.GetOrdinal(String name)
at NHibernate.Driver.NHybridDataReader.GetOrdinal(String name)
at NHibernate.Type.NullableType.NullSafeGet(IDataReader rs, String name)
at NHibernate.Type.NullableType.NullSafeGet(IDataReader rs, String[] names, ISessionImplementor session, Object owner)
at NHibernate.Type.AbstractType.Hydrate(IDataReader rs, String[] names, ISessionImplementor session, Object owner)
at NHibernate.Loader.Loader.Hydrate(IDataReader rs, Object id, Object obj, ILoadable persister, ISessionImplementor session, String[][] suffixedPropertyColumns)
at NHibernate.Loader.Loader.LoadFromResultSet(IDataReader rs, Int32 i, Object obj, Type instanceClass, EntityKey key, LockMode lockMode, ILoadable rootPersister, ISessionImplementor session)
at NHibernate.Loader.Loader.InstanceNotYetLoaded(IDataReader dr, Int32 i, ILoadable persister, EntityKey key, LockMode lockMode, EntityKey optionalObjectKey, Object optionalObject, IList hydratedObjects, ISessionImplementor session)
at NHibernate.Loader.Loader.GetRow(IDataReader rs, ILoadable[] persisters, EntityKey[] keys, Object optionalObject, EntityKey optionalObjectKey, LockMode[] lockModes, IList hydratedObjects, ISessionImplementor session)
at NHibernate.Loader.Loader.GetRowFromResultSet(IDataReader resultSet, ISessionImplementor session, QueryParameters queryParameters, LockMode[] lockModeArray, EntityKey optionalObjectKey, IList hydratedObjects, EntityKey[] keys, Boolean returnProxies)
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)
2008-04-17 15:24:34,732 [10] ERROR NHibernate.Util.ADOExceptionReporter [(null)] - [PBPNumber]
If I use HQL and it works fine, just not working for SQL Query.
Any suggestions?
|