Hi, > how did you get the version of H2 database I'm using?
The build number is included in the error message: [90020-128] means error code 90020, build 128. Which is version 1.2.128 from 2010-01-30 (sorry 2009 was wrong). Regards, Thomas On Thu, May 23, 2013 at 9:33 PM, Rnj <[email protected]> wrote: > I'm sorry to confuse you. I could resolve the issue. > I am trying to get a jdbc connection through jetty in serverconnector > class and in hellohandler class I am again trying to the connection using > DriverManager, that created exception. > I'm curious to know, how did you get the version of H2 database I'm using? > > > On Thursday, May 23, 2013 1:32:13 PM UTC-5, Thomas Mueller wrote: > >> Hi, >> >> The exception says the database is already open in another process. To >> find out which process that could be, I suggest to run "jps" on the command >> line. >> >> Please note you are using a very old version of H2 (from 2009 I think). >> You should upgrade to a more recent version. >> >> Regards, >> Thomas >> >> >> On Thu, May 23, 2013 at 7:17 PM, Rnj <[email protected]> wrote: >> >>> I have my H2 database and Jetty Web server installed in lib folder of my >>> Java project. I'm trying to create a jdbc connection using following code : >>> >>> ServerConnector.java >>> >>> Server server = new Server(8080); >>>> JDBCSessionIdManager idMgr = new JDBCSessionIdManager(server); >>>> idMgr.setWorkerName("xyz"); >>>> idMgr.setDriverInfo("org.h2.**Driver", "jdbc:h2:~/test"); >>>> idMgr.setScavengeInterval(60)**; >>>> server.setSessionIdManager(**idMgr); >>>> server.setHandler(new HelloHandler()); >>>> server.start(); >>>> server.join(); >>> >>> >>> HelloHandler.java >>> >>>> @Override >>>> public void handle(String target, Request baseRequest, >>>> HttpServletRequest request, HttpServletResponse response) throws >>>> IOException, ServletException >>>> { >>>> response.setContentType("text/**html;charset=utf-8"); >>>> response.setStatus(**HttpServletResponse.SC_OK); >>>> baseRequest.setHandled(true); >>>> StringBuilder crTblQuery = new StringBuilder(); >>>> crTblQuery.append("SELECT AVG(Convert(BPS_AVG,INT)) FROM FRAMES where >>>> CLKRX_DATE = '2/13/2013'"); >>>> DbConnector dbConnector = new DbConnector(); >>>> try >>>> { >>>> Connection con = dbConnector.getDbConnection(); >>>> Statement st = con.createStatement(); >>>> ResultSet rs = st.executeQuery(crTblQuery.**toString()); >>>> rs.next(); >>>> response.getWriter().println("**<h1>" + rs.getString(1) + "</h1>"); >>>> if (_body != null) >>>> response.getWriter().println(_**body); >>>> >>>> con.close(); >>>> } >>>> catch (ClassNotFoundException | SQLException e) >>>> { >>>> e.printStackTrace(); >>>> } >>>> >>>> } >>> >>> >>> and I get following error when I run ServerConnector class >>> "Database may be already in use: "Locked by another process". Possible >>> solutions: close all other connection(s); use the server mode [90020-128]" >>> >>> How to resolve this issue? >>> >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "H2 Database" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to h2-database...@**googlegroups.com. >>> To post to this group, send email to [email protected]. >>> >>> Visit this group at >>> http://groups.google.com/**group/h2-database?hl=en<http://groups.google.com/group/h2-database?hl=en> >>> . >>> For more options, visit >>> https://groups.google.com/**groups/opt_out<https://groups.google.com/groups/opt_out> >>> . >>> >>> >>> >> >> -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/h2-database?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
