Thanks, that works. lol, I just made such a stupid mistake..
Wolfgang Schreiner wrote:
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.
