How to change the default value that hibernate inserts for Primary key field?

Question

I have class called users, in which I have a primary key userid ... Now when I put the object of this class in MYSql dataabase which creates a table named users, Hibernate puts a default row with primary key having value 0 and rest of the fields as null...

When I use @Column(name="userid", Columndefintion="int default -1") it still puts the value for userid as 0 which I don`t want.

USER.Java
package schema;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Lob;
import javax.persistence.Table;



    @Entity
    public class users {

            @Id
            public int userid;

        private String username;
        private String pw;
        private String fname;
        private String lname;
        private String gender;
        private String dob;
        private String jdate;
        private String ldate;
        private String address;
        private String email;
        private String tel;

        @Column(name="pic")
        @Lob
        private byte[] pic;

        @Column(name="tpic")
        @Lob
        private byte[] tpic;

        public int getUserid() {
            return userid;
        }
        public void setUserid(int userid) {
            this.userid = userid;
        }
        public String getUsername() {
            return username;
        }
        public void setUsername(String username) {
            this.username = username;
        }
        public String getPw() {
            return pw;
        }
        public void setPw(String pw) {
            this.pw = pw;
        }
        public String getFname() {
            return fname;
        }
        public void setFname(String fname) {
            this.fname = fname;
        }
        public String getLname() {
            return lname;
        }
        public void setLname(String lname) {
            this.lname = lname;
        }
        public String getGender() {
            return gender;
        }
        public void setGender(String gender) {
            this.gender = gender;
        }
        public String getDob() {
            return dob;
        }
        public void setDob(String dob) {
            this.dob = dob;
        }
        public String getJdate() {
            return jdate;
        }
        public void setJdate(String jdate) {
            this.jdate = jdate;
        }
        public String getLdate() {
            return ldate;
        }
        public void setLdate(String ldate) {
            this.ldate = ldate;
        }
        public String getAddress() {
            return address;
        }
        public void setAddress(String address) {
            this.address = address;
        }
        public String getEmail() {
            return email;
        }
        public void setEmail(String email) {
            this.email = email;
        }
        public String getTel() {
            return tel;
        }
        public void setTel(String tel) {
            this.tel = tel;
        }
        public byte[] getPic() {
            return pic;
        }
        public void setPic(byte[] pic) {
            this.pic = pic;
        }
        public byte[] getTpic() {
            return tpic;
        }
        public void setTpic(byte[] tpic) {
            this.tpic = tpic;
        }


}


Hibernate.cfg.xml

<?xml version='1.0' encoding='utf-8'?>
<!--
  ~ Hibernate, Relational Persistence for Idiomatic Java
  ~
  ~ Copyright (c) 2010, Red Hat Inc. or third-party contributors as
  ~ indicated by the @author tags or express copyright attribution
  ~ statements applied by the authors.  All third-party contributions are
  ~ distributed under license by Red Hat Inc.
  ~
  ~ This copyrighted material is made available to anyone wishing to use, modify,
  ~ copy, or redistribute it subject to the terms and conditions of the GNU
  ~ Lesser General Public License, as published by the Free Software Foundation.
  ~
  ~ This program is distributed in the hope that it will be useful,
  ~ but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
  ~ or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU Lesser General Public License
  ~ for more details.
  ~
  ~ You should have received a copy of the GNU Lesser General Public License
  ~ along with this distribution; if not, write to:
  ~ Free Software Foundation, Inc.
  ~ 51 Franklin Street, Fifth Floor
  ~ Boston, MA  02110-1301  USA
  -->
<!DOCTYPE hibernate-configuration PUBLIC
        "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">

<hibernate-configuration>

    <session-factory>

        <!-- Database connection settings -->
        <property name="dialect">org.hibernate.dialect.MySQLDialect</property>
        <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
        <property name="connection.url">jdbc:mysql://localhost:3306/bg</property>
        <property name="connection.username">root</property>
        <property name="connection.password"/>


        <!-- JDBC connection pool (use the built-in) -->
        <property name="connection.pool_size">1</property>


        <!-- Echo all executed SQL to stdout -->
        <property name="show_sql">true</property>

        <!-- Drop and re-create the database schema on startup -->
        <property name="hbm2ddl.auto">update</property>

        <mapping class="schema.friendship"/>
        <mapping class="schema.users"/>
        <mapping class="schema.resources"/>
        <mapping class="schema.manipulation"/>



    </session-factory>

</hibernate-configuration>

Is there a way I can insert a different default value coz when I try to load data again after creation, when I try to insert userid=0 it says Caused by: java.sql.BatchUpdateException: Duplicate entry '0' for key 'PRIMARY'

Also using hbm2ddl.auto as update does not update that existing 0,null,null ... column.. why?

Answer 1

If what you want is to have a different value automatically assigned to the userid column for each row, you can use the @GeneratedValue annotation, e.g.:

@Id @GeneratedValue(strategy=GenerationType.TABLE)
public int userid;

See the JPA/Hibernate doc for the different generation strategies available.