Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hi,
I am using Hibernate (EJB 3.0) in standalone mode i.e. I am instantiated my own EntityManager it is not being injected for me by the App Server.

Any time I use the entity manager to make a call, hibernate does a huge amout of database initialisation.
For example, it binds all entities (Pojos), it checks table meta data, it tries to update tables it does not need to update etc. I could understand why Hibernate would do this the first time a call is made to the database or why it would do it at startup. However I cannot understand why it does it everytime a database call is made.
It means that a load of work that does not need to be done is being repeated and hence database calls are taking longer.


Here is my persistence.xml,

<persistence>
- <persistence-unit name="h-source">
- <properties>
<property name="hibernate.connection.driver_class" value="oracle.jdbc.driver.OracleDriver" />
<property name="hibernate.connection.username" value="alex_garageDB" />
<property name="hibernate.connection.password" value="alex_garageDB" />
<property name="hibernate.show_sql" value="true" />
<property name="hibernate.connection.url" value="jdbc:oracle:thin:@opc151:1521:ora10g" />
<property name="hibernate.hbm2ddl.auto" value="update" />
<property name="hibernate.cache.provider_class" value="org.hibernate.cache.HashtableCacheProvider" />
<property name="hibernate.dialect" value="org.hibernate.dialect.Oracle9Dialect" />
</properties>
</persistence-unit>
</persistence>

And here is the logging,

