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