mysql> use nieuwetest
Database changed
mysql> describe user;
+------------+--------------+------+-----+---------+----------------+
| Field      | Type         | Null | Key | Default | Extra          |
+------------+--------------+------+-----+---------+----------------+
| ID         | bigint(20)   | NO   | PRI | NULL    | auto_increment |
| ENABLED    | tinyint(4)   | NO   |     |         |                |
| USERNAME   | varchar(255) | NO   | UNI |         |                |
| EMAIL      | varchar(255) | NO   |     |         |                |
| FIRST_NAME | varchar(255) | NO   |     |         |                |
| LAST_NAME  | varchar(255) | NO   |     |         |                |
+------------+--------------+------+-----+---------+----------------+
6 rows in set (0.04 sec)

mysql> show tables;
+----------------------+
| Tables_in_nieuwetest |
+----------------------+
| user                 |
+----------------------+
1 row in set (0.00 sec)

mysql> use nieuwetest;
Database changed
mysql> describe user;
ERROR 1146 (42S02): Table 'nieuwetest.user' doesn't exist
mysql> describe USER;
+------------+--------------+------+-----+---------+----------------+
| Field      | Type         | Null | Key | Default | Extra          |
+------------+--------------+------+-----+---------+----------------+
| ID         | bigint(20)   | NO   | PRI | NULL    | auto_increment |
| ENABLED    | tinyint(4)   | NO   |     |         |                |
| USERNAME   | varchar(255) | NO   | UNI |         |                |
| EMAIL      | varchar(255) | NO   |     |         |                |
| FIRST_NAME | varchar(255) | NO   |     |         |                |
| LAST_NAME  | varchar(255) | NO   |     |         |                |
+------------+--------------+------+-----+---------+----------------+
6 rows in set (0.01 sec)

mysql> show tables;
+----------------------+
| Tables_in_nieuwetest |
+----------------------+
| USER                 |
+----------------------+
1 row in set (0.00 sec)

15:49:05,747 ERROR JDBCExceptionReporter:72 - Unknown database 'NIEUWETEST'
15:49:05,749 ERROR SchemaUpdate:165 - could not complete schema update
org.hibernate.exception.SQLGrammarException: could not get table metadata: USER
   at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
   at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
   at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
   at org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseMetadata.java:100)
   at org.hibernate.cfg.Configuration.generateSchemaUpdateScript(Configuration.java:838)
   at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:140)
   at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:296)
   at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1176)
   at nl.ap400.test.hibernate.InitSessionFactory.initSessionFactory(InitSessionFactory.java:45)
   at nl.ap400.test.hibernate.InitSessionFactory.getInstance(InitSessionFactory.java:20)
   at nl.ap400.test.hibernate.MainApp.createUser(MainApp.java:53)
   at nl.ap400.test.hibernate.MainApp.main(MainApp.java:25)
Caused by: java.sql.SQLException: Unknown database 'NIEUWETEST'
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2926)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
   at com.mysql.jdbc.Connection.execSQL(Connection.java:2972)
   at com.mysql.jdbc.Connection.execSQL(Connection.java:2902)
   at com.mysql.jdbc.Statement.executeQuery(Statement.java:822)
   at com.mysql.jdbc.DatabaseMetaData$9.forEach(DatabaseMetaData.java:4453)
   at com.mysql.jdbc.DatabaseMetaData$IterateBlock.doForAll(DatabaseMetaData.java:79)
   at com.mysql.jdbc.DatabaseMetaData.getTables(DatabaseMetaData.java:4440)
   at com.mysql.jdbc.DatabaseMetaData$2.forEach(DatabaseMetaData.java:1928)
   at com.mysql.jdbc.DatabaseMetaData$IterateBlock.doForAll(DatabaseMetaData.java:79)
   at com.mysql.jdbc.DatabaseMetaData.getColumns(DatabaseMetaData.java:1894)
   at org.hibernate.tool.hbm2ddl.TableMetadata.initColumns(TableMetadata.java:177)
   at org.hibernate.tool.hbm2ddl.TableMetadata.<init>(TableMetadata.java:33)
   at org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseMetadata.java:85)
   ... 8 more

<?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">

<!-- Generated by MyEclipse Hibernate Tools.                   -->
<hibernate-configuration>

