Can't connect to MySQL database with Hibernate

[Adam Compton]

Hi, I'm trying to get my program to connect to my database, I've got the connection details here:

MySQL database name: a1847282_animals
MySQL user name: a1847282_adam
Password for MySQL user: passw0rd

Table name: Animals
Field 1: animalID - int size 3
Field 2: animalName - text size 20
Field 3: animalType - text size 20

My Hibernate Config File:

<?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="connection.driver_class">com.mysql.jdbc.Driver</property>
    <property name="dialect">org.hibernate.dialect.MySQLDialect</property>
    <property name="hibernate.connection.url">jdbc:mysql://mysql2.000webhost.com/a1847282_animals</property>
    <property name="hibernate.connection.username">a1847282_adam</property>
    <property name="hibernate.connection.password">passw0rd</property>
    
    <property name="connection.pool_size">1</property> 
    <!-- Enable Hibernate's automatic session context management -->
    <property name="current_session_context_class">thread</property> 
    <!-- Disable the second-level cache -->
    <property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property> 
    <!-- Echo all executed SQL to stdout -->
    <property name="show_sql">true</property>
    
    <!-- Mapping files -->
    <mapping resource="animal.hbm.xml"/>
  </session-factory>
</hibernate-configuration>

My Hibernate Mapping file

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC 
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
  <class name="animaldatabase.Animal" table="Animals">
   <id name="animalID" type="int" column="animalID" >
       <generator class="assigned" />
  </id>
  
  <property name="animalName">
     <column name="animalName" />
  </property>
  <property name="animalType">
    <column name="animalType"/>
  </property>
 </class>
</hibernate-mapping>

My Mapping Class

package animaldatabase;

public abstract class Animal 
{
    protected int animalID;
    protected String animalName;
    protected String animalType;
    
    public Animal(int id, String name)
    {
        this.animalID = id;
        this.animalName = name;
        this.animalType = "Unspecified";
    }
    
    public int getAnimalID()
    {
        return animalID;
    }
    
    public void setAnimalID(int newID)
    {
        this.animalID = newID;
    }
    
    public String getAnimalName()
    {
        return this.animalName;
    }
    
    public void setAnimalName(String newName)
    {
        this.animalName = newName;
    }
    
    public String getAnimalType()
    {
        return this.animalType;
    }
    
    public void setAnimalType(String newType)
    {
        this.animalType = newType;
    }
    
    public String toString(){
      //returns the animal details
      return("Animal ID:= " + getAnimalID() + "\nAnimal Name:= " 
              + getAnimalName() + "\nAnimal Type:= " + getAnimalType());
   } 
}

Here's my code to save data to the database from a List<Animal>

public void saveDatabase() 
    {
        try {
            // Write out Array to the database
             /*This step will read hibernate.cfg.xml and prepare hibernate for use*/
            SessionFactory sessionFactory = new 
                    Configuration().configure().buildSessionFactory();
            session = sessionFactory.openSession();
        
            for(int i = 0; i < animalsList.size(); i++) {
                try {
                    /*Create new instance of Contact and set 
                      values in it by reading them from form object*/
                    System.out.println("Inserting Record");
                
                    AnimalsMapping am = new AnimalsMapping(animalsList.get(i).getAnimalID(),
                        animalsList.get(i).getAnimalName(), animalsList.get(i).getAnimalType());
                    
                    session.save(animalsList.get(i));
                } catch(Exception e){
                    System.out.println(e.getMessage());
                }
            }
        }
        catch(Exception e) {
            System.out.println(e.getMessage());
        }
        finally {
            // Actual contact insertion will happen at this step
            session.flush();
            session.close();
        }
    }

Now when I try and connect I get these errors:

