We are using hSQL + Orion in server mode as follows:
1) snip from data-source.xml
note the line url="jdbc:HypersonicSQL:hsql://jaguar" which is the hsql
"server mode" jdbc url
<data-source
name="Default data-source"
class="com.evermind.sql.ConnectionDataSource"
location="jdbc/DefaultDS"
pooled-location="jdbc/DefaultPooledDS"
xa-location="jdbc/xa/DefaultXADS"
ejb-location="jdbc/DefaultEJBDS"
url="jdbc:HypersonicSQL:hsql://jaguar"
connection-driver="org.hsql.jdbcDriver"
username="sa"
password=""
schema="database-schemas/hypersonic.xml"
/>
b) start hsql using "java -cp \orion\lib\hSql.jar org.hsql.Server"
Works fine & you can connect to the hsql server using the hSql DataBase
manager concurrently with orion also to see what is being stored.
Kind Regards
Neville Burnell
Business Manager Software
-----Original Message-----
From: Joseph B. Ottinger [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 10 August 2000 4:56 AM
To: Orion-Interest
Cc: [EMAIL PROTECTED]
Subject: RE: Jive
Sure. hsql serves just as a sort of "default database" for orion, so
you'll always have SOMETHING, even though the default mode of hsql kinda
sucks.
(Anyone looked into getting hsql to run in server mode from inside
orion?)
On Wed, 9 Aug 2000, J.T. Wenting wrote:
> Will Orion survive without hSQL installed? I do not use it for
anything
> myself, so if Orion can do without, so can I. I could always replace
it with
> another database if that is possible (instantDb, Interbase, Oracle (at
> work), even MS Access...).
>
> Jeroen T Wenting
> [EMAIL PROTECTED]
> ICQ UIN #9191966
>
> It's the end of the world as we know it and I feel fine (Michael
Stipe)
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Joseph B.
> Ottinger
> Sent: 09 August 2000 19:06
> To: Orion-Interest
> Cc: Orion-Interest; Matt Adam Tucker
> Subject: Re: Jive
>
>
> Um, no. It's not a bug in orion.
>
> It's a classpath issue, and literally a problem with hsql.jar, as
> stated. $ORION/lib jars get put in the classpath, and since Tree.class
in
> hsql is in the default package, it's exposed according to java's
rules. If
> you want to blame Java, fine. Go for it. If you want to blame hsql,
> fine. Go for it. In either case, blame is deserved (well, mostly for
hsql,
> but hey.) Orion is doing nothing to the classpath to make it behave
> oddly. The solution is to fix hsql.jar, really, not modify orion or
jive.
>
> On Wed, 9 Aug 2000, Chris Miller wrote:
>
> > Thanks for the reply Jeroen.
> >
> > As far as I can see, this is actually a bug in Orion - it's exposing
the
> > classes in hsql.jar (and probably the other /lib jars?) to JSP pages
when
> it
> > shouldn't be. I don't think Jive needs fixing?
> >
> > As for the hSQL scripts, I'm sorry but I don't have any - I'm
actually
> using
> > SQL Server (but I have a script for that if you want it?). My
solution to
> > the problem I described was to simply remove the hsql.jar file from
> > /orion/lib since I'm not using it.
> >
> > ----- Original Message -----
> > From: "J.T. Wenting" <[EMAIL PROTECTED]>
> > To: "Orion-Interest" <[EMAIL PROTECTED]>
> > Cc: "Matt Adam Tucker" <[EMAIL PROTECTED]>
> > Sent: Wednesday, August 09, 2000 3:38 PM
> > Subject: RE: Jive
> >
> >
> > > I'm working on building Jive. I'll look into it and forward your
message
> > to
> > > the main maintainers. Jive probably does not see the class, but
the JSP
> > > engine does. Maybe that's what is causing problems.
> > > Have you been able to create the Jive database on hSQL? If so, can
you
> > send
> > > in the SQL scripts for it? We want to have broad support.
> > >
> > > Jeroen T. Wenting
> > > [EMAIL PROTECTED]
> > >
> > > Murphy was wrong, things that can't go wrong will anyway
> > >
> > > > -----Original Message-----
> > > > From: [EMAIL PROTECTED]
> > > > [mailto:[EMAIL PROTECTED]]On Behalf Of Chris
Miller
> > > > Sent: Wednesday, August 09, 2000 15:13
> > > > To: Orion-Interest
> > > > Cc: [EMAIL PROTECTED]
> > > > Subject: Jive
> > > >
> > > >
> > > > Has anyone here used Jive (www.coolservlets.com/jive) with Orion
> > (1.1.37)?
> > > > I've just tried to set it up, and hit a problem because the
> > > > orion/lib/hsql.jar file contains a class called 'Tree'. Jive
also has
> a
> > > > class called this, and when I try to use it in a JSP page, Orion
finds
> > > > Hypersonic's Tree class first.
> > > >
> > > > So the question is, should this Hypersonic class be visible to
my
> > > > JSP page?
> > > > I would have thought not unless I explicitly used <%@ page
import ...
> %>
> > > >
> > > > Has anyone else seen this problem?
> > > >
> > >
> > >
> > >
> >
> >
> >
>
> -----------------------------------------------------------
> Joseph B. Ottinger [EMAIL PROTECTED]
> http://cupid.suninternet.com/~joeo HOMES.COM Developer
>
>
>
-----------------------------------------------------------
Joseph B. Ottinger [EMAIL PROTECTED]
http://cupid.suninternet.com/~joeo HOMES.COM Developer
