Hi, Well, if the error message really is exactly this, then for some reason the database URL in the code itself is an empty string (you can't always thrust what is in the GUI).
You may want to debug. Regards, Thomas On Wed, Mar 4, 2015 at 12:20 PM, Max Telfer <[email protected]> wrote: > 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]> 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=7bf7b4baf44ad8fe >>> da620ade65171441 >>> >>> 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. > -- 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.
