You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@turbine.apache.org by Age Mooy <am...@home.nl> on 2001/10/02 14:13:48 UTC
Using HyperSonic
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:
database.default.url=jdbc:HypersonicSQL:..\..\resources\db\hypersonic\standalone
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.
2) doInsert() doesn't work.
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 ?
Thanx,
Age
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
Re: Using HyperSonic
Posted by Jason van Zyl <jv...@apache.org>.
On 10/2/01 10:54 AM, "Age Mooy" <am...@home.nl> wrote:
>
>> 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}
>
> Any vague guess as to when TDK 2.2 is coming ?
Vague guess: two weeks. I am working on an installer which seems to be all
fine and well but SSL setup is proving to be a severe PITA.
> I'm using the CVS HEAD of jakarta-turbine-2... does that mean I get this new
> TurbineResources behaviour ?
It's in CVS HEAD
${applicationRoot}
${webappRoot}
are available, and that's it so far. I usually put the hsqldb in the
WEB-INF/db directory myself and always use the ${webappRoot}.
> Where can I find the list of properties that is available like that in the TRP
> ?
> This is very usefull stuff, thanx !!
>
> Age
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: turbine-user-help@jakarta.apache.org
--
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: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
RE: Using HyperSonic
Posted by Age Mooy <am...@home.nl>.
> 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}
Any vague guess as to when TDK 2.2 is coming ?
I'm using the CVS HEAD of jakarta-turbine-2... does that mean I get this new TurbineResources behaviour ?
Where can I find the list of properties that is available like that in the TRP ?
This is very usefull stuff, thanx !!
Age
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
Re: Using HyperSonic
Posted by Jason van Zyl <jv...@apache.org>.
On 10/2/01 8:13 AM, "Age Mooy" <am...@home.nl> 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: turbine-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: turbine-user-help@jakarta.apache.org
--
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: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org