<session-factory>
   <property name="connection.url">
      jdbc:mysql://localhost:3306/nieuwetest
   </property>

   <property name="connection.username">root</property>
   <property name="connection.password"></property>
   <property name="connection.driver_class">
      com.mysql.jdbc.Driver
   </property>
   <property name="dialect">
      org.hibernate.dialect.MySQLInnoDBDialect
   </property>
   <property name="show_sql">true</property>
   <property name="transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</property>
   <property name="current_session_context_class">thread</property>
   <property name="hbm2ddl.auto">update</property>
   <mapping resource="nl/ap400/test/hibernate/User.hbm.xml" />

</session-factory>

</hibernate-configuration>

<?xml version="1.0" encoding="UTF-8"?>
<!--
     Attention: Generated code! Do not modify by hand!
     Generated by: hibernate.hbm.xml.vsl in andromda-hibernate-cartridge.
  -->
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
          "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping default-cascade="none">
    <class name="nl.ap400.test.hibernate.User" table="USER" dynamic-insert="false" dynamic-update="false">
        <id name="id" type="java.lang.Long" unsaved-value="null">
            <column name="ID" sql-type="BIGINT"/>
            <generator class="native">
            </generator>
        </id>

        <property name="enabled" type="boolean">
            <column name="ENABLED" not-null="true" unique="false" sql-type="TINYINT"/>
        </property>
        <property name="username" type="java.lang.String">
            <column name="USERNAME" not-null="true" unique="false" unique-key="usernameUnique" sql-type="VARCHAR(255) BINARY"/>
        </property>
        <property name="email" type="java.lang.String">
            <column name="EMAIL" not-null="true" unique="false" sql-type="VARCHAR(255) BINARY"/>
        </property>
        <property name="firstName" type="java.lang.String">
            <column name="FIRST_NAME" not-null="true" unique="false" sql-type="VARCHAR(255) BINARY"/>
        </property>
        <property name="lastName" type="java.lang.String">
            <column name="LAST_NAME" not-null="true" unique="false" sql-type="VARCHAR(255) BINARY"/>
        </property>

    </class>
</hibernate-mapping>

package nl.ap400.test.hibernate;

import java.io.Serializable;

public class User implements Serializable {
    private static final long serialVersionUID = -5356167726657927602L;

    private java.lang.Long id;

    private java.lang.String username;
   
    private java.lang.String password;
   
    private java.lang.String firstName;

    private java.lang.String lastName;

    private java.lang.String email;

    private boolean enabled;
   
    public boolean equals(Object object)  {
        if (this == object)
        {
            return true;
        }
        if (!(object instanceof User))
        {
            return false;
        }
        final User that = (User)object;
        if (this.id == null || that.getId() == null || !this.id.equals(that.getId()))
        {
            return false;
        }
        return true;
    }

    public String toString() {
       return "@" + id + " " + firstName + " " + lastName;
    }

   public java.lang.String getEmail() {
      return email;
   }

   public boolean isEnabled() {
      return enabled;
   }

   public java.lang.String getFirstName() {
      return firstName;
   }

   public java.lang.Long getId() {
      return id;
   }

   public java.lang.String getLastName() {
      return lastName;
   }

   public java.lang.String getPassword() {
      return password;
   }

   public java.lang.String getUsername() {
      return username;
   }

   public void setEmail(java.lang.String email) {
      this.email = email;
   }

   public void setEnabled(boolean enabled) {
      this.enabled = enabled;
   }

   public void setFirstName(java.lang.String firstName) {
      this.firstName = firstName;
   }

   public void setId(java.lang.Long id) {
      this.id = id;
   }

   public void setLastName(java.lang.String lastName) {
      this.lastName = lastName;
   }

   public void setPassword(java.lang.String password) {
      this.password = password;
   }

   public void setUsername(java.lang.String username) {
      this.username = username;
   }
}

package nl.ap400.test.hibernate;

import java.util.Iterator;
import java.util.List;

import org.apache.log4j.Logger;
import org.hibernate.HibernateException;
import org.hibernate.Transaction;
import org.hibernate.classic.Session;

public class MainApp {
   private static Logger log = Logger.getLogger(MainApp.class);

   public static void main(String[] args) {
      
      for (int i = 0; i < 10; i++) {
         User user = new User();
         user.setEmail("my@email.com");
         user.setFirstName("xander");
         user.setLastName("wiseGuy");
         user.setEnabled(true);
         user.setPassword("secret");
         user.setUsername("xander_"+i);
      
         createUser(user);
      }
            
      listUser();

   }

