I've had luck using Postgres and Oracle. Postgres is fairly easy to get
running and only requires a minimal amount of work to migrate to Oracle if
you need to. The current version of Oracle 8 for Linux doesn't work on Red
Hat 6 out of the box. We had to back out to 5.2 to get it to work. (some bad
linking problems).
Postgres drivers are fairly easy to get working so if you're doing a small
project that's probably the way to go. Both Oracle and Postgres have type 4
drivers. I strongly recommend the Type 4 drivers for Oracle (use
classes111.zip).
Performance wise, you're definitely going to get better performance with
Oracle especially under heavy load (and with many database connections).
Any database with JDBC type 4 drivers will work. If the databases support
ODBC then you can also use some sort of ODBC:JDBC bridge, but I wouldn't
recommend it.
Philip S. Constantinou
-----Original Message-----
From: A mailing list about Java Server Pages specification and
reference [mailto:[EMAIL PROTECTED]] On Behalf Of Craig R.
McClanahan
Sent: Monday, June 14, 1999 8:55 AM
To: [EMAIL PROTECTED]
Subject: Re: Need opinions: JDBC capable database for Linux
Tod Liebeck wrote:
> Any opinions on which database (Oracle, DB2, Postgre, Informix, Sybase,
> etc) would be best for doing some JSP+database expirementation on a Red
> Hat 6 Intel Linux box? I'm just looking for something to play with...
> my biggest priority is that it not be an absolute nightmare to install
> and get working with JSP. Also, if anyone knows, which of these
> databases support JDBC on Linux.
>
> Thanks
> --Tod Liebeck, [EMAIL PROTECTED]
>
>
===========================================================================
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
body
> of the message "signoff JSP-INTEREST". For general help, send email to
> [EMAIL PROTECTED] and include in the body of the message "help".
I have had personal experience with using Oracle, and MySQL databases under
Linux. I've got colleagues that use Postgres under it as well). None of
these databases are particularly hard to get set up. As long as you get
your
class paths set up to include the JDBC drivers, it's pretty easy to use them
from servlets and JSP pages too.
The new JSWDK-1.0-EA release also works under Linux -- I've been using it
(talking with an Oracle database using the Oracle thin driver) with
Blackdown's pre-v2 Java2 JDK.
Craig McClanahan
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff JSP-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff JSP-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
