Pet DAO

The PetDAO class is used for various database operations on the Pet entity.

Finish the findNamedPetsBySpecies method so that it returns all pets of the appropriate species. The method should not return any Pets whose name field is null. The method accepts a Hibernate Session object that it should use to make the query.

For example, if the Pets table contains:

id  name   species
--------------------
0   Lady   Dog
1   Max    Cat
2   null   Camel

calling findNamedPetsBySpecies with "Cat" as the species, should return a list that contains a pet named "Max" with the id 1.

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 PetDAO {
    
    public List<Pet> findNamedPetsBySpecies(Session session, String species) {
        throw new UnsupportedOperationException("Waiting to be implemented.");
    }
    
    @Entity(name = "Pet")
    @Table
    public static class Pet {
        @Id
        public Integer id;
        @Column
        public String name;
        @Column
        public String species;
        
        public Pet() {}
        
        public Pet(Integer id, String name, String species) {
            this.id = id;
            this.name = name;
            this.species = species;
        }
    }
    
    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(Pet.class).buildSessionFactory();
        
        Session session = sessionFactory.openSession();
        session.beginTransaction();
        
        Pet dog = new Pet(0, "Lady", "Dog");
        Pet cat = new Pet(1, "Max", "Cat");
        Pet camel = new Pet(2, null, "Camel");
        
        session.save(dog);
        session.save(cat);
        session.save(camel);
        session.flush();

        PetDAO petDao = new PetDAO();
        List<Pet> pets = petDao.findNamedPetsBySpecies(session, "Cat");
        for(Pet p : pets) {
            System.out.println(p.id);
            System.out.println(p.name);
            System.out.println(p.species);
        }
    }
}

Example case: java.lang.UnsupportedOperationException at PetDAO.findNamedPetsBySpecies(PetDAO.java:11)
All pets have names: java.lang.UnsupportedOperationException at PetDAO.findNamedPetsBySpecies(PetDAO.java:11)
Some pets don't have names: java.lang.UnsupportedOperationException at PetDAO.findNamedPetsBySpecies(PetDAO.java:11)

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 50+ 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...