java - Failed to connect hypersonic(HSQLDB) DB on Apache 7.0 -
i have project in eclipse defined 'dynamic web project' on apache-tomcat 7.0 server.
 need connect hypersonic db (hsqldb) in of java classses.
the code i'm trying make simple:
private connection getconnection(){     connection conn;      try {            class.forname("org.hsqldb.jdbcdriver");         conn = drivermanager.getconnection("jdbc:hsqldb:hsql://localhost","sa","");         return conn;     }      catch (exception e) {         e.printstacktrace();     }        return null; }   i added hsqldb.jar lib library located in project , defined in java build path on eclipse.
the problem i'm getting error:
java.lang.classnotfoundexception: org.hsqldb.jdbcdriver     @ org.apache.catalina.loader.webappclassloader.loadclass(webappclassloader.java:1722)     @ org.apache.catalina.loader.webappclassloader.loadclass(webappclassloader.java:1573)     @ java.lang.class.forname0(native method)     @ java.lang.class.forname(unknown source)     @ root.login.getconnection(login.java:75)     @ root.login.dopost(login.java:35)   so cannot find org.hsqldb.jdbcdriver class reason.
 have made configuration many times before that, , went well.
funny story:
managed have simple java project main function , function on same configuration, , went on exact same machine.
- what can in order find class?
 - is there more information need tell make clearer?
 
in web application, have add hsqldb.jar file web-inf/lib folder of application (or $tomcat_home/lib folder, if have more webapps using it). have in eclipse project's classpath not enough.
Comments
Post a Comment