How to insert data to the exist table by using Hibernate...

yumeiqiu · **Joined:** Mon Jun 21, 2004 3:43 pm **Posts:** 19

I can create the table and insert the data to that blank table. But I
couldn't insert new data to the exist table. For example,

I already have one user table have several rows record like this in MySQL Database:

UID Uname
1 Apple
2 Banana
3 Cat

Then if I would like to insert the new user " Dog" in to this table
and automatic generate the UID as 4. How to do that?

anthony · **Posted:** Thu Jun 24, 2004 3:34 pm

show mapping files, and java code

yumeiqiu · **Joined:** Mon Jun 21, 2004 3:43 pm **Posts:** 19

Here is my mapping file:

Code:

-
   <hibernate-mapping>
-
   <!--
 
    Created by the Middlegen Hibernate plugin

    http://boss.bekk.no/boss/middlegen/
    http://hibernate.sourceforge.net/
-->
-
   <class name="test.User" table="users">
-
   <id name="uno" type="java.lang.Integer" column="Uno">
<generator class="assigned"/>
</id>
<property name="uname" type="java.lang.String" column="UName" not-null="true" length="25"/>
<!-- associations -->
<!-- bi-directional one-to-many association to Model -->
-
   <set name="models" lazy="true" inverse="true">
-
   <key>
<column name="Uno"/>
</key>
<one-to-many class="test.Model"/>
</set>
</class>
</hibernate-mapping>

And this is my code

Code:

package test;

import net.sf.hibernate.Session;
import net.sf.hibernate.Transaction;
import net.sf.hibernate.SessionFactory;
import net.sf.hibernate.cfg.Configuration;
import net.sf.hibernate.tool.hbm2ddl.SchemaExport;
import net.sf.hibernate.Query;
import net.sf.hibernate.Hibernate;
import net.sf.hibernate.type.LongType;

  public class trytest {
    public trytest() {
    }

    public static void main(String[] args) throws Exception {
      Configuration cfg = new Configuration().addClass(User.class);

   //   new SchemaExport(cfg).create(true, true);

      //sessionFactory
      SessionFactory sessions = cfg.buildSessionFactory();
      //sessionFactory
      Session session = sessions.openSession();
      //
     Transaction tx = session.beginTransaction();

        User u1= new User("Maple");

        session.save(u1);
        session.flush();
    
      tx.commit();

      session.close();

      session.close();
        
    }

  }

anthony · **Posted:** Fri Jun 25, 2004 2:41 am

your id is "assigned" so you have to set it before calling .save()

yumeiqiu · **Joined:** Mon Jun 21, 2004 3:43 pm **Posts:** 19

Thank you, I got it!