Use 2 separate data source to connec to 2 different DB
Ionel Condor
<cionel@RO-PLANET To: [EMAIL PROTECTED]
.RO> cc:
Sent by: A Subject: JSP & DB2
mailing list
about Java Server
Pages
specification and
reference
<JSP-INTEREST@jav
a.sun.com>
07/31/00 04:53 PM
Please respond to
A mailing list
about Java Server
Pages
specification and
reference
Hi,
If someone uses IBM DB2 as his DBMS for JSP here is a question:
I have two databases, each with a few tables.
Somewhere in a bean I write a query which must use a table from DB1
and a table from DB2 is a select statement.
Does anyone know how to configure DB2 (grant statements I suppose) in
order to succeed... I mean one of the DB to see also the tables from the
other DB.
I have done the same thing in Oracle by allowing rights on a scheme
but I don't know how can be done in DB2. Please give me an example.
Thanks,
Ionel Condor.
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
Kian Lee, Ooi
e-Business Sdn. Bhd.
Tel: (604) 890-8143 Ext: 166
Fax: (604) 890-1771
E-Mail: [EMAIL PROTECTED]
---
Disclaimer:
Confidential information may be contained in the e-mail and any files
transmitted with it ('Message'). If you are not the addressee indicated in
this Message (or responsible for the delivery of this Message to such
person), you are hereby notified that any dissemination, distribution,
printing or copying of this Message or any part thereof is strictly
prohibited. In such a case, you should delete this Message immediately and
advise the sender by return e-mail. Opinions, conclusions and other
information in this Message that do not relate to the official business of
e-BX nor any of its related companies shall be understood as neither given
nor endorsed by e-BX nor any of its related companies.
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
