Thought I'd repost this over here.

I'm testing out nHibernate with oracle 8i databases. In both instances I'm getting

Exception: System.Data.OracleClient.OracleException
Message: ORA-12704: character set mismatch

If I use an expression with createcriteria.

If I just do a list I can retrieve all the rows just fine. Regular ADO using the client libraries works just fine.

In once instance the column is a char(12) and in another it's a varchar2(1).

First database NLS_LANG=american_america.WE8ISO8859P1
Second is american_america.US7ASCII.

Code snip:

IList allCompanys = session.CreateCriteria(typeof(FileType))
.Add(Expression.Eq(field, fldValue))
.List();

Is there some way to set the charset? I do use hibernate without problems with Java.

Is there maybe some connection string parameter will set the charset? Does this happen with HQL queries? I'm not familiar with Oracle, so I can't help much, unfortunately.

I'll have to check to see if there are any parameter that can be passed. Here is the log file. I tried to format it a little nicer. What I don't understand is that if I use System.Data.OracleClient with a parapared statement it works just fine.

NHibernate.Impl.BatcherImpl [] <> - about to open: 0 open IDbCommands, 0 open DataReaders

NHibernate.Impl.BatcherImpl [] <> - Building an IDbCommand object for the SqlString: SELECT this.file_type as file_type0_, this.created_userid as created_3_0_, this.description as descript2_0_, this.created_dtm as created_4_0_ FROM av49_file_type this WHERE (this.file_type = :this.file_type)

NHibernate.Type.NullableType [] <> - binding 'S' to parameter: 0
2005-05-13 13:49:19,468 [3196] INFO NHibernate.Loader.Loader [] <> - SELECT this.file_type as file_type0_, this.created_userid as created_3_0_, this.description as descript2_0_, this.created_dtm as created_4_0_ FROM av49_file_type this WHERE (this.file_type = :p0)

NHibernate.Impl.BatcherImpl [] <> - Preparing SELECT this.file_type as file_type0_, this.created_userid as created_3_0_, this.description as descript2_0_, this.created_dtm as created_4_0_ FROM av49_file_type this WHERE (this.file_type = :p0)

NHibernate.Connection.DriverConnectionProvider [] <> - Obtaining IDbConnection from Driver

NHibernate.Impl.BatcherImpl [] <> - done closing: 0 open IDbCommands, 0 open DataReaders

Here is the problem, but I'm not sure what is causing it.

In this function...

protected virtual IDbDataParameter GenerateParameter( IDbCommand command, string name, Parameter parameter, Dialect.Dialect dialect )


If I comment out this line it works fine.
//dbParam.DbType = parameter.SqlType.DbType;

When the DbType was getting set it was being set to NVarChar2 while the OciType was a VarChar2. Any way to step into that call to see what is happening.

This was the value of DbType.
parameter.SqlType.DbType = String System.Data.DbType


In my class "FileType" this is the field.
[NHibernate.Mapping.Attributes.Id("file_type", typeof(NHibernate.Id.Assigned))]

I'm using attributes. I tried to also set the property value, but everything I tried failed.

If I set the DbType to AnsiString or nothing it works fine.

op.DbType = System.Data.DbType.AnsiString;

The metaData now says varchar2 like it should.

<property name="..." type="AnsiString" />

if you're using IQuery

q.SetAnsiString( ... )

http://nhibernate.sourceforge.net/nh-do ... basictypes

Mike

I have the some problem but using a search criteria...