Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Database for WebSphere5

Re: Database for WebSphere5

From: Mladen Gogala <mladen_at_wangtrading.com>
Date: Tue, 23 Mar 2004 10:59:59 -0500
Message-ID: <20040323155959.GA1230@mladen.wangtrading.com>


Even if there is DB2 (UDB) CPU licensing, it's still significantly cheaper then Oracle. For two small tables, DB2 will perform more then adequately. In addition to that, the last time I checked, IBM had some bundling (WebSphere + runtime DB2). As WebSphere is an application server, you should still be able to use EJB, servlets and Oracle's thin JDBC driver to connect to an oracle database. I'm not quite sure about being able to use OCI JDBC driver and utilize Oracle*Net connections. You'll have to contact IBM for that.

On 03/23/2004 10:19:18 AM, Peter Barnett wrote:
> We just upgraded to WebSphere5. During user
> acceptance testing I discovered that the WAS schema
> has exactly TWO tables. Investigating further, I
> found out that these two tables are dynamic. When
> someone logs in these tables are populated and when
> the user logs out the data is deleted.
>
> Out of the box, WAS will install a default DB2
> database on the same server as the application server.
> Even though I am an Oracle bigot, it seems silly to
> pay for cpu licensing for two small tables. I am
> leaning toward asking our middle-ware administrators
> to use the default install and save the cpu licensing
> expense for Oracle.
>
> Does anyone have any experience with this
> configuration? Especially, hidden gotchas, like DB2
> cpu licensing?
>
> =====
> Pete Barnett
> Lead Database Administrator
> The Regence Group
> pnbarne_at_regence.com
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Finance Tax Center - File online. File on time.
> http://taxes.yahoo.com/filing.html
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Tue Mar 23 2004 - 11:17:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US