How can i insert a row using hibernate method?

Question

I am trying to insert a row into a relation table Stock Category.

I am following this example: http://www.mkyong.com/hibernate/hibernate-many-to-many-example-join-table-extra-column-annotation/

Now I already have data in table stock and category.

Later I want to associate a stock and category to each other.

How I can do this without writing a custom sql query?

Is it possible if I can add StockCategory like this?

Stock stock = new Stock();
stock.setStockId(1);
Category category = new Category();
category.setCategoryId(1);
StockCategory stockCategory = new StockCategory();

stockCategory.setStock(stock); //here you need to get the stock object by id 
stockCategory.setCategory(category1); //here you need to get the category1 object by id
stockCategory.setCreatedDate(new Date()); //extra column
stockCategory.setCreatedBy("system"); //extra column
session.save(stockCategory );

Thanks in advance.

where are some fields like nullable = false.You need to set values to those — PSR
– PSR, Commented Mar 18, 2013 at 14:23

kometen · Accepted Answer · 2016-10-30 15:50:18Z

6

StockCategory stockCategory = new StockCategory();

stockCategory.setStock(stock); //here you need to get the stock object by id
stockCategory.setCategory(category1); //here you need to get the category1 object by id
stockCategory.setCreatedDate(new Date()); //extra column
stockCategory.setCreatedBy("system"); //extra column
session.save(stock);

It is also there

edited Oct 30, 2016 at 15:50

kometen

8,1306 gold badges48 silver badges64 bronze badges

answered Mar 18, 2013 at 13:37

PSR

40.4k43 gold badges115 silver badges154 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Thinker Over a year ago

If I have other fields of stock and category as null . Will it still works?

PSR Over a year ago

if you specified the fields are not null it will throw exception.If they are nullable no problem.

PSR Over a year ago

@Thinker Did not specified in the example as nullable = false.So by default they are nullable.So no problem for u

PSR Over a year ago

@Thinker did you understand now

Thinker Over a year ago

No.You dint get my point. I have a new Stock having id as 11. And new Category having id as 12. Now these two link does not have a row in stockcategory table . Then I just want to insert a new row in stockcategory table. I dont want to update user.

|

Peter Campbell · Accepted Answer · 2013-03-18 13:51:58Z

2

An ORM like Hibernate map Java objects to the datasource and create a model of this data, then you create and update the objects and call a save subroutine to update the model. The Insert/Update/Delete SQL commands are done by the ORM library.

So in the example of creating a new object, the datasource is not updated until session.save(stock) is called.

   session.beginTransaction();

    Stock stock = new Stock();
    stock.setStockCode("7052");
    stock.setStockName("PADINI");

    //assume category id is 7
    Category category1 = (Category)session.get(Category.class, 7);

    StockCategory stockCategory = new StockCategory();
    stockCategory.setStock(stock);
    stockCategory.setCategory(category1);
    stockCategory.setCreatedDate(new Date()); //extra column
    stockCategory.setCreatedBy("system"); //extra column

    stock.getStockCategories().add(stockCategory);

    session.save(stock);

    session.getTransaction().commit();

answered Mar 18, 2013 at 13:51

Peter Campbell

6711 gold badge7 silver badges35 bronze badges

1 Comment

Nik Over a year ago

This is exactly what I wanted to know.

Sashi · Accepted Answer · 2013-03-18 14:27:20Z

As long as you define appropriate relationships, your code will work. For example - if your StockCategory.java looks something like this, then what you are doing will work.

Class StockCategory{

     @ManyToOne(...)
     private Stock stock;

     @ManyToOne(...)
     private Category category;
}

Then the following code will work. You don't have to populate other fields in Stock and Category.

    Stock stock = new Stock();
    stock.setStockId(1);
    Category category = new Category();
    category.setCategoryId(1);
    StockCategory stockCategory = new StockCategory();

    stockCategory.setStock(stock); 
    stockCategory.setCategory(category1); 
    stockCategory.setCreatedDate(new Date()); //extra column
    stockCategory.setCreatedBy("system"); //extra column
    session.save(stockCategory );

Collectives™ on Stack Overflow

How can i insert a row using hibernate method?

3 Answers 3

6 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

6 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related