DB Connection at www.mycgiserver.com

[Faisal Farooqui]

hi guys!!
can any 1 of u help me? actually Im working on a web-site built at the free space provided by www.mycgiserver.com, I used HSQLDB(Hypersonic DB), when i tried at my own computer it worked, but when i uploaded it at mycgiserver its giving me error.
when i used fully URL of my DB, It showed the msg that "Connection is broken"
and when i used relative path to DB(:/~usedid/Dbname) it showed the msg that File Input/Output error.
guys its very very urgent. i hope you will try to help me.
thanks in advance
bye
FAF (Faisal Ahmed Farooqui)
IBM Certified Solution Developer(OOAD & SCJP)
Sun Certified Web Component Developer

[Andres Gonzalez]

Mine is working like this:

String dbUrl  = "jdbc:HypersonicSQL:/members/mYLeTtErsDR4/<yourDbName>";
Class.forName("org.hsql.jdbcDriver");
Connection con = DriverManager.getConnection(dbUrl,"", "");
Statement stmt = con.createStatement(); 
....
....

is that what you're doing?
hope it helps