13:13:49,093 DEBUG SQL:393 - select employees0_.I_COMPANY_EMPLOYEES as I3_4_, employees0_.C_COMPANY_EMPLOYEES as C4_4_, employees0_.I as I4_, employees0_.C as C4_, employees0_.I as I108_3_, employees0_.C as C108_3_, employees0_.boeVersion as boeVersion108_3_, employees0_.I_PERSON_BESTFRIEND as I11_108_3_, employees0_.C_PERSON_BESTFRIEND as C12_108_3_, employees0_.firstName as firstName108_3_, employees0_.insurance as insurance108_3_, employees0_.insuranNo as insuranNo108_3_, employees0_.lastName as lastName108_3_, employees0_.pension as pension108_3_, employees0_.taxArea as taxArea108_3_, employees0_.taxCode as taxCode108_3_, employees0_.employeeNumber as employee1_109_3_, employees0_.rsi as rsi109_3_, employees0_.I_COMPANY_EMPLOYEES as I3_109_3_, employees0_.C_COMPANY_EMPLOYEES as C4_109_3_, employees0_.email as email112_3_, employees0_.grade as grade112_3_, employees0_.clazz_ as clazz_3_, person1_.I as I108_0_, person1_.C as C108_0_, person1_.boeVersion as boeVersion108_0_, person1_.I_PERSON_BESTFRIEND as I11_108_0_, person1_.C_PERSON_BESTFRIEND as C12_108_0_, person1_.firstName as firstName108_0_, person1_.insurance as insurance108_0_, person1_.insuranNo as insuranNo108_0_, person1_.lastName as lastName108_0_, person1_.pension as pension108_0_, person1_.taxArea as taxArea108_0_, person1_.taxCode as taxCode108_0_, person1_.employeeNumber as employee1_109_0_, person1_.rsi as rsi109_0_, person1_.I_COMPANY_EMPLOYEES as I3_109_0_, person1_.C_COMPANY_EMPLOYEES as C4_109_0_, person1_.customerNumber as customer1_111_0_, person1_.email as email112_0_, person1_.grade as grade112_0_, person1_.clazz_ as clazz_0_, person2_.I as I108_1_, person2_.C as C108_1_, person2_.boeVersion as boeVersion108_1_, person2_.I_PERSON_BESTFRIEND as I11_108_1_, person2_.C_PERSON_BESTFRIEND as C12_108_1_, person2_.firstName as firstName108_1_, person2_.insurance as insurance108_1_, person2_.insuranNo as insuranNo108_1_, person2_.lastName as lastName108_1_, person2_.pension as pension108_1_, person2_.taxArea as taxArea108_1_, person2_.taxCode as taxCode108_1_, person2_.employeeNumber as employee1_109_1_, person2_.rsi as rsi109_1_, person2_.I_COMPANY_EMPLOYEES as I3_109_1_, person2_.C_COMPANY_EMPLOYEES as C4_109_1_, person2_.customerNumber as customer1_111_1_, person2_.email as email112_1_, person2_.grade as grade112_1_, person2_.clazz_ as clazz_1_, company3_.I as I110_2_, company3_.C as C110_2_, company3_.name as name110_2_, company3_.boeVersion as boeVersion110_2_, company3_.registeredNumber as register5_110_2_ from ( select C_COMPANY_EMPLOYEES, employeeNumber, insuranNo, C, taxArea, rsi, null as grade, C_PERSON_BESTFRIEND, lastName, I, boeVersion, I_COMPANY_EMPLOYEES, firstName, taxCode, null as email, insurance, pension, I_PERSON_BESTFRIEND, 1 as clazz_ from TEmployee union all select C_COMPANY_EMPLOYEES, employeeNumber, insuranNo, C, taxArea, rsi, grade, C_PERSON_BESTFRIEND, lastName, I, boeVersion, I_COMPANY_EMPLOYEES, firstName, taxCode, email, insurance, pension, I_PERSON_BESTFRIEND, 3 as clazz_ from TMechanic ) employees0_ left outer join ( select null as C_COMPANY_EMPLOYEES, null as employeeNumber, insuranNo, C, taxArea, null as rsi, null as grade, C_PERSON_BESTFRIEND, lastName, I, boeVersion, null as customerNumber, null as I_COMPANY_EMPLOYEES, firstName, taxCode, null as email, insurance, pension, I_PERSON_BESTFRIEND, 0 as clazz_ from TPerson union all select C_COMPANY_EMPLOYEES, employeeNumber, insuranNo, C, taxArea, rsi, grade, C_PERSON_BESTFRIEND, lastName, I, boeVersion, null as customerNumber, I_COMPANY_EMPLOYEES, firstName, taxCode, email, insurance, pension, I_PERSON_BESTFRIEND, 3 as clazz_ from TMechanic union all select C_COMPANY_EMPLOYEES, employeeNumber, insuranNo, C, taxArea, rsi, null as grade, C_PERSON_BESTFRIEND, lastName, I, boeVersion, null as customerNumber, I_COMPANY_EMPLOYEES, firstName, taxCode, null as email, insurance, pension, I_PERSON_BESTFRIEND, 1 as clazz_ from TEmployee union all select null as C_COMPANY_EMPLOYEES, null as employeeNumber, insuranNo, C, taxArea, null as rsi, null as grade, C_PERSON_BESTFRIEND, lastName, I, boeVersion, customerNumber, null as I_COMPANY_EMPLOYEES, firstName, taxCode, null as email, insurance, pension, I_PERSON_BESTFRIEND, 2 as clazz_ from TCustomer ) person1_ on employees0_.I_PERSON_BESTFRIEND=person1_.I and employees0_.C_PERSON_BESTFRIEND=person1_.C left outer join ( select null as C_COMPANY_EMPLOYEES, null as employeeNumber, insuranNo, C, taxArea, null as rsi, null as grade, C_PERSON_BESTFRIEND, lastName, I, boeVersion, null as customerNumber, null as I_COMPANY_EMPLOYEES, firstName, taxCode, null as email, insurance, pension, I_PERSON_BESTFRIEND, 0 as clazz_ from TPerson union all select C_COMPANY_EMPLOYEES, employeeNumber, insuranNo, C, taxArea, rsi, grade, C_PERSON_BESTFRIEND, lastName, I, boeVersion, null as customerNumber, I_COMPANY_EMPLOYEES, firstName, taxCode, email, insurance, pension, I_PERSON_BESTFRIEND, 3 as clazz_ from TMechanic union all select C_COMPANY_EMPLOYEES, employeeNumber, insuranNo, C, taxArea, rsi, null as grade, C_PERSON_BESTFRIEND, lastName, I, boeVersion, null as customerNumber, I_COMPANY_EMPLOYEES, firstName, taxCode, null as email, insurance, pension, I_PERSON_BESTFRIEND, 1 as clazz_ from TEmployee union all select null as C_COMPANY_EMPLOYEES, null as employeeNumber, insuranNo, C, taxArea, null as rsi, null as grade, C_PERSON_BESTFRIEND, lastName, I, boeVersion, customerNumber, null as I_COMPANY_EMPLOYEES, firstName, taxCode, null as email, insurance, pension, I_PERSON_BESTFRIEND, 2 as clazz_ from TCustomer ) person2_ on person1_.I_PERSON_BESTFRIEND=person2_.I and person1_.C_PERSON_BESTFRIEND=person2_.C left outer join TCompany company3_ on person2_.I_COMPANY_EMPLOYEES=company3_.I and person2_.C_COMPANY_EMPLOYEES=company3_.C where employees0_.I_COMPANY_EMPLOYEES=? and employees0_.C_COMPANY_EMPLOYEES=?
Hibernate: select employees0_.I_COMPANY_EMPLOYEES as I3_4_, employees0_.C_COMPANY_EMPLOYEES as C4_4_, employees0_.I as I4_, employees0_.C as C4_, employees0_.I as I108_3_, employees0_.C as C108_3_, employees0_.boeVersion as boeVersion108_3_, employees0_.I_PERSON_BESTFRIEND as I11_108_3_, employees0_.C_PERSON_BESTFRIEND as C12_108_3_, employees0_.firstName as firstName108_3_, employees0_.insurance as insurance108_3_, employees0_.insuranNo as insuranNo108_3_, employees0_.lastName as lastName108_3_, employees0_.pension as pension108_3_, employees0_.taxArea as taxArea108_3_, employees0_.taxCode as taxCode108_3_, employees0_.employeeNumber as employee1_109_3_, employees0_.rsi as rsi109_3_, employees0_.I_COMPANY_EMPLOYEES as I3_109_3_, employees0_.C_COMPANY_EMPLOYEES as C4_109_3_, employees0_.email as email112_3_, employees0_.grade as grade112_3_, employees0_.clazz_ as clazz_3_, person1_.I as I108_0_, person1_.C as C108_0_, person1_.boeVersion as boeVersion108_0_, person1_.I_PERSON_BESTFRIEND as I11_108_0_, person1_.C_PERSON_BESTFRIEND as C12_108_0_, person1_.firstName as firstName108_0_, person1_.insurance as insurance108_0_, person1_.insuranNo as insuranNo108_0_, person1_.lastName as lastName108_0_, person1_.pension as pension108_0_, person1_.taxArea as taxArea108_0_, person1_.taxCode as taxCode108_0_, person1_.employeeNumber as employee1_109_0_, person1_.rsi as rsi109_0_, person1_.I_COMPANY_EMPLOYEES as I3_109_0_, person1_.C_COMPANY_EMPLOYEES as C4_109_0_, person1_.customerNumber as customer1_111_0_, person1_.email as email112_0_, person1_.grade as grade112_0_, person1_.clazz_ as clazz_0_, person2_.I as I108_1_, person2_.C as C108_1_, person2_.boeVersion as boeVersion108_1_, person2_.I_PERSON_BESTFRIEND as I11_108_1_, person2_.C_PERSON_BESTFRIEND as C12_108_1_, person2_.firstName as firstName108_1_, person2_.insurance as insurance108_1_, person2_.insuranNo as insuranNo108_1_, person2_.lastName as lastName108_1_, person2_.pension as pension108_1_, person2_.taxArea as taxArea108_1_, person2_.taxCode as taxCode108_1_, person2_.employeeNumber as employee1_109_1_, person2_.rsi as rsi109_1_, person2_.I_COMPANY_EMPLOYEES as I3_109_1_, person2_.C_COMPANY_EMPLOYEES as C4_109_1_, person2_.customerNumber as customer1_111_1_, person2_.email as email112_1_, person2_.grade as grade112_1_, person2_.clazz_ as clazz_1_, company3_.I as I110_2_, company3_.C as C110_2_, company3_.name as name110_2_, company3_.boeVersion as boeVersion110_2_, company3_.registeredNumber as register5_110_2_ from ( select C_COMPANY_EMPLOYEES, employeeNumber, insuranNo, C, taxArea, rsi, null as grade, C_PERSON_BESTFRIEND, lastName, I, boeVersion, I_COMPANY_EMPLOYEES, firstName, taxCode, null as email, insurance, pension, I_PERSON_BESTFRIEND, 1 as clazz_ from TEmployee union all select C_COMPANY_EMPLOYEES, employeeNumber, insuranNo, C, taxArea, rsi, grade, C_PERSON_BESTFRIEND, lastName, I, boeVersion, I_COMPANY_EMPLOYEES, firstName, taxCode, email, insurance, pension, I_PERSON_BESTFRIEND, 3 as clazz_ from TMechanic ) employees0_ left outer join ( select null as C_COMPANY_EMPLOYEES, null as employeeNumber, insuranNo, C, taxArea, null as rsi, null as grade, C_PERSON_BESTFRIEND, lastName, I, boeVersion, null as customerNumber, null as I_COMPANY_EMPLOYEES, firstName, taxCode, null as email, insurance, pension, I_PERSON_BESTFRIEND, 0 as clazz_ from TPerson union all select C_COMPANY_EMPLOYEES, employeeNumber, insuranNo, C, taxArea, rsi, grade, C_PERSON_BESTFRIEND, lastName, I, boeVersion, null as customerNumber, I_COMPANY_EMPLOYEES, firstName, taxCode, email, insurance, pension, I_PERSON_BESTFRIEND, 3 as clazz_ from TMechanic union all select C_COMPANY_EMPLOYEES, employeeNumber, insuranNo, C, taxArea, rsi, null as grade, C_PERSON_BESTFRIEND, lastName, I, boeVersion, null as customerNumber, I_COMPANY_EMPLOYEES, firstName, taxCode, null as email, insurance, pension, I_PERSON_BESTFRIEND, 1 as clazz_ from TEmployee union all select null as C_COMPANY_EMPLOYEES, null as employeeNumber, insuranNo, C, taxArea, null as rsi, null as grade, C_PERSON_BESTFRIEND, lastName, I, boeVersion, customerNumber, null as I_COMPANY_EMPLOYEES, firstName, taxCode, null as email, insurance, pension, I_PERSON_BESTFRIEND, 2 as clazz_ from TCustomer ) person1_ on employees0_.I_PERSON_BESTFRIEND=person1_.I and employees0_.C_PERSON_BESTFRIEND=person1_.C left outer join ( select null as C_COMPANY_EMPLOYEES, null as employeeNumber, insuranNo, C, taxArea, null as rsi, null as grade, C_PERSON_BESTFRIEND, lastName, I, boeVersion, null as customerNumber, null as I_COMPANY_EMPLOYEES, firstName, taxCode, null as email, insurance, pension, I_PERSON_BESTFRIEND, 0 as clazz_ from TPerson union all select C_COMPANY_EMPLOYEES, employeeNumber, insuranNo, C, taxArea, rsi, grade, C_PERSON_BESTFRIEND, lastName, I, boeVersion, null as customerNumber, I_COMPANY_EMPLOYEES, firstName, taxCode, email, insurance, pension, I_PERSON_BESTFRIEND, 3 as clazz_ from TMechanic union all select C_COMPANY_EMPLOYEES, employeeNumber, insuranNo, C, taxArea, rsi, null as grade, C_PERSON_BESTFRIEND, lastName, I, boeVersion, null as customerNumber, I_COMPANY_EMPLOYEES, firstName, taxCode, null as email, insurance, pension, I_PERSON_BESTFRIEND, 1 as clazz_ from TEmployee union all select null as C_COMPANY_EMPLOYEES, null as employeeNumber, insuranNo, C, taxArea, null as rsi, null as grade, C_PERSON_BESTFRIEND, lastName, I, boeVersion, customerNumber, null as I_COMPANY_EMPLOYEES, firstName, taxCode, null as email, insurance, pension, I_PERSON_BESTFRIEND, 2 as clazz_ from TCustomer ) person2_ on person1_.I_PERSON_BESTFRIEND=person2_.I and person1_.C_PERSON_BESTFRIEND=person2_.C left outer join TCompany company3_ on person2_.I_COMPANY_EMPLOYEES=company3_.I and person2_.C_COMPANY_EMPLOYEES=company3_.C where employees0_.I_COMPANY_EMPLOYEES=? and employees0_.C_COMPANY_EMPLOYEES=?
13:13:49,171 FATAL Ejb3Configuration:504 - META-INF/MANIFEST.MFO-:-Ofalse
13:13:49,171 FATAL Ejb3Configuration:504 - META-INF/persistence.xmlO-:-Ofalse
13:13:49,187 INFO AnnotationBinder:386 - Binding entity from annotated class: com.fineos.ta.test.driver.OTestCases.hibernate.Person
13:13:49,187 INFO EntityBinder:325 - Bind entity com.fineos.ta.test.driver.OTestCases.hibernate.Person on table TPerson
13:13:49,187 INFO AnnotationBinder:386 - Binding entity from annotated class: com.fineos.ta.test.driver.OTestCases.hibernate.Employee
13:13:49,187 INFO EntityBinder:325 - Bind entity com.fineos.ta.test.driver.OTestCases.hibernate.Employee on table TEmployee
13:13:49,187 INFO AnnotationBinder:386 - Binding entity from annotated class: com.fineos.ta.test.driver.OTestCases.hibernate.Company
13:13:49,187 INFO EntityBinder:325 - Bind entity com.fineos.ta.test.driver.OTestCases.hibernate.Company on table TCompany
13:13:49,203 INFO AnnotationBinder:386 - Binding entity from annotated class: com.fineos.ta.test.driver.OTestCases.hibernate.Customer
13:13:49,203 INFO EntityBinder:325 - Bind entity com.fineos.ta.test.driver.OTestCases.hibernate.Customer on table TCustomer
13:13:49,203 INFO AnnotationBinder:386 - Binding entity from annotated class: com.fineos.ta.test.driver.OTestCases.hibernate.Mechanic
13:13:49,203 INFO EntityBinder:325 - Bind entity com.fineos.ta.test.driver.OTestCases.hibernate.Mechanic on table TMechanic
13:13:49,203 INFO AnnotationBinder:386 - Binding entity from annotated class: com.fineos.ta.test.driver.OTestCases.hibernate.Address
13:13:49,203 INFO EntityBinder:325 - Bind entity com.fineos.ta.test.driver.OTestCases.hibernate.Address on table TAddress
13:13:49,203 INFO CollectionBinder:578 - Mapping collection: com.fineos.ta.test.driver.OTestCases.hibernate.Company.employees -> TEmployee
13:13:49,234 INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (not for production use!)
13:13:49,234 INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 20
13:13:49,234 INFO DriverManagerConnectionProvider:45 - autocommit mode: true
13:13:49,234 INFO DriverManagerConnectionProvider:80 - using driver: oracle.jdbc.driver.OracleDriver at URL: jdbc:oracle:thin:@opc151:1521:ora10g
13:13:49,234 INFO DriverManagerConnectionProvider:86 - connection properties: {user=alex_garageDB, password=****, autocommit=true, release_mode=auto}
13:13:49,265 INFO SettingsFactory:78 - RDBMS: Oracle, version: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
13:13:49,265 INFO SettingsFactory:79 - JDBC driver: Oracle JDBC driver, version: 10.2.0.2.0
13:13:49,265 INFO Dialect:128 - Using dialect: org.hibernate.dialect.Oracle9Dialect
13:13:49,265 INFO TransactionFactoryFactory:34 - Transaction strategy: org.hibernate.transaction.JDBCTransactionFactory
13:13:49,265 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
13:13:49,281 INFO SettingsFactory:126 - Automatic flush during beforeCompletion(): disabled
13:13:49,281 INFO SettingsFactory:130 - Automatic session close at end of transaction: disabled
13:13:49,281 INFO SettingsFactory:137 - JDBC batch size: 15
13:13:49,281 INFO SettingsFactory:140 - JDBC batch updates for versioned data: disabled
13:13:49,281 INFO SettingsFactory:145 - Scrollable result sets: enabled
13:13:49,281 INFO SettingsFactory:153 - JDBC3 getGeneratedKeys(): disabled
13:13:49,281 INFO SettingsFactory:161 - Connection release mode: auto
13:13:49,281 INFO SettingsFactory:188 - Default batch fetch size: 1
13:13:49,281 INFO SettingsFactory:192 - Generate SQL with comments: disabled
13:13:49,281 INFO SettingsFactory:196 - Order SQL updates by primary key: disabled
13:13:49,281 INFO SettingsFactory:357 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
13:13:49,281 INFO ASTQueryTranslatorFactory:24 - Using ASTQueryTranslatorFactory
13:13:49,281 INFO SettingsFactory:204 - Query language substitutions: {}
13:13:49,281 INFO SettingsFactory:210 - Second-level cache: enabled
13:13:49,281 INFO SettingsFactory:214 - Query cache: disabled
13:13:49,281 INFO SettingsFactory:344 - Cache provider: org.hibernate.cache.HashtableCacheProvider
13:13:49,281 INFO SettingsFactory:229 - Optimize cache for minimal puts: disabled
13:13:49,281 INFO SettingsFactory:238 - Structured second-level cache entries: disabled
13:13:49,281 INFO SettingsFactory:258 - Echoing all SQL to stdout
13:13:49,281 INFO SettingsFactory:265 - Statistics: disabled
13:13:49,281 INFO SettingsFactory:269 - Deleted entity synthetic identifier rollback: disabled
13:13:49,281 INFO SettingsFactory:284 - Default entity-mode: pojo
13:13:49,296 INFO SessionFactoryImpl:159 - building session factory
13:13:49,453 INFO DriverManagerConnectionProvider:147 - cleaning up connection pool: jdbc:oracle:thin:@opc151:1521:ora10g
13:13:49,468 INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI, no JNDI name configured
13:13:49,468 INFO SchemaUpdate:115 - Running hbm2ddl schema update
13:13:49,468 INFO SchemaUpdate:126 - fetching database metadata
13:13:49,500 INFO SchemaUpdate:138 - updating schema
13:13:49,562 INFO TableMetadata:40 - table found: AKGAR.TADDRESS
13:13:49,578 INFO TableMetadata:41 - columns: [boeversion, i, country, lastupdatedate, street, c, postcode, i_osuser_updatedby, c_osuser_updatedby, flags, city]
13:13:49,578 INFO TableMetadata:43 - foreign keys: []
13:13:49,578 INFO TableMetadata:44 - indexes: [pk_taddress]
13:13:49,843 INFO TableMetadata:40 - table found: AKGAR.TCOMPANY
13:13:49,843 INFO TableMetadata:41 - columns: [i_address_address, i_paddress_paddress, c, c_pmanager_pmanaging_dir, i, boeversion, lastupdatedate, c_address_address, c_osuser_updatedby, i_osuser_updatedby, flags, c_manager_managing_dire, c_paddress_paddress, registerednum, i_pmanager_pmanaging_dir, name, i_manager_managing_dire]
13:13:49,843 INFO TableMetadata:43 - foreign keys: []
13:13:49,843 INFO TableMetadata:44 - indexes: [icompanymanagermanaging_dire, icompanycompanypaddress, icompanyaddressaddress, pk_tcompany, icompanypmanagerpmanaging_dir]
13:13:50,187 INFO TableMetadata:40 - table found: AKGAR.TCUSTOMER
13:13:50,187 INFO TableMetadata:41 - columns: [insuranno, title, c, taxarea, sex, i, c_licence_licence, i_person_spouse, flags, insurance, customernumbe, c_person_spouse, c_address_homeaddress, i_person_bestfriend, secondtitle, i_address_homeaddress, wage_monamt, c_person_bestfriend, lastname, boeversion, i_licence_licence, lastupdatedate, firstname, i_osuser_updatedby, c_osuser_updatedby, taxcode, dateofbirth, wage_moncur, pension]
13:13:50,187 INFO TableMetadata:43 - foreign keys: []
13:13:50,187 INFO TableMetadata:44 - indexes: [icustomrpersonbestfriend, icustomraddresshomeaddress, icustomrlicencelicence, icustomrpersonspouse, pk_tcustomer]
13:13:52,062 INFO TableMetadata:40 - table found: AKGAR.TEMPLOYEE
13:13:52,078 INFO TableMetadata:41 - columns: [c_company_employees, savings_moncur, insuranno, taxarea, byteattr, profile, sex, i_company_employees, c_employe_team, i_person_spouse, c_address_homeaddress, c_person_spouse, secondtitle, fulllicence, employeenumbe, i_address_homeaddress, contracttype, wage_monamt, c_person_bestfriend, boeversion, lastupdatedate, floatattr, c_osuser_updatedby, i_osuser_updatedby, firstname, integerattr, pension, startdate, title, c, blobattr, rsi, salary_monamt, i, salary_moncur, c_licence_licence, savings_monamt, flags, insurance, doubleattr, i_person_bestfriend, medicalhistory, i_manager_manages, shortattr, longattr, lastname, i_employe_team, i_licence_licence, taxcode, c_manager_manages, clobattr, dateofbirth, bigdecimalattr, wage_moncur]
13:13:52,078 INFO TableMetadata:43 - foreign keys: []
13:13:52,078 INFO TableMetadata:44 - indexes: [iemployelicencelicence, iemployeemployeteam, pk_temployee, iemployecompanyemployees, iemployeaddresshomeaddress, iemployepersonspouse, iemployepersonbestfriend, iemployemanagermanages]
13:13:54,406 INFO TableMetadata:40 - table found: AKGAR.TMECHANIC
13:13:54,406 INFO TableMetadata:41 - columns: [c_company_employees, hourlyrate_monamt, savings_moncur, insuranno, taxarea, byteattr, grade, i_wkorder_workers, profile, sex, dept, i_company_employees, c_employe_team, i_person_spouse, c_address_homeaddress, c_person_spouse, secondtitle, fulllicence, employeenumbe, i_address_homeaddress, contracttype, wage_monamt, c_person_bestfriend, boeversion, lastupdatedate, floatattr, firstname, c_osuser_updatedby, i_osuser_updatedby, qualification, integerattr, pension, startdate, title, c, blobattr, rsi, salary_monamt, i, salary_moncur, c_wkorder_workers, c_licence_licence, hourlyrate_moncur, savings_monamt, flags, insurance, doubleattr, i_person_bestfriend, medicalhistory, i_manager_manages, shortattr, longattr, lastname, i_employe_team, i_licence_licence, taxcode, c_manager_manages, clobattr, dateofbirth, bigdecimalattr, email, wage_moncur]
13:13:54,406 INFO TableMetadata:43 - foreign keys: []
13:13:54,406 INFO TableMetadata:44 - indexes: [imechancpersonbestfriend, imechanccompanyemployees, imechancaddresshomeaddress, imechancwkorderworkers, imechancmanagermanages, pk_tmechanic, imechanclicencelicence, imechancpersonspouse, imechancemployeteam]
13:13:54,781 INFO TableMetadata:40 - table found: AKGAR.TPERSON
13:13:54,781 INFO TableMetadata:41 - columns: [insuranno, title, c, taxarea, sex, i, c_licence_licence, i_person_spouse, flags, insurance, c_person_spouse, c_address_homeaddress, i_person_bestfriend, secondtitle, i_address_homeaddress, wage_monamt, c_person_bestfriend, lastname, boeversion, i_licence_licence, lastupdatedate, firstname, i_osuser_updatedby, c_osuser_updatedby, taxcode, dateofbirth, wage_moncur, pension]
13:13:54,781 INFO TableMetadata:43 - foreign keys: []
13:13:54,781 INFO TableMetadata:44 - indexes: [ipersonaddresshomeaddress, pk_tperson, ipersonpersonbestfriend, ipersonpersonspouse, ipersonlicencelicence]
13:13:54,796 ERROR SchemaUpdate:155 - Unsuccessful: alter table TCompany add registeredNumber number(19,0)
13:13:54,796 ERROR SchemaUpdate:156 - ORA-01430: column being added already exists in table