   private static void listUser() {
      Transaction tx = null;
      Session session = InitSessionFactory.getInstance().getCurrentSession();
      try {
         tx = session.beginTransaction();
         List Users = session.createQuery("select u from User as u").list();
         for (Iterator iter = Users.iterator(); iter.hasNext();) {
            User element = (User) iter.next();
            log.info(element);
         }
         tx.commit();
      } catch (HibernateException e) {
         e.printStackTrace();
         if (tx != null && tx.isActive())
            tx.rollback();

      }
   }

   private static void createUser(User User) {
      Transaction tx = null;
      Session session = InitSessionFactory.getInstance().getCurrentSession();
      try {
         tx = session.beginTransaction();
         session.save(User);
         tx.commit();
      } catch (HibernateException e) {
         e.printStackTrace();
         if (tx != null && tx.isActive())
            tx.rollback();
      }
   }
}

package nl.ap400.test.hibernate;

import javax.naming.InitialContext;

import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
import org.hibernate.cfg.Environment;

public class InitSessionFactory {

   private static final Configuration cfg = new Configuration();
   private static org.hibernate.SessionFactory sessionFactory;

   private static String CONFIG_FILE_LOCATION = "/hibernate.cfg.xml";


   public static SessionFactory getInstance() {
      if (sessionFactory == null) initSessionFactory();
      return sessionFactory;
   }

   public Session getCurrentSession() {
      return sessionFactory.getCurrentSession();
   }

   public static void close(){
      if (sessionFactory != null) sessionFactory.close();
      sessionFactory = null;
   }

   private static synchronized void initSessionFactory() {
      if (sessionFactory == null) {
         
         try {
            cfg.configure(CONFIG_FILE_LOCATION);
            String sessionFactoryJndiName = cfg.getProperty(Environment.SESSION_FACTORY_NAME);
            
            if (sessionFactoryJndiName != null) {
               cfg.buildSessionFactory();
               sessionFactory = (SessionFactory) (new InitialContext())
                     .lookup(sessionFactoryJndiName);
            } else{
               sessionFactory = cfg.buildSessionFactory();
            }

         } catch (Exception ex) {
            throw new HibernateException("Could not initialize the Hibernate configuration", ex);
         }
         
      }
   }
}

log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.Target=System.out
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n
log4j.logger.org.hibernate=info
log4j.logger.org.hibernate.SQL=debug
log4j.logger.org.hibernate.type=info
log4j.logger.org.hibernate.tool.hbm2ddl=info
log4j.logger.org.hibernate.cache=info

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

- - - - MySQL commands - - - -

mysql -h localhost -u root -pXXX mysql
CREATE DATABASE test CHARACTER SET utf8;
GRANT ALL PRIVILEGES ON test.* TO 'test'@'localhost' IDENTIFIED BY 'test';

# MySQL
db.dialect = org.hibernate.dialect.MySQLDialect
db.driver  = com.mysql.jdbc.Driver
db.uri     = jdbc:mysql://localhost/test
db.user    = test
db.pass    = test
# options: useUnicode=true, characterEncoding=UTF-8

