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