I am using an entity bean to create my table in MySQL4.1.13 I have a table called user which has userid,username,password as its columns. The userid is a primary key over here. But I want the user name to be unique. I.e if a user with the name 'Adrian' is present in the database then another user with this user name should not be created.
I have been told that you can configure a unique key in jbosscmp-jdbc.xml using insert-after-ejb-post-create.
But i dont know how to use it. Can anyone give me a sample code for using this.