ptreves
asked on
Missing Sequence from Eclipse Hibernate Project
Hello,
I am getting the following stack trace when trying to execute a JUnit Test Class from the Eclipse Console.
0 [main] INFO org.hibernate.cfg.Environm ent - Hibernate 3.3.0.SP1
16 [main] INFO org.hibernate.cfg.Environm ent - hibernate.properties not found
16 [main] INFO org.hibernate.cfg.Environm ent - Bytecode provider name : javassist
16 [main] INFO org.hibernate.cfg.Environm ent - using JDK 1.4 java.sql.Timestamp handling
47 [main] INFO org.hibernate.cfg.Configur ation - configuring from resource: /hibernate.cfg.xml
47 [main] INFO org.hibernate.cfg.Configur ation - Configuration resource: /hibernate.cfg.xml
94 [main] INFO org.hibernate.cfg.Configur ation - Reading mappings from resource : Account.hbm.xml
156 [main] INFO org.hibernate.cfg.HbmBinde r - Mapping class: courses.hibernate.vo.Accou nt -> ACCOUNT
172 [main] INFO org.hibernate.cfg.HbmBinde r - Mapping collection: courses.hibernate.vo.Accou nt.account Owners -> ACCOUNT_ACCOUNT_OWNER
187 [main] INFO org.hibernate.cfg.HbmBinde r - Mapping subclass: courses.hibernate.vo.Savin gsAccount -> ACCOUNT
187 [main] INFO org.hibernate.cfg.HbmBinde r - Mapping subclass: courses.hibernate.vo.Check ingAccount -> ACCOUNT
187 [main] INFO org.hibernate.cfg.HbmBinde r - Mapping subclass: courses.hibernate.vo.CdAcc ount -> ACCOUNT
187 [main] INFO org.hibernate.cfg.Configur ation - Reading mappings from resource : AccountOwner.hbm.xml
203 [main] INFO org.hibernate.cfg.HbmBinde r - Mapping class: courses.hibernate.vo.Accou ntOwner -> ACCOUNT_OWNER
203 [main] INFO org.hibernate.cfg.HbmBinde r - Mapping collection: courses.hibernate.vo.Accou ntOwner.ac counts -> ACCOUNT_ACCOUNT_OWNER
203 [main] INFO org.hibernate.cfg.Configur ation - Reading mappings from resource : AccountTransaction.hbm.xml
218 [main] INFO org.hibernate.cfg.HbmBinde r - Mapping class: courses.hibernate.vo.Accou ntTransact ion -> ACCOUNT_TRANSACTION
250 [main] INFO org.hibernate.cfg.HbmBinde r - Mapping joined-subclass: courses.hibernate.vo.Physi calAccount Transactio n -> PHYSICAL_ACCOUNT_TRANSACTI ON
250 [main] INFO org.hibernate.cfg.HbmBinde r - Mapping joined-subclass: courses.hibernate.vo.Elect ronicAccou ntTransact ion -> ELECTRONIC_ACCOUNT_TRANSAC TION
250 [main] INFO org.hibernate.cfg.Configur ation - Reading mappings from resource : EBill.hbm.xml
265 [main] INFO org.hibernate.cfg.HbmBinde r - Mapping class: courses.hibernate.vo.EBill -> EBILL
265 [main] INFO org.hibernate.cfg.Configur ation - Reading mappings from resource : EBiller.hbm.xml
281 [main] INFO org.hibernate.cfg.HbmBinde r - Mapping class: courses.hibernate.vo.EBill er -> EBILLER
281 [main] INFO org.hibernate.cfg.Configur ation - Reading mappings from resource : EBillerRegistration.hbm.xm l
296 [main] INFO org.hibernate.cfg.HbmBinde r - Mapping class: courses.hibernate.vo.EBill erRegistra tion -> ACCOUNT_EBILLER
296 [main] INFO org.hibernate.cfg.Configur ation - Configured SessionFactory: null
296 [main] INFO org.hibernate.cfg.HbmBinde r - Mapping collection: courses.hibernate.vo.Accou nt.ebiller Registrati ons -> ACCOUNT_EBILLER
296 [main] INFO org.hibernate.cfg.HbmBinde r - Mapping collection: courses.hibernate.vo.Accou nt.account Transactio ns -> ACCOUNT_TRANSACTION
296 [main] INFO org.hibernate.cfg.HbmBinde r - Mapping collection: courses.hibernate.vo.Accou nt.ebills -> EBILL
296 [main] INFO org.hibernate.cfg.HbmBinde r - Mapping collection: courses.hibernate.vo.EBill er.ebiller Registrati ons -> ACCOUNT_EBILLER
296 [main] INFO org.hibernate.cfg.HbmBinde r - Mapping collection: courses.hibernate.vo.EBill er.ebills -> EBILL
328 [main] INFO org.hibernate.connection.D riverManag erConnecti onProvider - Using Hibernate built-in connection pool (not for production use!)
328 [main] INFO org.hibernate.connection.D riverManag erConnecti onProvider - Hibernate connection pool size: 1
328 [main] INFO org.hibernate.connection.D riverManag erConnecti onProvider - autocommit mode: false
343 [main] INFO org.hibernate.connection.D riverManag erConnecti onProvider - using driver: oracle.jdbc.driver.OracleD river at URL: jdbc:oracle:thin:@localhos t:1521:XE
343 [main] INFO org.hibernate.connection.D riverManag erConnecti onProvider - connection properties: {user=lecture5, password=****}
452 [main] INFO org.hibernate.cfg.Settings Factory - RDBMS: Oracle, version: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
452 [main] INFO org.hibernate.cfg.Settings Factory - JDBC driver: Oracle JDBC driver, version: 10.2.0.1.0XE
468 [main] INFO org.hibernate.dialect.Dial ect - Using dialect: org.hibernate.dialect.Orac le10gDiale ct
468 [main] INFO org.hibernate.transaction. Transactio nFactoryFa ctory - Using default transaction strategy (direct JDBC transactions)
468 [main] INFO org.hibernate.transaction. Transactio nManagerLo okupFactor y - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
468 [main] INFO org.hibernate.cfg.Settings Factory - Automatic flush during beforeCompletion(): disabled
468 [main] INFO org.hibernate.cfg.Settings Factory - Automatic session close at end of transaction: disabled
468 [main] INFO org.hibernate.cfg.Settings Factory - JDBC batch size: 15
468 [main] INFO org.hibernate.cfg.Settings Factory - JDBC batch updates for versioned data: disabled
468 [main] INFO org.hibernate.cfg.Settings Factory - Scrollable result sets: enabled
468 [main] INFO org.hibernate.cfg.Settings Factory - JDBC3 getGeneratedKeys(): disabled
468 [main] INFO org.hibernate.cfg.Settings Factory - Connection release mode: auto
468 [main] INFO org.hibernate.cfg.Settings Factory - Default batch fetch size: 1
468 [main] INFO org.hibernate.cfg.Settings Factory - Generate SQL with comments: disabled
468 [main] INFO org.hibernate.cfg.Settings Factory - Order SQL updates by primary key: disabled
468 [main] INFO org.hibernate.cfg.Settings Factory - Order SQL inserts for batching: disabled
468 [main] INFO org.hibernate.cfg.Settings Factory - Query translator: org.hibernate.hql.ast.ASTQ ueryTransl atorFactor y
468 [main] INFO org.hibernate.hql.ast.ASTQ ueryTransl atorFactor y - Using ASTQueryTranslatorFactory
468 [main] INFO org.hibernate.cfg.Settings Factory - Query language substitutions: {}
468 [main] INFO org.hibernate.cfg.Settings Factory - JPA-QL strict compliance: disabled
468 [main] INFO org.hibernate.cfg.Settings Factory - Second-level cache: enabled
468 [main] INFO org.hibernate.cfg.Settings Factory - Query cache: disabled
468 [main] INFO org.hibernate.cfg.Settings Factory - Cache region factory : org.hibernate.cache.impl.N oCachingRe gionFactor y
468 [main] INFO org.hibernate.cfg.Settings Factory - Optimize cache for minimal puts: disabled
468 [main] INFO org.hibernate.cfg.Settings Factory - Structured second-level cache entries: disabled
468 [main] INFO org.hibernate.cfg.Settings Factory - Echoing all SQL to stdout
468 [main] INFO org.hibernate.cfg.Settings Factory - Statistics: disabled
468 [main] INFO org.hibernate.cfg.Settings Factory - Deleted entity synthetic identifier rollback: disabled
468 [main] INFO org.hibernate.cfg.Settings Factory - Default entity-mode: pojo
468 [main] INFO org.hibernate.cfg.Settings Factory - Named query checking : enabled
499 [main] INFO org.hibernate.impl.Session FactoryImp l - building session factory
655 [main] INFO org.hibernate.impl.Session FactoryObj ectFactory - Not binding factory to JNDI, no JNDI name configured
Hibernate: select hibernate_sequence.nextval from dual
764 [main] WARN org.hibernate.util.JDBCExc eptionRepo rter - SQL Error: 2289, SQLState: 42000
764 [main] ERROR org.hibernate.util.JDBCExc eptionRepo rter - ORA-02289: sequence does not exist
Hibernate: select hibernate_sequence.nextval from dual
780 [main] WARN org.hibernate.util.JDBCExc eptionRepo rter - SQL Error: 2289, SQLState: 42000
780 [main] ERROR org.hibernate.util.JDBCExc eptionRepo rter - ORA-02289: sequence does not exist
Hibernate: select hibernate_sequence.nextval from dual
780 [main] WARN org.hibernate.util.JDBCExc eptionRepo rter - SQL Error: 2289, SQLState: 42000
780 [main] ERROR org.hibernate.util.JDBCExc eptionRepo rter - ORA-02289: sequence does not exist
Hibernate: select hibernate_sequence.nextval from dual
780 [main] WARN org.hibernate.util.JDBCExc eptionRepo rter - SQL Error: 2289, SQLState: 42000
780 [main] ERROR org.hibernate.util.JDBCExc eptionRepo rter - ORA-02289: sequence does not exist
Hibernate: select hibernate_sequence.nextval from dual
780 [main] WARN org.hibernate.util.JDBCExc eptionRepo rter - SQL Error: 2289, SQLState: 42000
780 [main] ERROR org.hibernate.util.JDBCExc eptionRepo rter - ORA-02289: sequence does not exist
I am using a Oracle XE and have created a sequence object as follows:
CREATE SEQUENCE HIBERNATE_SEQUENCE START WITH 1 INCREMENT BY 1;
Why do I get the oracle error saying the sequence does not exist ?
Paolo
I am getting the following stack trace when trying to execute a JUnit Test Class from the Eclipse Console.
0 [main] INFO org.hibernate.cfg.Environm
16 [main] INFO org.hibernate.cfg.Environm
16 [main] INFO org.hibernate.cfg.Environm
16 [main] INFO org.hibernate.cfg.Environm
47 [main] INFO org.hibernate.cfg.Configur
47 [main] INFO org.hibernate.cfg.Configur
94 [main] INFO org.hibernate.cfg.Configur
156 [main] INFO org.hibernate.cfg.HbmBinde
172 [main] INFO org.hibernate.cfg.HbmBinde
187 [main] INFO org.hibernate.cfg.HbmBinde
187 [main] INFO org.hibernate.cfg.HbmBinde
187 [main] INFO org.hibernate.cfg.HbmBinde
187 [main] INFO org.hibernate.cfg.Configur
203 [main] INFO org.hibernate.cfg.HbmBinde
203 [main] INFO org.hibernate.cfg.HbmBinde
203 [main] INFO org.hibernate.cfg.Configur
218 [main] INFO org.hibernate.cfg.HbmBinde
250 [main] INFO org.hibernate.cfg.HbmBinde
250 [main] INFO org.hibernate.cfg.HbmBinde
250 [main] INFO org.hibernate.cfg.Configur
265 [main] INFO org.hibernate.cfg.HbmBinde
265 [main] INFO org.hibernate.cfg.Configur
281 [main] INFO org.hibernate.cfg.HbmBinde
281 [main] INFO org.hibernate.cfg.Configur
296 [main] INFO org.hibernate.cfg.HbmBinde
296 [main] INFO org.hibernate.cfg.Configur
296 [main] INFO org.hibernate.cfg.HbmBinde
296 [main] INFO org.hibernate.cfg.HbmBinde
296 [main] INFO org.hibernate.cfg.HbmBinde
296 [main] INFO org.hibernate.cfg.HbmBinde
296 [main] INFO org.hibernate.cfg.HbmBinde
328 [main] INFO org.hibernate.connection.D
328 [main] INFO org.hibernate.connection.D
328 [main] INFO org.hibernate.connection.D
343 [main] INFO org.hibernate.connection.D
343 [main] INFO org.hibernate.connection.D
452 [main] INFO org.hibernate.cfg.Settings
452 [main] INFO org.hibernate.cfg.Settings
468 [main] INFO org.hibernate.dialect.Dial
468 [main] INFO org.hibernate.transaction.
468 [main] INFO org.hibernate.transaction.
468 [main] INFO org.hibernate.cfg.Settings
468 [main] INFO org.hibernate.cfg.Settings
468 [main] INFO org.hibernate.cfg.Settings
468 [main] INFO org.hibernate.cfg.Settings
468 [main] INFO org.hibernate.cfg.Settings
468 [main] INFO org.hibernate.cfg.Settings
468 [main] INFO org.hibernate.cfg.Settings
468 [main] INFO org.hibernate.cfg.Settings
468 [main] INFO org.hibernate.cfg.Settings
468 [main] INFO org.hibernate.cfg.Settings
468 [main] INFO org.hibernate.cfg.Settings
468 [main] INFO org.hibernate.cfg.Settings
468 [main] INFO org.hibernate.hql.ast.ASTQ
468 [main] INFO org.hibernate.cfg.Settings
468 [main] INFO org.hibernate.cfg.Settings
468 [main] INFO org.hibernate.cfg.Settings
468 [main] INFO org.hibernate.cfg.Settings
468 [main] INFO org.hibernate.cfg.Settings
468 [main] INFO org.hibernate.cfg.Settings
468 [main] INFO org.hibernate.cfg.Settings
468 [main] INFO org.hibernate.cfg.Settings
468 [main] INFO org.hibernate.cfg.Settings
468 [main] INFO org.hibernate.cfg.Settings
468 [main] INFO org.hibernate.cfg.Settings
468 [main] INFO org.hibernate.cfg.Settings
499 [main] INFO org.hibernate.impl.Session
655 [main] INFO org.hibernate.impl.Session
Hibernate: select hibernate_sequence.nextval
764 [main] WARN org.hibernate.util.JDBCExc
764 [main] ERROR org.hibernate.util.JDBCExc
Hibernate: select hibernate_sequence.nextval
780 [main] WARN org.hibernate.util.JDBCExc
780 [main] ERROR org.hibernate.util.JDBCExc
Hibernate: select hibernate_sequence.nextval
780 [main] WARN org.hibernate.util.JDBCExc
780 [main] ERROR org.hibernate.util.JDBCExc
Hibernate: select hibernate_sequence.nextval
780 [main] WARN org.hibernate.util.JDBCExc
780 [main] ERROR org.hibernate.util.JDBCExc
Hibernate: select hibernate_sequence.nextval
780 [main] WARN org.hibernate.util.JDBCExc
780 [main] ERROR org.hibernate.util.JDBCExc
I am using a Oracle XE and have created a sequence object as follows:
CREATE SEQUENCE HIBERNATE_SEQUENCE START WITH 1 INCREMENT BY 1;
Why do I get the oracle error saying the sequence does not exist ?
Paolo
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I solved this. Thanks.
its just a warning you can ignore this message.
check this link
http://www.myeclipseide.com/PNphpBB2-viewtopic-t-5286.html