13:13:54,796 ERROR SchemaUpdate:155 - Unsuccessful: alter table TCustomer add customerNumber varchar2(255 char)
13:13:54,796 ERROR SchemaUpdate:156 - ORA-01430: column being added already exists in table

13:13:54,812 ERROR SchemaUpdate:155 - Unsuccessful: alter table TEmployee add employeeNumber number(19,0)
13:13:54,812 ERROR SchemaUpdate:156 - ORA-01430: column being added already exists in table

13:13:54,812 ERROR SchemaUpdate:155 - Unsuccessful: alter table TMechanic add employeeNumber number(19,0)
13:13:54,812 ERROR SchemaUpdate:156 - ORA-01430: column being added already exists in table

13:13:54,828 ERROR SchemaUpdate:155 - Unsuccessful: alter table TEmployee add constraint FKF171B722836FCF31 foreign key (I_COMPANY_EMPLOYEES, C_COMPANY_EMPLOYEES) references TCompany
13:13:54,828 ERROR SchemaUpdate:156 - ORA-02275: such a referential constraint already exists in the table

13:13:54,859 ERROR SchemaUpdate:155 - Unsuccessful: alter table TMechanic add constraint FKF171B722836FCF3172db5ff8 foreign key (I_COMPANY_EMPLOYEES, C_COMPANY_EMPLOYEES) references TCompany
13:13:54,859 ERROR SchemaUpdate:156 - ORA-02275: such a referential constraint already exists in the table