13-May-2011 22:46:32 org.hibernate.cfg.Environment <clinit>
INFO: Hibernate 3.2.5
13-May-2011 22:46:32 org.hibernate.cfg.Environment <clinit>
INFO: hibernate.properties not found
13-May-2011 22:46:32 org.hibernate.cfg.Environment buildBytecodeProvider
INFO: Bytecode provider name : cglib
13-May-2011 22:46:32 org.hibernate.cfg.Environment <clinit>
INFO: using JDK 1.4 java.sql.Timestamp handling
13-May-2011 22:46:32 org.hibernate.cfg.Configuration configure
INFO: configuring from resource: /hibernate.cfg.xml
13-May-2011 22:46:32 org.hibernate.cfg.Configuration getConfigurationInputStream
INFO: Configuration resource: /hibernate.cfg.xml
13-May-2011 22:46:32 org.hibernate.cfg.Configuration addResource
INFO: Reading mappings from resource : animal.hbm.xml
13-May-2011 22:46:32 org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues
INFO: Mapping class: animaldatabase.Animal -> Animals
13-May-2011 22:46:32 org.hibernate.cfg.Configuration doConfigure
INFO: Configured SessionFactory: null
13-May-2011 22:46:32 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Using Hibernate built-in connection pool (not for production use!)
13-May-2011 22:46:32 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Hibernate connection pool size: 1
13-May-2011 22:46:32 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: autocommit mode: false
13-May-2011 22:46:32 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://mysql2.000webhost.com/a1847282_animals
13-May-2011 22:46:32 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: connection properties: {user=a1847282_adam, password=****}
13-May-2011 22:46:54 org.hibernate.cfg.SettingsFactory buildSettings
WARNING: Could not obtain connection metadata
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1118)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343)
	at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2308)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2122)
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:774)
	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:49)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:375)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:289)
	at java.sql.DriverManager.getConnection(DriverManager.java:582)
	at java.sql.DriverManager.getConnection(DriverManager.java:154)
	at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
	at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:84)
	at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2009)
	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1292)
	at animaldatabase.AnimalDatabase.saveDatabase(AnimalDatabase.java:109)
	at animaldatabase.AnimalDatabaseMain.showMainMenu(AnimalDatabaseMain.java:34)
	at animaldatabase.AnimalDatabaseMain.main(AnimalDatabaseMain.java:50)
Caused by: java.net.ConnectException: Connection timed out: connect
	at java.net.PlainSocketImpl.socketConnect(Native Method)
	at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
	at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
	at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
	at java.net.Socket.connect(Socket.java:519)
	at java.net.Socket.connect(Socket.java:469)
	at java.net.Socket.<init>(Socket.java:366)
	at java.net.Socket.<init>(Socket.java:208)
	at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292)
	... 20 more
13-May-2011 22:46:54 org.hibernate.dialect.Dialect <init>
INFO: Using dialect: org.hibernate.dialect.MySQLDialect
13-May-2011 22:46:54 org.hibernate.transaction.TransactionFactoryFactory buildTransactionFactory
INFO: Using default transaction strategy (direct JDBC transactions)
13-May-2011 22:46:54 org.hibernate.transaction.TransactionManagerLookupFactory getTransactionManagerLookup
INFO: No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
13-May-2011 22:46:54 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Automatic flush during beforeCompletion(): disabled
13-May-2011 22:46:54 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Automatic session close at end of transaction: disabled
13-May-2011 22:46:54 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Scrollable result sets: disabled
13-May-2011 22:46:54 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC3 getGeneratedKeys(): disabled
13-May-2011 22:46:54 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Connection release mode: auto
13-May-2011 22:46:54 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Maximum outer join fetch depth: 2
13-May-2011 22:46:54 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Default batch fetch size: 1
13-May-2011 22:46:54 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Generate SQL with comments: disabled
13-May-2011 22:46:54 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Order SQL updates by primary key: disabled
13-May-2011 22:46:54 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Order SQL inserts for batching: disabled
13-May-2011 22:46:54 org.hibernate.cfg.SettingsFactory createQueryTranslatorFactory
INFO: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
13-May-2011 22:46:54 org.hibernate.hql.ast.ASTQueryTranslatorFactory <init>
INFO: Using ASTQueryTranslatorFactory
13-May-2011 22:46:54 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Query language substitutions: {}
13-May-2011 22:46:54 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JPA-QL strict compliance: disabled
13-May-2011 22:46:54 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Second-level cache: enabled
13-May-2011 22:46:54 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Query cache: disabled
13-May-2011 22:46:54 org.hibernate.cfg.SettingsFactory createCacheProvider
INFO: Cache provider: org.hibernate.cache.NoCacheProvider
13-May-2011 22:46:54 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Optimize cache for minimal puts: disabled
13-May-2011 22:46:54 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Structured second-level cache entries: disabled
13-May-2011 22:46:54 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Echoing all SQL to stdout
13-May-2011 22:46:54 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Statistics: disabled
13-May-2011 22:46:54 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Deleted entity synthetic identifier rollback: disabled
13-May-2011 22:46:54 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Default entity-mode: pojo
13-May-2011 22:46:54 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Named query checking : enabled
13-May-2011 22:46:54 org.hibernate.impl.SessionFactoryImpl <init>
INFO: building session factory
Exception in thread "main" java.lang.NullPointerException
	at animaldatabase.AnimalDatabase.saveDatabase(AnimalDatabase.java:133)
	at animaldatabase.AnimalDatabaseMain.showMainMenu(AnimalDatabaseMain.java:34)
	at animaldatabase.AnimalDatabaseMain.main(AnimalDatabaseMain.java:50)
