Hi everybody:
I'm trying to make an example of the use of NHibernate with POstGreSQL.
I already have the mapping file:
<?xml version="1.0" encoding="utf-8" ?>
- <hibernate-mapping xmlns="urn:nhibernate-mapping-2.0" namespace="Prision" assembly="Prision">
- <class name="Imagenes" table="Imagenes" schema="public">
- <id name="key" column="id" type="String">
<generator class="assigned" />
</id>
<property name="name" type="String" column="name" />
</class>
</hibernate-mapping>
and the mapped class:
public class Imagenes
{
private string _key;
private string _name;
public Imagenes()
{
}
protected string key {
get{return this._key ; }
set{this._key = value ; }
}
protected string name
{
get{return this._name ; }
set{this._name = value ; }
}
// public
public string Key
{
get{return this._key ; }
set{this._key = value ; }
}
public string Name
{
get{return this._name ; }
set{this._name = value ; }
}
}
}
The problem comes when I try to make an insertion or load from the table. I'm using the following code and when I call the Save o Load Method I receive an Exception: could not insert/load Prisiones.Imagenes#1
The code is:
Configuration config = new Configuration();
IDictionary props = new Hashtable();
props["hibernate.connection.provider"] =
"NHibernate.Connection.DriverConnectionProvider";
props["hibernate.dialect" ] = "NHibernate.Dialect.PostgreSQLDialect";
props["hibernate.connection.driver_class"] =
"NHibernate.Driver.NpgsqlDriver" ;
props["hibernate.connection.connection_string"] =
"Server=10.128.23.155;Port=5432;User Id=alejandro;Password=alejandro;Database=NTest;" ;
props["hibernate.cache.provider_class"]="NHibernate.Cache.HashtableCacheProvider, NHibernate" ;
props["hibernate.cache.use_query_cache"]= "true" ;
props["hibernate.use_reflection_optimizer"] = "false" ;
props["show_sql"] = "false" ;
foreach( DictionaryEntry de in props )
{
config.SetProperty( de.Key.ToString(), de.Value.ToString() );
}
config.AddAssembly("Prision");
ISessionFactory fact = config.BuildSessionFactory() ;
ISession sesion = fact.OpenSession();
ITransaction st = sesion.BeginTransaction() ;
Imagenes nueva = (Imagenes)sesion.Load(typeof(Imagenes),"1") ;
st.Commit();
sesion.Close() ;
Any help???
Please!!!!
Login
FAQ
Search
