hibernate with HSQL db - Acquisition Attempt Failed Error

[Padma Priya]

Hi all,

I am trying to run the helloworld program fromJava persistance with Hibernate(http://www.amazon.com/Java-Persistence-Hibernate-Christian-Bauer/dp/1932394885/ref=sr_1_1?ie=UTF8&s=books&qid=1282779459&sr=8-1.)

But I am getting acquisition attempt failed error. Could anyone please help me out.

My pojo is Message.java

package hello;

public class Message {
    private Long id;
    private String text;
    private Message nextMessage;

    Message() {}

    public Message(String text) {
        this.text = text;
    }

    public Long getId() {
        return id;
    }
    private void setId(Long id) {
        this.id = id;
    }

    public String getText() {
        return text;
    }
    public void setText(String text) {
        this.text = text;
    }

     public Message getNextMessage() {
         return nextMessage;
     }
     public void setNextMessage(Message nextMessage) {
         this.nextMessage = nextMessage;
     }
}

HibernateUtil.java

package persistence;

import org.hibernate.*;
import org.hibernate.cfg.*;

/**
 * Startup Hibernate and provide access to the singleton SessionFactory
 */
public class HibernateUtil {

  private static SessionFactory sessionFactory;

  static {
    try {
       sessionFactory = new Configuration().configure().buildSessionFactory();
    } catch (Throwable ex) {
       throw new ExceptionInInitializerError(ex);
    }
  }

  public static SessionFactory getSessionFactory() {
      // Alternatively, we could look up in JNDI here
      return sessionFactory;
  }

  public static void shutdown() {
      // Close caches and connection pools
      getSessionFactory().close();
  }
}

HelloWorld.java

  
package hello;

import org.hibernate.*;
import persistence.*;
import java.util.*;

public class HelloWorld {

    public static void main(String[] args) {

        // ############################################################################

        // First unit of work
        System.out.println("First unit of work");
        Session session = HibernateUtil.getSessionFactory().openSession();
         System.out.println(session);
        Transaction tx = session.beginTransaction();

        Message message = new Message("Hello World");
         System.out.println(message);
        session.save(message);

        tx.commit();
        session.close();

        // ############################################################################

        // Second unit of work
        Session secondSession = HibernateUtil.getSessionFactory().openSession();
        Transaction secondTransaction = secondSession.beginTransaction();

        List messages =
            secondSession.createQuery("from Message m order by m.text asc").list();

        System.out.println( messages.size() + " message(s) found:" );

        for ( Iterator iter = messages.iterator(); iter.hasNext(); ) {
            Message loadedMsg = (Message) iter.next();
            System.out.println( loadedMsg.getText() );
        }

        secondTransaction.commit();
        secondSession.close();

        // ############################################################################

        // Third unit of work
        Session thirdSession = HibernateUtil.getSessionFactory().openSession();
        Transaction thirdTransaction = thirdSession.beginTransaction();

        // message.getId() holds the identifier value of the first message
        Message loadedMessage = (Message) thirdSession.get( Message.class, message.getId());
        loadedMessage.setText( "Greetings Earthling" );
        loadedMessage.setNextMessage(
            new Message( "Take me to your leader (please)" )
        );

        thirdTransaction.commit();
        thirdSession.close();

        // ############################################################################

        // Final unit of work (just repeat the query)
        // TODO: You can move this query into the thirdSession before the commit, makes more sense!
        Session fourthSession = HibernateUtil.getSessionFactory().openSession();
        Transaction fourthTransaction = fourthSession.beginTransaction();

        messages =
            fourthSession.createQuery("from Message m order by m.text asc").list();

        System.out.println( messages.size() + " message(s) found:" );

        for ( Iterator iter = messages.iterator(); iter.hasNext(); ) {
            Message loadedMsg = (Message) iter.next();
            System.out.println( loadedMsg.getText() );
        }

        fourthTransaction.commit();
        fourthSession.close();


        // Shutting down the application
        HibernateUtil.shutdown();
    }
}
  

My ant build file is

build.xml

<project name="Hello World" default="compile" basedir=".">

    <!-- Name of project and version -->
    <property name="proj.name"      value="Hello World"/>
    <property name="proj.shortname" value="helloworld"/>
    <property name="version"        value="1.0"/>

    <!-- Global properties for this build -->
    <property name="database.dir"           value="database"/>
    <property name="src.java.dir"           value="src/java"/>
    <property name="lib.dir"                value="lib"/>
    <property name="build.dir"              value="build"/>

    <!-- Classpath declaration -->
    <path id="project.classpath">
        <fileset dir="${lib.dir}">
            <include name="**/*.jar"/>
            <include name="**/*.zip"/>
        </fileset>
    </path>

    <!-- Useful shortcuts -->
    <patternset id="meta.files">
        <include name="**/*.xml"/>
        <include name="**/*.properties"/>
    </patternset>

    <!-- Clean up -->
    <target name="clean" description="Clean the build directory">
        <delete dir="${build.dir}"/>
        <mkdir dir="${build.dir}"/>
    </target>

    <!-- Compile Java source -->
    <target name="compile">
        <mkdir dir="${build.dir}"/>
        <javac srcdir="${src.java.dir}"
               destdir="${build.dir}"
               classpathref="project.classpath"/>
    </target>

    <!-- Copy metadata to build classpath -->
    <target name="copymetafiles">
        <mkdir dir="${build.dir}"/>
        <copy todir="${build.dir}">
            <fileset dir="${src.java.dir}">
                <patternset refid="meta.files"/>
            </fileset>
        </copy>
    </target>

    <!-- Run HelloWorld -->
    <target name="run" depends="compile, copymetafiles"
        description="Build and run HelloWorld">
        <java fork="true"
              classname="hello.HelloWorld"
              classpathref="project.classpath">
            <classpath path="${build.dir}"/>
        </java>
    </target>

    <!-- Hibernate Tools import -->
    <taskdef name="hibernatetool"
             classname="org.hibernate.tool.ant.HibernateToolTask"
             classpathref="project.classpath"/>

    <!-- Export the database schema -->
    <target name="schemaexport" depends="compile, copymetafiles"
        description="Exports a generated schema to DB and file">

        <hibernatetool destdir="${basedir}">
            <classpath path="${build.dir}"/>
            <configuration
                configurationfile="${build.dir}/hibernate.cfg.xml"/>
            <hbm2ddl
                drop="true"
                create="true"
                export="true"
                outputfilename="${proj.shortname}-ddl.sql"
                delimiter=";"
                format="true"/>
        </hibernatetool>
    </target>

    <!-- Start the HSQL DB server -->
    <target name="startdb" description="Run HSQL database server with clean DB">
        <!-- Delete database files -->
        <delete dir="${database.dir}"/>
        <java classname="org.hsqldb.Server"
              fork="yes"
              classpathref="project.classpath"
              failonerror="true">
            <arg value="-database.0"/>
            <arg value="file:${database.dir}/db"/>
        </java>
    </target>

    <!-- Start the HSQL DB browser tool -->
    <target name="dbmanager" description="Start HSQL DB manager">
        <java
            classname="org.hsqldb.util.DatabaseManagerSwing"
            fork="yes"
            classpathref="project.classpath"
            failonerror="true">
            <arg value="-url"/>
            <arg value="jdbc:hsqldb:hsql://localhost/"/>
            <arg value="-driver"/>
            <arg value="org.hsqldb.jdbcDriver"/>
        </java>
    </target>

</project>

My hibernate.cfg.xml is

  
<?xml version='1.0' encoding='utf-8'?> <!DOCTYPE hibernate-configuration
        PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN"
        "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>
    <session-factory>

        <property name="hibernate.connection.driver_class">org.hsqldb.jdbcDriver</property>
        <property name="hibernate.connection.url">jdbc:hsqldb:hsql://localhost</property>
        <property name="hibernate.connection.username">sa</property>

        <property name="hibernate.c3p0.min_size">5</property>
        <property name="hibernate.c3p0.max_size">20</property>
        <property name="hibernate.c3p0.timeout">300</property>
        <property name="hibernate.c3p0.max_statements">50</property>
        <property name="hibernate.c3p0.idle_test_period">3000</property>

        <!-- SQL to stdout logging
        <property name="show_sql">true</property>
        <property name="format_sql">true</property>
        <property name="use_sql_comments">true</property>
        -->

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

        <mapping resource="hello/Message.hbm.xml"/>

    </session-factory>
</hibernate-configuration>
  

My Hibernate mapping file is

Message.hbm.xml

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

<hibernate-mapping>

    <class
        name="hello.Message"
        table="MESSAGES">

        <id
            name="id"
            column="MESSAGE_ID">
            <generator class="native"/>
        </id>

        <property
            name="text"
            column="MESSAGE_TEXT"/>

        <many-to-one
            name="nextMessage"
            cascade="all"
            column="NEXT_MESSAGE_ID"
            foreign-key="FK_NEXT_MESSAGE"/>

    </class>

</hibernate-mapping>
  

I have all the needed jar files under

D:\JavaProjects\MyProjects\JPWH\helloworld-native\lib

My Hibernate version

hibernate-distribution-3.5.5-Final

My Hsqldb version

hsqldb-2.0.0

when i run ant

ant clean
ant compile
ant copymetafiles
ant startdb
ant dbmanager

All the above run fine. but when i run the command ant schemaexport i get the following error

 



D:\JavaProjects\MyProjects\JPWH\helloworld-native>ant schemaexport
[color=red]Buildfile: D:\JavaProjects\MyProjects\JPWH\helloworld-native\build.xml

compile:
    [javac] D:\JavaProjects\MyProjects\JPWH\helloworld-native\build.xml:39: warn
ing: 'includeantruntime' was not set, defaulting to build.sysclasspath=last; set
 to false for repeatable builds

copymetafiles:

schemaexport:
[hibernatetool] Executing Hibernate Tool with a Standard Configuration
[hibernatetool] 1. task: hbm2ddl (Generates database schema)
[hibernatetool] 16:17:53,876  WARN BasicResourcePool:1222 - com.mchange.v2.resou
rcepool.BasicResourcePool$AcquireTask@73eb904d -- Acquisition Attempt Failed!!!
Clearing pending acquires. While trying to acquire a needed new resource, we fai
led to succeed more than the maximum number of allowed acquisition attempts (30)
.
[hibernatetool] 16:17:53,876  WARN BasicResourcePool:1222 - com.mchange.v2.resou
rcepool.BasicResourcePool$AcquireTask@101a0ae6 -- Acquisition Attempt Failed!!!
Clearing pending acquires. While trying to acquire a needed new resource, we fai
led to succeed more than the maximum number of allowed acquisition attempts (30)
.
[hibernatetool] 16:17:53,907 ERROR SchemaExport:202 - schema export unsuccessful

[hibernatetool] java.sql.SQLException: Connections could not be acquired from th
e underlying database!
[hibernatetool]         at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.j
ava:104)
[hibernatetool]         at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.che
ckoutPooledConnection(C3P0PooledConnectionPool.java:236)
[hibernatetool]         at com.mchange.v2.c3p0.PoolBackedDataSource.getConnectio
n(PoolBackedDataSource.java:94)
[hibernatetool]         at org.hibernate.connection.C3P0ConnectionProvider.getCo
nnection(C3P0ConnectionProvider.java:35)
[hibernatetool]         at org.hibernate.tool.hbm2ddl.ManagedProviderConnectionH
elper.prepare(ManagedProviderConnectionHelper.java:28)
[hibernatetool]         at org.hibernate.tool.hbm2ddl.SchemaExport.execute(Schem
aExport.java:180)
[hibernatetool]         at org.hibernate.tool.hbm2ddl.SchemaExport.create(Schema
Export.java:133)
[hibernatetool]         at org.hibernate.tool.ant.Hbm2DDLExporterTask.execute(Hb
m2DDLExporterTask.java:55)
[hibernatetool]         at org.hibernate.tool.ant.HibernateToolTask.execute(Hibe
rnateToolTask.java:171)
[hibernatetool]         at org.apache.tools.ant.UnknownElement.execute(UnknownEl
ement.java:291)
[hibernatetool]         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native M
ethod)
[hibernatetool]         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMet
hodAccessorImpl.java:39)
[hibernatetool]         at sun.reflect.DelegatingMethodAccessorImpl.invoke(Deleg
atingMethodAccessorImpl.java:25)
[hibernatetool]         at java.lang.reflect.Method.invoke(Method.java:597)
[hibernatetool]         at org.apache.tools.ant.dispatch.DispatchUtils.execute(D
ispatchUtils.java:106)
[hibernatetool]         at org.apache.tools.ant.Task.perform(Task.java:348)
[hibernatetool]         at org.apache.tools.ant.Target.execute(Target.java:390)
[hibernatetool]         at org.apache.tools.ant.Target.performTasks(Target.java:
411)
[hibernatetool]         at org.apache.tools.ant.Project.executeSortedTargets(Pro
ject.java:1397)
[hibernatetool]         at org.apache.tools.ant.Project.executeTarget(Project.ja
va:1366)
[hibernatetool]         at org.apache.tools.ant.helper.DefaultExecutor.executeTa
rgets(DefaultExecutor.java:41)
[hibernatetool]         at org.apache.tools.ant.Project.executeTargets(Project.j
ava:1249)
[hibernatetool]         at org.apache.tools.ant.Main.runBuild(Main.java:801)
[hibernatetool]         at org.apache.tools.ant.Main.startAnt(Main.java:218)
[hibernatetool]         at org.apache.tools.ant.launch.Launcher.run(Launcher.jav
a:280)
[hibernatetool]         at org.apache.tools.ant.launch.Launcher.main(Launcher.ja
va:109)
[hibernatetool] Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceExce
ption: A ResourcePool could not acquire a resource from its primary factory or s
ource.
[hibernatetool]         at com.mchange.v2.resourcepool.BasicResourcePool.awaitAc
quire(BasicResourcePool.java:970)
[hibernatetool]         at com.mchange.v2.resourcepool.BasicResourcePool.checkou
tResource(BasicResourcePool.java:208)
[hibernatetool]         at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.che
ckoutPooledConnection(C3P0PooledConnectionPool.java:232)
[hibernatetool]         ... 24 more
[hibernatetool] 1 errors occurred while performing <hbm2ddl>.
[hibernatetool] Error #1: java.sql.SQLException: Connections could not be acquir
ed from the underlying database!

BUILD SUCCESSFUL
Total time: 31 seconds[/color]
D:\JavaProjects\MyProjects\JPWH\helloworld-native>   

Thanks for your time and patience.

With regards
Deepthi