notes on schuchert jpa tutor 4

finally the last tutor at http://schuchert.wikispaces.com/JPA+Tutorial+4+-+Inheritance+and+Polymorphic+Queries

lets move!

• remember to rename BookAlreadyCheckedOut as ResourceAlreadyCheckedOut and BookNotCheckedOut as ResourceNotCheckedOut to get rid of compilation errors.
• the same issue as in http://hilaltarakci.blogspot.com/2009/10/notes-on-schuchert-jpa-tutor-3.html

now, all tests should pass..

well, time to go to my own project, thanks to schuchert, tutors are really helpful :)

notes on schuchert jpa tutor 3

now the tutor i follow is http://schuchert.wikispaces.com/JPA+Tutorial+3+-+A+Mini+Application

lets see what happens..

so perfect, just in test methods of LibraryTest, the assertEquals methods used to compare floats that take 2 params are deprecated. Instead define a delta as follows and pass it as 3rd param to mentioned methods. Thus, tests will pass i think :)

private static final float DELTA = (float) 0.0;


...

assertEquals(.., .., DELTA);

notes on schuchert jpa tutor 2

the tutor is at http://schuchert.wikispaces.com/JPA+Tutorial+2+-+Working+with+Queries+1

lets follow..

• comment out the exception in the  unsuccessfulSingleResultTooManyEntries  test case of QueriesTest.. thus, it will pass..

 @Test// (expected = NonUniqueResultException.class)

    public void unsuccessfulSingleResultTooManyEntries() {

insertPerson();

        insertPerson();




        // This will fail because we expect a single result

        // but in fact there are 2 results returned.

        em.createQuery("from Person").getSingleResult();

    }

this is because,  getSingleResult() does not get angry when there are more than one records and just picks the first one..

notes on schuchert jpa tutor 1

i am following schuchert's jpa tutor 1 at http://schuchert.wikispaces.com/JPA+Tutorial+1+-+Getting+Started

however, my environment is netbeans 6.5 + glassfish v2 + postgre..

lets note down some drawbacks i faced:

• i get the following error while trying to run PersonTest :
  

Testcase: emptyTest(entity.PersonTest):        Caused an ERROR

[PersistenceUnit: SchuchertJpaTutor1PU] Unable to build EntityManagerFactory

javax.persistence.PersistenceException: [PersistenceUnit: SchuchertJpaTutor1PU] Unable to build EntityManagerFactory

        at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:677)

        at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:126)

        at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:51)

        at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:33)

        at entity.PersonTest.initEmfAndEm(PersonTest.java:24)

Caused by: org.hibernate.HibernateException: Could not find datasource

        at org.hibernate.connection.DatasourceConnectionProvider.configure(DatasourceConnectionProvider.java:56)

        at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:124)

        at org.hibernate.ejb.InjectionSettingsFactory.createConnectionProvider(InjectionSettingsFactory.java:29)

        at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:62)

        at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2009)

        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1292)

        at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:859)

        at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:669)

Caused by: javax.naming.NoInitialContextException: Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file:  java.naming.factory.initial

        at javax.naming.spi.NamingManager.getInitialContext(NamingManager.java:645)

        at javax.naming.InitialContext.getDefaultInitCtx(InitialContext.java:288)

        at javax.naming.InitialContext.getURLOrDefaultInitCtx(InitialContext.java:325)

        at javax.naming.InitialContext.lookup(InitialContext.java:392)

        at org.hibernate.connection.DatasourceConnectionProvider.configure(DatasourceConnectionProvider.java:52)

Testcase: emptyTest(entity.PersonTest):        Caused an ERROR

null

java.lang.NullPointerException at entity.PersonTest.cleanup(PersonTest.java:31)

Test entity.PersonTest FAILED

to fix:

- use in memory database in unit tests with persistence.xml as follows:

<?xml version="1.0" encoding="UTF-8"?>

<persistence version="1.0" xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">

<persistence-unit name="SchuchertJpaTutor1TestPU" transaction-type="RESOURCE_LOCAL">

    <provider>org.hibernate.ejb.HibernatePersistence</provider>

    <non-jta-data-source></non-jta-data-source>

    <exclude-unlisted-classes>false</exclude-unlisted-classes>

    <properties>

        <property name="hibernate.connection.url" value="jdbc:hsqldb:mem:unit-testing-jpa"/>

        <property name="hibernate.connection.driver_class" value="org.hsqldb.jdbcDriver"/>

        <property name="hibernate.dialect" value="org.hibernate.dialect.HSQLDialect"/>

        <property name="hibernate.hbm2ddl.auto" value="create-drop"/>

        <property name="hibernate.connection.username" value="sa"/>

        <property name="hibernate.connection.password" value=""/>

    </properties>

  </persistence-unit>

</persistence>

- add hsqldb.jar and (possibly) servlet.jar to test libs 

and run the test again, it should pass now..

(more on http://eskatos.wordpress.com/2007/10/15/unit-test-jpa-entities-with-in-memory-database/)

• when Address is added to Person, delete the final keyword from getter and setter methods for address.(it results in compile error..)

the project is here: http://schuchert.wikispaces.com/JPA+Tutorial+1+-+Entire+Source+Base

i will continue with the next tutorial, so see you at the next blog entry :)

jpa tutorial

the tutor to be followed: http://schuchert.wikispaces.com/JPA+Tutorial+1+-+Getting+Started

linked from http://schuchert.wikispaces.com/EJB+3+and+Java+Persistence+API

TODO: details soon..

Edit on 04/10/2009 at 14:10: http://hilaltarakci.blogspot.com/2009/10/notes-on-schuchert-jpa-tutor-1.html

Edit on 05/10/2009 at 17:30:http://hilaltarakci.blogspot.com/2009/10/notes-on-schuchert-jpa-tutor-2.html

Edit on 06/10/2009 at 10:53: http://hilaltarakci.blogspot.com/2009/10/notes-on-schuchert-jpa-tutor-3.html

Edit on 06/10/2009 at 14:32: http://hilaltarakci.blogspot.com/2009/10/notes-on-schuchert-jpa-tutor-4.html

jpa annotation reference documentation

for jpa annotations 

• http://www.oracle.com/technology/products/ias/toplink/jpa/resources/toplink-jpa-annotations.html   --> very famous reference
• http://www.jpox.org/docs/1_2/jpa/annotations.html
  

for hibernate annotations

• http://docs.jboss.org/hibernate/stable/annotations/reference/en/html_single/ ,  same documentation at a different address  http://docs.huihoo.com/hibernate/annotations-reference-3.2.1/
  
• http://tadtech.blogspot.com/2007/09/hibernate-association-mappings-in.html --> only the associations
  
• http://www.roseindia.net/hibernate/ --> with code samples :)

hibernate association mappings

excellent documentation :)

http://tadtech.blogspot.com/2007/09/hibernate-association-mappings-in.html