API tools faq
paste
Guest User

Untitled

a guest
Oct 20th, 2018
82
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 14.87 KB | None | 0 0
raw download clone embed print report
  1. @Configuration
  2. @Profile({ Profiles.DEV })
  3. public class DevDataSourceConfiguration {
  4.  
  5. @Bean(initMethod = "start", destroyMethod = "stop")
  6. public Server h2WebServer() throws SQLException {
  7. return Server.createWebServer("-web", "-webAllowOthers", "-webPort", "8082");
  8. }
  9.  
  10. @Bean(initMethod = "start", destroyMethod = "stop")
  11. @DependsOn("h2WebServer")
  12. public Server h2Server() throws SQLException {
  13. return Server.createTcpServer("-tcp", "-tcpAllowOthers", "-tcpPort", "9092");
  14. }
  15.  
  16. @Bean
  17. @DependsOn("h2Server")
  18. public DataSource datasource() {
  19. HikariDataSource ds = new HikariDataSource();
  20. ds.setDriverClassName("org.h2.Driver");
  21. ds.setJdbcUrl("jdbc:h2:tcp://localhost/~/bignibou");
  22. return ds;
  23. }
  24. }
  25.  
  26. 2015-05-17 17:02:24.544 WARN 595 [ExecutorRunner-pool-3-thread-11 - G.ￄﾃ] Could not setAutoCommit(true) for: bignibou
  27. org.h2.jdbc.JdbcSQLException: Connection is broken: "unexpected status 16777216" [90067-176]
  28. at org.h2.message.DbException.getJdbcSQLException(DbException.java:344)
  29. at org.h2.message.DbException.get(DbException.java:178)
  30. at org.h2.message.DbException.get(DbException.java:154)
  31. at org.h2.engine.SessionRemote.done(SessionRemote.java:621)
  32. at org.h2.command.CommandRemote.prepare(CommandRemote.java:69)
  33. at org.h2.command.CommandRemote.<init>(CommandRemote.java:46)
  34. at org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:476)
  35. at org.h2.engine.SessionRemote.setAutoCommitSend(SessionRemote.java:243)
  36. at org.h2.engine.SessionRemote.setAutoCommit(SessionRemote.java:210)
  37. at org.h2.jdbc.JdbcConnection.setAutoCommit(JdbcConnection.java:431)
  38. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  39. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  40. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  41. at java.lang.reflect.Method.invoke(Method.java:497)
  42. at com.onseven.dbvis.h.B.C.ￄﾁ(Z:2206)
  43. at com.onseven.dbvis.h.B.F$A.call(Z:2515)
  44. at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  45. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  46. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  47. at java.lang.Thread.run(Thread.java:745)
  48. 2015-05-17 17:02:24.546 INFO 595 [ExecutorRunner-pool-3-thread-11 - AbstractFacade.getCatalog] Could not getCatalog for: bignibou
  49. org.h2.jdbc.JdbcSQLException: Connection is broken: "unexpected status 16777216" [90067-176]
  50. at org.h2.message.DbException.getJdbcSQLException(DbException.java:344)
  51. at org.h2.message.DbException.get(DbException.java:178)
  52. at org.h2.message.DbException.get(DbException.java:154)
  53. at org.h2.engine.SessionRemote.done(SessionRemote.java:621)
  54. at org.h2.command.CommandRemote.prepare(CommandRemote.java:69)
  55. at org.h2.command.CommandRemote.<init>(CommandRemote.java:46)
  56. at org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:476)
  57. at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1188)
  58. at org.h2.jdbc.JdbcConnection.getCatalog(JdbcConnection.java:598)
  59. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  60. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  61. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  62. at java.lang.reflect.Method.invoke(Method.java:497)
  63. at com.onseven.dbvis.h.B.C.ￄﾁ(Z:2206)
  64. at com.onseven.dbvis.h.B.F$A.call(Z:2515)
  65. at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  66. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  67. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  68. at java.lang.Thread.run(Thread.java:745)
  69.  
  70. 2015-05-26 12:25:13.601 INFO 159 [pool-3-thread-8 - Q.flush] 05-26 12:25:13 jdbc:
  71. /**/Connection conn1 = DriverManager.getConnection("jdbc:h2:tcp://localhost/~/bignibou;trace_level_system_out=3", "", "");
  72. 2015-05-26 12:25:13.602 INFO 159 [pool-3-thread-8 - Q.flush] 05-26 12:25:13 jdbc:
  73. /**/DatabaseMetaData dbMeta1 = conn1.getMetaData();
  74. 2015-05-26 12:25:13.602 INFO 159 [pool-3-thread-8 - Q.flush] 05-26 12:25:13 jdbc:
  75. /**/conn1.setAutoCommit(true);
  76. 2015-05-26 12:25:13.602 INFO 159 [pool-3-thread-8 - Q.flush] 05-26 12:25:13 jdbc: SESSION_PREPARE_READ_PARAMS 0
  77. 2015-05-26 12:25:13.603 INFO 159 [pool-3-thread-8 - Q.flush] 05-26 12:25:13 jdbc: exception
  78. 2015-05-26 12:25:13.603 INFO 159 [pool-3-thread-8 - Q.flush] org.h2.jdbc.JdbcSQLException: Connection is broken: "unexpected status 16777216" [90067-176]
  79. 2015-05-26 12:25:13.603 INFO 159 [pool-3-thread-8 - Q.flush] at org.h2.message.DbException.getJdbcSQLException(DbException.java:344)
  80. 2015-05-26 12:25:13.603 INFO 159 [pool-3-thread-8 - Q.flush] at org.h2.message.DbException.get(DbException.java:178)
  81. 2015-05-26 12:25:13.603 INFO 159 [pool-3-thread-8 - Q.flush] at org.h2.message.DbException.get(DbException.java:154)
  82. 2015-05-26 12:25:13.603 INFO 159 [pool-3-thread-8 - Q.flush] at org.h2.engine.SessionRemote.done(SessionRemote.java:621)
  83. 2015-05-26 12:25:13.603 INFO 159 [pool-3-thread-8 - Q.flush] at org.h2.command.CommandRemote.prepare(CommandRemote.java:69)
  84. 2015-05-26 12:25:13.603 INFO 159 [pool-3-thread-8 - Q.flush] at org.h2.command.CommandRemote.<init>(CommandRemote.java:46)
  85. 2015-05-26 12:25:13.603 INFO 159 [pool-3-thread-8 - Q.flush] at org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:476)
  86. 2015-05-26 12:25:13.603 INFO 159 [pool-3-thread-8 - Q.flush] at org.h2.engine.SessionRemote.setAutoCommitSend(SessionRemote.java:243)
  87. 2015-05-26 12:25:13.603 INFO 159 [pool-3-thread-8 - Q.flush] at org.h2.engine.SessionRemote.setAutoCommit(SessionRemote.java:210)
  88. 2015-05-26 12:25:13.604 INFO 159 [pool-3-thread-8 - Q.flush] at org.h2.jdbc.JdbcConnection.setAutoCommit(JdbcConnection.java:431)
  89. 2015-05-26 12:25:13.604 INFO 159 [pool-3-thread-8 - Q.flush] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  90. 2015-05-26 12:25:13.604 INFO 159 [pool-3-thread-8 - Q.flush] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  91. 2015-05-26 12:25:13.604 INFO 159 [pool-3-thread-8 - Q.flush] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  92. 2015-05-26 12:25:13.604 INFO 159 [pool-3-thread-8 - Q.flush] at java.lang.reflect.Method.invoke(Method.java:497)
  93. 2015-05-26 12:25:13.604 INFO 159 [pool-3-thread-8 - Q.flush] at com.onseven.dbvis.h.B.C.ￄﾁ(Z:2206)
  94. 2015-05-26 12:25:13.604 INFO 159 [pool-3-thread-8 - Q.flush] at com.onseven.dbvis.h.B.F$A.call(Z:2515)
  95. 2015-05-26 12:25:13.604 INFO 159 [pool-3-thread-8 - Q.flush] at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  96. 2015-05-26 12:25:13.604 INFO 159 [pool-3-thread-8 - Q.flush] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  97. 2015-05-26 12:25:13.604 INFO 159 [pool-3-thread-8 - Q.flush] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  98. 2015-05-26 12:25:13.604 INFO 159 [pool-3-thread-8 - Q.flush] at java.lang.Thread.run(Thread.java:745)
  99. 2015-05-26 12:25:13.604 WARN 159 [ExecutorRunner-pool-2-thread-2 - G.ￄﾃ] Could not setAutoCommit(true) for: bignibou
  100. org.h2.jdbc.JdbcSQLException: Connection is broken: "unexpected status 16777216" [90067-176]
  101. at org.h2.message.DbException.getJdbcSQLException(DbException.java:344)
  102. at org.h2.message.DbException.get(DbException.java:178)
  103. at org.h2.message.DbException.get(DbException.java:154)
  104. at org.h2.engine.SessionRemote.done(SessionRemote.java:621)
  105. at org.h2.command.CommandRemote.prepare(CommandRemote.java:69)
  106. at org.h2.command.CommandRemote.<init>(CommandRemote.java:46)
  107. at org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:476)
  108. at org.h2.engine.SessionRemote.setAutoCommitSend(SessionRemote.java:243)
  109. at org.h2.engine.SessionRemote.setAutoCommit(SessionRemote.java:210)
  110. at org.h2.jdbc.JdbcConnection.setAutoCommit(JdbcConnection.java:431)
  111. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  112. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  113. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  114. at java.lang.reflect.Method.invoke(Method.java:497)
  115. at com.onseven.dbvis.h.B.C.ￄﾁ(Z:2206)
  116. at com.onseven.dbvis.h.B.F$A.call(Z:2515)
  117. at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  118. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  119. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  120. at java.lang.Thread.run(Thread.java:745)
  121. 2015-05-26 12:25:13.605 INFO 159 [pool-3-thread-8 - Q.flush] 05-26 12:25:13 jdbc:
  122. /**/conn1.isClosed();
  123. 2015-05-26 12:25:13.605 INFO 159 [pool-3-thread-8 - Q.flush] 05-26 12:25:13 jdbc:
  124. /**/conn1.getAutoCommit();
  125. 2015-05-26 12:25:13.608 INFO 159 [ExecutorRunner-pool-2-thread-2 - Q.flush] 05-26 12:25:13 jdbc:
  126. /**/dbMeta1.getSearchStringEscape();
  127. 2015-05-26 12:25:13.608 INFO 159 [pool-3-thread-8 - Q.flush] 05-26 12:25:13 jdbc:
  128. /**/conn1.isClosed();
  129. 2015-05-26 12:25:13.608 INFO 159 [pool-3-thread-8 - Q.flush] 05-26 12:25:13 jdbc:
  130. /**/conn1.getAutoCommit();
  131. 2015-05-26 12:25:13.608 INFO 159 [pool-3-thread-8 - Q.flush] 05-26 12:25:13 jdbc:
  132. /**/conn1.getCatalog();
  133. 2015-05-26 12:25:13.608 INFO 159 [pool-3-thread-8 - Q.flush] 05-26 12:25:13 jdbc: SESSION_PREPARE_READ_PARAMS 1
  134. 2015-05-26 12:25:13.608 INFO 159 [pool-3-thread-8 - Q.flush] 05-26 12:25:13 jdbc: exception
  135. 2015-05-26 12:25:13.609 INFO 159 [pool-3-thread-8 - Q.flush] org.h2.jdbc.JdbcSQLException: Connection is broken: "unexpected status 16777216" [90067-176]
  136. 2015-05-26 12:25:13.609 INFO 159 [pool-3-thread-8 - Q.flush] at org.h2.message.DbException.getJdbcSQLException(DbException.java:344)
  137. 2015-05-26 12:25:13.609 INFO 159 [pool-3-thread-8 - Q.flush] at org.h2.message.DbException.get(DbException.java:178)
  138. 2015-05-26 12:25:13.609 INFO 159 [pool-3-thread-8 - Q.flush] at org.h2.message.DbException.get(DbException.java:154)
  139. 2015-05-26 12:25:13.609 INFO 159 [pool-3-thread-8 - Q.flush] at org.h2.engine.SessionRemote.done(SessionRemote.java:621)
  140. 2015-05-26 12:25:13.609 INFO 159 [pool-3-thread-8 - Q.flush] at org.h2.command.CommandRemote.prepare(CommandRemote.java:69)
  141. 2015-05-26 12:25:13.609 INFO 159 [pool-3-thread-8 - Q.flush] at org.h2.command.CommandRemote.<init>(CommandRemote.java:46)
  142. 2015-05-26 12:25:13.609 INFO 159 [pool-3-thread-8 - Q.flush] at org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:476)
  143. 2015-05-26 12:25:13.609 INFO 159 [pool-3-thread-8 - Q.flush] at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1188)
  144. 2015-05-26 12:25:13.609 INFO 159 [pool-3-thread-8 - Q.flush] at org.h2.jdbc.JdbcConnection.getCatalog(JdbcConnection.java:598)
  145. 2015-05-26 12:25:13.609 INFO 159 [pool-3-thread-8 - Q.flush] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  146. 2015-05-26 12:25:13.609 INFO 159 [pool-3-thread-8 - Q.flush] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  147. 2015-05-26 12:25:13.609 INFO 159 [pool-3-thread-8 - Q.flush] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  148. 2015-05-26 12:25:13.609 INFO 159 [pool-3-thread-8 - Q.flush] at java.lang.reflect.Method.invoke(Method.java:497)
  149. 2015-05-26 12:25:13.609 INFO 159 [pool-3-thread-8 - Q.flush] at com.onseven.dbvis.h.B.C.ￄﾁ(Z:2206)
  150. 2015-05-26 12:25:13.610 INFO 159 [pool-3-thread-8 - Q.flush] at com.onseven.dbvis.h.B.F$A.call(Z:2515)
  151. 2015-05-26 12:25:13.610 INFO 159 [pool-3-thread-8 - Q.flush] at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  152. 2015-05-26 12:25:13.610 INFO 159 [pool-3-thread-8 - Q.flush] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  153. 2015-05-26 12:25:13.610 INFO 159 [pool-3-thread-8 - Q.flush] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  154. 2015-05-26 12:25:13.610 INFO 159 [pool-3-thread-8 - Q.flush] at java.lang.Thread.run(Thread.java:745)
  155. 2015-05-26 12:25:13.610 INFO 159 [ExecutorRunner-pool-2-thread-2 - AbstractFacade.getCatalog] Could not getCatalog for: bignibou
  156. org.h2.jdbc.JdbcSQLException: Connection is broken: "unexpected status 16777216" [90067-176]
  157. at org.h2.message.DbException.getJdbcSQLException(DbException.java:344)
  158. at org.h2.message.DbException.get(DbException.java:178)
  159. at org.h2.message.DbException.get(DbException.java:154)
  160. at org.h2.engine.SessionRemote.done(SessionRemote.java:621)
  161. at org.h2.command.CommandRemote.prepare(CommandRemote.java:69)
  162. at org.h2.command.CommandRemote.<init>(CommandRemote.java:46)
  163. at org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:476)
  164. at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1188)
  165. at org.h2.jdbc.JdbcConnection.getCatalog(JdbcConnection.java:598)
  166. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  167. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  168. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  169. at java.lang.reflect.Method.invoke(Method.java:497)
  170. at com.onseven.dbvis.h.B.C.ￄﾁ(Z:2206)
  171. at com.onseven.dbvis.h.B.F$A.call(Z:2515)
  172. at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  173. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  174. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  175. at java.lang.Thread.run(Thread.java:745)
  176. 2015-05-26 12:25:13.611 INFO 159 [pool-3-thread-8 - Q.flush] 05-26 12:25:13 jdbc:
  177. /**/conn1.isClosed();
  178. 2015-05-26 12:25:13.611 INFO 159 [pool-3-thread-8 - Q.flush] 05-26 12:25:13 jdbc:
  179. /**/conn1.getAutoCommit();
  180. 2015-05-26 12:25:13.611 INFO 159 [pool-3-thread-8 - Q.flush] 05-26 12:25:13 jdbc:
  181. /**/Statement stat1 = conn1.createStatement();
  182. 2015-05-26 12:25:13.611 INFO 159 [pool-3-thread-8 - Q.flush] 05-26 12:25:13 jdbc:
  183. /**/ResultSet rs1 = stat1.executeQuery("call schema()");
  184. 2015-05-26 12:25:13.611 INFO 159 [pool-3-thread-8 - Q.flush] 05-26 12:25:13 jdbc: SESSION_PREPARE_READ_PARAMS 2
  185.  
  186. 05-26 12:25:13 database: connecting session #14 to /Users/julien/bignibou
  187. 05-26 12:25:13 jdbc[14]:
  188. /*SQL */SET TRACE_LEVEL_SYSTEM_OUT 3;
  189. 05-26 12:29:04 jdbc[13]:
  190. /*SQL */ROLLBACK;
  191. 05-26 12:29:04 jdbc[14]:
  192. /*SQL */ROLLBACK;
  193. 05-26 12:29:04 database: disconnecting session #14
  194. 05-26 12:29:04 database: disconnected session #14
  195. 05-26 12:29:04 database: disconnecting session #13
  196. 05-26 12:29:04 database: disconnected session #13
  197.  
  198. [localhost-startStop-1] ERROR StackTrace - Full Stack Trace:
  199. org.h2.jdbc.JdbcSQLException: Connection is broken: "java.net.ConnectException: Connection refused: connect: localhost" [90067-176]
  200.  
  201. dependencies {
  202. ...
  203. test "org.grails:grails-datastore-test-support:1.0.2-grails-2.4"
  204. runtime "com.h2database:h2:1.4.196"
  205. }
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!