Hibernate Community • View topic - SQL Server identity not generated in the Mapping Files

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

SQL Server identity not generated in the Mapping Files

Page 1 of 1

[ 5 posts ]

Previous topic | Next topic

Author

Message

leela.a

Post subject: SQL Server identity not generated in the Mapping Files

Posted: Mon Jun 15, 2009 11:41 am

Newbie

Joined: Mon Jun 15, 2009 10:51 am
Posts: 4

Hello,

I am using SQL Server 2005. I am generating the Mapping Files and Domain Objects using the Eclipse Hibernate Code Generation Tools through Hibernate Plugin for the Eclipse.Almost all my tables have the identity type Primary Key. But in the .hbm.xml files generated, it is not reflected. I see <generator class="assigned"> in the generated Mapping files. I had to change all the generated Mapping Files to point it to identity. I have to do this everytime I generate the Mapping Files. Is this a bug in Hibernate/Hibernate tools of Eclipse? Did anyone face this problem. Am I doing something wrong? Some body please reply me if you have any idea of the issue.

Thanks,
Leela

Top

somu_ngm1

Post subject: Re: SQL Server identity not generated in the Mapping Files

Posted: Tue Jun 16, 2009 8:11 am

Regular

Joined: Wed Jun 20, 2007 1:53 am
Posts: 75

There are lot of generator class like assigned, increment (this require sequence name if DB is Oracle), etc., I think there is no way for Hibernate to identify this generator class from database schema, somehow we have to instruct it in the tool. can you post one of your auto generated mapping file and its correspoding database tabel structure?

Top

leela.a

Post subject: Re: SQL Server identity not generated in the Mapping Files

Posted: Tue Jun 16, 2009 3:00 pm

Newbie

Joined: Mon Jun 15, 2009 10:51 am
Posts: 4

Hello Please find my Users Table structure and the generated mapping file below.
I am giving you the create script for the Table

Users Table:

Code:

CREATE TABLE [dbo].[Users](
   [userid] [int] IDENTITY(1,1) NOT NULL,
   [firstname] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
   [lastname] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
   [password] [varchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
   [phone] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
   [email] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
   [username] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
   [createUser] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
   [createDate] [datetime] NOT NULL,
   [updateUser] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
   [updateDate] [datetime] NULL,
 CONSTRAINT [PK_Users] PRIMARY KEY CLUSTERED 
(
   [userid] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

Users.hbm.xml

Code:

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated Jun 6, 2009 7:40:18 PM by Hibernate Tools 3.2.4.GA -->
<hibernate-mapping>
    <class name="Users" table="Users" schema="dbo" catalog="suiteaccess">
        <id name="userid" type="int">
            <column name="userid" />
            <generator class="assigned" />
        </id>
        <property name="firstname" type="string">
            <column name="firstname" length="30" not-null="true" />
        </property>
        <property name="lastname" type="string">
            <column name="lastname" length="30" not-null="true" />
        </property>
        <property name="password" type="string">
            <column name="password" length="8" not-null="true" />
        </property>
        <property name="phone" type="string">
            <column name="phone" length="20" />
        </property>
        <property name="email" type="string">
            <column name="email" length="50" />
        </property>
        <property name="username" type="string">
            <column name="username" length="50" not-null="true" />
        </property>
        <property name="createUser" type="string">
            <column name="createUser" length="50" not-null="true" />
        </property>
        <property name="createDate" type="timestamp">
            <column name="createDate" length="23" not-null="true" />
        </property>
        <property name="updateUser" type="string">
            <column name="updateUser" length="50" />
        </property>
        <property name="updateDate" type="timestamp">
            <column name="updateDate" length="23" />
        </property>
    </class>
    
 </hibernate-mapping>

Top

somu_ngm1

Post subject: Re: SQL Server identity not generated in the Mapping Files

Posted: Fri Jun 19, 2009 10:34 am

Regular

Joined: Wed Jun 20, 2007 1:53 am
Posts: 75

Hi,

You have defined userid as primary key, so that hibernate tool genrated mapping file with <id> as userid. I think by default its generator class set to 'assigned' .

Which generator class(assigned,increment,etc.,) would you expect to be mapped in generated mapping files?

which DB are you using?

Top

leela.a

Post subject: Re: SQL Server identity not generated in the Mapping Files

Posted: Mon Jun 22, 2009 12:02 pm

Newbie

Joined: Mon Jun 15, 2009 10:51 am
Posts: 4

I am using SQL Server 2005. I want it to be identity
Is it possible?

Top

Page 1 of 1

[ 5 posts ]

Board index » Hibernate & Java Persistence » Hibernate 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