Right, but this is fairly normal - there's nothing unique about doing this as compared to, for example, using Oracle or any other external database. The problem is in how hsql stores data in local mode - it stores it as raw SQL, which isn't very efficient on startup, and isn't very secure. What you're doing is the "normal" way to run hsql in server mode, which requires two VMs to be running. While the new linux jvm (1.3.0 beta-refresh) is MUCH improved in terms of memory requirements, it's still too hefty for my poor machine to just allocate a new VM for DB access (esp. when postgres is already running - but hsql is *great* for debugging purposes.) What I'd like to see is if someone managed to run hsql along with the web applications, inside *one* VM, instead of running the two VMs. On Fri, 11 Aug 2000, Neville Burnell wrote: > 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 > ----------------------------------------------------------- Joseph B. Ottinger [EMAIL PROTECTED] http://cupid.suninternet.com/~joeo HOMES.COM Developer
