Hello,

I am running Hibernate in Eclipse and installed Oracle Express Edition on my computer.
When I try to run a test class using JUnit I get the following stack error trace in the Eclipse console:

16 [main] INFO org.hibernate.cfg.Environment - Hibernate 3.3.0.SP1
16 [main] INFO org.hibernate.cfg.Environment - hibernate.properties not found
16 [main] INFO org.hibernate.cfg.Environment - Bytecode provider name : javassist
16 [main] INFO org.hibernate.cfg.Environment - using JDK 1.4 java.sql.Timestamp handling
47 [main] INFO org.hibernate.cfg.Configuration - configuring from resource: /hibernate.cfg.xml
47 [main] INFO org.hibernate.cfg.Configuration - Configuration resource: /hibernate.cfg.xml
94 [main] INFO org.hibernate.cfg.Configuration - Reading mappings from resource : Account.hbm.xml
156 [main] INFO org.hibernate.cfg.HbmBinder - Mapping class: courses.hibernate.vo.Account -> ACCOUNT
172 [main] INFO org.hibernate.cfg.HbmBinder - Mapping collection: courses.hibernate.vo.Account.accountOwners -> ACCOUNT_ACCOUNT_OWNER
187 [main] INFO org.hibernate.cfg.HbmBinder - Mapping subclass: courses.hibernate.vo.SavingsAccount -> ACCOUNT
187 [main] INFO org.hibernate.cfg.HbmBinder - Mapping subclass: courses.hibernate.vo.CheckingAccount -> ACCOUNT
187 [main] INFO org.hibernate.cfg.HbmBinder - Mapping subclass: courses.hibernate.vo.CdAccount -> ACCOUNT
187 [main] INFO org.hibernate.cfg.Configuration - Reading mappings from resource : AccountOwner.hbm.xml
218 [main] INFO org.hibernate.cfg.HbmBinder - Mapping class: courses.hibernate.vo.AccountOwner -> ACCOUNT_OWNER
218 [main] INFO org.hibernate.cfg.HbmBinder - Mapping collection: courses.hibernate.vo.AccountOwner.accounts -> ACCOUNT_ACCOUNT_OWNER
218 [main] INFO org.hibernate.cfg.Configuration - Reading mappings from resource : AccountTransaction.hbm.xml
234 [main] INFO org.hibernate.cfg.HbmBinder - Mapping class: courses.hibernate.vo.AccountTransaction -> ACCOUNT_TRANSACTION
265 [main] INFO org.hibernate.cfg.HbmBinder - Mapping joined-subclass: courses.hibernate.vo.PhysicalAccountTransaction -> PHYSICAL_ACCOUNT_TRANSACTION
265 [main] INFO org.hibernate.cfg.HbmBinder - Mapping joined-subclass: courses.hibernate.vo.ElectronicAccountTransaction -> ELECTRONIC_ACCOUNT_TRANSACTION
265 [main] INFO org.hibernate.cfg.Configuration - Reading mappings from resource : EBill.hbm.xml
281 [main] INFO org.hibernate.cfg.HbmBinder - Mapping class: courses.hibernate.vo.EBill -> EBILL
281 [main] INFO org.hibernate.cfg.Configuration - Reading mappings from resource : EBiller.hbm.xml
296 [main] INFO org.hibernate.cfg.HbmBinder - Mapping class: courses.hibernate.vo.EBiller -> EBILLER
296 [main] INFO org.hibernate.cfg.Configuration - Reading mappings from resource : EBillerRegistration.hbm.xml
312 [main] INFO org.hibernate.cfg.HbmBinder - Mapping class: courses.hibernate.vo.EBillerRegistration -> ACCOUNT_EBILLER
312 [main] INFO org.hibernate.cfg.Configuration - Configured SessionFactory: null
312 [main] INFO org.hibernate.cfg.HbmBinder - Mapping collection: courses.hibernate.vo.Account.ebillerRegistrations -> ACCOUNT_EBILLER
312 [main] INFO org.hibernate.cfg.HbmBinder - Mapping collection: courses.hibernate.vo.Account.accountTransactions -> ACCOUNT_TRANSACTION
312 [main] INFO org.hibernate.cfg.HbmBinder - Mapping collection: courses.hibernate.vo.Account.ebills -> EBILL
312 [main] INFO org.hibernate.cfg.HbmBinder - Mapping collection: courses.hibernate.vo.EBiller.ebillerRegistrations -> ACCOUNT_EBILLER
312 [main] INFO org.hibernate.cfg.HbmBinder - Mapping collection: courses.hibernate.vo.EBiller.ebills -> EBILL
328 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - Using Hibernate built-in connection pool (not for production use!)
328 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - Hibernate connection pool size: 1
328 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - autocommit mode: false
343 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - using driver: oracle.jdbc.driver.OracleDriver at URL: jdbc:oracle:thin:@localhost:1521:XE
343 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - connection properties: {user=lecture5, password=****}
452 [main] INFO org.hibernate.cfg.SettingsFactory - RDBMS: Oracle, version: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
452 [main] INFO org.hibernate.cfg.SettingsFactory - JDBC driver: Oracle JDBC driver, version: 10.2.0.1.0XE
468 [main] INFO org.hibernate.dialect.Dialect - Using dialect: org.hibernate.dialect.Oracle10gDialect
468 [main] INFO org.hibernate.transaction.TransactionFactoryFactory - Using default transaction strategy (direct JDBC transactions)
468 [main] INFO org.hibernate.transaction.TransactionManagerLookupFactory - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
468 [main] INFO org.hibernate.cfg.SettingsFactory - Automatic flush during beforeCompletion(): disabled
468 [main] INFO org.hibernate.cfg.SettingsFactory - Automatic session close at end of transaction: disabled
468 [main] INFO org.hibernate.cfg.SettingsFactory - JDBC batch size: 15
468 [main] INFO org.hibernate.cfg.SettingsFactory - JDBC batch updates for versioned data: disabled
468 [main] INFO org.hibernate.cfg.SettingsFactory - Scrollable result sets: enabled
468 [main] INFO org.hibernate.cfg.SettingsFactory - JDBC3 getGeneratedKeys(): disabled
468 [main] INFO org.hibernate.cfg.SettingsFactory - Connection release mode: auto
468 [main] INFO org.hibernate.cfg.SettingsFactory - Default batch fetch size: 1
468 [main] INFO org.hibernate.cfg.SettingsFactory - Generate SQL with comments: disabled
468 [main] INFO org.hibernate.cfg.SettingsFactory - Order SQL updates by primary key: disabled
468 [main] INFO org.hibernate.cfg.SettingsFactory - Order SQL inserts for batching: disabled
468 [main] INFO org.hibernate.cfg.SettingsFactory - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
468 [main] INFO org.hibernate.hql.ast.ASTQueryTranslatorFactory - Using ASTQueryTranslatorFactory
468 [main] INFO org.hibernate.cfg.SettingsFactory - Query language substitutions: {}
468 [main] INFO org.hibernate.cfg.SettingsFactory - JPA-QL strict compliance: disabled
468 [main] INFO org.hibernate.cfg.SettingsFactory - Second-level cache: enabled
468 [main] INFO org.hibernate.cfg.SettingsFactory - Query cache: disabled
468 [main] INFO org.hibernate.cfg.SettingsFactory - Cache region factory : org.hibernate.cache.impl.NoCachingRegionFactory
468 [main] INFO org.hibernate.cfg.SettingsFactory - Optimize cache for minimal puts: disabled
468 [main] INFO org.hibernate.cfg.SettingsFactory - Structured second-level cache entries: disabled
484 [main] INFO org.hibernate.cfg.SettingsFactory - Echoing all SQL to stdout
484 [main] INFO org.hibernate.cfg.SettingsFactory - Statistics: disabled
484 [main] INFO org.hibernate.cfg.SettingsFactory - Deleted entity synthetic identifier rollback: disabled
484 [main] INFO org.hibernate.cfg.SettingsFactory - Default entity-mode: pojo
484 [main] INFO org.hibernate.cfg.SettingsFactory - Named query checking : enabled
499 [main] INFO org.hibernate.impl.SessionFactoryImpl - building session factory
655 [main] INFO org.hibernate.impl.SessionFactoryObjectFactory - Not binding factory to JNDI, no JNDI name configured
Hibernate: select HIBERNATE_SEQUENCE.nextval from dual
780 [main] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 2289, SQLState: 42000
780 [main] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-02289: sequence does not exist