13:13:54,859 INFO SchemaUpdate:160 - schema update complete
13:13:54,859 DEBUG SQL:393 - SELECT SPERSON.NEXTVAL FROM DUAL
Hibernate: SELECT SPERSON.NEXTVAL FROM DUAL
o is 829 class class java.math.BigDecimal
13:13:54,859 INFO SessionFactoryImpl:766 - closing
13:13:54,859 INFO DriverManagerConnectionProvider:147 - cleaning up connection pool: jdbc:oracle:thin:@opc151:1521:ora10g
13:13:54,875 FATAL Ejb3Configuration:504 - META-INF/MANIFEST.MFO-:-Ofalse
13:13:54,875 FATAL Ejb3Configuration:504 - META-INF/persistence.xmlO-:-Ofalse
13:13:54,875 INFO AnnotationBinder:386 - Binding entity from annotated class: com.fineos.ta.test.driver.OTestCases.hibernate.Person
13:13:54,875 INFO EntityBinder:325 - Bind entity com.fineos.ta.test.driver.OTestCases.hibernate.Person on table TPerson
13:13:54,890 INFO AnnotationBinder:386 - Binding entity from annotated class: com.fineos.ta.test.driver.OTestCases.hibernate.Employee
13:13:54,890 INFO EntityBinder:325 - Bind entity com.fineos.ta.test.driver.OTestCases.hibernate.Employee on table TEmployee
13:13:54,890 INFO AnnotationBinder:386 - Binding entity from annotated class: com.fineos.ta.test.driver.OTestCases.hibernate.Company
13:13:54,890 INFO EntityBinder:325 - Bind entity com.fineos.ta.test.driver.OTestCases.hibernate.Company on table TCompany
13:13:54,890 INFO AnnotationBinder:386 - Binding entity from annotated class: com.fineos.ta.test.driver.OTestCases.hibernate.Customer
13:13:54,890 INFO EntityBinder:325 - Bind entity com.fineos.ta.test.driver.OTestCases.hibernate.Customer on table TCustomer
13:13:54,890 INFO AnnotationBinder:386 - Binding entity from annotated class: com.fineos.ta.test.driver.OTestCases.hibernate.Mechanic
13:13:54,890 INFO EntityBinder:325 - Bind entity com.fineos.ta.test.driver.OTestCases.hibernate.Mechanic on table TMechanic
13:13:54,890 INFO AnnotationBinder:386 - Binding entity from annotated class: com.fineos.ta.test.driver.OTestCases.hibernate.Address
13:13:54,890 INFO EntityBinder:325 - Bind entity com.fineos.ta.test.driver.OTestCases.hibernate.Address on table TAddress
13:13:54,906 INFO CollectionBinder:578 - Mapping collection: com.fineos.ta.test.driver.OTestCases.hibernate.Company.employees -> TEmployee
13:13:54,921 INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (not for production use!)
13:13:54,921 INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 20
13:13:54,921 INFO DriverManagerConnectionProvider:45 - autocommit mode: true
13:13:54,921 INFO DriverManagerConnectionProvider:80 - using driver: oracle.jdbc.driver.OracleDriver at URL: jdbc:oracle:thin:@opc151:1521:ora10g
13:13:54,921 INFO DriverManagerConnectionProvider:86 - connection properties: {user=alex_garageDB, password=****, autocommit=true, release_mode=auto}
13:13:54,968 INFO SettingsFactory:78 - RDBMS: Oracle, version: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
13:13:54,968 INFO SettingsFactory:79 - JDBC driver: Oracle JDBC driver, version: 10.2.0.2.0
13:13:54,968 INFO Dialect:128 - Using dialect: org.hibernate.dialect.Oracle9Dialect
13:13:54,968 INFO TransactionFactoryFactory:34 - Transaction strategy: org.hibernate.transaction.JDBCTransactionFactory
13:13:54,968 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
13:13:54,968 INFO SettingsFactory:126 - Automatic flush during beforeCompletion(): disabled
13:13:54,968 INFO SettingsFactory:130 - Automatic session close at end of transaction: disabled
13:13:54,968 INFO SettingsFactory:137 - JDBC batch size: 15
13:13:54,968 INFO SettingsFactory:140 - JDBC batch updates for versioned data: disabled
13:13:54,968 INFO SettingsFactory:145 - Scrollable result sets: enabled
13:13:54,968 INFO SettingsFactory:153 - JDBC3 getGeneratedKeys(): disabled
13:13:54,968 INFO SettingsFactory:161 - Connection release mode: auto
13:13:54,968 INFO SettingsFactory:188 - Default batch fetch size: 1
13:13:54,968 INFO SettingsFactory:192 - Generate SQL with comments: disabled
13:13:54,968 INFO SettingsFactory:196 - Order SQL updates by primary key: disabled
13:13:54,968 INFO SettingsFactory:357 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
13:13:54,968 INFO ASTQueryTranslatorFactory:24 - Using ASTQueryTranslatorFactory
13:13:54,968 INFO SettingsFactory:204 - Query language substitutions: {}
13:13:54,968 INFO SettingsFactory:210 - Second-level cache: enabled
13:13:54,968 INFO SettingsFactory:214 - Query cache: disabled
13:13:54,968 INFO SettingsFactory:344 - Cache provider: org.hibernate.cache.HashtableCacheProvider
13:13:54,968 INFO SettingsFactory:229 - Optimize cache for minimal puts: disabled
13:13:54,968 INFO SettingsFactory:238 - Structured second-level cache entries: disabled
13:13:54,968 INFO SettingsFactory:258 - Echoing all SQL to stdout
13:13:54,984 INFO SettingsFactory:265 - Statistics: disabled
13:13:54,984 INFO SettingsFactory:269 - Deleted entity synthetic identifier rollback: disabled
13:13:54,984 INFO SettingsFactory:284 - Default entity-mode: pojo
13:13:55,000 INFO SessionFactoryImpl:159 - building session factory
13:13:55,109 INFO DriverManagerConnectionProvider:147 - cleaning up connection pool: jdbc:oracle:thin:@opc151:1521:ora10g
13:13:55,156 INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI, no JNDI name configured
13:13:55,156 INFO SchemaUpdate:115 - Running hbm2ddl schema update
13:13:55,156 INFO SchemaUpdate:126 - fetching database metadata
13:13:55,187 INFO SchemaUpdate:138 - updating schema
13:13:55,234 INFO TableMetadata:40 - table found: AKGAR.TADDRESS
13:13:55,234 INFO TableMetadata:41 - columns: [boeversion, i, country, lastupdatedate, street, c, postcode, i_osuser_updatedby, c_osuser_updatedby, flags, city]
13:13:55,234 INFO TableMetadata:43 - foreign keys: []
13:13:55,234 INFO TableMetadata:44 - indexes: [pk_taddress]
13:13:55,468 INFO TableMetadata:40 - table found: AKGAR.TCOMPANY
13:13:55,468 INFO TableMetadata:41 - columns: [i_address_address, i_paddress_paddress, c, c_pmanager_pmanaging_dir, i, boeversion, lastupdatedate, c_address_address, c_osuser_updatedby, i_osuser_updatedby, flags, c_manager_managing_dire, c_paddress_paddress, registerednum, i_pmanager_pmanaging_dir, name, i_manager_managing_dire]
13:13:55,468 INFO TableMetadata:43 - foreign keys: []
13:13:55,468 INFO TableMetadata:44 - indexes: [icompanymanagermanaging_dire, icompanycompanypaddress, icompanyaddressaddress, pk_tcompany, icompanypmanagerpmanaging_dir]
13:13:55,859 INFO TableMetadata:40 - table found: AKGAR.TCUSTOMER
13:13:55,859 INFO TableMetadata:41 - columns: [insuranno, title, c, taxarea, sex, i, c_licence_licence, i_person_spouse, flags, insurance, customernumbe, c_person_spouse, c_address_homeaddress, i_person_bestfriend, secondtitle, i_address_homeaddress, wage_monamt, c_person_bestfriend, lastname, boeversion, i_licence_licence, lastupdatedate, firstname, i_osuser_updatedby, c_osuser_updatedby, taxcode, dateofbirth, wage_moncur, pension]
13:13:55,859 INFO TableMetadata:43 - foreign keys: []
13:13:55,859 INFO TableMetadata:44 - indexes: [icustomrpersonbestfriend, icustomraddresshomeaddress, icustomrlicencelicence, icustomrpersonspouse, pk_tcustomer]
13:13:57,625 INFO TableMetadata:40 - table found: AKGAR.TEMPLOYEE
13:13:57,625 INFO TableMetadata:41 - columns: [c_company_employees, savings_moncur, insuranno, taxarea, byteattr, profile, sex, i_company_employees, c_employe_team, i_person_spouse, c_address_homeaddress, c_person_spouse, secondtitle, fulllicence, employeenumbe, i_address_homeaddress, contracttype, wage_monamt, c_person_bestfriend, boeversion, lastupdatedate, floatattr, c_osuser_updatedby, i_osuser_updatedby, firstname, integerattr, pension, startdate, title, c, blobattr, rsi, salary_monamt, i, salary_moncur, c_licence_licence, savings_monamt, flags, insurance, doubleattr, i_person_bestfriend, medicalhistory, i_manager_manages, shortattr, longattr, lastname, i_employe_team, i_licence_licence, taxcode, c_manager_manages, clobattr, dateofbirth, bigdecimalattr, wage_moncur]
13:13:57,640 INFO TableMetadata:43 - foreign keys: []
13:13:57,640 INFO TableMetadata:44 - indexes: [iemployelicencelicence, iemployeemployeteam, pk_temployee, iemployecompanyemployees, iemployeaddresshomeaddress, iemployepersonspouse, iemployepersonbestfriend, iemployemanagermanages]
13:13:59,984 INFO TableMetadata:40 - table found: AKGAR.TMECHANIC
13:13:59,984 INFO TableMetadata:41 - columns: [c_company_employees, hourlyrate_monamt, savings_moncur, insuranno, taxarea, byteattr, grade, i_wkorder_workers, profile, sex, dept, i_company_employees, c_employe_team, i_person_spouse, c_address_homeaddress, c_person_spouse, secondtitle, fulllicence, employeenumbe, i_address_homeaddress, contracttype, wage_monamt, c_person_bestfriend, boeversion, lastupdatedate, floatattr, firstname, c_osuser_updatedby, i_osuser_updatedby, qualification, integerattr, pension, startdate, title, c, blobattr, rsi, salary_monamt, i, salary_moncur, c_wkorder_workers, c_licence_licence, hourlyrate_moncur, savings_monamt, flags, insurance, doubleattr, i_person_bestfriend, medicalhistory, i_manager_manages, shortattr, longattr, lastname, i_employe_team, i_licence_licence, taxcode, c_manager_manages, clobattr, dateofbirth, bigdecimalattr, email, wage_moncur]
13:14:00,000 INFO TableMetadata:43 - foreign keys: []
13:14:00,000 INFO TableMetadata:44 - indexes: [imechancpersonbestfriend, imechanccompanyemployees, imechancaddresshomeaddress, imechancwkorderworkers, imechancmanagermanages, pk_tmechanic, imechanclicencelicence, imechancpersonspouse, imechancemployeteam]
13:14:00,390 INFO TableMetadata:40 - table found: AKGAR.TPERSON
13:14:00,390 INFO TableMetadata:41 - columns: [insuranno, title, c, taxarea, sex, i, c_licence_licence, i_person_spouse, flags, insurance, c_person_spouse, c_address_homeaddress, i_person_bestfriend, secondtitle, i_address_homeaddress, wage_monamt, c_person_bestfriend, lastname, boeversion, i_licence_licence, lastupdatedate, firstname, i_osuser_updatedby, c_osuser_updatedby, taxcode, dateofbirth, wage_moncur, pension]
13:14:00,390 INFO TableMetadata:43 - foreign keys: []
13:14:00,390 INFO TableMetadata:44 - indexes: [ipersonaddresshomeaddress, pk_tperson, ipersonpersonbestfriend, ipersonpersonspouse, ipersonlicencelicence]
13:14:00,390 ERROR SchemaUpdate:155 - Unsuccessful: alter table TCompany add registeredNumber number(19,0)
13:14:00,390 ERROR SchemaUpdate:156 - ORA-01430: column being added already exists in table