Java Result: 1

[Hauke Ingmar Schmidt]

Hi! Welcome to the Ranch!

Adam Compton wrote:

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

Caused by: java.net.ConnectException: Connection timed out: connect

That doesn't look like a Hibernate problem to me. Can you reach your database by other means?

[Adam Compton]

I'm not sure how else to do it, the only way I can check to see if it worked is to use PHPMyAdmin on the web host site.

I have these namespaces on the class file that handles the saving and loading but I can't get the getSession() method to create queries:

import java.util.*;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
import org.hibernate.Query;
import org.hibernate.SQLQuery;

public void saveDatabase() 
    {
        try {
            // Write out Array to the database
             /*This step will read hibernate.cfg.xml and prepare hibernate for use*/
            SessionFactory sessionFactory = new 
                    Configuration().configure().buildSessionFactory();
            session = sessionFactory.openSession();
        
            for(int i = 0; i < animalsList.size(); i++) {
                try {
                    /*Create new instance of Contact and set 
                      values in it by reading them from form object*/
                    System.out.println("Inserting Record");
                
                    AnimalsMapping am = new AnimalsMapping(animalsList.get(i).getAnimalID(),
                        animalsList.get(i).getAnimalName(), animalsList.get(i).getAnimalType());
                    
                    session.save(animalsList.get(i));
                } catch(Exception e){
                    System.out.println(e.getMessage());
                }
            }
        }
        catch(Exception e) {
            System.out.println(e.getMessage());
        }
        finally {
            // Actual contact insertion will happen at this step
            session.flush();
            session.close();
        }
    }

    public static void loadDatabase() 
    {
        //Read Array in from the database.
        
        try {
            Query q = getSession().createQuery("from Animals");
            List<Animal> list = q.list();
        } catch (Exception ex) {
            System.out.println("Could Not Load Saves");
        } 
   }

[Hauke Ingmar Schmidt]

PHPMyAdmin runs on the server, so it is not helpful in this case.

You could try to connect with the MySql Query Browser from your local machine. Or setup the database connection in your IDE (which is handy anyways, especially when you use the JBoss Hibernate tools later). All IDEs have some means of database browser.

[Hauke Ingmar Schmidt]

Adam Compton wrote:

    <property name="hibernate.connection.url">jdbc:mysql://mysql2.000webhost.com/a1847282_animals</property>

Hm.... and you have to be sure your web host allows connections from outside (i.e. applications not running on the same server) to the database. For security reasons this typically will not be the case. Then you have to setup a local database for development.

[Adam Compton]

I'm quite new to using MySQL in Java and Hibernate, can you tell me how to do it in Netbeans 7?

[Adam Compton]

Okay if I can't link to it from the outside is there a way I can upload the .jar file of the program to the web host and run it from there? It's a console based program.

Also can you tell me what namespace I need to implement to get getSession() to work as well for my loadDatabase method?

[Hauke Ingmar Schmidt]

You can find a tutorial at the Netbeans site.

[Hauke Ingmar Schmidt]

Okay if I can't link to it from the outside is there a way I can upload the .jar file of the program to the web host and run it from there?

I doubt it. You need a shell access and Java installed. Then it is just as any other system, if you want to use it as console tool and not as a web app.

Do you have a dedicated or virtual server? Then yes, you can do whatever you want. Within the typical (cheap) web package? Next to no chance. Most probably you can run PHP there...

[Adam Compton]

I've changed to using a local database within NetBeans and I've almost got it to work but I'm having some issues either regarding the mapping or the way I'm using the sessionfactory.

Configuration file, I think it's working 100% now.

<?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="connection.driver_class">com.mysql.jdbc.Driver</property>
    <property name="dialect">org.hibernate.dialect.MySQLDialect</property>
    <property name="hibernate.connection.url">jdbc:derby://localhost:1527/AnimalsDatabase</property>
    <property name="hibernate.connection.username">AdamCompton</property>  
    <property name="hibernate.connection.password">Passw0rd</property>
    <property name="connection.pool_size">1</property>
    <!-- Enable Hibernate's automatic session context management -->
    <property name="current_session_context_class">thread</property>
    <!-- Disable the second-level cache -->
    <property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>
    <!-- Echo all executed SQL to stdout -->
    <property name="show_sql">true</property>
    <!-- Mapping files -->
    <mapping resource="animal.hbm.xml"/>
  </session-factory>
