Addition to prev. post. why h2 (org.h2.engine.Session - in memory database) is used?
If you will see full error stack you will that H2 database classes is used. Why NOT ORACLE classes?
why h2 (org.h2.engine.Session class - in memory database) is used?
Addition to post. why h2 (org.h2.engine.Session - in memory database) is used?
Error 2012-08-23 16:45:41,856 [http-bio-8080-exec-9] ERROR util.JDBCExceptionReporter - Table "CHECKTYPES" not found; SQL statement:
select * from ( select this_.CHECKTYPECODE as CHECKTYP1_3_0_, this_.active as active3_0_, this_.availabilitychecktype as availabi3_3_0_, this_.checktypecode as checktyp1_3_0_, this_.checktypedescr as checktyp4_3_0_, this_.TARGETTYPECODE as TARGETTY5_3_0_ from CHECKTYPES this_ ) where rownum <= ? [42102-164]
| Error 2012-08-23 16:45:41,981 [http-bio-8080-exec-9] ERROR errors.GrailsExceptionResolver - JdbcSQLException occurred when processing request: [GET] /Tst7/checktypes/list
Table "CHECKTYPES" not found; SQL statement:
select * from ( select this_.CHECKTYPECODE as CHECKTYP1_3_0_, this_.active as active3_0_, this_.availabilitychecktype as availabi3_3_0_, this_.checktypecode as checktyp1_3_0_, this_.checktypedescr as checktyp4_3_0_, this_.TARGETTYPECODE as TARGETTY5_3_0_ from CHECKTYPES this_ ) where rownum <= ? [42102-164]. Stacktrace follows:
Message: Table "CHECKTYPES" not found; SQL statement:
select * from ( select this_.CHECKTYPECODE as CHECKTYP1_3_0_, this_.active as active3_0_, this_.availabilitychecktype as availabi3_3_0_, this_.checktypecode as checktyp1_3_0_, this_.checktypedescr as checktyp4_3_0_, this_.TARGETTYPECODE as TARGETTY5_3_0_ from CHECKTYPES this_ ) where rownum <= ? [42102-164]
Line | Method
->> 329 | getJdbcSQLException in org.h2.message.DbException
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
| 169 | get in ''
| 146 | get . . . . . . . . . . . in ''
| 4753 | readTableOrView in org.h2.command.Parser
| 1080 | readTableFilter . . . . . in ''
| 1686 | parseSelectSimpleFromPart in ''
| 1793 | parseSelectSimple . . . . in ''
| 1680 | parseSelectSub in ''
| 1523 | parseSelectUnion . . . . in ''
| 1022 | readTableFilter in ''
| 1686 | parseSelectSimpleFromPart in ''
| 1793 | parseSelectSimple in ''
| 1680 | parseSelectSub . . . . . in ''
| 1523 | parseSelectUnion in ''
| 1511 | parseSelect . . . . . . . in ''
| 405 | parsePrepared in ''
| 279 | parse . . . . . . . . . . in ''
| 251 | parse in ''
| 217 | prepareCommand . . . . . in ''
| 415 | prepareLocal in org.h2.engine.Session
| 364 | prepareCommand . . . . . in ''
| 1121 | prepareCommand in org.h2.jdbc.JdbcConnection
| 71 | <init> . . . . . . . . . in org.h2.jdbc.JdbcPreparedStatement
| 267 | prepareStatement in org.h2.jdbc.JdbcConnection
| 281 | prepareStatement . . . . in org.apache.commons.dbcp.DelegatingConnection
| 313 | prepareStatement in org.apache.commons.dbcp.PoolingDataSource$PoolGuar dConnectionWrapper
| 55 | <init> . . . . . . . . . in grails.orm.PagedResultList
| 37 | list in tst7.ChecktypesController
| 195 | doFilter . . . . . . . . in grails.plugin.cache.web.filter.PageFragmentCaching Filter
| 63 | doFilter in grails.plugin.cache.web.filter.AbstractFilter
| 1110 | runWorker . . . . . . . . in java.util.concurrent.ThreadPoolExecutor
| 603 | run in java.util.concurrent.ThreadPoolExecutor$Worker
^ 722 | run . . . . . . . . . . . in java.lang.Threadc