You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@juddi.apache.org by Flair 喻俨 <zf...@yahoo.com.cn> on 2005/11/20 17:55:07 UTC

HSQLDB problem

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.

Re: HSQLDB problem

Posted by Flair 喻俨 <fy...@gmail.com>.

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.
>>
>>
>>     
>
>
>

Re: HSQLDB problem

Posted by Wolfgang Schreiner <e9...@student.tuwien.ac.at>.

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.
>
>