</hibernate-configuration>

The database is called AnimalsDatabase:
Table: Animals
PK: id - integer
name - varchar
type - varchar

Now the thing I'm confused about is when I created the table the names were all lowercase but on the Services database explorer they come up as full CAPS.

The Mapping File:

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC 
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
 <class name="animaldatabase.Animal" table="ANIMALS">
  <id name="animalID" type="integer">
   <generator class="assigned" />  
  </id>
  
  <property name="animalName" type="string">
   <column name="name"/>
  </property>
  <property name="animalType" type="string">
   <column name="type"/>
  </property>
 </class>
</hibernate-mapping>

The save method in my program:

public void saveDatabase() 
    {
        try {
            // Write out Array to the database
             /*This step will read hibernate.cfg.xml and prepare hibernate for use*/
            SessionFactory sessionFactory = new 
                    Configuration().configure().buildSessionFactory();
            session = sessionFactory.openSession();

            
            for(int i = 0; i < animalsList.size(); i++) {
                try {
                    /*Create new instance of Contact and set 
                      values in it by reading them from form object*/
                    System.out.println("Inserting Record");
                    
                    session.save(animalsList.get(i));
                    
                    // Actual contact insertion will happen at this step
                    session.flush();
            
                } catch(Exception e){
                    System.out.println(e.getMessage());
                }
            }
            
            session.close();
        }
        catch(Exception e) {
            System.out.println(e.getMessage());
        }
    }

Here are the errors:

