persisting in J2SE

noamg · **Posted:** Thu Jul 27, 2006 1:09 pm

Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 3.2 rc2

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using: sqlserver 2005 express

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

I am just starting out here. Finally got a connection to the database, and my queries don't throw exceptions, but when I try to persist, I don't get anything int he database. I am working on J2SE 5 - is there some kind of special way to access the entityManager so that the persist will get to the database?

thanks for the tips.

Code:

Book book = new Book("test");
      entityManager.persist(book);

poswald · **Joined:** Wed Apr 26, 2006 2:41 pm **Posts:** 30

That should work as soon as you commit... J2SE code usually defers the commit until the end. Show us all the code where you're getting the EntityManager and your entity mappings.

noamg · **Posted:** Thu Jul 27, 2006 5:32 pm

here's my test, quite simple.
The book class has a generated Integer id, and String title, both with corresponding get/set methods.

Code:

public class BookTest {
   private static EntityManagerFactory entityManagerFactory;
   private EntityManager entityManager;

   @BeforeClass
   public static void setUpBeforeClass() throws Exception {
      try {
         entityManagerFactory = Persistence
               .createEntityManagerFactory("dnd");
      } catch (Exception e) {
         System.out.println(e);
      }
   }

   @AfterClass
   public static void tearDownAfterClass() throws Exception {
      if (entityManagerFactory != null) {
         entityManagerFactory.close();
      }
   }

   @Before
   public void setUp() throws Exception {
      entityManager = entityManagerFactory.createEntityManager();
   }

   @After
   public void tearDown() throws Exception {
      if (entityManager != null) {
         entityManager.close();
      }
   }

   @Test
   public void testPersistBook() {
      Book book = new Book("test");
      entityManager.persist(book);
   }

   @Test
   public void testGetBook() {
      List<Book> books = entityManager.createQuery(
            "from Book b where b.title = 'test'").getResultList();
      assertNotNull(books);
      System.out.println(books.size());
   }
}

The first test works, in that it doesn't throw any exceptions.
The second just shows there are 0 books in the database, and I also just check at the table itself to see it myself.
what can cause it?

emmanuel · **Posted:** Fri Jul 28, 2006 2:22 pm

em.getTransaction().begin()

noamg · **Posted:** Sat Jul 29, 2006 9:01 am

that's what I needed..