c# – NHibernate.Exceptions.GenericADOException:无法执行查
发布时间:2020-12-15 17:22:54 所属栏目:百科 来源:网络整理
导读:我有一个遗留应用程序(vfp 8),我需要从中提取数据(无插入).我使用Accnum字段作为主键,它在表中定义为字符11. 工厂配置: ?xml version="1.0" encoding="utf-8" ?hibernate-configuration xmlns="urn:nhibernate-configuration-2.2"reflection-optimizer use=
我有一个遗留应用程序(vfp 8),我需要从中提取数据(无插入).我使用Accnum字段作为主键,它在表中定义为字符11.
工厂配置: <?xml version="1.0" encoding="utf-8" ?> <hibernate-configuration xmlns="urn:nhibernate-configuration-2.2"> <reflection-optimizer use="false" /> <session-factory> <property name="connection.provider">NHibernate.Connection.DriverConnectionProvider</property> <property name="dialect">NHibernate.Dialect.GenericDialect</property> <property name="connection.driver_class">NHibernate.Driver.OleDbDriver</property> <property name="connection.connection_string">Provider=VFPOLEDB.1;Data Source=C:AnalysisQuantiumdevelopmentRD warehouse_RDAUWHData;Collating Sequence=MACHINE</property> <property name="show_sql">false</property> </session-factory> </hibernate-configuration> 这是我的映射文件: <?xml version="1.0" encoding="utf-8" ?> <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" assembly="RDLabels" namespace="RDLabels.Domain"> <class name="CustMast"> <id name="Accnum" column="Accnum" type="string"> <generator class="assigned"/> </id> <property name="Fullname" /> <property name="Add" /> <property name="State" /> </class> </hibernate-mapping> 班级: public class CustMast { private string _accnum; public virtual string Accnum { get { return _accnum; } set { _accnum = value; } } private string _fullname; public virtual string Fullname { get { return _fullname; } set { _fullname = value; } } private string _add; public virtual string Add { get { return _add; } set { _add = value; } } private string _state; public virtual string State { get { return _state; } set { _state = value; } } } 以下是获取记录的代码: public CustMast GetByAccnum(String accnum) { using (ISession session = NHibernateHelper.OpenSession()) { CustMast custMast = session .CreateCriteria(typeof(CustMast)) .Add(Restrictions.Eq("Accnum",accnum)) .UniqueResult<CustMast>(); return custMast; } } 完整的错误是: NHibernate.Exceptions.GenericADOException : could not execute query [ SELECT this_.Accnum as Accnum0_0_,this_.Fullname as Fullname0_0_,this_.Add as Add0_0_,this_.State as State0_0_ FROM CustMast this_ WHERE this_.Accnum = ? ] Name:cp0 - Value:00059337444 [SQL: SELECT this_.Accnum as Accnum0_0_,this_.State as State0_0_ FROM CustMast this_ WHERE this_.Accnum = ?] ----> System.IndexOutOfRangeException : Invalid index 0 for this OleDbParameterCollection with Count=0. - d:CSharpNHNHnhibernatesrcNHibernateLoaderLoader.cs:1590 运行NHibernate Profiler,它显示: WARN: reflection-optimizer property is ignored out of application configuration file. WARN: System.IndexOutOfRangeException: Invalid index 0 for this OleDbParameterCollection with Count=0. at System.Data.OleDb.OleDbParameterCollection.RangeCheck(Int32 index) at System.Data.OleDb.OleDbParameterCollection.GetParameter(Int32 index) at System.Data.Common.DbParameterCollection.System.Collections.IList.get_Item(Int32 index) at NHibernate.Driver.DriverBase.ExpandQueryParameters(IDbCommand cmd,SqlString sqlString) in d:CSharpNHNHnhibernatesrcNHibernateDriverDriverBase.cs:line 235 at NHibernate.AdoNet.AbstractBatcher.ExpandQueryParameters(IDbCommand cmd,SqlString sqlString) in d:CSharpNHNHnhibernatesrcNHibernateAdoNetAbstractBatcher.cs:line 232 at NHibernate.Loader.Loader.PrepareQueryCommand(QueryParameters queryParameters,Boolean scroll,ISessionImplementor session) in d:CSharpNHNHnhibernatesrcNHibernateLoaderLoader.cs:line 1152 ERROR: Invalid index 0 for this OleDbParameterCollection with Count=0. 解决方法
每当我传递一个参数时,我都在努力解决我的linq查询丢失相同的错误.如果我没有传递任何参数并做了session.Query()他们会工作正常.
我挣扎了几天,但我发现这张Nhibernate jira票here.它解释了SQLParameters和Iseries Db2提供程序的明显问题. 我知道您使用的是其他提供商,但您可能只需下载最新的Nhibernate核心源代码,构建它并在项目中引用最新版本即可获益.它解决了我的问题. (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |