Matt,
Here is all the information minus the using statements in the source
code.
Thanks
David
Exception:
{"could not load an entity: [ADRPData.Domain.DocType#ArbAssocRuling]
[SQL: SELECT doctype0_.SDOCTYPEID as SDOCTYPEID1_0_,
doctype0_.SDOCTYPECODE as SDOCTYPE2_1_0_, doctype0_.sSettings as
sSettings1_0_, doctype0_.sTemplate as sTemplate1_0_,
doctype0_.sArchiveOnly as sArchive5_1_0_, doctype0_.sDocTypeDescriptio
as sDocType6_1_0_, doctype0_.sPrinterName as sPrinter7_1_0_,
doctype0_.sViewableInMCare as sViewabl8_1_0_,
doctype0_.sMCareDescription as sMCareDe9_1_0_, doctype0_.sDocGroup as
sDocGroup1_0_ FROM DocType doctype0_ WHERE doctype0_.SDOCTYPEID=?]"}
Inner Exception:
{"Invalid index 0 for this DB2ParameterCollection with Count=0."}
DocType.hbm.xml:
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"
assembly="ADRPData"
namespace="ADRPData.Domain">
<class name="DocType">
<id name="sDocTypeID" column="SDOCTYPEID" type="String">
<generator class="assigned" />
</id>
<property name="sDocTypeCode" column="SDOCTYPECODE" />
<property name="sSettings" />
<property name="sTemplate" />
<property name="sArchiveOnly" />
<property name="sDocTypeDescriptio" />
<property name="sPrinterName" />
<property name="sViewableInMCare" />
<property name="sMCareDescription" />
<property name="sDocGroup" />
</class>
</hibernate-mapping>
DocType.cs:
namespace ADRPData.Domain
{
public class DocType
{
public virtual string sDocTypeID { get; set; }
public virtual string sDocTypeCode { get; set; }
public virtual string sSettings { get; set; }
public virtual string sTemplate { get; set; }
public virtual string sArchiveOnly { get; set; }
public virtual string sDocTypeDescriptio { get; set; }
public virtual string sPrinterName { get; set; }
public virtual string sViewableInMCare { get; set; }
public virtual string sMCareDescription { get; set; }
public virtual string sDocGroup { get; set; }
}
}
Program.cs - ConsoleApplication:
namespace ADRPConsole
{
class Program
{
private static ISessionFactory _sessionFactory;
private static Configuration _configuration;
static void Main(string[] args)
{
_configuration = new Configuration();
_configuration.Configure();
_configuration.AddAssembly(typeof(DocType).Assembly);
_sessionFactory = _configuration.BuildSessionFactory();
IDocTypeRepository repository = new DocTypeRepository();
var fromDb = repository.GetById("ArbAssocRuling");
Console.WriteLine("DocTypeCode:" + fromDb.sDocTypeCode);
}
}
}
On Sep 1, 5:48 am, MattO <[email protected]> wrote:
> Dbl,
>
> Welcome to the minority of users who are still using DB2!
>
> The first XML example is pretty much what I use for DB2 on IBM i
> (AS400).
>
> I don't think your error however is due to improper XML
> configuration. I think it is something else. I think we need more
> code to figure it out. Can you post your code for the DocType class,
> the code that is trying to load the domain, and the exception (and
> inner exception detail) from the query you are trying to perform?
>
> Matt
>
> On Aug 31, 1:17 pm, DBLWizard <[email protected]> wrote:
>
>
>
>
>
>
>
> > Howdy,
>
> > I am trying to get DB2 zOS 9 to work with NHibernate but I can not
> > find clear documenation on how to setup the app.config and the
> > hibernate.cfg.xml file. I'm getting an error when its trying to build
> > the SQL statements a substituting parameters. So I want to make sure
> > I've got my config file setup. I have tried both of these to
> > configurations and both get the same error.
>
> > <?xml version="1.0" encoding="utf-8" ?>
> > <hibernate-configuration xmlns="urn:nhibernate-configuration-2.2">
> > <session-factory name="Test">
> > <property
> > name="connection.provider">NHibernate.Connection.DriverConnectionProvider</
> > property>
> > <property name="dialect">NHibernate.Dialect.DB2Dialect</property>
> > <property
> > name="connection.driver_class">NHibernate.Driver.DB2Driver</property>
> > <property
> > name="connection.connection_string">Database=dbalias;Uid=myUid;Pwd=myPass</
> > property>
> > <property name="show_sql">true</property>
> > </session-factory>
> > </hibernate-configuration>
>
> > This is an ODBC example I found:
>
> > <?xml version="1.0" encoding="utf-8" ?>
> > <hibernate-configuration xmlns="urn:nhibernate-configuration-2.0" >
> > <session-factory name="session">
> > <property
> > name="connection.provider">NHibernate.Connection.DriverConnectionProvider</
> > property>
> > <property
> > name="connection.driver_class">NHibernate.Driver.OdbcDriver</property>
> > <property name="connection.connection_string">driver={IBM DB2
> > ODBC
> > DRIVER};Database=db;hostname=host;port=port;protocol=TCPIP;uid=uid;
> > pwd=pwd</property>
> > <property name="show_sql">true</property>
> > <property name="dialect">NHibernate.Dialect.DB2Dialect</
> > property>
> > </session-factory>
> > </hibernate-configuration>
>
> > As I said I've tried both of these and get the same error and it
> > revolves around the false return of the UseNamedPrefixInSql function.
> > The Error I'm getting is:
>
> > could not load an entity: [ADRPData.Domain.DocType#ArbAssocRuling]
> > [SQL: SELECT doctype0_.SDOCTYPEID as SDOCTYPEID1_0_,doctype0_.
> > SDOCTYPECODE as SDOCTYPE2_1_0_ FROM DocType doctype0_ WHERE
> > doctype0_.SDOCTYPEID=?]
>
> > Can anybody point me to a good resource for using NHibernate with DB2
> > zOS or how this config file should be set to make things work
> > correctly.
>
> > Thanks
>
> > dbl
--
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.
