RE: Database for WebSphere5
- From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 23 Mar 2004 11:14:03 -0500
Peter,
You are talking about the SESSIONS table, correct?
I created two schema's in my Websphere application - one for the SESSIONS
table and one for the application data. Websphere connects twice to the
same Oracle database to store all the information it needs.
I think optionally, Websphere can store this session info in it's own cache
- it may not need a database to do this.
At any rate, you can use the same database where your data is stored to do
this.
hope this helps.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
From: Peter Barnett [mailto:regdba@xxxxxxxxx]
Sent: Tuesday, March 23, 2004 10:19 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Database for WebSphere5
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@xxxxxxxxxxx
__________________________________
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
