Stock

The Stock class is used to represent a snapshot of a company's stock in the database.

Add appropriate annotations to the class, so that Hibernate maps it in the following way:

The id field should be the primary key, which should be generated when the object is saved.
The companyName field should be mapped to the "company_name" column in the database.
The price field should be mapped to the "price" column in the database, it should never be null.

Java SE 13, Hibernate 5.4

Show starting code

import java.util.*;
import java.util.logging.*;
import javax.persistence.*;
import org.hibernate.*;
import org.hibernate.cfg.*;
import org.hibernate.query.Query;

public class Stock {
    private Integer id;

    private String companyName;

    private Integer price;

    public int getId() {
        return id;
    }
    
    public void setId(Integer id) {
        this.id = id;
    }
    
    public String getCompanyName() {
        return companyName;
    }
    
    public void setCompanyName(String companyName) {
        this.companyName = companyName;
    }
    
    public Integer getPrice() {
        return price;
    }
    
    public void setPrice(Integer price) {
        this.price = price;
    }
    
    public static void main(String[] args) {
        LogManager logManager = LogManager.getLogManager();
        Logger logger = logManager.getLogger("");
        logger.setLevel(Level.OFF);

        Properties prop = new Properties();

        prop.setProperty("hibernate.connection.url", "jdbc:h2:mem:db1");
        prop.setProperty("dialect", "org.hibernate.dialect.H2Dialect");
        prop.setProperty("hibernate.hbm2ddl.auto", "create");

        SessionFactory sessionFactory = new Configuration().addProperties(prop)
            .addAnnotatedClass(Stock.class).buildSessionFactory();
        
        Session session = sessionFactory.openSession();
        session.beginTransaction();
        Stock stock = new Stock();
        stock.setCompanyName("Big company");
        stock.setPrice(1000);

        session.save(stock);
        session.flush();
        Query<Stock> query = session.createQuery("FROM Stock", Stock.class);
        List<Stock> stocks = query.list();
        for(Stock st : stocks) {
            System.out.println(st.getId());
            System.out.println(st.getCompanyName());
            System.out.println(st.getPrice());
        }
    }
}

The id field is correctly mapped: org.hibernate.MappingException
The companyName field is correctly mapped: org.hibernate.MappingException
The price field is correctly mapped: org.hibernate.MappingException
The id field is auto generated and is the id of the entity: org.hibernate.MappingException

Use this question for your test

<< Previous Next >> Back to questions

Score Distribution

# of candidates

0-33%
34-67%
68-100%

Score

Would you like to see our other questions?

We have 1000+ premium hand-crafted questions for 160+ job skills and 20+ coding languages. We prefer questions with small samples of actual work over academic problems or brain teasers.

Visit our question library

Private Concierge

Send us an email with an explanation of your testing needs and a list of candidates. We will create an appropriate test, invite your candidates, review their results, and send you a detailed report.

Contact Private Concierge

Would you like to see our tests? The following tests contain Java Hibernate related questions:

Java and Hibernate Online Test

Java, Hibernate, and Spring Boot Online Test

Java, Hibernate, and Spring Framework Online Test

On the TestDome Blog

Screening Applicants: The Good, the Bad and the Ugly

Since we’re all biased and we use incorrect proxies, why not just outsource hiring to experts or recruitment agencies? After all, they’ve been screening people for many years, so they must know how to do it right?

Not really. I was surprised to discover that many experts disagree with each other. Everybody praises their pet method and criticizes the others. Many of these methods look legitimate, but are based on...