3 Replies Latest reply on Aug 23, 2004 8:01 AM by Darran Lofthouse

    How to connect to HyperSonic DB on JBoss?

    Piotr Wierzejewski Newbie

      Hi, i'm learning jBoss and at the beginning i would like connect to data base on jBoss. I have here part of my code:
      Connection con = null;
      Statement stm = null;
      ResultSet rs = null;
      try
      {
      Class.forName("?????")
      con = DriverManager.getConnection("????","user","password");

      stm = con.createStatement();
      rs = stm.executeQuery("select * from przedmioty");
      while (rs.next())
      {
      System.out.println(rs.getString("nazwa"));
      }
      if (con != null)
      con.close();

      What drivers should I use to connect to the HyperSonic? Do I need to install them? Where can i find them? What should i put in firs paramater in DriverManager.getConnecton(???,"user", "password")?