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=7bf7b4baf44ad8feda620ade651714
> 41
>
> 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]
> <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');>
> .
> To post to this group, send email to [email protected]
> <javascript:_e(%7B%7D,'cvml','[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.
