hsqldb + j9: Can't connect after create database
843849Oct 21 2005 — edited Aug 26 2006Hi,
I'm working on a j2me project with WSDD 5.7.1 and hsqldb 1.7.3. I solved many configurations problems that I've had, but now I'm facing a strange problem.
When I try to connect for the first time and the database files are not created, it connects with no problem, create tables and I could perform some sql operations.
But after that, when I try to connect again the following error occurs:
Driver not found: jdbc:hsqldb:file:dbmovel (dbmovel is the name of my database).
The error happens with the following instruction:
conn = DriverManager.getConnection("jdbc:hsqldb:file:dbmovel" ,
usr, pwd);
It passes ok by the Class.forName("org.hsqldb.jdbcDriver");
I just can connect again if I delete the database files created by hsqldb.
Thanks for some help.