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? View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4055015#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...