Hi,
I am getting problem with Sql Server 2005.


My nhibernate configaration is as
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-configuration xmlns="urn:nhibernate-configuration-2.0" >
<session-factory name="NHibernate.Test">
<!-- properties -->

<property name="connection.provider">NHibernate.Connection.DriverConnectionProvider</property>
<property name="connection.driver_class">NHibernate.Driver.SqlClientDriver</property>
<property name="connection.connection_string">Server=CURVA_DB\CURVA;initial catalog=curva;User ID=curva;Password=curva;Min Pool Size=2</property>
<property name="show_sql">true</property>
<property name="dialect">NHibernate.Dialect.MsSql2005Dialect</property>

<property name="use_outer_join">true</property>
<property name="query.substitutions">true 1, false 0, yes 'Y', no 'N'</property>
<!-- mapping files -->
<mapping assembly="Kgisl.Curva.Entity" />
</session-factory>

</hibernate-configuration>

I am using Nhibernate 1.2 beta

When I run any sql command it gives "Could execute query[SQL...."

But when I connect to SQL Server 2000 it works fine.

This is the stacktrace,
場所 NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
場所 NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters)
場所 NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet querySpaces, IType[] resultTypes)
場所 NHibernate.Loader.Criteria.CriteriaLoader.List(ISessionImplementor session)
場所 NHibernate.Impl.SessionImpl.Find(CriteriaImpl criteria, IList results)
場所 NHibernate.Impl.SessionImpl.Find(CriteriaImpl criteria)
場所 NHibernate.Impl.CriteriaImpl.List()
場所 Kgisl.Curva.DataAccess.BaseDataAccess.GetByType(Type type) 場所 D:\Projects\Curva\DataAccess\BaseDataAccess.cs:行 285


Please help me.

Thanks,

Shomun

Can you post your configuration file

Hi Rob

Thanks for your reply.

My hibernate configuaration contains the following,
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-configuration xmlns="urn:nhibernate-configuration-2.0" >


<session-factory name="NHibernate.Test">
<!-- properties -->

<property name="connection.provider">NHibernate.Connection.DriverConnectionProvider</property>
<property name="connection.driver_class">NHibernate.Driver.SqlClientDriver</property>
<property name="connection.connection_string">Server=CURVA_DB\CURVA;initial catalog=curva;User ID=curva;Password=curva;Min Pool Size=2</property>
<property name="show_sql">true</property>
<property name="dialect">NHibernate.Dialect.MsSql2005Dialect</property>

<property name="use_outer_join">true</property>
<property name="query.substitutions">true 1, false 0, yes 'Y', no 'N'</property>
<!-- mapping files -->
<mapping assembly="Kgisl.Curva.Entity" />
</session-factory>

</hibernate-configuration>


Please let me know if you need anything else.

Thnaks again,
Shomun

I still didn'T fine any clue.
Please help to find out the problem

Shomun

What is the error?
Please post the full exception stack, including all the errors.

Hi Ayende
Thanks for your reply.
Its a NHibernate.ADOException

Here is the error message,

could not execute query[SQL: SELECT this_.curva_id as curva1_5_0_, this_.valid_flg as valid2_5_0_, this_.vol_sts_kbn as vol3_5_0_, this_.furi_sei as furi4_5_0_, this_.furi_mei as furi5_5_0_, this_.kanji_sei as kanji6_5_0_, this_.kanji_mei as kanji7_5_0_, this_.sex_kbn as sex8_5_0_, this_.birth_ymd as birth9_5_0_, this_.zip as zip5_0_, this_.adr1 as adr11_5_0_, this_.adr2 as adr12_5_0_, this_.adr3 as adr13_5_0_, this_.tel as tel5_0_, this_.fax as fax5_0_, this_.mtel as mtel5_0_, this_.mmail as mmail5_0_, this_.pcmail as pcmail5_0_, this_.vol_pw as vol19_5_0_, this_.cnt_kbn as cnt20_5_0_, this_.kibou_kbn as kibou21_5_0_, this_.tiken_kbn as tiken22_5_0_, this_.job_kbn as job23_5_0_, this_.reg_dt as reg24_5_0_, this_.rreg_dt as rreg25_5_0_, this_.top_int_curva_id as top26_5_0_, this_.int_curva_id as int27_5_0_, this_.reg_media_id as reg28_5_0_, this_.emp_id as emp29_5_0_, this_.img_path as img30_5_0_, this_.indid_path as indid31_5_0_, this_.pledge_path as pledge32_5_0_, this_.last_med_dt as last33_5_0_, this_.reg_type as reg34_5_0_ FROM volunteer this_]


The stacktrace,
場所 NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
場所 NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters)
場所 NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet querySpaces, IType[] resultTypes)
場所 NHibernate.Loader.Criteria.CriteriaLoader.List(ISessionImplementor session)
場所 NHibernate.Impl.SessionImpl.Find(CriteriaImpl criteria, IList results)
場所 NHibernate.Impl.SessionImpl.Find(CriteriaImpl criteria)
場所 NHibernate.Impl.CriteriaImpl.List()
場所 Kgisl.Curva.DataAccess.BaseDataAccess.GetByType(Type type) 場所 D:\Projects\Curva\DataAccess\BaseDataAccess.cs:行 285


Please let me know if you need any information.

Thanks again,
Shomun

Sorry, this is not the full exception message.
It is missing the internal exception details.
Please do exception.ToString() and post all the results here.