Hibernate Community • View topic - Any way to force db collation type?

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

Any way to force db collation type?

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

jafin

Post subject: Any way to force db collation type?

Posted: Wed Oct 05, 2005 3:56 am

Beginner

Joined: Mon Aug 15, 2005 11:50 pm
Posts: 22

Dear NHibernate doyens,

I am using NHibernate 0.99 RC2 to cross two databases. One stores user accounts, another stores the programs data.

Code:

<class name="Data.Entities.ProjectRegister.Project" table="ProjectRegister.dbo.Project" lazy="true">

<class name="Data.Entities.Security.Employee" table="Security.dbo.Employee" lazy="true">

I just ran a query to fetch data from both tables and received the SQL error:

Code:

Cannot resolve collation conflict for equal to operation

The security database does not share the same collation type as the Data database. Is there any way I can tell the db via HQL (or another mean) that I want to enforce a certain collation type for one of the tables?

I guess I shouldn't be traversing multiple databases just yet....
:cry:

Thanks,
Jason

Top

jafin

Post subject:

Posted: Thu Oct 06, 2005 12:17 am

Beginner

Joined: Mon Aug 15, 2005 11:50 pm
Posts: 22

I've attempted to fix my issue by modifying the mapping file like so:

Code:

<class name="Data.Entities.Security.Employee,Class" table="Security.dbo.Employee" lazy="true">

      <id name="UserName" type="string">
         <column name="Username" sql-type="varchar(30) collate database_default" unique="true" />
         <generator class="native"/>
      </id>
.....

Unfortunately when the join between the two tables occur using the Username as the Key the collate database_default isn't being shown in the resultant SQL...

This is the log section of the SQL Join that Hibernate spits out:

Code:

left outer join Security.dbo.Employee employee3_ on project0_.ProjectManagerUsername=employee3_.Username

This is what I need it to say to work:
'

Code:

left outer join Security.dbo.Employee employee3_ on project0_.ProjectManagerUsername=employee3_.Username COLLATE database_default

I'll keep playing....

Top

cj_browna

Post subject: Re: Any way to force db collation type?

Posted: Thu Nov 19, 2009 7:50 am

Newbie

Joined: Thu Nov 19, 2009 7:48 am
Posts: 4

did you manage to resolve this as ive got the same issue.

thanks,

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum