Guest User

Untitled

a guest
Nov 12th, 2018
124
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.15 KB | None | 0 0
  1. @BeforeClass
  2. public static void setUpJdbc() throws IOException, InterruptedException, SQLException {
  3. Connection c = DriverManager.getConnection("jdbc:postgresql://localhost:5432/default_db", "user_name", "pw");
  4. Statement statement = c.createStatement();
  5. statement.executeUpdate("create database test_db with template test_template;");
  6. statement.close();
  7. c.close();
  8. }
  9.  
  10. @AfterClass
  11. public static void tearDownJdbc() throws SQLException {
  12. Connection c = DriverManager.getConnection("jdbc:postgresql://localhost:5432/default_db", "user_name", "pw");
  13. Statement statement = c.createStatement();
  14. statement.executeUpdate("REVOKE CONNECT ON DATABASE test_db FROM public;");
  15. statement.execute("SELECT pid, pg_terminate_backend(pid) n" +
  16. "FROM pg_stat_activity n" +
  17. "WHERE datname = 'test_db' AND pid <> pg_backend_pid();");
  18. statement.executeUpdate("drop database if exists test_db;");
  19. statement.close();
  20. c.close();
  21. }
  22.  
  23. public List<Object> query(String sqlquery) throws DatabaseConnectionException {
  24. Session session = null;
  25. Transaction transcation = null;
  26. List<Object> sqlQueryResults = null;
  27. try {
  28. session = factory.openSession();
  29. transcation = session.beginTransaction();
  30. Query query = session.createNativeQuery(sqlquery);
  31. sqlQueryResults = query.list();
  32. transcation.commit();
  33. } catch (SQLGrammarException e) {
  34. if (transcation != null)
  35. transcation.rollback();
  36. throw new DatabaseConnectionException();
  37. } catch (HibernateException e) {
  38. if (transcation != null)
  39. transcation.rollback();
  40. throw new DatabaseConnectionException();
  41. } finally {
  42. if (session != null)
  43. session.close();
  44. }
  45. return sqlQueryResults;
  46. }
  47.  
  48. org.hibernate.exception.JDBCConnectionException: Unable to release JDBC Connection
  49. at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:115)
  50. at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
  51. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
  52. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
  53. at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.releaseConnection(LogicalConnectionManagedImpl.java:199)
  54. at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.close(LogicalConnectionManagedImpl.java:239)
  55. at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.close(JdbcCoordinatorImpl.java:189)
  56. at org.hibernate.internal.AbstractSharedSessionContract.close(AbstractSharedSessionContract.java:311)
  57. at org.hibernate.internal.SessionImpl.close(SessionImpl.java:423)
  58. at com.dummy.DataLayer.query(DataLayer.java:173)
  59. at com.dummy.MITypeCompositeDAO.getLatestExecutionForUser(MITypeCompositeDAO.java:71)
  60. at com.dummy.MITypeCompositeDAO.getMITypeCompositeForUser(MITypeCompositeDAO.java:137)
  61. at com.dummy.MITypeCompositeDAOTest.testGetMITypeCompositeForUser(MITypeCompositeDAOTest.java:62)
  62. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  63. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  64. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  65. at java.lang.reflect.Method.invoke(Method.java:498)
  66. at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)
  67. at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
  68. at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)
  69. at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)
  70. at org.junit.runners.BlockJUnit4ClassRunner.runNotIgnored(BlockJUnit4ClassRunner.java:79)
  71. at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:71)
  72. at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:49)
  73. at org.junit.runners.ParentRunner$3.run(ParentRunner.java:193)
  74. at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:52)
  75. at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:191)
  76. at org.junit.runners.ParentRunner.access$000(ParentRunner.java:42)
  77. at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:184)
  78. at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
  79. at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)
  80. at org.junit.runners.ParentRunner.run(ParentRunner.java:236)
  81. at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:369)
  82. at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:275)
  83. at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:239)
  84. at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:160)
  85. at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:373)
  86. at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:334)
  87. at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:119)
  88. at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:407)
  89. Caused by: org.postgresql.util.PSQLException: This connection has been closed.
  90. at org.postgresql.jdbc.PgConnection.checkClosed(PgConnection.java:766)
  91. at org.postgresql.jdbc.PgConnection.setAutoCommit(PgConnection.java:712)
  92. at org.hibernate.engine.jdbc.connections.internal.PooledConnections.add(PooledConnections.java:68)
  93. at org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl.closeConnection(DriverManagerConnectionProviderImpl.java:195)
  94. at org.hibernate.internal.NonContextualJdbcConnectionAccess.releaseConnection(NonContextualJdbcConnectionAccess.java:46)
  95. at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.releaseConnection(LogicalConnectionManagedImpl.java:196)
  96. ... 35 more
Add Comment
Please, Sign In to add comment