Guest User

Untitled

a guest
Aug 24th, 2018
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.58 KB | None | 0 0
  1. Data is not saving in MEMORY Table of HSQL
  2. ...the default, MEMORY tables are persistent.
  3.  
  4. CREATE MEMORY TABLE SESSIONS(
  5. SESSION_DATE DATE NOT NULL,
  6. IN_TIME TIMESTAMP NOT NULL,
  7. OUT_TIME TIMESTAMP NOT NULL)
  8.  
  9. DriverManager.getConnection("jdbc:hsqldb:file:"+
  10. DbConnection.class.getResource("/loginTimerDB").getPath()+"/loginTimerDB",
  11. "SA",
  12. "");
  13.  
  14. "jdbc:hsqldb:file:loginTimerDB/loginTimerDB"
  15.  
  16. connection.prepareStatement("SHUTDOWN").execute();
  17.  
  18. jdbc:hsqldb:file:loginTimerDB/loginTimerDB;shutdown=true
Add Comment
Please, Sign In to add comment