CREATE TABLE `player` (
  `idPlayer` int(10) unsigned NOT NULL auto_increment,
  `firstname` varchar(45) default NULL,
  `lastname` varchar(45) default NULL,
  `hcp` float default NULL,
  `number` varchar(12) default NULL,
  PRIMARY KEY  (`idPlayer`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

<session-factory>   
   <property name="connection.url">jdbc:mysql://localhost:3306/db060621</property>
   <property name="connection.username">root</property>
   <property name="connection.password">root</property>
   <property name ="connection.driver_class"> com.mysql.jdbc.Driver </property>
   <property name = "dialect" > org.hibernate.dialect.MySQLDialect </property>
   <property name="myeclipse.connection.profile">Golfing</property>
   <mapping resource="is/in/domain/Player.hbm.xml" />
</session-factory>

private void listUsers() {
      log.info( "####### list user" );
      Transaction tx = session.beginTransaction();
      List players = session.createQuery("from Player").list();
      for (Iterator iter = players.iterator(); iter.hasNext();) {
      Player element = (Player) iter.next();      
      log.info(element);
      }
      tx.commit();
   }

<?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.connection.driver_class"> org.gjt.mm.mysql.Driver </property>
   <property name="hibernate.connection.password">root</property>
   <property name="hibernate.connection.url"> jdbc:mysql://localhost/db060621</property>
   <property name="hibernate.connection.username"> root</property>
   <!-- property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property -->
   <property name="hibernate.dialect"> org.hibernate.dialect.MySQLInnoDBDialect</property>   
   <!-- JDBC connection pool (use the built-in) -->
   <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>
   <!-- Drop and re-create the database schema on startup -->
   <!--  property name="hbm2ddl.auto">create</property  -->

   <mapping resource="is/in/domain/Player.hbm.xml" />
</session-factory>
</hibernate-configuration>