Hibernate Community • View topic - Help nedded with Varchar2 as a Primary Key

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

Help nedded with Varchar2 as a Primary Key

Page 1 of 1

[ 4 posts ]

Previous topic | Next topic

Author

Message

p_kumar81

Post subject: Help nedded with Varchar2 as a Primary Key

Posted: Tue Jan 10, 2006 11:57 pm

Beginner

Joined: Mon Jan 09, 2006 8:02 am
Posts: 22

I am trying to use Varchar2 as a primary key in my Oracle table.

Loginid varchar2(10)

Now when i try and create a mapping in my XML File it reads as

<id name="Id" column="LogonId">
<generator class="native" />
</id>

My class has this defined as a string.

Now this throws an Run Time exception of "Identifier Type Mismatch".

When i change this to Number and Integer in Oracle and Class File it works perfectly Fine. Any ideas what this error could be

Regards

Prasanth

Top

k-dub

Post subject:

Posted: Wed Jan 11, 2006 12:52 am

Contributor

Joined: Thu May 12, 2005 8:45 am
Posts: 226

What happens when you set the generator class to "assigned"?

Top

sandipandeb

Post subject:

Posted: Wed Jan 11, 2006 1:45 am

Beginner

Joined: Mon Oct 17, 2005 1:58 am
Posts: 27

Unless the primary case is an auto incremental numeric field you should not use generator class=native.

You should use generator class=assigned

Top

p_kumar81

Post subject:

Posted: Wed Jan 11, 2006 2:49 am

Beginner

Joined: Mon Jan 09, 2006 8:02 am
Posts: 22

Thankz for the Help. I had some basic programming Error. Its Now solved.

Top

Page 1 of 1

[ 4 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