I once had the same problem: Try to change the class name to org.hsqldb.jdbcDriver regards, wol.
Flair 喻俨 wrote: > I've got these info in http://localhost:8080/juddi/happyjuddi.jsp page > when I'm setting up HSQLDB as the persistent storage of jUDDI: > > + Got a JNDI Context! > + Got a JDBC DataSource (dsname=java:comp/env/jdbc/juddiDB) > - DB connection was not aquired. (Cannot load JDBC driver class > 'org.hsql.jdbcDriver') > - SELECT COUNT(*) FROM PUBLISHER failed (null) > > I'm currently using j2sdk_1.5.0_05, Tomcat 5.5.12, jUDDI 0.9 rc4, > HSQLDB 1.8.0.2 > I've put the hsqldb.jar in %CATALINA_HOME%/common/lib > I've added a juddi.xml file in %CATALINA_HOME%/conf/Catalina/localhost > which looks like this: > <Context path="/juddi" docBase="juddi" debug="5" reloadable="true" > crossContext="true"> > <Logger className="org.apache.catalina.logger.FileLogger" > prefix="localhost_juddi_log." suffix=".txt" timestamp="true"/> > <Resource > name="jdbc/juddiDB" auth="Container" > type="javax.sql.DataSource" > username="sa" > password="" > driverClassName="org.hsql.jdbcDriver" > url="jdbc:hsqldb:hsql://localhost/uddiRepo" > maxActive="8" > maxIdle="4" > validationQuery="select count(*) from PUBLISHER" /> > </Context> > I've created the database using the scripts under > juddi-0.9rc4\sql\hsqldb directory. > (java -cp hsqldb.jar org.hsqldb.Server -database.0 ../data/uddiRepo > -dbname.0 uddiRepo) > I've also started up the HSQLDB in server mode, and I can use the > DatabaseManager to connect by issuing the command: > java -cp hsqldb.jar org.hsqldb.util.DatabaseManagerSwing > > Can anybody help to get me right? Thx very much. > >
