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.
<snip/>
> I think the copy into the db directory should do it.
+1
> >>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)?"
Chris.
--
C h r i s t i a n H a u l
[EMAIL PROTECTED]
fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08