13:14:00,406 ERROR SchemaUpdate:155 - Unsuccessful: alter table TCustomer add customerNumber varchar2(255 char)
13:14:00,406 ERROR SchemaUpdate:156 - ORA-01430: column being added already exists in table

13:14:00,437 ERROR SchemaUpdate:155 - Unsuccessful: alter table TEmployee add employeeNumber number(19,0)
13:14:00,437 ERROR SchemaUpdate:156 - ORA-01430: column being added already exists in table

13:14:00,453 ERROR SchemaUpdate:155 - Unsuccessful: alter table TMechanic add employeeNumber number(19,0)
13:14:00,453 ERROR SchemaUpdate:156 - ORA-01430: column being added already exists in table

13:14:00,468 ERROR SchemaUpdate:155 - Unsuccessful: alter table TEmployee add constraint FKF171B722836FCF31 foreign key (I_COMPANY_EMPLOYEES, C_COMPANY_EMPLOYEES) references TCompany
13:14:00,468 ERROR SchemaUpdate:156 - ORA-02275: such a referential constraint already exists in the table

13:14:00,500 ERROR SchemaUpdate:155 - Unsuccessful: alter table TMechanic add constraint FKF171B722836FCF3172db5ff8 foreign key (I_COMPANY_EMPLOYEES, C_COMPANY_EMPLOYEES) references TCompany
13:14:00,500 ERROR SchemaUpdate:156 - ORA-02275: such a referential constraint already exists in the table