CREATE TABLE `USER` (
  `ID` bigint(20) NOT NULL auto_increment,
  `ENABLED` tinyint(4) NOT NULL,
  `USERNAME` varchar(255) character set utf8 collate utf8_bin NOT NULL,
  `EMAIL` varchar(255) character set utf8 collate utf8_bin NOT NULL,
  `FIRST_NAME` varchar(255) character set utf8 collate utf8_bin NOT NULL,
  `LAST_NAME` varchar(255) character set utf8 collate utf8_bin NOT NULL,
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `USERNAME` (`USERNAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

default-storage-engine = InnoDB
default-table-type = InnoDB

mysql> show engines;
+------------+---------+----------------------------------------------------------------+
| Engine     | Support | Comment                                                        |
+------------+---------+----------------------------------------------------------------+
| MyISAM     | YES     | Default engine as of MySQL 3.23 with great performance         |
| MEMORY     | YES     | Hash based, stored in memory, useful for temporary tables      |
| InnoDB     | DEFAULT | Supports transactions, row-level locking, and foreign keys     |
| BerkeleyDB | YES     | Supports transactions and page-level locking                   |
| BLACKHOLE  | NO      | /dev/null storage engine (anything you write to it disappears) |
| EXAMPLE    | NO      | Example storage engine                                         |
| ARCHIVE    | NO      | Archive storage engine                                         |
| CSV        | NO      | CSV storage engine                                             |
| ndbcluster | NO      | Clustered, fault-tolerant, memory-based tables                 |
| FEDERATED  | NO      | Federated MySQL storage engine                                 |
| MRG_MYISAM | YES     | Collection of identical MyISAM tables                          |
| ISAM       | NO      | Obsolete storage engine                                        |
+------------+---------+----------------------------------------------------------------+
12 rows in set (0.00 sec)

mysql> show table types;
+------------+---------+----------------------------------------------------------------+
| Engine     | Support | Comment                                                        |
+------------+---------+----------------------------------------------------------------+
| MyISAM     | YES     | Default engine as of MySQL 3.23 with great performance         |
| MEMORY     | YES     | Hash based, stored in memory, useful for temporary tables      |
| InnoDB     | DEFAULT | Supports transactions, row-level locking, and foreign keys     |
| BerkeleyDB | YES     | Supports transactions and page-level locking                   |
| BLACKHOLE  | NO      | /dev/null storage engine (anything you write to it disappears) |
| EXAMPLE    | NO      | Example storage engine                                         |
| ARCHIVE    | NO      | Archive storage engine                                         |
| CSV        | NO      | CSV storage engine                                             |
| ndbcluster | NO      | Clustered, fault-tolerant, memory-based tables                 |
| FEDERATED  | NO      | Federated MySQL storage engine                                 |
| MRG_MYISAM | YES     | Collection of identical MyISAM tables                          |
| ISAM       | NO      | Obsolete storage engine                                        |
+------------+---------+----------------------------------------------------------------+
12 rows in set, 1 warning (0.00 sec)

innodb_data_file_path=/path/to/innodb/ibdata1:50M

# the following is the InnoDB configuration
# if you wish to disable innodb instead
# uncomment just the next line
#skip-innodb
#
# the rest of the innodb config follows:
# don't eat too much memory, we're trying to be safe on 64Mb boxes
# you might want to bump this up a bit on boxes with more RAM
innodb_buffer_pool_size = 16M
# this is the default, increase it if you have lots of tables
innodb_additional_mem_pool_size = 2M
#
# i'd like to use /var/lib/mysql/innodb, but that is seen as a database :-(
# and upstream wants things to be under /var/lib/mysql/, so that's the route
# we have to take for the moment
#innodb_data_home_dir           = /var/lib/mysql/
#innodb_log_arch_dir            = /var/lib/mysql/
#innodb_log_group_home_dir      = /var/lib/mysql/
# you may wish to change this size to be more suitable for your system
# the max is there to avoid run-away growth on your machine
innodb_data_file_path = ibdata1:10M:autoextend:max:128M
# we keep this at around 25% of of innodb_buffer_pool_size
# sensible values range from 1MB to (1/innodb_log_files_in_group*innodb_buffer_pool_size)
innodb_log_file_size = 5M
# this is the default, increase it if you have very large transactions going on
innodb_log_buffer_size = 8M
# this is the default and won't hurt you
# you shouldn't need to tweak it
set-variable = innodb_log_files_in_group=2
# see the innodb config docs, the other options are not always safe
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50

[mysqld]
default-storage-engine = innodb
default-table-type = innodb
innodb_data_file_path=ibdata1:10M:autoextend

db.dialect = org.hibernate.dialect.MySQLInnoDBDialect

db.dialect = org.hibernate.dialect.MySQLDialect

mysql> use facicash;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> describe users;
+----------------------+--------------+------+-----+---------+----------------+
| Field                | Type         | Null | Key | Default | Extra          |
+----------------------+--------------+------+-----+---------+----------------+
| user_id              | bigint(20)   | NO   | PRI | NULL    | auto_increment |
| ctime                | datetime     | NO   |     |         |                |
| mtime                | datetime     | NO   |     |         |                |
| creator              | bigint(20)   | YES  | MUL | NULL    |                |
| owner                | bigint(20)   | YES  | MUL | NULL    |                |
| login_name           | varchar(40)  | NO   | UNI |         |                |
| passwd               | varchar(255) | NO   |     |         |                |
| activex              | bit(1)       | NO   |     |         |                |
| organization_unit_id | bigint(20)   | NO   | MUL |         |                |
+----------------------+--------------+------+-----+---------+----------------+
9 rows in set (0.02 sec)

mysql> describe USERS;
ERROR 1146 (42S02): Table 'facicash.USERS' doesn't exist