Hi Kevin,
Do you create the database in IBConsole ? Because the ibconsole has an bug when
creating databases.
If so, you probably have to get the newer version of IBConsole :
URL : http://www.interbase.com/open/downloads/ib_download.html
goto the miscellaneous section (at the bottumn of the page) and download
IBConsole - build 308. You must overwrite the ibconsole in your interbase
install directory. If you want the interbase-database-schema.xml (for orion cmp
managed persistence) mail me and i will sent it to you.
Further more i think interbase 6 is an very good database but I would like to
know
if it handle a large amount of connections at the same time (like 500 or
something).
There isn't much info about that in the docs.
Greetings Wim Veninga.
"Duffey, Kevin" wrote:
> Hey Scott,
>
> Interbase 6 is pretty nice in my opinion. Its SQL 92 compliant (if that
> means anything), its completely free and is now open-source, has a type IV
> jdbc driver, and it has a VERY small foot-print. It runs on most platforms I
> believe, and thus far its pretty darn fast. However, I have not been able to
> successfully create a database in it. I keep getting some stupid error when
> I try to create a database and I can't find any information on it. I'll have
> to post to the Interbase site probably..or maybe there is a newer version. I
> wish there was some more detailed info on how to completely set up
> Interbase. I can however connect via my java app and get connections out. I
> just can't seem to create tables and what not. Anyways..I worked with
> Interbase 4 and it was pretty fast, so I am sure 6 is better in many ways
> (that is not always true..but I hope it is).
>
> > -----Original Message-----
> > From: Scott Stirling [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, October 11, 2000 3:25 PM
> > To: Orion-Interest
> > Subject: RE: HARDWARE FOR J2EE apps
> >
> >
> > Why would you use mySQL over Postgresl? They're both free,
> > but Postgresql has a
> > JDBC driver that's XA-compliant. Also, mySQL is known to
> > blow away your whole
> > database if it has a bad crash, whereas Postgresql is better
> > at persisting data
> > through a bad crash.
> >
> > How does Interbase 6 compare to Postgresql? Is it free?
> >
> > Scott Stirling
> > West Newton, MA
> >
> > > -----Original Message-----
> > > From: [EMAIL PROTECTED]
> > > [mailto:[EMAIL PROTECTED]]On Behalf Of
> > Duffey, Kevin
> > > Sent: Wednesday, October 11, 2000 4:01 PM
> > > To: Orion-Interest
> > > Subject: RE: HARDWARE FOR J2EE apps
> > >
> > >
> > > Hi,
> > >
> > > > sounds very nice but what about the database? how do you
> > cluster that
> > > > without spending an arm and a leg? our experience is, that
> > > > it's not that
> > > > hard to set up clustered web services with static pages and
> > > > servlets but
> > > > the really expensive part is, when you want that high
> > > > availability for your
> > > > database. it doesn't buy you much if you have highly
> > > > available ejbs when
> > > > the database server goes down. many people use clustered
> > > > apache/jserv on
> > > > linux and cheap pc-hardware for high volume transactional
> > > > websites but have
> > > > a large enterprise sun running oracle in the back. anyone out
> > > > there running
> > > > a configuration with orion that includes a database with
> > > > failover that
> > > > doesn't blow up the budget too much (compared to other
> > components)?
> > >
> > > Well, to start off with there is mySQL and the one I like
> > the most is
> > > Interbase 6..a free powerful RDBMS. However, as far as
> > clustering them..I
> > > don't quite know the best way. I would think a
> > load-balancer or a switch or
> > > something, would be required. Nobody ever said it was
> > cheap! ;) I used to
> > > think $25,000 could easily set up a website from front to
> > back, software,
> > > hardware, etc..but not even close these days. If you are
> > just starting out,
> > > I would use Orion for front-end and ejb-logic tiers in a clustered
> > > environment (for developing/testing), with a single server
> > running mySQL or
> > > Interbase for the database. Once you get some funding and
> > move beyond the
> > > concept phase, you should put a sizeable chunk to invest in
> > co-locating your
> > > site and doing the full load-balancing setup. I would
> > estimate a cheap setup
> > > with 2 front-end web/servlet servers failed over, 2 ejb
> > servers, and a
> > > database cluster will still run around $100,000, to co-lo
> > it..which is
> > > probably the best thing to do to make sure its up 24/7.
> > >
> > >
> >
> >
