1 Reply Latest reply on Apr 25, 2002 7:01 AM by kiuma

    JBoss 3.0 RC1 Hypersonic HELP!

    kiuma Newbie

      Hello, I'm trying to test jboss 3.0 with jaas-howto.zip examples.

      But when I try to build the tables I have an error.
      It seems to connect but it doesn't apply statements.

      here is some piece of code:

      public static void main(String[] args)
      {
      try
      {
      // Load the Hypersonic JDBC driver
      Class.forName("org.hsqldb.jdbcDriver");
      String jdbcURL = "jdbc:hsqldb:hsql://127.0.0.1:1476";
      Connection conn = DriverManager.getConnection(jdbcURL, "sa", "");
      Statement statement = conn.createStatement();
      createPrincipalsTable(statement);
      .....
      }

      static void createPrincipalsTable(Statement statement) throws SQLException
      {
      try
      {
      statement.execute("DROP TABLE Principals");
      }
      catch(SQLException e)
      {
      // Ok, assume table does not exist
      }
      boolean result = statement.execute("CREATE TABLE Principals ("
      + "PrincipalID VARCHAR(64) PRIMARY KEY,"
      + "Password VARCHAR(64) )"
      );
      System.out.println("Created Principals table, result="+result);

      .......
      }

      output is:

      Created Principals table, result=false

      Any suggestion?