cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christian Haul <>
Subject Re: esql samples
Date Wed, 12 Mar 2003 08:39:23 GMT
On 11.Mar.2003 -- 06:33 PM, Torsten Curdt wrote:
> >>I wanted to look after the esql samples but found
> >>
> >>1) the hsqldb not being filled (where did we do this before?)
> >
> >
> >I noticed this a few days ago, but haven't had time to write about it.  
> >I'm pretty sure from experiencing adding a new table to the demo a month 
> >ago that the hsqldb was not built automatically.  I had to modify the 
> >hsql running on my machine, and commit WEB-INF/db/hsql.script (or 
> >whatever) that was created when hsql shut down.  I could be wrong.  But 
> >that's what I remember.
> Hm... I see. So it's enough to just copy the sql script into the
> WEB-INF/db location. I'll take look...

Yes, that's what's happening. Nice enough, the db.script is more or
less SQL.


> I think the copy into the db directory should do it.


> >>2) the jdbc url, user and password not being replaced
> >
> >This i'm not sure about, but was it done by filter before?
> Yes it was. And the variables are already in the properties.
> As well the build.xml looks like it *should* work (on the first glance).
> But since this is only used for the "personal" datasource it doesn't
> make any sense all to have it configurable in the properties. It's just
> for the example database. Let's KISS :)

Well, the idea was to make it easy to switch to $MY_FAVOURITE_DBMS for
the user. I believe a frequently asked question is "how do I make the
samples work with (MySQL|PostgreSQL|Oracle|DB2|Sybase|Access)?"

C h r i s t i a n       H a u l
    fingerprint: 99B0 1D9D 7919 644A 4837  7D73 FEF9 6856 335A 9E08

View raw message