pre configured netbeans project with NoSuchMethodError hibernate and spring conflict

Question

so I'm trying to get my Java Application to connect to SQL Server 2012 through the Microsoft JDBC Driver 4.0 for SQL Server, and everything seems to be going well but hibernate just keeps coming back with NullExceptions and won't execute anything within the try/catch (hence the NullException), I have absolutely no idea why. Here is the pastebin from netbeans console (e.getMessage()) running hibernate (for the purposes of this question, I am using an example table called prime_table).

In the pastebin log, you'll notice ...

Feb 11, 2013 5:21:04 PM org.hibernate.cfg.Configuration doConfigure INFO: Configured SessionFactory: null

any ideas on why this is occuring? (I'm not sure, but it may be relevant to the overall stack trace).

Other logs (During JSP build)

• Netbeans (run)
• Apache tomcat
• Apache tomcat log
• Sql server ERRORLOG.log
• Hibernate throwable stacktrace (Update 2/14/2013)

All logs will be available up until Mid/Late March 2013

Resources, I've been reading

• Hibernate Example
• [Help] Null Pointer Exception in session.flush() Hibernate
• hibernate.cfg.xml not found
• hibernate map java Long to MySQL BIGINT error

Pre Configured Netbeans Project Setup commandline: tree /f

_{(source: iforce.co.nz)}

Hibernate.cfg.xml (Added "hibernate.cache.provider_class" as suggested by Hari)

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
  <session-factory>
    <property name="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</property>
    <property name="hibernate.connection.driver_class">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>
    <property name="hibernate.connection.url">jdbc:sqlserver://Michael-PC:1433;databaseName=PrimeDB</property>
    <property name="hibernate.connection.username">sa</property>
    <property name="hibernate.connection.password">online12</property>
    <property name="hibernate.connection.pool_size">10</property>
    <property name="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</property>
    <property name="hibernate.show_sql">true</property>
    <property name="hibernate.hbm2ddl.auto">update</property>
    <!-- Data Mappings -->
    <mapping resource="prime.hbm.xml"/>
  </session-factory>
</hibernate-configuration>

Prime

public class Prime {

    private long prime;

    public void setPrime(long nPrime){
        this.prime = nPrime;
    }

    public long getPrime(){
        return this.prime;
    }

}

prime.hbm.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
  <class name="nz.co.xyleap.db.Prime" table="prime_table">
    <id name="prime" type="long" column="prime" />
  </class>
</hibernate-mapping>

Prime Table

CREATE TABLE prime_table (
    [prime] bigint PRIMARY KEY NOT NULL,
)

Session function or FirstExample.java

public class FirstExample {

    public static void main(String[] args) {
        FirstExample ex = new FirstExample();
        ex.session();
    }

    public void session() {
        Session session = null;
        try {
            // This step will read hibernate.cfg.xml and prepare hibernate for use
            SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
            session = sessionFactory.openSession();
            session.beginTransaction();
            //Create new instance of Contact and set values in it by reading them from form object
            System.out.println("inserting record 13");
            Prime p = new Prime();
            p.setPrime(13);
            session.save(p);
            System.out.println("Done");
        } catch (Exception e) {
            System.out.println(e.getMessage());
        } finally {
            // Actual contact insertion will happen at this step
            session.flush();
            session.close();
        }
    }

}

As far as I know everything should be correct, and I should be able to insert records from Java Hibernate to my SQL database. But for some reason I can't :-/

UPDATE : Hibernate on its own, runs fine. But in conjunction with Spring, these errors occur. (More information in comments).

Answer 1

It looks like you're missing a library that Hibernate needs at run time. I saw the same behavior as you with your code (MySQL 5, MySQL JDBC driver, Mac OS) until I changed the line:

catch (Exception e) {
      System.out.println(e.getMessage());
}

To:

catch (Throwable e) {
       e.printStackTrace();
}

I then started seeing a whole set of NoClassDefFoundError and ClassNotFoundError messages about libraries that Hibernate was looking for but were not included in my CLASSPATH. I suspect that you're missing a library that Hibernate needs, and because you're catching Exception and not Throwable - which catches Error - you're not seeing the error message. See:

Why catch Exceptions in Java, when you can catch Throwables?

If you catch the Throwable you'll see fairly quickly what libraries and classes you're missing: my guess would be that you're probably missing EHCache (which Hibernate seems to use as a second-level cache by default), CGLIB/ASM, or the Java Transaction API. If you're missing EHCache and you want hibernate to use its own, in-memory Hashtable cache instead of EHCache, add the line below to hibernate.cfg.xml:

<property name="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</property>

Update, based on comments to answer:

I don't use NetBeans and so I haven't run into this problem, but it appears fairly widespread. See:

Error : java.lang.NoSuchMethodError: org.objectweb.asm.ClassWriter.<init>(I)V

http://www.hildeberto.com/2008/05/hibernate-and-jersey-conflict-on.html (Reports a similar problem with Hibernate and Jersey in Netbeans)

https://hibernate.onjira.com/browse/HHH-2222 (Hibernate bug report mentioning this problem)

http://netbeans.org/bugzilla/show_bug.cgi?id=145589 (Netbeans bug report for bundled Hibernate using older versions of cglib).

The StackOverflow post linked to above has quite a lot of detail. To summarize:

• Hibernate 3.2 uses CGLib 2.1.3 for run-time code generation, to improve performance and to generate proxies for one-to-one and one-to-many mappings.

• CGLib is a higher-level wrapper around ASM, a bytecode manipulation library. CGLib 2.1.3 requires ASM 1.5.3, which is binary incompatible with ASM 2.2. ASM 2.2 in turn is a dependency for Spring versions < 2.5.

• To resolve these problems between Hibernate and Spring, Spring 2.5 bundles its own version of asm with a spring package name; later versions of Hibernate use CGLIB 2.2, which also bundles its own version of ASM with a custom package name. The most recent versions of Hibernate do away with CGLIB altogether and use Javassist instead, but NetBeans still bundles Hibernate 3.2.5.

You have a few options, then:

• Update the Hibernate library package in Netbeans with CGLIB 2.2

• Tell Hibernate to use Javassist for runtime code generation. Add this line to hibernate.properties, or specify it as a system property using -D (you can't specify this property in hibernate.cfg.xml, apparently):

  hibernate.bytecode.provider=javassist

Good luck, this has been rather an interesting question!

Answer 2

It is dying at session.flush(); because session is null and something in the try-block is throwing an exception, probably a runtimeexception like nullpointer or something. The fact that the session is null will cause another nullptr and it will hide the original one. So I suggest that you make it

if(session!=null)
{
    session.flush();
    session.close();
}

and then run it to see what the actual problem is.

I also suggest that you replace the "System.out.println(e.getMessage());" with atleast e.printStackTrace(); or preferably proper logging.