DBRepository problems

Juan Carl <[email protected]> Sun, 15 Feb 2004 21:26:40 -0300 (ART)
Newsgroups gmane.comp.java.jpublish.devel
Message-ID <[email protected]>
Hello..
I'm trying to run the jpublish-example with the
content stored in a HSQLDB database, but I receive
this message (in the browser) when I try to read the
page: "Error: null".
It seems there isn't a problem with the SQL statement.
I think it's a problem with the connection, because I
can't see any signal from the org.hsqldb.Server when I
do the $db_repository.get($page.Path) from the
template. I've the hsqldb.jar in the /lib directory.

This is my db configuration in the jpublish.xml
(similar to the jpublish-example)

<repository name="db_repository"
classname="org.jpublish.repository.db.DBRepository">
	    <driver>org.hsqldb.jdbcDriver</driver>
	    <url>jdbc:hsqldb:hsql://localhost:9001</url>
	    <username>sa</username>
	    <password></password>
	    <content-query>select body from contenido where
path = ?</content-query>
	    <last-modified-query>select last_modified from
contenido where path = ?</last-modified-query>
	    <paths-query>select * from contenido where path
like ?</paths-query>
	</repository>


The table in my database is "contenido" and has the
same attributes I've seen in the jpublish-example...
The server is running ok, because I've connected to it
from the hsqldb DatabaseManager...
¿What I'm doing wrong?

Please apologize me if it's a basic question, but I
need some help.

Thanks a lot...

          Juan Pablo

PD: I'm using JPublish 2.0, Tomcat 4.1.24 and HSQLDB 1.7

------------
Los mejores usados y las más tentadoras 
ofertas de 0km están en Yahoo! Autos.
Comprá o vendé tu auto en
http://autos.yahoo.com.ar


-------------------------------------------------------
SF.Net is sponsored by: Speed Start Your Linux Apps Now.
Build and deploy apps & Web services for Linux with
a free DVD software kit from IBM. Click Now!
http://ads.osdn.com/?ad_id=1356&alloc_id=3438&op=click