15-May-2011 17:46:03 org.hibernate.cfg.Environment <clinit>
INFO: Hibernate 3.2.5
15-May-2011 17:46:03 org.hibernate.cfg.Environment <clinit>
INFO: hibernate.properties not found
15-May-2011 17:46:03 org.hibernate.cfg.Environment buildBytecodeProvider
INFO: Bytecode provider name : cglib
15-May-2011 17:46:03 org.hibernate.cfg.Environment <clinit>
INFO: using JDK 1.4 java.sql.Timestamp handling
15-May-2011 17:46:03 org.hibernate.cfg.Configuration configure
INFO: configuring from resource: /hibernate.cfg.xml
15-May-2011 17:46:03 org.hibernate.cfg.Configuration getConfigurationInputStream
INFO: Configuration resource: /hibernate.cfg.xml
15-May-2011 17:46:03 org.hibernate.cfg.Configuration addResource
INFO: Reading mappings from resource : animal.hbm.xml
15-May-2011 17:46:03 org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues
INFO: Mapping class: animaldatabase.Animal -> ANIMALS
15-May-2011 17:46:03 org.hibernate.cfg.Configuration doConfigure
INFO: Configured SessionFactory: null
15-May-2011 17:46:03 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Using Hibernate built-in connection pool (not for production use!)
15-May-2011 17:46:03 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Hibernate connection pool size: 1
15-May-2011 17:46:03 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: autocommit mode: false
15-May-2011 17:46:03 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: using driver: com.mysql.jdbc.Driver at URL: jdbc:derby://localhost:1527/AnimalsDatabase
15-May-2011 17:46:03 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: connection properties: {user=AdamCompton, password=****}
15-May-2011 17:46:03 org.hibernate.cfg.SettingsFactory buildSettings
INFO: RDBMS: Apache Derby, version: 10.6.2.1 - (999685)
15-May-2011 17:46:03 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC driver: Apache Derby Network Client JDBC Driver, version: 10.6.2.1 - (999685)
15-May-2011 17:46:03 org.hibernate.dialect.Dialect <init>
INFO: Using dialect: org.hibernate.dialect.MySQLDialect
15-May-2011 17:46:03 org.hibernate.transaction.TransactionFactoryFactory buildTransactionFactory
INFO: Using default transaction strategy (direct JDBC transactions)
15-May-2011 17:46:03 org.hibernate.transaction.TransactionManagerLookupFactory getTransactionManagerLookup
INFO: No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
15-May-2011 17:46:03 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Automatic flush during beforeCompletion(): disabled
15-May-2011 17:46:03 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Automatic session close at end of transaction: disabled
15-May-2011 17:46:03 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC batch size: 15
15-May-2011 17:46:03 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC batch updates for versioned data: disabled
15-May-2011 17:46:03 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Scrollable result sets: enabled
15-May-2011 17:46:03 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC3 getGeneratedKeys(): disabled
15-May-2011 17:46:03 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Connection release mode: auto
15-May-2011 17:46:03 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Maximum outer join fetch depth: 2
15-May-2011 17:46:03 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Default batch fetch size: 1
15-May-2011 17:46:03 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Generate SQL with comments: disabled
15-May-2011 17:46:03 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Order SQL updates by primary key: disabled
15-May-2011 17:46:03 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Order SQL inserts for batching: disabled
15-May-2011 17:46:03 org.hibernate.cfg.SettingsFactory createQueryTranslatorFactory
INFO: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
15-May-2011 17:46:03 org.hibernate.hql.ast.ASTQueryTranslatorFactory <init>
INFO: Using ASTQueryTranslatorFactory
15-May-2011 17:46:03 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Query language substitutions: {}
15-May-2011 17:46:03 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JPA-QL strict compliance: disabled
15-May-2011 17:46:03 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Second-level cache: enabled
15-May-2011 17:46:03 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Query cache: disabled
15-May-2011 17:46:03 org.hibernate.cfg.SettingsFactory createCacheProvider
INFO: Cache provider: org.hibernate.cache.NoCacheProvider
15-May-2011 17:46:03 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Optimize cache for minimal puts: disabled
15-May-2011 17:46:03 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Structured second-level cache entries: disabled
15-May-2011 17:46:03 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Echoing all SQL to stdout
15-May-2011 17:46:03 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Statistics: disabled
15-May-2011 17:46:03 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Deleted entity synthetic identifier rollback: disabled
15-May-2011 17:46:03 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Default entity-mode: pojo
15-May-2011 17:46:03 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Named query checking : enabled
15-May-2011 17:46:03 org.hibernate.impl.SessionFactoryImpl <init>
INFO: building session factory
Exception in thread "main" java.lang.NoSuchMethodError: org.objectweb.asm.ClassWriter.<init>(I)V
	at net.sf.cglib.core.DebuggingClassWriter.<init>(DebuggingClassWriter.java:47)
	at net.sf.cglib.core.DefaultGeneratorStrategy.getClassWriter(DefaultGeneratorStrategy.java:30)
	at net.sf.cglib.core.DefaultGeneratorStrategy.generate(DefaultGeneratorStrategy.java:24)
	at net.sf.cglib.core.AbstractClassGenerator.create(AbstractClassGenerator.java:216)
	at net.sf.cglib.core.KeyFactory$Generator.create(KeyFactory.java:144)
	at net.sf.cglib.core.KeyFactory.create(KeyFactory.java:116)
	at net.sf.cglib.core.KeyFactory.create(KeyFactory.java:108)
	at net.sf.cglib.core.KeyFactory.create(KeyFactory.java:104)
	at net.sf.cglib.proxy.Enhancer.<clinit>(Enhancer.java:69)
	at org.hibernate.proxy.pojo.cglib.CGLIBLazyInitializer.getProxyFactory(CGLIBLazyInitializer.java:117)
	at org.hibernate.proxy.pojo.cglib.CGLIBProxyFactory.postInstantiate(CGLIBProxyFactory.java:43)
	at org.hibernate.tuple.entity.PojoEntityTuplizer.buildProxyFactory(PojoEntityTuplizer.java:162)
	at org.hibernate.tuple.entity.AbstractEntityTuplizer.<init>(AbstractEntityTuplizer.java:135)
	at org.hibernate.tuple.entity.PojoEntityTuplizer.<init>(PojoEntityTuplizer.java:55)
	at org.hibernate.tuple.entity.EntityEntityModeToTuplizerMapping.<init>(EntityEntityModeToTuplizerMapping.java:56)
	at org.hibernate.tuple.entity.EntityMetamodel.<init>(EntityMetamodel.java:295)
	at org.hibernate.persister.entity.AbstractEntityPersister.<init>(AbstractEntityPersister.java:434)
	at org.hibernate.persister.entity.SingleTableEntityPersister.<init>(SingleTableEntityPersister.java:109)
	at org.hibernate.persister.PersisterFactory.createClassPersister(PersisterFactory.java:55)
	at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:226)
	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1294)
	at animaldatabase.AnimalDatabase.saveDatabase(AnimalDatabase.java:109)
	at animaldatabase.AnimalDatabaseMain.showMainMenu(AnimalDatabaseMain.java:34)
	at animaldatabase.AnimalDatabaseMain.main(AnimalDatabaseMain.java:50)
Java Result: 1