On 10/2/01 8:13 AM, "Age Mooy" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm trying to get my tdk app to work with a standalone HyperSonic database and
> I'm running into some problems.
>
> 1) Has anyone managed to get a relative path working in the jdbc url ? I have
> tried variations on this:
The next version of the TDK will work with hypersonic. I have built the
sample app using hypersonic many times and have been very impressed with it.
I have made a few changes to turbine in order to make this work easily
including a relocatable applicationRoot which is available for use in the
TRP as ${applicationRoot}: so your URL for hypersonic becomes
database.default.url = jdbc:hsqldb:${applicationRoot}/db/${database}
> database.default.url=jdbc:HypersonicSQL:..\..\resources\db\hypersonic\standalo
> ne
>
> where I assumes that the working directory was web-inf/lib, which it clearly
> isn't. I'd rather not have fully
> qualified paths in my TurbineResources.properties because that kinda ruins the
> pluggability of my webapp.
Hsql (I am using the new 1.61) doesn't seem to like relative paths which I
have worked around in the same manner that the Jetspeed group has by making
changes to the TurbineResourceService and ExtendedProperties (3.x) so that
variable interpolation works in the TRP file.
> 2) doInsert() doesn't work.
It does work, with the 1.61 version I have at any rate. The sample app works
very well so database problems at all.
> BasePeer.doInsert() throws a NullPointerException because when it calls
> isPriorToInsert() on the IDGenerator
> belonging to the table. This is null because the database adaptor for
> HyperSonic returns NO_ID_METHOD as the
> id method.
>
> I have the idMethod of my tables set to "native" in my schma (IDENTITY in
> HyperSonic SQL)
>
> So how do I get doInsert() to work for HyperSonic ? Is the ID Broker the only
> option ?
I used the id broker myself I didn't try hsqldb's native method. I'm sure I
could get it to work but I use the id table method for everything.
>
> Thanx,
> Age
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
--
jvz.
Jason van Zyl
http://tambora.zenplex.org
http://jakarta.apache.org/turbine
http://jakarta.apache.org/velocity
http://jakarta.apache.org/alexandria
http://jakarta.apache.org/commons
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
