These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 
Author Message
 Post subject: Error: cannot complete schema update
PostPosted: Thu Jul 29, 2010 10:24 am 
Newbie

Joined: Wed Jul 28, 2010 9:43 pm
Posts: 3
I am trying to change my configuration file so that my application can connect to an Oracle database.
the application can connect to an Apache and MySQL database.

I am getting an error when updating the schema. A table is not found.
My config file is as follows:

<property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="hibernate.connection.url">jdbc:oracle:thin:@localhost:1521:XE</property>
<property name="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</property>
<property name="hibernate.connection.username">system</property>
<property name="hibernate.connection.password">protech</property>
<property name="hibernate.default_schema">${hibernate.default_schema}</property>
<!-- JDBC connection pool (use the built-in) -->
<!-- property name="connection.pool_size">1</property> -->

<!-- Important! addendum to what is in text -->
<!-- property name="hibernate.query.factory_class">org.hibernate.hql.classic.ClassicQueryTranslatorFactory</property> -->

<!-- Enable Hibernate's automatic session context management -->
<!-- property name="current_session_context_class">thread</property> -->

<!-- Disable the second-level cache -->
<!-- property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property> -->

<!-- Echo all executed SQL to stdout - You can disable this once you have it working -->
<property name="show_sql">true</property>

<property name="hibernate.hbm2ddl.auto">update</property>
<mapping resource="psp/dataAccess/hbm/PartTypesStandardDao.hbm.xml" />
<mapping resource="psp/dataAccess/hbm/ProgramDao.hbm.xml" />
<mapping resource="psp/dataAccess/hbm/SetAddDao.hbm.xml" />
<mapping resource="psp/dataAccess/hbm/TestReportsDao.hbm.xml" />
<mapping resource="psp/dataAccess/hbm/LecturesDao.hbm.xml" />
<mapping resource="psp/dataAccess/hbm/ProcessTypesDao.hbm.xml" />
<mapping resource="psp/dataAccess/hbm/AnalysisReportsDao.hbm.xml" />
<mapping resource="psp/dataAccess/hbm/LogDDetailDao.hbm.xml" />
<mapping resource="psp/dataAccess/hbm/SetBaseDao.hbm.xml" />
<mapping resource="psp/dataAccess/hbm/SetReuseDao.hbm.xml" />
<mapping resource="psp/dataAccess/hbm/SizeMeasureDao.hbm.xml" />
(more tables follows...)

The stack trace is as follows:

