00:12:21,437  INFO PersistenceLayer:125 - Using (from airlift-config.xml) petstore.entity.impl.PetstoreEntityManagerFactory for entityManagerFactoryClassname.
00:12:21,640  INFO HibernateEntityManagerFactory:60 - Using Hibernate version 2
00:12:21,687  INFO Environment:483 - Hibernate 2.1.8
00:12:21,703  INFO Environment:517 - loaded properties from resource hibernate.properties: {hibernate.connection.driver_class=com.mysql.jdbc.Driver, hibernate.cglib.use_reflection_optimizer=true, hibernate.cache.provider_class=net.sf.hibernate.cache.EhCacheProvider, hibernate.cache.use_query_cache=true, hibernate.max_fetch_depth=1, hibernate.dialect=net.sf.hibernate.dialect.MySQLDialect, hibernate.jdbc.use_streams_for_binary=true, hibernate.jdbc.batch_size=0, hibernate.query.substitutions=true 1, false 0, yes 'Y', no 'N', hibernate.proxool.pool_alias=pool1, hibernate.connection.username=test, hibernate.connection.url=jdbc:mysql:///test, hibernate.connection.password=, hibernate.connection.pool_size=3}
00:12:21,718  INFO Environment:542 - using java.io streams to persist binary types
00:12:21,718  INFO Environment:543 - using CGLIB reflection optimizer
00:12:21,734  INFO Environment:572 - using JDK 1.4 java.sql.Timestamp handling
00:12:21,734  INFO Configuration:351 - Mapping resource: airliftj/persistence/options/OptionType.hbm.xml
00:12:22,203  INFO Binder:229 - Mapping class: airliftj.persistence.options.OptionType -> OPTION_TYPE
00:12:22,375  INFO Configuration:351 - Mapping resource: airliftj/persistence/options/OptionCode.hbm.xml
00:12:22,437  INFO Binder:229 - Mapping class: airliftj.persistence.options.OptionCode -> OPTION_CODE
00:12:22,453  INFO Configuration:351 - Mapping resource: airliftj/persistence/HiSequenceNumber.hbm.xml
00:12:22,515  INFO Binder:229 - Mapping class: airliftj.persistence.HiSequenceNumber -> HI_SEQ_NUMBER
00:12:22,515  INFO Configuration:351 - Mapping resource: petstore/entity/Person.hbm.xml
00:12:22,593  INFO Binder:229 - Mapping class: petstore.entity.Person -> PERSON
00:12:22,703  INFO Binder:169 - Mapping subclass: petstore.entity.Customer -> PERSON
00:12:23,171  INFO Binder:169 - Mapping subclass: petstore.entity.impl.CustomerImpl -> PERSON
00:12:23,171  INFO Binder:169 - Mapping subclass: petstore.entity.SupplierContact -> PERSON
00:12:23,171  INFO Binder:169 - Mapping subclass: petstore.entity.impl.SupplierContactImpl -> PERSON
00:12:23,171  INFO Binder:169 - Mapping subclass: petstore.entity.impl.PersonImpl -> PERSON
00:12:23,187  INFO Configuration:351 - Mapping resource: petstore/entity/Phone.hbm.xml
00:12:23,234  INFO Binder:229 - Mapping class: petstore.entity.Phone -> PHONE
00:12:23,250  INFO Binder:169 - Mapping subclass: petstore.entity.impl.PhoneImpl -> PHONE
00:12:23,250  INFO Configuration:351 - Mapping resource: petstore/entity/Address.hbm.xml
00:12:23,328  INFO Binder:229 - Mapping class: petstore.entity.Address -> ADDRESS
00:12:23,328  INFO Binder:169 - Mapping subclass: petstore.entity.impl.AddressImpl -> ADDRESS
00:12:23,343  INFO Configuration:351 - Mapping resource: petstore/entity/Profile.hbm.xml
00:12:23,375  INFO Binder:229 - Mapping class: petstore.entity.Profile -> PROFILE
00:12:23,375  INFO Binder:169 - Mapping subclass: petstore.entity.impl.ProfileImpl -> PROFILE
00:12:23,390  INFO Configuration:641 - processing one-to-many association mappings
00:12:23,390  INFO Binder:1181 - Mapping collection: airliftj.persistence.options.OptionType.optionCodes -> OPTION_CODE
00:12:23,390  INFO Binder:1181 - Mapping collection: petstore.entity.Person.phone -> PHONE
00:12:23,406  INFO Binder:1181 - Mapping collection: petstore.entity.Person.address -> ADDRESS
00:12:23,406  INFO Configuration:650 - processing one-to-one association property references
00:12:23,406  INFO Configuration:675 - processing foreign key constraints
00:12:23,468  INFO Dialect:86 - Using dialect: net.sf.hibernate.dialect.MySQLDialect
00:12:23,500  INFO SettingsFactory:70 - Maximim outer join fetch depth: 1
00:12:23,500  INFO SettingsFactory:74 - Use outer join fetching: true
00:12:23,515  INFO DriverManagerConnectionProvider:42 - Using Hibernate built-in connection pool (not for production use!)
00:12:23,515  INFO DriverManagerConnectionProvider:43 - Hibernate connection pool size: 3
00:12:23,515  INFO DriverManagerConnectionProvider:77 - using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql:///test
00:12:23,531  INFO DriverManagerConnectionProvider:78 - connection properties: {user=test, password=}
00:12:23,546  INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of process level read-write cache is not recommended)
00:12:23,937  INFO SettingsFactory:114 - Use scrollable result sets: true
00:12:23,937  INFO SettingsFactory:117 - Use JDBC3 getGeneratedKeys(): true
00:12:23,953  INFO SettingsFactory:120 - Optimize cache for minimal puts: false
00:12:23,953  INFO SettingsFactory:129 - Query language substitutions: {no='N', true=1, yes='Y', false=0}
00:12:23,953  INFO SettingsFactory:140 - cache provider: net.sf.hibernate.cache.EhCacheProvider
00:12:23,968  INFO SettingsFactory:152 - query cache factory: net.sf.hibernate.cache.StandardQueryCacheFactory
00:12:23,984  INFO Configuration:1130 - instantiating and configuring caches
00:12:24,015  WARN Configurator:125 - No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/C:/airlift/workspace-phaseII/airlift-project/airliftj/docs/design/entityModelUMLToXML/tutorial/eclipse-workspace/tutorial-project/lib/hibernate/lib/ehcache-0.9.jar!/ehcache-failsafe.xml
00:12:24,125  INFO SessionFactoryImpl:119 - building session factory
00:12:24,203  INFO ReflectHelper:186 - reflection optimizer disabled for: petstore.entity.Profile, BulkBeanException: Cannot find specified property (property setUpdateSequence)
00:12:24,281  INFO ReflectHelper:186 - reflection optimizer disabled for: petstore.entity.Person, BulkBeanException: Cannot find specified property (property setUpdateSequence)
00:12:24,703  INFO ReflectHelper:186 - reflection optimizer disabled for: petstore.entity.Customer, BulkBeanException: Cannot find specified property (property setEmailNewsletter)
00:12:24,796  INFO ReflectHelper:186 - reflection optimizer disabled for: petstore.entity.SupplierContact, BulkBeanException: Cannot find specified property (property setSupplierCompanyName)
00:12:24,828  INFO ReflectHelper:186 - reflection optimizer disabled for: petstore.entity.Phone, BulkBeanException: Cannot find specified property (property setUpdateSequence)
00:12:25,015  INFO ReflectHelper:186 - reflection optimizer disabled for: petstore.entity.Address, BulkBeanException: Cannot find specified property (property setUpdateSequence)
00:12:25,390  INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI, no JNDI name configured
00:12:25,390  INFO UpdateTimestampsCache:35 - starting update timestamps cache at region: net.sf.hibernate.cache.UpdateTimestampsCache
00:12:25,390  WARN EhCacheProvider:97 - Could not find configuration [net.sf.hibernate.cache.UpdateTimestampsCache]; using defaults.
00:12:25,437  INFO StandardQueryCache:41 - starting query cache at region: net.sf.hibernate.cache.StandardQueryCache
00:12:25,437  WARN EhCacheProvider:97 - Could not find configuration [net.sf.hibernate.cache.StandardQueryCache]; using defaults.
00:12:25,453  INFO HibernateEntityManager:62 - Using Hibernate version 2
00:12:25,468  INFO Dialect:86 - Using dialect: net.sf.hibernate.dialect.MySQLDialect
00:12:25,468  INFO Configuration:641 - processing one-to-many association mappings
00:12:25,468  INFO Configuration:650 - processing one-to-one association property references
00:12:25,468  INFO Configuration:675 - processing foreign key constraints
00:12:25,468  INFO Configuration:641 - processing one-to-many association mappings
00:12:25,484  INFO Configuration:650 - processing one-to-one association property references
00:12:25,484  INFO Configuration:675 - processing foreign key constraints
00:12:25,484  INFO SchemaExport:98 - Running hbm2ddl schema export
00:12:25,484  INFO SchemaExport:117 - exporting generated schema to database
00:12:25,484  INFO DriverManagerConnectionProvider:42 - Using Hibernate built-in connection pool (not for production use!)
00:12:25,484  INFO DriverManagerConnectionProvider:43 - Hibernate connection pool size: 3
00:12:25,484  INFO DriverManagerConnectionProvider:77 - using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql:///test
00:12:25,484  INFO DriverManagerConnectionProvider:78 - connection properties: {user=test, password=}
alter table OPTION_CODE drop foreign key FK6CB163774BEAC276
alter table PHONE drop foreign key FK489454ED8F32245
alter table ADDRESS drop foreign key FKE66327D4D8F32245
drop table if exists OPTION_CODE
drop table if exists PERSON
drop table if exists HI_SEQ_NUMBER
drop table if exists OPTION_TYPE
drop table if exists PROFILE
drop table if exists PHONE
drop table if exists ADDRESS
create table OPTION_CODE (
   id bigint not null,
   updateSequence integer not null,
   storedCode varchar(255) not null,
   shortDescription varchar(255) not null,
   longDescription varchar(255),
   OPTION_TYPE_ID bigint,
   LIST_POSITION integer,
   primary key (id)
)
create table PERSON (
   id bigint not null,
   CONCRETE_TYPE varchar(255) not null,
   updateSequence integer not null,
   emailAddress varchar(255),
   firstName varchar(255),
   lastName varchar(255),
   middleName varchar(255),
   title varchar(255),
   suffix varchar(255),
   emailNewsletter bit,
   registered date,
   bannerPreference varchar(255),
   myListPreference varchar(255),
   preferredLanguage varchar(255),
   supplierCompanyName varchar(255),
   primary key (id)
)
create table HI_SEQ_NUMBER (
   id bigint not null,
   nextNumber bigint not null,
   primary key (id)
)
create table OPTION_TYPE (
   id bigint not null,
   updateSequence integer not null,
   name varchar(255) not null,
   storedAsType integer,
   primary key (id)
)
create table PROFILE (
   id bigint not null,
   CONCRETE_TYPE varchar(255) not null,
   updateSequence integer not null,
   bannerPreference varchar(255),
   myListPreference varchar(255),
   preferredLanguage varchar(255),
   primary key (id)
)
create table PHONE (
   id bigint not null,
   CONCRETE_TYPE varchar(255) not null,
   updateSequence integer not null,
   areaCode varchar(255),
   country varchar(255),
   city varchar(255),
   localNumber varchar(255),
   extension varchar(255),
   phoneType varchar(255),
   PERSON_ID bigint,
   primary key (id)
)
create table ADDRESS (
   id bigint not null,
   CONCRETE_TYPE varchar(255) not null,
   updateSequence integer not null,
   addressType varchar(255),
   city varchar(255),
   country varchar(255),
   line1 varchar(255),
   line2 varchar(255),
   line3 varchar(255),
   postalCode varchar(255),
   state varchar(255),
   PERSON_ID bigint,
   primary key (id)
)
alter table OPTION_CODE add index FK6CB163774BEAC276 (OPTION_TYPE_ID), add constraint FK6CB163774BEAC276 foreign key (OPTION_TYPE_ID) references OPTION_TYPE (id)
alter table PHONE add index FK489454ED8F32245 (PERSON_ID), add constraint FK489454ED8F32245 foreign key (PERSON_ID) references PERSON (id)
alter table ADDRESS add index FKE66327D4D8F32245 (PERSON_ID), add constraint FKE66327D4D8F32245 foreign key (PERSON_ID) references PERSON (id)
00:12:26,218  INFO SchemaExport:160 - schema export complete
00:12:26,218  INFO DriverManagerConnectionProvider:143 - cleaning up connection pool: jdbc:mysql:///test
00:12:26,234  INFO HibernateEntityManager:62 - Using Hibernate version 2
00:12:26,250 DEBUG HibernateTransactionManager:55 - Creating (opening) TransactionManager:airliftj.persistence.hibernate.version2.HibernateTransactionManager@163f7a1
00:12:26,546  INFO DriverManagerConnectionProvider:143 - cleaning up connection pool: jdbc:mysql:///test
00:12:26,609 DEBUG BaseEntityManager:184 - Assigning unique primary key ID:64 to Entity of type:airliftj.persistence.options.OptionType
00:12:26,609 DEBUG BaseEntityManager:184 - Assigning unique primary key ID:65 to Entity of type:airliftj.persistence.options.OptionCode
00:12:26,625 DEBUG BaseEntityManager:184 - Assigning unique primary key ID:66 to Entity of type:airliftj.persistence.options.OptionCode
00:12:26,718 DEBUG HibernateTransactionManager:63 - Closing TransactionManager:airliftj.persistence.hibernate.version2.HibernateTransactionManager@163f7a1
00:12:26,718 DEBUG HibernateTransactionManager:63 - Closing TransactionManager:airliftj.persistence.hibernate.version2.HibernateTransactionManager@163f7a1