Guest User

Untitled

a guest
Jan 13th, 2019
133
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.57 KB | None | 0 0
  1. JdbcSQLException for a grails app with h2 database?
  2. class ResultService {
  3.  
  4. def recentStoryRuns() {
  5. StoryRun.list(sort: "batch.dateCreated", order: "desc")
  6. }
  7. }
  8.  
  9. org.h2.jdbc.JdbcSQLException: Table "STORY_RUN" not found; SQL statement:
  10. select this_.id as id3_1_, this_.version as version3_1_, this_.batch_id as batch3_3_1_, this_.batch_iteration as batch4_3_1_, this_.browser_string as browser5_3_1_, this_.easybresult_id as easybres6_3_1_, this_.failed_scenarios as failed7_3_1_, this_.last_parse_error as last8_3_1_, this_.passed_scenarios as passed9_3_1_, this_.result_parsed_story_status as result10_3_1_, this_.status as status3_1_, this_.story as story3_1_, this_.total_scenarios as total13_3_1_, this_.xml as xml3_1_, storyrunba1_.id as id2_0_, storyrunba1_.version as version2_0_, storyrunba1_.batch_id as batch3_2_0_, storyrunba1_.browsers_string as browsers4_2_0_, storyrunba1_.date_created as date5_2_0_, storyrunba1_.iterations as iterations2_0_, storyrunba1_.site_profile as site7_2_0_, storyrunba1_.stories_string as stories8_2_0_ from story_run this_ inner join story_run_batch storyrunba1_ on this_.batch_id=storyrunba1_.id order by storyrunba1_.date_created desc [42102-164]
  11. at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
  12. at org.h2.message.DbException.get(DbException.java:169)
  13. at org.h2.message.DbException.get(DbException.java:146)
  14. at org.h2.command.Parser.readTableOrView(Parser.java:4753)
  15. at org.h2.command.Parser.readTableFilter(Parser.java:1080)
  16. at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1686)
  17. at org.h2.command.Parser.parseSelectSimple(Parser.java:1793)
  18. at org.h2.command.Parser.parseSelectSub(Parser.java:1680)
  19. at org.h2.command.Parser.parseSelectUnion(Parser.java:1523)
  20. at org.h2.command.Parser.parseSelect(Parser.java:1511)
  21. at org.h2.command.Parser.parsePrepared(Parser.java:405)
  22. at org.h2.command.Parser.parse(Parser.java:279)
  23. at org.h2.command.Parser.parse(Parser.java:251)
  24. at org.h2.command.Parser.prepareCommand(Parser.java:217)
  25. at org.h2.engine.Session.prepareLocal(Session.java:415)
  26. at org.h2.engine.Session.prepareCommand(Session.java:364)
  27. at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1121)
  28. at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:71)
  29. at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:267)
  30. at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281)
  31. at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313)
  32. at kindlingtests.ResultService.recentStoryRuns(ResultService.groovy:6)
  33. at kindlingtests.HomeService.results(HomeService.groovy:19)
  34. at kindlingtests.ModelFields$_closure1.doCall(ModelFields.groovy:13)
  35. at kindlingtests.ModelFields.<init>(ModelFields.groovy:12)
  36. at kindlingtests.HomeService.setControllerModelFields(HomeService.groovy:9)
  37. at kindlingtests.HomeService.setControllerModelFields(HomeService.groovy:8)
  38. at kindlingtests.HomeController.index(HomeController.groovy:14)
  39. at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
  40. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
  41. at java.lang.Thread.run(Thread.java:680)
  42.  
  43. dataSource {
  44. pooled = true
  45. driverClassName = "org.h2.Driver"
  46. username = "sa"
  47. password = ""
  48. }
  49. hibernate {
  50. cache.use_second_level_cache = true
  51. cache.use_query_cache = true
  52. cache.region.factory_class = 'net.sf.ehcache.hibernate.EhCacheRegionFactory'
  53. }
  54. // environment specific settings
  55. environments {
  56. development {
  57. dataSource {
  58. dbCreate = "create-drop" // one of 'create', 'create-drop', 'update', 'validate', ''
  59. url = "jdbc:h2:mem:devDb;MVCC=TRUE"
  60. }
  61. }
  62. test {
  63. dataSource {
  64. dbCreate = "update"
  65. url = "jdbc:h2:mem:testDb;MVCC=TRUE"
  66. }
  67. }
  68. production {
  69. dataSource {
  70. dbCreate = "update"
  71. url = "jdbc:h2:mem:prodDb;MVCC=TRUE"
  72. pooled = true
  73. properties {
  74. maxActive = -1
  75. minEvictableIdleTimeMillis=1800000
  76. timeBetweenEvictionRunsMillis=1800000
  77. numTestsPerEvictionRun=3
  78. testOnBorrow=true
  79. testWhileIdle=true
  80. testOnReturn=true
  81. validationQuery="SELECT 1"
  82. }
  83. }
  84. }
  85. }
Add Comment
Please, Sign In to add comment