trouble with connecting database in a servlet

[hylee101001]

I tried to connect DB in a servlet. So I made ConnecDB function like below, and this funciton will be called in doPost method of the servlet. However, this function does not connect to DB. Do you know why?

I don't understand because when I run exact same function in another class's main, it works.



public static void ConnectDB(){
Connection c =null;

try{
String connectionString = "jdbc:hsqldb:hsql://localhost:9001";
c = DriverManager.getConnection(connectionString); //connect!!
}// end of try
catch(SQLException e){
System.out.println("\n--- SQLException caught ---\n");
while (e != null)
{
System.out.println("Message: " + e.getMessage());
System.out.println("SQLState: " + e.getSQLState());
System.out.println("Vendor ErrorCode: " + e.getErrorCode());
e = e.getNextException();
System.out.println();

}
}// end of catch

catch(Exception e){
e.printStackTrace();

}// end of catch
finally{
if (c !=null){
try{
c.close();
}
catch(Exception e2){
//do nothing - can't do anything anyway.
}
}// end of if
}// end of finally
}

[Tolls]

What errors/exceptions do you get?

[OC-John]

Yes, please paste the exceptions that is displayed. If you were able to access the database using the same function in the scripts located in the same server/system, then you may have to analyze the DB privileges too.

[Tolls]

Until we see the exception there's little point preempting the cause of the problem.

[nicephotog]

Try my book of dirty tricks here...
http://www.nicephotog-jsp.net/QueryU...and_source.zip