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?
sorry it was ok!