13:14:00,500 INFO SchemaUpdate:160 - schema update complete
13:14:00,500 DEBUG SQL:393 - SELECT SEMPLOYEE.NEXTVAL FROM DUAL
Hibernate: SELECT SEMPLOYEE.NEXTVAL FROM DUAL
o is 229 class class java.math.BigDecimal
13:14:00,500 INFO SessionFactoryImpl:766 - closing
13:14:00,500 INFO DriverManagerConnectionProvider:147 - cleaning up connection pool: jdbc:oracle:thin:@opc151:1521:ora10g
13:14:00,515 FATAL Ejb3Configuration:504 - META-INF/MANIFEST.MFO-:-Ofalse
13:14:00,515 FATAL Ejb3Configuration:504 - META-INF/persistence.xmlO-:-Ofalse
13:14:00,515 INFO AnnotationBinder:386 - Binding entity from annotated class: com.fineos.ta.test.driver.OTestCases.hibernate.Person
13:14:00,515 INFO EntityBinder:325 - Bind entity com.fineos.ta.test.driver.OTestCases.hibernate.Person on table TPerson
13:14:00,531 INFO AnnotationBinder:386 - Binding entity from annotated class: com.fineos.ta.test.driver.OTestCases.hibernate.Employee
13:14:00,531 INFO EntityBinder:325 - Bind entity com.fineos.ta.test.driver.OTestCases.hibernate.Employee on table TEmployee
13:14:00,531 INFO AnnotationBinder:386 - Binding entity from annotated class: com.fineos.ta.test.driver.OTestCases.hibernate.Company
13:14:00,531 INFO EntityBinder:325 - Bind entity com.fineos.ta.test.driver.OTestCases.hibernate.Company on table TCompany
13:14:00,531 INFO AnnotationBinder:386 - Binding entity from annotated class: com.fineos.ta.test.driver.OTestCases.hibernate.Customer
13:14:00,531 INFO EntityBinder:325 - Bind entity com.fineos.ta.test.driver.OTestCases.hibernate.Customer on table TCustomer
13:14:00,531 INFO AnnotationBinder:386 - Binding entity from annotated class: com.fineos.ta.test.driver.OTestCases.hibernate.Mechanic
13:14:00,531 INFO EntityBinder:325 - Bind entity com.fineos.ta.test.driver.OTestCases.hibernate.Mechanic on table TMechanic
13:14:00,531 INFO AnnotationBinder:386 - Binding entity from annotated class: com.fineos.ta.test.driver.OTestCases.hibernate.Address
13:14:00,546 INFO EntityBinder:325 - Bind entity com.fineos.ta.test.driver.OTestCases.hibernate.Address on table TAddress
13:14:00,546 INFO CollectionBinder:578 - Mapping collection: com.fineos.ta.test.driver.OTestCases.hibernate.Company.employees -> TEmployee
13:14:00,562 INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (not for production use!)
13:14:00,578 INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 20
13:14:00,578 INFO DriverManagerConnectionProvider:45 - autocommit mode: true
13:14:00,578 INFO DriverManagerConnectionProvider:80 - using driver: oracle.jdbc.driver.OracleDriver at URL: jdbc:oracle:thin:@opc151:1521:ora10g
13:14:00,578 INFO DriverManagerConnectionProvider:86 - connection properties: {user=alex_garageDB, password=****, autocommit=true, release_mode=auto}
13:14:00,609 INFO SettingsFactory:78 - RDBMS: Oracle, version: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
13:14:00,609 INFO SettingsFactory:79 - JDBC driver: Oracle JDBC driver, version: 10.2.0.2.0
13:14:00,609 INFO Dialect:128 - Using dialect: org.hibernate.dialect.Oracle9Dialect
13:14:00,609 INFO TransactionFactoryFactory:34 - Transaction strategy: org.hibernate.transaction.JDBCTransactionFactory
13:14:00,609 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
13:14:00,609 INFO SettingsFactory:126 - Automatic flush during beforeCompletion(): disabled
13:14:00,609 INFO SettingsFactory:130 - Automatic session close at end of transaction: disabled
13:14:00,609 INFO SettingsFactory:137 - JDBC batch size: 15
13:14:00,609 INFO SettingsFactory:140 - JDBC batch updates for versioned data: disabled
13:14:00,609 INFO SettingsFactory:145 - Scrollable result sets: enabled
13:14:00,625 INFO SettingsFactory:153 - JDBC3 getGeneratedKeys(): disabled
13:14:00,625 INFO SettingsFactory:161 - Connection release mode: auto
13:14:00,625 INFO SettingsFactory:188 - Default batch fetch size: 1
13:14:00,625 INFO SettingsFactory:192 - Generate SQL with comments: disabled
13:14:00,625 INFO SettingsFactory:196 - Order SQL updates by primary key: disabled
13:14:00,625 INFO SettingsFactory:357 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
13:14:00,625 INFO ASTQueryTranslatorFactory:24 - Using ASTQueryTranslatorFactory
13:14:00,625 INFO SettingsFactory:204 - Query language substitutions: {}
13:14:00,625 INFO SettingsFactory:210 - Second-level cache: enabled
13:14:00,625 INFO SettingsFactory:214 - Query cache: disabled
13:14:00,625 INFO SettingsFactory:344 - Cache provider: org.hibernate.cache.HashtableCacheProvider
13:14:00,625 INFO SettingsFactory:229 - Optimize cache for minimal puts: disabled
13:14:00,625 INFO SettingsFactory:238 - Structured second-level cache entries: disabled
13:14:00,625 INFO SettingsFactory:258 - Echoing all SQL to stdout
13:14:00,625 INFO SettingsFactory:265 - Statistics: disabled
13:14:00,625 INFO SettingsFactory:269 - Deleted entity synthetic identifier rollback: disabled
13:14:00,625 INFO SettingsFactory:284 - Default entity-mode: pojo
13:14:00,640 INFO SessionFactoryImpl:159 - building session factory
13:14:00,750 INFO DriverManagerConnectionProvider:147 - cleaning up connection pool: jdbc:oracle:thin:@opc151:1521:ora10g
13:14:00,812 INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI, no JNDI name configured
13:14:00,812 INFO SchemaUpdate:115 - Running hbm2ddl schema update
13:14:00,812 INFO SchemaUpdate:126 - fetching database metadata
13:14:00,843 INFO SchemaUpdate:138 - updating schema
13:14:00,890 INFO TableMetadata:40 - table found: AKGAR.TADDRESS
13:14:00,890 INFO TableMetadata:41 - columns: [boeversion, i, country, lastupdatedate, street, c, postcode, i_osuser_updatedby, c_osuser_updatedby, flags, city]
13:14:00,890 INFO TableMetadata:43 - foreign keys: []
13:14:00,890 INFO TableMetadata:44 - indexes: [pk_taddress]
13:14:01,140 INFO TableMetadata:40 - table found: AKGAR.TCOMPANY
13:14:01,140 INFO TableMetadata:41 - columns: [i_address_address, i_paddress_paddress, c, c_pmanager_pmanaging_dir, i, boeversion, lastupdatedate, c_address_address, c_osuser_updatedby, i_osuser_updatedby, flags, c_manager_managing_dire, c_paddress_paddress, registerednum, i_pmanager_pmanaging_dir, name, i_manager_managing_dire]
13:14:01,140 INFO TableMetadata:43 - foreign keys: []
13:14:01,140 INFO TableMetadata:44 - indexes: [icompanymanagermanaging_dire, icompanycompanypaddress, icompanyaddressaddress, pk_tcompany, icompanypmanagerpmanaging_dir]
13:14:01,500 INFO TableMetadata:40 - table found: AKGAR.TCUSTOMER
13:14:01,500 INFO TableMetadata:41 - columns: [insuranno, title, c, taxarea, sex, i, c_licence_licence, i_person_spouse, flags, insurance, customernumbe, c_person_spouse, c_address_homeaddress, i_person_bestfriend, secondtitle, i_address_homeaddress, wage_monamt, c_person_bestfriend, lastname, boeversion, i_licence_licence, lastupdatedate, firstname, i_osuser_updatedby, c_osuser_updatedby, taxcode, dateofbirth, wage_moncur, pension]
13:14:01,500 INFO TableMetadata:43 - foreign keys: []
13:14:01,500 INFO TableMetadata:44 - indexes: [icustomrpersonbestfriend, icustomraddresshomeaddress, icustomrlicencelicence, icustomrpersonspouse, pk_tcustomer]
13:14:03,156 INFO TableMetadata:40 - table found: AKGAR.TEMPLOYEE
13:14:03,156 INFO TableMetadata:41 - columns: [c_company_employees, savings_moncur, insuranno, taxarea, byteattr, profile, sex, i_company_employees, c_employe_team, i_person_spouse, c_address_homeaddress, c_person_spouse, secondtitle, fulllicence, employeenumbe, i_address_homeaddress, contracttype, wage_monamt, c_person_bestfriend, boeversion, lastupdatedate, floatattr, c_osuser_updatedby, i_osuser_updatedby, firstname, integerattr, pension, startdate, title, c, blobattr, rsi, salary_monamt, i, salary_moncur, c_licence_licence, savings_monamt, flags, insurance, doubleattr, i_person_bestfriend, medicalhistory, i_manager_manages, shortattr, longattr, lastname, i_employe_team, i_licence_licence, taxcode, c_manager_manages, clobattr, dateofbirth, bigdecimalattr, wage_moncur]
13:14:03,156 INFO TableMetadata:43 - foreign keys: []
13:14:03,156 INFO TableMetadata:44 - indexes: [iemployelicencelicence, iemployeemployeteam, pk_temployee, iemployecompanyemployees, iemployeaddresshomeaddress, iemployepersonspouse, iemployepersonbestfriend, iemployemanagermanages]
13:14:05,593 INFO TableMetadata:40 - table found: AKGAR.TMECHANIC
13:14:05,593 INFO TableMetadata:41 - columns: [c_company_employees, hourlyrate_monamt, savings_moncur, insuranno, taxarea, byteattr, grade, i_wkorder_workers, profile, sex, dept, i_company_employees, c_employe_team, i_person_spouse, c_address_homeaddress, c_person_spouse, secondtitle, fulllicence, employeenumbe, i_address_homeaddress, contracttype, wage_monamt, c_person_bestfriend, boeversion, lastupdatedate, floatattr, firstname, c_osuser_updatedby, i_osuser_updatedby, qualification, integerattr, pension, startdate, title, c, blobattr, rsi, salary_monamt, i, salary_moncur, c_wkorder_workers, c_licence_licence, hourlyrate_moncur, savings_monamt, flags, insurance, doubleattr, i_person_bestfriend, medicalhistory, i_manager_manages, shortattr, longattr, lastname, i_employe_team, i_licence_licence, taxcode, c_manager_manages, clobattr, dateofbirth, bigdecimalattr, email, wage_moncur]
13:14:05,609 INFO TableMetadata:43 - foreign keys: []
13:14:05,609 INFO TableMetadata:44 - indexes: [imechancpersonbestfriend, imechanccompanyemployees, imechancaddresshomeaddress, imechancwkorderworkers, imechancmanagermanages, pk_tmechanic, imechanclicencelicence, imechancpersonspouse, imechancemployeteam]
13:14:06,109 INFO TableMetadata:40 - table found: AKGAR.TPERSON
13:14:06,109 INFO TableMetadata:41 - columns: [insuranno, title, c, taxarea, sex, i, c_licence_licence, i_person_spouse, flags, insurance, c_person_spouse, c_address_homeaddress, i_person_bestfriend, secondtitle, i_address_homeaddress, wage_monamt, c_person_bestfriend, lastname, boeversion, i_licence_licence, lastupdatedate, firstname, i_osuser_updatedby, c_osuser_updatedby, taxcode, dateofbirth, wage_moncur, pension]
13:14:06,125 INFO TableMetadata:43 - foreign keys: []
13:14:06,125 INFO TableMetadata:44 - indexes: [ipersonaddresshomeaddress, pk_tperson, ipersonpersonbestfriend, ipersonpersonspouse, ipersonlicencelicence]
13:14:06,125 ERROR SchemaUpdate:155 - Unsuccessful: alter table TCompany add registeredNumber number(19,0)
13:14:06,125 ERROR SchemaUpdate:156 - ORA-01430: column being added already exists in table

13:14:06,140 ERROR SchemaUpdate:155 - Unsuccessful: alter table TCustomer add customerNumber varchar2(255 char)
13:14:06,140 ERROR SchemaUpdate:156 - ORA-01430: column being added already exists in table

13:14:06,156 ERROR SchemaUpdate:155 - Unsuccessful: alter table TEmployee add employeeNumber number(19,0)
13:14:06,156 ERROR SchemaUpdate:156 - ORA-01430: column being added already exists in table

13:14:06,171 ERROR SchemaUpdate:155 - Unsuccessful: alter table TMechanic add employeeNumber number(19,0)
13:14:06,171 ERROR SchemaUpdate:156 - ORA-01430: column being added already exists in table

13:14:06,187 ERROR SchemaUpdate:155 - Unsuccessful: alter table TEmployee add constraint FKF171B722836FCF31 foreign key (I_COMPANY_EMPLOYEES, C_COMPANY_EMPLOYEES) references TCompany
13:14:06,187 ERROR SchemaUpdate:156 - ORA-02275: such a referential constraint already exists in the table

13:14:06,218 ERROR SchemaUpdate:155 - Unsuccessful: alter table TMechanic add constraint FKF171B722836FCF3172db5ff8 foreign key (I_COMPANY_EMPLOYEES, C_COMPANY_EMPLOYEES) references TCompany
13:14:06,218 ERROR SchemaUpdate:156 - ORA-02275: such a referential constraint already exists in the table

