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,
|