Hi again The URL and Console fields are in the original post. What should it be?
Thanks Max On Wednesday, March 4, 2015 at 5:43:31 PM UTC+11, Thomas Mueller wrote: > > Hi, > > If the message is really > > java.sql.SQLException: No suitable driver found for > at java.sql.DriverManager.getConnection(Unknown... > > then your database URL is empty (an empty String). > > Regards, > Thomas > > On Tuesday, March 3, 2015, Max Telfer <[email protected] <javascript:>> > wrote: > >> Hi >> >> I have posted this before. I am using an old version, h2-1.3.159, that is >> quite OK for my use. >> >> Many updates ago, I could, in Windows, double click on theH2 jar file >> and the console would open and allow me to view/edit my database. >> >> Now I get the following: >> >> No suitable driver found for >> <http://192.168.1.2:8082/login.do?jsessionid=7bf7b4baf44ad8feda620ade65171441#> >> >> 08001/0 >> java.sql.SQLException: No suitable driver found for >> at java.sql.DriverManager.getConnection(Unknown Source) >> at java.sql.DriverManager.getConnection(Unknown Source) >> at org.h2.util.JdbcUtils.getConnection(JdbcUtils.java:188) >> at org.h2.server.web.WebServer.getConnection(WebServer.java:608) >> at org.h2.server.web.WebApp.login(WebApp.java:889) >> at org.h2.server.web.WebApp.process(WebApp.java:207) >> at org.h2.server.web.WebApp.processRequest(WebApp.java:166) >> at org.h2.server.web.WebThread.process(WebThread.java:132) >> at org.h2.server.web.WebThread.run(WebThread.java:88) >> at java.lang.Thread.run(Unknown Source) >> >> I am using windows 7 64 bit. >> >> The URL that is used when the jar file is clicked is: >> http://192.168.1.2:8082/login.do?jsessionid= >> 7bf7b4baf44ad8feda620ade65171441 >> >> The Console fields are: >> Generic H2 (Server) >> org.h2.Driver >> jdbc:h2:c:/ProgramData/companyname/dbshift >> >> My Java code connects to the database OK with a blank Username and >> Password (it has never been set to my recollection) and with the code lines: >> Class.forName("org.h2.Driver"); >> and >> con = DriverManager.getConnection("jdbc:h2:" + connectionURL + >> ";AUTO_SERVER=TRUE") where connectionURL is the location of the database >> directory. >> >> Please assist >> >> Many thanks >> >> Max >> >> -- >> 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. >> For more options, visit https://groups.google.com/d/optout. >> > -- 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. For more options, visit https://groups.google.com/d/optout.