13:14:06,218 INFO SchemaUpdate:160 - schema update complete
13:14:06,218 DEBUG SQL:393 - SELECT SPERSON.NEXTVAL FROM DUAL
Hibernate: SELECT SPERSON.NEXTVAL FROM DUAL
o is 830 class class java.math.BigDecimal
13:14:06,218 INFO SessionFactoryImpl:766 - closing
13:14:06,218 INFO DriverManagerConnectionProvider:147 - cleaning up connection pool: jdbc:oracle:thin:@opc151:1521:ora10g
13:14:06,234 FATAL Ejb3Configuration:504 - META-INF/MANIFEST.MFO-:-Ofalse
13:14:06,234 FATAL Ejb3Configuration:504 - META-INF/persistence.xmlO-:-Ofalse
13:14:06,234 INFO AnnotationBinder:386 - Binding entity from annotated class: com.fineos.ta.test.driver.OTestCases.hibernate.Person
13:14:06,234 INFO EntityBinder:325 - Bind entity com.fineos.ta.test.driver.OTestCases.hibernate.Person on table TPerson
13:14:06,250 INFO AnnotationBinder:386 - Binding entity from annotated class: com.fineos.ta.test.driver.OTestCases.hibernate.Employee
13:14:06,343 INFO EntityBinder:325 - Bind entity com.fineos.ta.test.driver.OTestCases.hibernate.Employee on table TEmployee
13:14:06,343 INFO AnnotationBinder:386 - Binding entity from annotated class: com.fineos.ta.test.driver.OTestCases.hibernate.Company
13:14:06,343 INFO EntityBinder:325 - Bind entity com.fineos.ta.test.driver.OTestCases.hibernate.Company on table TCompany
13:14:06,343 INFO AnnotationBinder:386 - Binding entity from annotated class: com.fineos.ta.test.driver.OTestCases.hibernate.Customer
13:14:06,343 INFO EntityBinder:325 - Bind entity com.fineos.ta.test.driver.OTestCases.hibernate.Customer on table TCustomer
13:14:06,343 INFO AnnotationBinder:386 - Binding entity from annotated class: com.fineos.ta.test.driver.OTestCases.hibernate.Mechanic
13:14:06,343 INFO EntityBinder:325 - Bind entity com.fineos.ta.test.driver.OTestCases.hibernate.Mechanic on table TMechanic
13:14:06,343 INFO AnnotationBinder:386 - Binding entity from annotated class: com.fineos.ta.test.driver.OTestCases.hibernate.Address
13:14:06,359 INFO EntityBinder:325 - Bind entity com.fineos.ta.test.driver.OTestCases.hibernate.Address on table TAddress
13:14:06,359 INFO CollectionBinder:578 - Mapping collection: com.fineos.ta.test.driver.OTestCases.hibernate.Company.employees -> TEmployee
13:14:06,375 INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (not for production use!)
13:14:06,375 INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 20
13:14:06,375 INFO DriverManagerConnectionProvider:45 - autocommit mode: true
13:14:06,375 INFO DriverManagerConnectionProvider:80 - using driver: oracle.jdbc.driver.OracleDriver at URL: jdbc:oracle:thin:@opc151:1521:ora10g
13:14:06,375 INFO DriverManagerConnectionProvider:86 - connection properties: {user=alex_garageDB, password=****, autocommit=true, release_mode=auto}
13:14:06,421 INFO SettingsFactory:78 - RDBMS: Oracle, version: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
13:14:06,421 INFO SettingsFactory:79 - JDBC driver: Oracle JDBC driver, version: 10.2.0.2.0
13:14:06,421 INFO Dialect:128 - Using dialect: org.hibernate.dialect.Oracle9Dialect
13:14:06,421 INFO TransactionFactoryFactory:34 - Transaction strategy: org.hibernate.transaction.JDBCTransactionFactory
13:14:06,421 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
13:14:06,421 INFO SettingsFactory:126 - Automatic flush during beforeCompletion(): disabled
13:14:06,421 INFO SettingsFactory:130 - Automatic session close at end of transaction: disabled
13:14:06,421 INFO SettingsFactory:137 - JDBC batch size: 15
13:14:06,421 INFO SettingsFactory:140 - JDBC batch updates for versioned data: disabled
13:14:06,421 INFO SettingsFactory:145 - Scrollable result sets: enabled
13:14:06,421 INFO SettingsFactory:153 - JDBC3 getGeneratedKeys(): disabled
13:14:06,421 INFO SettingsFactory:161 - Connection release mode: auto
13:14:06,421 INFO SettingsFactory:188 - Default batch fetch size: 1
13:14:06,421 INFO SettingsFactory:192 - Generate SQL with comments: disabled
13:14:06,421 INFO SettingsFactory:196 - Order SQL updates by primary key: disabled
13:14:06,421 INFO SettingsFactory:357 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
13:14:06,437 INFO ASTQueryTranslatorFactory:24 - Using ASTQueryTranslatorFactory
13:14:06,437 INFO SettingsFactory:204 - Query language substitutions: {}
13:14:06,437 INFO SettingsFactory:210 - Second-level cache: enabled
13:14:06,437 INFO SettingsFactory:214 - Query cache: disabled
13:14:06,437 INFO SettingsFactory:344 - Cache provider: org.hibernate.cache.HashtableCacheProvider
13:14:06,437 INFO SettingsFactory:229 - Optimize cache for minimal puts: disabled
13:14:06,437 INFO SettingsFactory:238 - Structured second-level cache entries: disabled
13:14:06,437 INFO SettingsFactory:258 - Echoing all SQL to stdout
13:14:06,437 INFO SettingsFactory:265 - Statistics: disabled
13:14:06,437 INFO SettingsFactory:269 - Deleted entity synthetic identifier rollback: disabled
13:14:06,437 INFO SettingsFactory:284 - Default entity-mode: pojo
13:14:06,453 INFO SessionFactoryImpl:159 - building session factory
13:14:06,625 INFO DriverManagerConnectionProvider:147 - cleaning up connection pool: jdbc:oracle:thin:@opc151:1521:ora10g
13:14:06,687 INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI, no JNDI name configured
13:14:06,687 INFO SchemaUpdate:115 - Running hbm2ddl schema update
13:14:06,687 INFO SchemaUpdate:126 - fetching database metadata
13:14:06,703 INFO SchemaUpdate:138 - updating schema
13:14:06,765 INFO TableMetadata:40 - table found: AKGAR.TADDRESS
13:14:06,765 INFO TableMetadata:41 - columns: [boeversion, i, country, lastupdatedate, street, c, postcode, i_osuser_updatedby, c_osuser_updatedby, flags, city]
13:14:06,765 INFO TableMetadata:43 - foreign keys: []
13:14:06,765 INFO TableMetadata:44 - indexes: [pk_taddress]
13:14:07,015 INFO TableMetadata:40 - table found: AKGAR.TCOMPANY
13:14:07,015 INFO TableMetadata:41 - columns: [i_address_address, i_paddress_paddress, c, c_pmanager_pmanaging_dir, i, boeversion, lastupdatedate, c_address_address, c_osuser_updatedby, i_osuser_updatedby, flags, c_manager_managing_dire, c_paddress_paddress, registerednum, i_pmanager_pmanaging_dir, name, i_manager_managing_dire]
13:14:07,015 INFO TableMetadata:43 - foreign keys: []
13:14:07,015 INFO TableMetadata:44 - indexes: [icompanymanagermanaging_dire, icompanycompanypaddress, icompanyaddressaddress, pk_tcompany, icompanypmanagerpmanaging_dir]
13:14:07,406 INFO TableMetadata:40 - table found: AKGAR.TCUSTOMER
13:14:07,406 INFO TableMetadata:41 - columns: [insuranno, title, c, taxarea, sex, i, c_licence_licence, i_person_spouse, flags, insurance, customernumbe, c_person_spouse, c_address_homeaddress, i_person_bestfriend, secondtitle, i_address_homeaddress, wage_monamt, c_person_bestfriend, lastname, boeversion, i_licence_licence, lastupdatedate, firstname, i_osuser_updatedby, c_osuser_updatedby, taxcode, dateofbirth, wage_moncur, pension]
13:14:07,406 INFO TableMetadata:43 - foreign keys: []
13:14:07,406 INFO TableMetadata:44 - indexes: [icustomrpersonbestfriend, icustomraddresshomeaddress, icustomrlicencelicence, icustomrpersonspouse, pk_tcustomer]
13:14:08,968 INFO TableMetadata:40 - table found: AKGAR.TEMPLOYEE
13:14:08,968 INFO TableMetadata:41 - columns: [c_company_employees, savings_moncur, insuranno, taxarea, byteattr, profile, sex, i_company_employees, c_employe_team, i_person_spouse, c_address_homeaddress, c_person_spouse, secondtitle, fulllicence, employeenumbe, i_address_homeaddress, contracttype, wage_monamt, c_person_bestfriend, boeversion, lastupdatedate, floatattr, c_osuser_updatedby, i_osuser_updatedby, firstname, integerattr, pension, startdate, title, c, blobattr, rsi, salary_monamt, i, salary_moncur, c_licence_licence, savings_monamt, flags, insurance, doubleattr, i_person_bestfriend, medicalhistory, i_manager_manages, shortattr, longattr, lastname, i_employe_team, i_licence_licence, taxcode, c_manager_manages, clobattr, dateofbirth, bigdecimalattr, wage_moncur]
13:14:08,968 INFO TableMetadata:43 - foreign keys: []
13:14:08,968 INFO TableMetadata:44 - indexes: [iemployelicencelicence, iemployeemployeteam, pk_temployee, iemployecompanyemployees, iemployeaddresshomeaddress, iemployepersonspouse, iemployepersonbestfriend, iemployemanagermanages]
13:14:11,109 INFO TableMetadata:40 - table found: AKGAR.TMECHANIC
13:14:11,109 INFO TableMetadata:41 - columns: [c_company_employees, hourlyrate_monamt, savings_moncur, insuranno, taxarea, byteattr, grade, i_wkorder_workers, profile, sex, dept, i_company_employees, c_employe_team, i_person_spouse, c_address_homeaddress, c_person_spouse, secondtitle, fulllicence, employeenumbe, i_address_homeaddress, contracttype, wage_monamt, c_person_bestfriend, boeversion, lastupdatedate, floatattr, firstname, c_osuser_updatedby, i_osuser_updatedby, qualification, integerattr, pension, startdate, title, c, blobattr, rsi, salary_monamt, i, salary_moncur, c_wkorder_workers, c_licence_licence, hourlyrate_moncur, savings_monamt, flags, insurance, doubleattr, i_person_bestfriend, medicalhistory, i_manager_manages, shortattr, longattr, lastname, i_employe_team, i_licence_licence, taxcode, c_manager_manages, clobattr, dateofbirth, bigdecimalattr, email, wage_moncur]
13:14:11,109 INFO TableMetadata:43 - foreign keys: []
13:14:11,109 INFO TableMetadata:44 - indexes: [imechancpersonbestfriend, imechanccompanyemployees, imechancaddresshomeaddress, imechancwkorderworkers, imechancmanagermanages, pk_tmechanic, imechanclicencelicence, imechancpersonspouse, imechancemployeteam]
13:14:11,484 INFO TableMetadata:40 - table found: AKGAR.TPERSON
13:14:11,484 INFO TableMetadata:41 - columns: [insuranno, title, c, taxarea, sex, i, c_licence_licence, i_person_spouse, flags, insurance, c_person_spouse, c_address_homeaddress, i_person_bestfriend, secondtitle, i_address_homeaddress, wage_monamt, c_person_bestfriend, lastname, boeversion, i_licence_licence, lastupdatedate, firstname, i_osuser_updatedby, c_osuser_updatedby, taxcode, dateofbirth, wage_moncur, pension]
13:14:11,484 INFO TableMetadata:43 - foreign keys: []
13:14:11,484 INFO TableMetadata:44 - indexes: [ipersonaddresshomeaddress, pk_tperson, ipersonpersonbestfriend, ipersonpersonspouse, ipersonlicencelicence]
13:14:11,500 ERROR SchemaUpdate:155 - Unsuccessful: alter table TCompany add registeredNumber number(19,0)
13:14:11,500 ERROR SchemaUpdate:156 - ORA-01430: column being added already exists in table