Hibernate: select HIBERNATE_SEQUENCE.nextval from dual
780 [main] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 2289, SQLState: 42000
780 [main] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-02289: sequence does not exist

Hibernate: select HIBERNATE_SEQUENCE.nextval from dual
780 [main] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 2289, SQLState: 42000
780 [main] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-02289: sequence does not exist

Hibernate: select HIBERNATE_SEQUENCE.nextval from dual
780 [main] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 2289, SQLState: 42000
780 [main] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-02289: sequence does not exist

Hibernate: select HIBERNATE_SEQUENCE.nextval from dual
780 [main] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 2289, SQLState: 42000
780 [main] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-02289: sequence does not exist

Hibernate: select HIBERNATE_SEQUENCE.nextval from dual
780 [main] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 2289, SQLState: 42000
780 [main] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-02289: sequence does not exist

Hibernate: select HIBERNATE_SEQUENCE.nextval from dual
780 [main] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 2289, SQLState: 42000
780 [main] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-02289: sequence does not exist

Hibernate: select HIBERNATE_SEQUENCE.nextval from dual
796 [main] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 2289, SQLState: 42000
796 [main] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-02289: sequence does not exist

Hibernate: select HIBERNATE_SEQUENCE.nextval from dual
796 [main] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 2289, SQLState: 42000
796 [main] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-02289: sequence does not exist

Hibernate: select HIBERNATE_SEQUENCE.nextval from dual
796 [main] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 2289, SQLState: 42000
796 [main] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-02289: sequence does not exist

Hibernate: select HIBERNATE_SEQUENCE.nextval from dual
796 [main] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 2289, SQLState: 42000
796 [main] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-02289: sequence does not exist

Hibernate: select HIBERNATE_SEQUENCE.nextval from dual
796 [main] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 2289, SQLState: 42000
796 [main] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-02289: sequence does not exist

Hibernate: select HIBERNATE_SEQUENCE.nextval from dual
796 [main] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 2289, SQLState: 42000
796 [main] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-02289: sequence does not exist

I can create a SEQUENCE object in Oracle XE.
Suggestions ?

Paolo