Not signed in (Sign In)

Vanilla 1.1.5a is a product of Lussumo. More Information: Documentation, Community Support.

General: H2 database connection problem

Bottom of Page

1 to 2 of 2

  1.  
    • CommentAuthorliz99
    • CommentTimeFeb 24th 2010
     
    Hello,

    I am having some trouble connecting to my H2 database - below is the
    block of code I wrote to establish the connection:

    Class.forName("org.h2.Driver").newInstance();
    Server server = Server.createTcpServer().start();
    Connection conn = DriverManager.getConnection("jdbc:h2:tcp://localhost/schedules", "sa", "");

    The Driver class, JDBC URL, User Name and Password I used in the code
    above is exactly the same to what I'm using to connect to my database
    in the H2 login page. The URL of my database login page is http://localhost:8082.
    8082 is the port I'm using that's tunneled via SSH to my actual
    database that's hosted in a separate server. When I tried to query the
    database by executing

    Statement stmt = conn.createStatement();
    rs = stmt.executeQuery("select * from Schedules");

    I got the following error in the console:
    org.h2.jdbc.JdbcSQLException: Table "Schedules" not found; SQL
    statement:
    select * from Schedules [42102-126]

    When I changed the table name to one that doesn't even exist in my
    database I got the same error message. Does anyone know what I've done
    wrong? Your help would be tremendously appreciated!

    Cheers,
    Liz
  2.  
    Hello Liz,

    I'm afraid this is the wrong forum. Please post your question in the h2 Google group instead:

    http://groups.google.com/group/h2-database

1 to 2 of 2

  1.