13:14:11,500 ERROR SchemaUpdate:155 - Unsuccessful: alter table TCustomer add customerNumber varchar2(255 char)
13:14:11,500 ERROR SchemaUpdate:156 - ORA-01430: column being added already exists in table

13:14:11,515 ERROR SchemaUpdate:155 - Unsuccessful: alter table TEmployee add employeeNumber number(19,0)
13:14:11,515 ERROR SchemaUpdate:156 - ORA-01430: column being added already exists in table

13:14:11,531 ERROR SchemaUpdate:155 - Unsuccessful: alter table TMechanic add employeeNumber number(19,0)
13:14:11,531 ERROR SchemaUpdate:156 - ORA-01430: column being added already exists in table

13:14:11,546 ERROR SchemaUpdate:155 - Unsuccessful: alter table TEmployee add constraint FKF171B722836FCF31 foreign key (I_COMPANY_EMPLOYEES, C_COMPANY_EMPLOYEES) references TCompany
13:14:11,562 ERROR SchemaUpdate:156 - ORA-02275: such a referential constraint already exists in the table

13:14:11,578 ERROR SchemaUpdate:155 - Unsuccessful: alter table TMechanic add constraint FKF171B722836FCF3172db5ff8 foreign key (I_COMPANY_EMPLOYEES, C_COMPANY_EMPLOYEES) references TCompany
13:14:11,578 ERROR SchemaUpdate:156 - ORA-02275: such a referential constraint already exists in the table

13:14:11,578 INFO SchemaUpdate:160 - schema update complete
13:14:11,578 DEBUG SQL:393 - SELECT SEMPLOYEE.NEXTVAL FROM DUAL
Hibernate: SELECT SEMPLOYEE.NEXTVAL FROM DUAL
o is 230 class class java.math.BigDecimal
13:14:11,578 INFO SessionFactoryImpl:766 - closing
13:14:11,578 INFO DriverManagerConnectionProvider:147 - cleaning up connection pool: jdbc:oracle:thin:@opc151:1521:ora10g
13:14:11,593 FATAL Ejb3Configuration:504 - META-INF/MANIFEST.MFO-:-Ofalse
13:14:11,593 FATAL Ejb3Configuration:504 - META-INF/persistence.xmlO-:-Ofalse
13:14:11,593 INFO AnnotationBinder:386 - Binding entity from annotated class: com.fineos.ta.test.driver.OTestCases.hibernate.Person
13:14:11,593 INFO EntityBinder:325 - Bind entity com.fineos.ta.test.driver.OTestCases.hibernate.Person on table TPerson
13:14:11,609 INFO AnnotationBinder:386 - Binding entity from annotated class: com.fineos.ta.test.driver.OTestCases.hibernate.Employee
13:14:11,609 INFO EntityBinder:325 - Bind entity com.fineos.ta.test.driver.OTestCases.hibernate.Employee on table TEmployee
13:14:11,609 INFO AnnotationBinder:386 - Binding entity from annotated class: com.fineos.ta.test.driver.OTestCases.hibernate.Company
13:14:11,609 INFO EntityBinder:325 - Bind entity com.fineos.ta.test.driver.OTestCases.hibernate.Company on table TCompany
13:14:11,609 INFO AnnotationBinder:386 - Binding entity from annotated class: com.fineos.ta.test.driver.OTestCases.hibernate.Customer
13:14:11,609 INFO EntityBinder:325 - Bind entity com.fineos.ta.test.driver.OTestCases.hibernate.Customer on table TCustomer
13:14:11,609 INFO AnnotationBinder:386 - Binding entity from annotated class: com.fineos.ta.test.driver.OTestCases.hibernate.Mechanic
13:14:11,609 INFO EntityBinder:325 - Bind entity com.fineos.ta.test.driver.OTestCases.hibernate.Mechanic on table TMechanic
13:14:11,609 INFO AnnotationBinder:386 - Binding entity from annotated class: com.fineos.ta.test.driver.OTestCases.hibernate.Address
13:14:11,609 INFO EntityBinder:325 - Bind entity com.fineos.ta.test.driver.OTestCases.hibernate.Address on table TAddress
13:14:11,625 INFO CollectionBinder:578 - Mapping collection: com.fineos.ta.test.driver.OTestCases.hibernate.Company.employees -> TEmployee
13:14:11,640 INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (not for production use!)
13:14:11,640 INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 20
13:14:11,640 INFO DriverManagerConnectionProvider:45 - autocommit mode: true
13:14:11,640 INFO DriverManagerConnectionProvider:80 - using driver: oracle.jdbc.driver.OracleDriver at URL: jdbc:oracle:thin:@opc151:1521:ora10g
13:14:11,640 INFO DriverManagerConnectionProvider:86 - connection properties: {user=alex_garageDB, password=****, autocommit=true, release_mode=auto}
13:14:11,687 INFO SettingsFactory:78 - RDBMS: Oracle, version: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
13:14:11,687 INFO SettingsFactory:79 - JDBC driver: Oracle JDBC driver, version: 10.2.0.2.0
13:14:11,687 INFO Dialect:128 - Using dialect: org.hibernate.dialect.Oracle9Dialect
13:14:11,687 INFO TransactionFactoryFactory:34 - Transaction strategy: org.hibernate.transaction.JDBCTransactionFactory
13:14:11,687 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
13:14:11,687 INFO SettingsFactory:126 - Automatic flush during beforeCompletion(): disabled
13:14:11,687 INFO SettingsFactory:130 - Automatic session close at end of transaction: disabled
13:14:11,687 INFO SettingsFactory:137 - JDBC batch size: 15
13:14:11,687 INFO SettingsFactory:140 - JDBC batch updates for versioned data: disabled
13:14:11,687 INFO SettingsFactory:145 - Scrollable result sets: enabled
13:14:11,687 INFO SettingsFactory:153 - JDBC3 getGeneratedKeys(): disabled
13:14:11,687 INFO SettingsFactory:161 - Connection release mode: auto
13:14:11,687 INFO SettingsFactory:188 - Default batch fetch size: 1
13:14:11,687 INFO SettingsFactory:192 - Generate SQL with comments: disabled
13:14:11,687 INFO SettingsFactory:196 - Order SQL updates by primary key: disabled
13

I am running jboss-EJB-3.0_Embeddable_ALPHA (is that what you mean by "standalone"?) and I have the same problems. Although all my (hibernatetools-generated) POJOS are annoted with e.g.
@OneToMany(cascade={CascadeType.ALL}, fetch=FetchType.LAZY, mappedBy="service")
a simple primary-key find results in dozens of selects.

Did you already find a solution?

Cheers,
Markus

What you guys describe is only done at startup time (ie once per session factory creation)

Thanks, I fixed it by only creating one EntityManagerFactory and then reusing that to create EntityManager's.

Hi,

Lazy fetching really wasn't working for me, but I used an old version of jboss-EJB-3.0_Embeddable. Now with RC9 everything works fine.

Cheers,
Markus