I would suggest PostgreSQL. It supports everything you would expect from a
database, including transaction support (and views, triggers in many languages,
as well as some OO stuff). A recent article in PHPBuilder.com compares PostGREs
and MySQL: PostGREs did so well, it looks like SourceForge will be ported to
PostGREs. The current version of PostGREs scales better than MySQL.
http://postgresql.readysetnet.com/
Kamen wrote:
> Just keep in mind that MySQL doesn't support transactions.
> Regards,
> Kamen
> ----- Original Message -----
> From: "Per Nyfelt" <[EMAIL PROTECTED]>
> To: "jBoss" <[EMAIL PROTECTED]>
> Sent: Saturday, November 25, 2000 4:24 PM
> Subject: RE: [jBoss-User] Interbase+jboss problems
>
> I recommend MySQL (www.mysql.com) for a relational database -it has binaries
> for all major OS's and is very easy to configure and scales well. For an
> OODBMS I recommend Ozone (www.ozone-db.org).
>
> Best regards,
> Per Nyfelt
>
> > -----Original Message-----
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED]]On Behalf Of Kamen
> > Sent: Saturday, November 25, 2000 1:22 PM
> > To: jBoss
> > Subject: Re: [jBoss-User] Interbase+jboss problems
> >
> >
> > It's supposed be able to run on windows as well.
> > It very easy to get it running ot Linux, but as far as I know it's not so
> > trivial to get it runnning on w2k. I had the same problem as you and a few
> > weeks ago I received an e-mail on this mailing list that somebody has
> > managed to get it running (on w2k), but I never bothered to try again.
> > Try to find that e-mail and use it as an instalation quide :)
> > Best regards,
> > Kamen.
> > ----- Original Message -----
> > From: "Torsten Terp" <[EMAIL PROTECTED]>
> > To: "jBoss" <[EMAIL PROTECTED]>
> > Sent: Saturday, November 25, 2000 12:03 PM
> > Subject: SV: [jBoss-User] Interbase+jboss problems
> >
> >
> > >
> > > Hi,
> > >
> > > Thanks... but isnt PostreSQL a Linux solution??
> > >
> > > I need to run it on win2k!
> > >
> > > ^torsten
> > >
> > > > -----Oprindelig meddelelse-----
> > > > Fra: [EMAIL PROTECTED]
> > > > [mailto:[EMAIL PROTECTED]]P� vegne af Kamen
> > > > Sendt: 25. november 2000 12:50
> > > > Til: jBoss
> > > > Emne: Re: [jBoss-User] Interbase+jboss problems
> > > >
> > > >
> > > > Hi,
> > > > Have you considered PostreSQL as an option?
> > > > It's quite sophisticated - has a more object based approach to
> > > > representing
> > > > the data, supports transactions and is open source.
> > > > Hope this might help :)
> > > > Regards,
> > > > Kamen
> > > > ----- Original Message -----
> > > > From: "Torsten Terp" <[EMAIL PROTECTED]>
> > > > To: "jBoss" <[EMAIL PROTECTED]>
> > > > Sent: Saturday, November 25, 2000 11:45 AM
> > > > Subject: SV: [jBoss-User] Interbase+jboss problems
> > > >
> > > >
> > > > > Hi
> > > > >
> > > > > Thanks for the advice!! I started looking at InterBase because I
> > thought
> > > > > it was one of the best opensource DBMSs out there (could still
> > > > be that of
> > > > > course :-)
> > > > >
> > > > > What did you do then? Did you turn to a comercial DBMS or
> > did you find
> > > > some
> > > > > other opensource that works better (and of course isnt too slow)
> > > > >
> > > > > Does anybody have an oppion on which to choose???
> > > > >
> > > > > Thanks...
> > > > >
> > > > > ^torsten
> > > > >
> > > > >
> > > > > > -----Oprindelig meddelelse-----
> > > > > > Fra: [EMAIL PROTECTED]
> > > > > > [mailto:[EMAIL PROTECTED]]Pa vegne af Tobias Frech
> > > > > > Sendt: 25. november 2000 09:36
> > > > > > Til: jBoss
> > > > > > Emne: Re: [jBoss-User] Interbase+jboss problems
> > > > > >
> > > > > >
> > > > > > Hi Torsten!
> > > > > > I won't answer your question, sorry. But I would like to warn
> > > > you, that
> > > > > > we had some major problems with the supplied JDBC driver for
> > > > Interbase.
> > > > > > It behaved _different_ than the console and did not understand all
> > the
> > > > > > needed syntax ! Also you have to be very careful with
> > Interbase with
> > > > > > such names like "User" or "Password" (keywords) for tables or
> > fields.
> > > > > > Interbase seems not be able to detect, when this is a keyword
> > > > and when a
> > > > > > name.
> > > > > >
> > > > > > Just my $.02
> > > > > >
> > > > > > Tobias
> > > > > >
> > > > > > Torsten Terp wrote:
> > > > > > >
> > > > > > > Hi,
> > > > > > >
> > > > > > > I have configured jboss to use interbase as a datasource like it
> > is
> > > > > > > described in
> > > > > > > the prelimanary jBoss 2.0 manual. When I start jboss i get the
> > > > following
> > > > > > > error:
> > > > > > >
> > > > > > > [Default] Error starting service
> > > > > > > 'DefaultDomain:name=InterBaseDB,service=XADataSource':
> > > > > > > javax.management.RuntimeErrorException: Error thrown in
> > operation
> > > > start
> > > > > > >
> > > > > > > From jboss.properties:
> > > > > > >
> > > > > > >
> > > > > > jdbc.drivers=org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDri
> > > > > > ver,interb
> > > > > > > ase.interclient.Driver
> > > > > > >
> > > > > > > From jboss.conf:
> > > > > > >
> > > > > > > <MLET CODE="org.jboss.jdbc.XADataSourceLoader"
> > ARCHIVE="jboss.jar,
> > > > > > > interclient-core.jar" CODEBASE="../../lib/ext/">
> > > > > > > <ARG TYPE="java.lang.String" VALUE="InterBaseDB">
> > > > > > > <ARG TYPE="java.lang.String"
> > > > > > > VALUE="org.jboss.minerva.xa.XADataSourceImpl">
> > > > > > > </MLET>
> > > > > > >
> > > > > > > From jboss.jcml:
> > > > > > >
> > > > > > > <mbean
> > > > name="DefaultDomain:service=XADataSource,name=InterBaseDB">
> > > > > > > <attribute name="Properties"></attribute>
> > > > > > > <attribute
> > > > > > > name="URL">jdbc:interbase://localhost/e:/emp.gdb</attribute>
> > > > > > > <attribute name="GCMinIdleTime">1200000</attribute>
> > > > > > > <attribute name="JDBCUser">SYSDBA</attribute>
> > > > > > > <attribute name="MaxSize">0</attribute>
> > > > > > > <attribute name="Password">masterkey</attribute>
> > > > > > > <attribute name="GCEnabled">false</attribute>
> > > > > > > <attribute name="InvalidateOnError">false</attribute>
> > > > > > > <attribute name="TimestampUsed">false</attribute>
> > > > > > > <attribute name="Blocking">true</attribute>
> > > > > > > <attribute name="GCInterval">120000</attribute>
> > > > > > > <attribute name="IdleTimeout">1800000</attribute>
> > > > > > > <attribute name="IdleTimeoutEnabled">false</attribute>
> > > > > > > <attribute name="LoggingEnabled">false</attribute>
> > > > > > > <attribute name="MaxIdleTimeoutPercent">1.0</attribute>
> > > > > > > <attribute name="MinSize">0</attribute>
> > > > > > > </mbean>
> > > > > > >
> > > > > > > When starting the driver loads fine:
> > > > > > >
> > > > > > > ...
> > > > > > > Classpath extension] Initialized
> > > > > > > JDBC] Loaded JDBC-driver:org.hsql.jdbcDriver
> > > > > > > JDBC] Loaded JDBC-driver:org.enhydra.instantdb.jdbc.idbDriver
> > > > > > > JDBC] Loaded JDBC-driver:interbase.interclient.Driver
> > > > > > > Webserver] Initializing
> > > > > > > Webserver] Initialized
> > > > > > > ...
> > > > > > >
> > > > > > > But when InterBase should start this happens:
> > > > > > >
> > > > > > > [InterBaseDB] Starting
> > > > > > > [InterBaseDB] XA Connection pool InterBaseDB bound to
> > > > java:/InterBaseDB
> > > > > > > [Default] Error starting service
> > > > > > > 'DefaultDomain:name=InterBaseDB,service=XADataSource':
> > > > > > > javax.management.RuntimeErrorException: Error thrown in
> > operation
> > > > start
> > > > > > >
> > > > > > > Does anybody know whats wrong???????
> > > > > > >
> > > > > > > Thanks in advance...
> > > > > > >
> > > > > > > ^terp
> > > > > > >
> > > > > > > --
> > > > > > > --------------------------------------------------------------
> > > > > > > To subscribe: [EMAIL PROTECTED]
> > > > > > > To unsubscribe: [EMAIL PROTECTED]
> > > > > > > Problems?: [EMAIL PROTECTED]
> > > > > >
> > > > > >
> > > > > > --
> > > > > > --------------------------------------------------------------
> > > > > > To subscribe: [EMAIL PROTECTED]
> > > > > > To unsubscribe: [EMAIL PROTECTED]
> > > > > > Problems?: [EMAIL PROTECTED]
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > > --
> > > > > --------------------------------------------------------------
> > > > > To subscribe: [EMAIL PROTECTED]
> > > > > To unsubscribe: [EMAIL PROTECTED]
> > > > > Problems?: [EMAIL PROTECTED]
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > > > --
> > > > --------------------------------------------------------------
> > > > To subscribe: [EMAIL PROTECTED]
> > > > To unsubscribe: [EMAIL PROTECTED]
> > > > Problems?: [EMAIL PROTECTED]
> > > >
> > > >
> > >
> > >
> > >
> > > --
> > > --------------------------------------------------------------
> > > To subscribe: [EMAIL PROTECTED]
> > > To unsubscribe: [EMAIL PROTECTED]
> > > Problems?: [EMAIL PROTECTED]
> > >
> > >
> >
> >
> >
> > --
> > --------------------------------------------------------------
> > To subscribe: [EMAIL PROTECTED]
> > To unsubscribe: [EMAIL PROTECTED]
> > Problems?: [EMAIL PROTECTED]
> >
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Problems?: [EMAIL PROTECTED]
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Problems?: [EMAIL PROTECTED]
--
Phil Surette
email: [EMAIL PROTECTED], [EMAIL PROTECTED]
if those fail: [EMAIL PROTECTED]
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
