Also with somebody'd suggestion i changed my code to the following
----------------------
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name = "id", nullable = false)
private Integer cNo;
----------------------

But now am getting errException
Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]'last_insert_id' is not a recognized function name.

Any suggestions?

Also i am connecting to SQL sever 2000
My persistence.xml is
<?xml version="1.0" encoding="UTF-8"?>

<persistence-unit name="shoestringPU">
<jta-data-source>java:/SCMSSQLDSS</jta-data-source>
com.j3ltd.server.entities.Person
com.j3ltd.server.entities.Address



</persistence-unit>


I am using SQL Server2000, but am using "org.hibernate.dialect.MySQLDialect" in persistence.xml

I am not sure if that is an issue?

I used


And my problem is resolved :)

Thanks All :)
Regards,
Ruchika