I am new to NHibernate (2.1.2) and am trying to get a working sample
going with our IDS-Express database (11.50) as proof of concept. I'm
currently using the OleDbDriver (Client-SDK 3.50.FC5 -- though I would
certainly be willing to use IfxDriver if I could get the configuration
right).
Borrowing from the example in NHibernate in Action (dated, I know, as
it basically covers 1.2), I'm trying to do a simple insert into a
table with the following schema:
create table "johnp".employee
(
id serial not null ,
name varchar(50),
manager integer
);
Upon trying to save my object, I get the following error:
{"While preparing INSERT INTO Employee (id, name, manager) VALUES
(0, ?, ?) an error occurred"}
"OleDbCommand.Prepare method requires all variable length parameters
to have an explicitly set non-zero Size."
Here is my mapping file:
<?xml version="1.0" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" auto-
import="true">
<class name="HelloNHibernate.Employee, HelloNHibernate"
lazy="false">
<id name="id" access="field">
<generator class="identity" />
</id>
<property name="name" access="field" column="name" />
<many-to-one access="field" name="manager" column="manager"
cascade="all" />
</class>
</hibernate-mapping>
And here is the relevant portion of my App.Config:
<hibernate-configuration xmlns="urn:nhibernate-configuration-2.2">
<session-factory>
<property
name="proxyfactory.factory_class">NHibernate.ByteCode.Castle.ProxyFactoryFactory,
NHibernate.ByteCode.Castle</property>
<property
name="connection.provider">NHibernate.Connection.DriverConnectionProvider</
property>
<property
name="connection.driver_class">NHibernate.Driver.OleDbDriver</
property>
<property
name="connection.connection_string">Provider=Ifxoledbc.3;Data
source=hellonhibern...@dev_on;Persist Security
Info=True;Password=********;User ID=********</property>
<property
name="dialect">NHibernate.Dialect.InformixDialect</property>
<property name="show_sql">false</property>
</session-factory>
</hibernate-configuration>
What do I need to change in my mapping/config to make this work?
--
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.
