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]