10:09:08,375 INFO Environment:514 - Hibernate 3.2.5
10:09:08,390 INFO Environment:547 - hibernate.properties not found
10:09:08,390 INFO Environment:681 - Bytecode provider name : cglib
10:09:08,421 INFO Environment:598 - using JDK 1.4 java.sql.Timestamp handling
10:09:08,515 INFO Configuration:1426 - configuring from resource: /hibernate.cfg.xml
10:09:08,515 INFO Configuration:1403 - Configuration resource: /hibernate.cfg.xml
10:09:08,718 INFO Configuration:553 - Reading mappings from resource : psp/dataAccess/hbm/PartTypesStandardDao.hbm.xml
10:09:08,906 INFO HbmBinder:300 - Mapping class: psp.dataAccess.dao.PartTypesStandardDao -> part_types_standard
10:09:09,062 INFO Configuration:553 - Reading mappings from resource : psp/dataAccess/hbm/ProgramDao.hbm.xml
10:09:09,109 INFO HbmBinder:300 - Mapping class: psp.dataAccess.dao.ProgramDao -> program
10:09:09,109 INFO Configuration:553 - Reading mappings from resource : psp/dataAccess/hbm/SetAddDao.hbm.xml
10:09:09,156 INFO HbmBinder:300 - Mapping class: psp.dataAccess.dao.SetAddDao -> set_add
10:09:09,156 INFO Configuration:553 - Reading mappings from resource : psp/dataAccess/hbm/TestReportsDao.hbm.xml
10:09:09,281 INFO HbmBinder:300 - Mapping class: psp.dataAccess.dao.TestReportsDao -> test_reports
10:09:09,281 INFO Configuration:553 - Reading mappings from resource : psp/dataAccess/hbm/LecturesDao.hbm.xml
10:09:09,312 INFO HbmBinder:300 - Mapping class: psp.dataAccess.dao.LecturesDao -> lectures
10:09:09,312 INFO Configuration:553 - Reading mappings from resource : psp/dataAccess/hbm/ProcessTypesDao.hbm.xml
10:09:09,328 INFO HbmBinder:300 - Mapping class: psp.dataAccess.dao.ProcessTypesDao -> process_types
10:09:09,343 INFO Configuration:553 - Reading mappings from resource : psp/dataAccess/hbm/AnalysisReportsDao.hbm.xml
10:09:09,359 INFO HbmBinder:300 - Mapping class: psp.dataAccess.dao.AnalysisReportsDao -> analysis_reports
10:09:09,359 INFO Configuration:553 - Reading mappings from resource : psp/dataAccess/hbm/LogDDetailDao.hbm.xml
10:09:09,375 INFO HbmBinder:300 - Mapping class: psp.dataAccess.dao.LogDDetailDao -> log_d_detail
10:09:09,593 INFO Configuration:553 - Reading mappings from resource : psp/dataAccess/hbm/SetBaseDao.hbm.xml
10:09:09,609 INFO HbmBinder:300 - Mapping class: psp.dataAccess.dao.SetBaseDao -> set_base
10:09:09,625 INFO Configuration:553 - Reading mappings from resource : psp/dataAccess/hbm/SetReuseDao.hbm.xml
10:09:09,640 INFO HbmBinder:300 - Mapping class: psp.dataAccess.dao.SetReuseDao -> set_reuse
10:09:09,640 INFO Configuration:553 - Reading mappings from resource : psp/dataAccess/hbm/SizeMeasureDao.hbm.xml
10:09:09,703 INFO HbmBinder:300 - Mapping class: psp.dataAccess.dao.SizeMeasureDao -> size_measure
10:09:09,703 INFO Configuration:553 - Reading mappings from resource : psp/dataAccess/hbm/PipsDao.hbm.xml
10:09:09,718 INFO HbmBinder:300 - Mapping class: psp.dataAccess.dao.PipsDao -> pips
10:09:09,718 INFO Configuration:553 - Reading mappings from resource : psp/dataAccess/hbm/PhasesDao.hbm.xml
10:09:09,750 INFO HbmBinder:300 - Mapping class: psp.dataAccess.dao.PhasesDao -> phases
10:09:09,750 INFO Configuration:553 - Reading mappings from resource : psp/dataAccess/hbm/TestCaseDao.hbm.xml
10:09:09,765 INFO HbmBinder:300 - Mapping class: psp.dataAccess.dao.TestCaseDao -> test_case
10:09:09,765 INFO Configuration:553 - Reading mappings from resource : psp/dataAccess/hbm/LogTDetailDao.hbm.xml
10:09:09,796 INFO HbmBinder:300 - Mapping class: psp.dataAccess.dao.LogTDetailDao -> log_t_detail
10:09:09,796 INFO Configuration:553 - Reading mappings from resource : psp/dataAccess/hbm/ScheduleweeksDao.hbm.xml
10:09:09,812 INFO HbmBinder:300 - Mapping class: psp.dataAccess.dao.ScheduleweeksDao -> scheduleweeks
10:09:09,828 INFO Configuration:553 - Reading mappings from resource : psp/dataAccess/hbm/PhaseDataDao.hbm.xml
10:09:09,843 INFO HbmBinder:300 - Mapping class: psp.dataAccess.dao.PhaseDataDao -> phase_data
10:09:09,859 INFO Configuration:553 - Reading mappings from resource : psp/dataAccess/hbm/ProcessesDao.hbm.xml
10:09:09,875 INFO HbmBinder:300 - Mapping class: psp.dataAccess.dao.ProcessesDao -> processes
10:09:09,875 INFO Configuration:553 - Reading mappings from resource : psp/dataAccess/hbm/ProgramSizeDao.hbm.xml
10:09:09,953 INFO HbmBinder:300 - Mapping class: psp.dataAccess.dao.ProgramSizeDao -> program_size
10:09:09,953 INFO Configuration:553 - Reading mappings from resource : psp/dataAccess/hbm/ScriptsDao.hbm.xml
10:09:09,984 INFO HbmBinder:300 - Mapping class: psp.dataAccess.dao.ScriptsDao -> scripts
10:09:09,984 INFO Configuration:553 - Reading mappings from resource : psp/dataAccess/hbm/ProductDao.hbm.xml
10:09:10,000 INFO HbmBinder:300 - Mapping class: psp.dataAccess.dao.ProductDao -> product
10:09:10,000 INFO Configuration:553 - Reading mappings from resource : psp/dataAccess/hbm/PartsDao.hbm.xml
10:09:10,015 INFO HbmBinder:300 - Mapping class: psp.dataAccess.dao.PartsDao -> parts
10:09:10,015 INFO Configuration:553 - Reading mappings from resource : psp/dataAccess/hbm/TaskSchedulePlansDao.hbm.xml
10:09:10,031 INFO HbmBinder:300 - Mapping class: psp.dataAccess.dao.TaskSchedulePlansDao -> task_schedule_plans
10:09:10,046 INFO Configuration:553 - Reading mappings from resource : psp/dataAccess/hbm/UserProfilesDao.hbm.xml
10:09:10,062 INFO HbmBinder:300 - Mapping class: psp.dataAccess.dao.UserProfilesDao -> user_profiles
10:09:10,062 INFO HbmBinder:1422 - Mapping collection: psp.dataAccess.dao.UserProfilesDao.programmingLanguagesExperience -> prog_lang_experience
10:09:10,062 INFO Configuration:553 - Reading mappings from resource : psp/dataAccess/hbm/DefectTypeDao.hbm.xml
10:09:10,093 INFO HbmBinder:300 - Mapping class: psp.dataAccess.dao.DefectTypeDao -> defect_type
10:09:10,093 INFO Configuration:553 - Reading mappings from resource : psp/dataAccess/hbm/UsersDao.hbm.xml
10:09:10,109 INFO HbmBinder:300 - Mapping class: psp.dataAccess.dao.UsersDao -> users
10:09:10,109 INFO Configuration:553 - Reading mappings from resource : psp/dataAccess/hbm/TasksDao.hbm.xml
10:09:10,125 INFO HbmBinder:300 - Mapping class: psp.dataAccess.dao.TasksDao -> tasks
10:09:10,140 INFO Configuration:553 - Reading mappings from resource : psp/dataAccess/hbm/LocTypesStandardDao.hbm.xml
10:09:10,156 INFO HbmBinder:300 - Mapping class: psp.dataAccess.dao.LocTypesStandardDao -> loc_types_standard
10:09:10,156 INFO Configuration:553 - Reading mappings from resource : psp/dataAccess/hbm/AssignmentsDao.hbm.xml
10:09:10,171 INFO HbmBinder:300 - Mapping class: psp.dataAccess.dao.AssignmentsDao -> assignments
10:09:10,171 INFO Configuration:553 - Reading mappings from resource : psp/dataAccess/hbm/ProjectsDao.hbm.xml
10:09:10,203 INFO HbmBinder:300 - Mapping class: psp.dataAccess.dao.ProjectsDao -> projects
10:09:10,203 INFO Configuration:553 - Reading mappings from resource : psp/dataAccess/hbm/ProgrammingLanguageDao.hbm.xml
10:09:10,218 INFO HbmBinder:300 - Mapping class: psp.dataAccess.dao.ProgrammingLanguageDao -> prog_languages
10:09:10,218 INFO Configuration:553 - Reading mappings from resource : psp/dataAccess/hbm/InstructorDao.hbm.xml
10:09:10,343 INFO HbmBinder:300 - Mapping class: psp.dataAccess.dao.InstructorDao -> instructors
10:09:10,343 INFO Configuration:1541 - Configured SessionFactory: null
10:09:10,343 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.PartTypesStandardDao.partsDaos -> parts
10:09:10,343 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.PartTypesStandardDao.setAddDaos -> set_add
10:09:10,343 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.ProgramDao.programSizeDaos -> program_size
10:09:10,343 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.TestReportsDao.testCaseDaos -> test_case
10:09:10,343 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.ProcessTypesDao.processesDaos -> processes
10:09:10,343 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.SizeMeasureDao.setBaseDaos -> set_base
10:09:10,343 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.SizeMeasureDao.partsDaos -> parts
10:09:10,343 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.SizeMeasureDao.partTypesStandardDaos -> part_types_standard
10:09:10,343 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.SizeMeasureDao.programSizeDaos -> program_size
10:09:10,343 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.SizeMeasureDao.setReuseDaos -> set_reuse
10:09:10,343 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.SizeMeasureDao.setAddDaos -> set_add
10:09:10,343 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.PhasesDao.tasksDaos -> tasks
10:09:10,343 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.PhasesDao.phaseDataDaos -> phase_data
10:09:10,343 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.PhaseDataDao.tasksDaos -> tasks
10:09:10,359 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.ProcessesDao.phasesDaos -> phases
10:09:10,359 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.ProcessesDao.pipsDaos -> pips
10:09:10,359 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.ProcessesDao.projectsDaos -> projects
10:09:10,359 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.ProcessesDao.scriptsDaos -> scripts
10:09:10,359 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.ProgramSizeDao.setAddDaos -> set_add
10:09:10,359 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.ProgramSizeDao.setBaseDaos -> set_base
10:09:10,359 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.ProgramSizeDao.setReuseDaos -> set_reuse
10:09:10,359 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.ProductDao.programDaos -> program
10:09:10,359 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.ProductDao.logDDetailDaos -> log_d_detail
10:09:10,359 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.ProductDao.partsDaos -> parts
10:09:10,359 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.ProductDao.testReportsDaos -> test_reports
10:09:10,359 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.PartsDao.setAddDaos -> set_add
10:09:10,359 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.TaskSchedulePlansDao.tasksDaos -> tasks
10:09:10,359 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.TaskSchedulePlansDao.scheduleweeksDaos -> scheduleweeks
10:09:10,359 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.UsersDao.taskSchedulePlansDaos -> task_schedule_plans
10:09:10,359 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.UsersDao.tasksDaos -> tasks
10:09:10,359 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.UsersDao.userProfilesDaos -> user_profiles
10:09:10,359 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.UsersDao.projectsDaos -> projects
10:09:10,359 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.UsersDao.scheduleweeksDaos -> scheduleweeks
10:09:10,359 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.UsersDao.instructorDaos -> instructors
10:09:10,359 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.TasksDao.logTDetailDaos -> log_t_detail
10:09:10,359 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.LocTypesStandardDao.setAddDaos -> set_add
10:09:10,359 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.LocTypesStandardDao.partsDaos -> parts
10:09:10,359 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.ProjectsDao.logDDetailDaos -> log_d_detail
10:09:10,359 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.ProjectsDao.pipsDaos -> pips
10:09:10,375 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.ProjectsDao.scheduleweeksDaos -> scheduleweeks
10:09:10,375 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.ProjectsDao.testReportsDaos -> test_reports
10:09:10,375 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.ProjectsDao.tasksDaos -> tasks
10:09:10,375 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.ProjectsDao.phaseDataDaos -> phase_data
10:09:10,375 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.ProjectsDao.productDaos -> product
10:09:10,375 INFO HbmBinder:2385 - Mapping collection: psp.dataAccess.dao.ProjectsDao.logTDetailDaos -> log_t_detail
10:09:10,390 INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (not for production use!)
10:09:10,390 INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 20
10:09:10,390 INFO DriverManagerConnectionProvider:45 - autocommit mode: false
10:09:10,421 INFO DriverManagerConnectionProvider:80 - using driver: oracle.jdbc.driver.OracleDriver at URL: jdbc:oracle:thin:@localhost:1521:XE
10:09:10,421 INFO DriverManagerConnectionProvider:86 - connection properties: {user=system, password=****}
10:09:10,968 INFO SettingsFactory:89 - RDBMS: Oracle, version: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
10:09:10,968 INFO SettingsFactory:90 - JDBC driver: Oracle JDBC driver, version: 10.1.0.2.0
10:09:11,031 INFO Dialect:152 - Using dialect: org.hibernate.dialect.Oracle10gDialect
10:09:11,031 INFO TransactionFactoryFactory:31 - Using default transaction strategy (direct JDBC transactions)
10:09:11,046 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
10:09:11,046 INFO SettingsFactory:143 - Automatic flush during beforeCompletion(): disabled
10:09:11,046 INFO SettingsFactory:147 - Automatic session close at end of transaction: disabled
10:09:11,046 INFO SettingsFactory:154 - JDBC batch size: 15
10:09:11,046 INFO SettingsFactory:157 - JDBC batch updates for versioned data: disabled
10:09:11,046 INFO SettingsFactory:162 - Scrollable result sets: enabled
10:09:11,046 INFO SettingsFactory:170 - JDBC3 getGeneratedKeys(): disabled
10:09:11,046 INFO SettingsFactory:178 - Connection release mode: auto
10:09:11,046 INFO SettingsFactory:205 - Default batch fetch size: 1
10:09:11,046 INFO SettingsFactory:209 - Generate SQL with comments: disabled
10:09:11,046 INFO SettingsFactory:213 - Order SQL updates by primary key: disabled
10:09:11,046 INFO SettingsFactory:217 - Order SQL inserts for batching: disabled
10:09:11,046 INFO SettingsFactory:386 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
10:09:11,062 INFO ASTQueryTranslatorFactory:24 - Using ASTQueryTranslatorFactory
10:09:11,062 INFO SettingsFactory:225 - Query language substitutions: {}
10:09:11,062 INFO SettingsFactory:230 - JPA-QL strict compliance: disabled
10:09:11,062 INFO SettingsFactory:235 - Second-level cache: enabled
10:09:11,062 INFO SettingsFactory:239 - Query cache: disabled
10:09:11,062 INFO SettingsFactory:373 - Cache provider: org.hibernate.cache.NoCacheProvider
10:09:11,062 INFO SettingsFactory:254 - Optimize cache for minimal puts: disabled
10:09:11,062 INFO SettingsFactory:263 - Structured second-level cache entries: disabled
10:09:11,062 INFO SettingsFactory:283 - Echoing all SQL to stdout
10:09:11,062 INFO SettingsFactory:290 - Statistics: disabled
10:09:11,062 INFO SettingsFactory:294 - Deleted entity synthetic identifier rollback: disabled
10:09:11,062 INFO SettingsFactory:309 - Default entity-mode: pojo
10:09:11,078 INFO SettingsFactory:313 - Named query checking : enabled
10:09:11,125 INFO SessionFactoryImpl:161 - building session factory
10:09:12,562 INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI, no JNDI name configured
10:09:12,578 INFO SchemaUpdate:115 - Running hbm2ddl schema update
10:09:12,578 INFO SchemaUpdate:126 - fetching database metadata
10:09:12,734 INFO SchemaUpdate:138 - updating schema
10:09:12,921 INFO DatabaseMetadata:96 - table not found: analysis_reports
10:09:12,921 ERROR SchemaUpdate:165 - could not complete schema update
org.hibernate.MappingException: Dialect does not support identity key generation
at org.hibernate.dialect.Dialect.getIdentityColumnString(Dialect.java:548)
at org.hibernate.dialect.Dialect.getIdentityColumnString(Dialect.java:538)
at org.hibernate.mapping.Table.sqlCreateString(Table.java:389)
at org.hibernate.cfg.Configuration.generateSchemaUpdateScript(Configuration.java:956)
at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:140)
at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:314)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1294)
at shared.dataAbstraction.AbstractDac.<clinit>(AbstractDac.java:42)
at psp.businessLogic.PspApplicationManagement.<init>(PspApplicationManagement.java:19)
at psp.controller.PspApplicationController.<init>(PspApplicationController.java:19)
at psp.ui.PspClientApplication.afterPSP_TSP_MDIcreation(PspClientApplication.java:121)
at psp.ui.PSP_TSP_MDIFrame$2.run(PSP_TSP_MDIFrame.java:300)
at java.awt.event.InvocationEvent.dispatch(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at org.openswing.swing.util.client.ApplicationEventQueue$InternalEventQueue.dispatchEvent(ApplicationEventQueue.java:130)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
10:09:13,531 DEBUG SQL:401 - select sizemeasur0_.SIZE_MEASURE_ID as SIZE1_10_, sizemeasur0_.SYMBOL as SYMBOL10_, sizemeasur0_.NAME as NAME10_, sizemeasur0_.DESCRIPTION as DESCRIPT4_10_, sizemeasur0_.CREATED_DATE as CREATED5_10_ from psp.size_measure sizemeasur0_
Hibernate: select sizemeasur0_.SIZE_MEASURE_ID as SIZE1_10_, sizemeasur0_.SYMBOL as SYMBOL10_, sizemeasur0_.NAME as NAME10_, sizemeasur0_.DESCRIPTION as DESCRIPT4_10_, sizemeasur0_.CREATED_DATE as CREATED5_10_ from psp.size_measure sizemeasur0_
10:09:13,546 WARN JDBCExceptionReporter:77 - SQL Error: 942, SQLState: 42000
10:09:13,546 ERROR JDBCExceptionReporter:78 - ORA-00942: table or view does not exist

org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2223)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at shared.dataAbstraction.AbstractDac.loadTestData(AbstractDac.java:137)
at psp.dataAccess.PspApplicationDac.<init>(PspApplicationDac.java:32)
at psp.businessLogic.PspApplicationManagement.<init>(PspApplicationManagement.java:19)
at psp.controller.PspApplicationController.<init>(PspApplicationController.java:19)
at psp.ui.PspClientApplication.afterPSP_TSP_MDIcreation(PspClientApplication.java:121)
at psp.ui.PSP_TSP_MDIFrame$2.run(PSP_TSP_MDIFrame.java:300)
at java.awt.event.InvocationEvent.dispatch(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at org.openswing.swing.util.client.ApplicationEventQueue$InternalEventQueue.dispatchEvent(ApplicationEventQueue.java:130)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: java.sql.SQLException: ORA-00942: table or view does not exist

isn't the table created when it reads the .xml file?
I don't see why the table cannot be found.

Thanks,


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.