no. i use a resultset direct with the statement. but it can be done also with 2 connections appoint the databases, but in this case you will make the logic to get the results which is same value and not with sql. De:A mailing list about Java Server Pages specification and reference Para:[EMAIL PROTECTED] Cópia: Data:Fri, 21 Feb 2003 18:56:04 +0100 Assunto:Re: accessing multiple databases from the same jsp > where did you declare prod1 and prod2? did u create two different > getConnection for them? > Thanks > > -----Original Message----- > From: Jaime Marcondes [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 21, 2003 5:51 PM > To: [EMAIL PROTECTED] > Subject: Re: accessing multiple databases from the same jsp > > > in oracle we use > > select name, value > from customer.prod1 ct, sales.prod2 sl > where sl.CustomerID = sl.CustomerID > > where prod1 is the database server1 and prod2 is the database server2. we > make use of a common connection in a server who permits to share the > connection between the 2 databases. > > > > De:A mailing list about Java Server Pages specification and reference > > Para:[EMAIL PROTECTED] > > Cópia: > > Data:Fri, 21 Feb 2003 18:39:31 +0100 > > Assunto:Re: accessing multiple databases from the same jsp > > > > > I'm using Tomcat and I want to connect to Sybase and MS2000... > > when you say db1@dblink, is db1 the name of the connection? and what would > > dblink refer to? > > > > Thanks and waitng to hear from you > > > > -----Original Message----- > > From: Jaime Marcondes [mailto:[EMAIL PROTECTED]] > > Sent: Friday, February 21, 2003 5:20 PM > > To: [EMAIL PROTECTED] > > Subject: Re:accessing multiple databases from the same jsp > > > > > > yes. you can use 2 database connections, since you have the permission to > do > > that in the connection of database. > > > > do you use witch database ? > > with Oracle, you will use: > > select * from db1@dblink, db2@dblink > > where db1.id = db2.id > > > > > > > > De:A mailing list about Java Server Pages specification and reference > > > > Para:[EMAIL PROTECTED] > > > > Cópia: > > > > Data:Fri, 21 Feb 2003 16:35:41 +0100 > > > > Assunto:accessing multiple databases from the same jsp > > > > > > > > > Hi all, > > > I have data held in two remote databases, and I want to write a jsp page > > > that will return only the records that occur or repeated in the two > > > databases(tables). So, could I create two connections to two different > > > databases from the same page? If yes would I be able to run a query that > > > will run against both of these tables at the same time so I can apply > > > something like Select * from db1,db2 where db1.table.id=db2.table.id ? > > > > > > Is this possible, if not do you have any alternate solutions. > > > > > > Thanks > > > > > > > > > =========================================================================== > > > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > > JSP-INTEREST". > > > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST > > DIGEST". > > > > > > Some relevant archives, FAQs and Forums on JSPs can be found at: > > > > > > http://java.sun.com/products/jsp > > > http://archives.java.sun.com/jsp-interest.html > > > http://forums.java.sun.com > > > http://www.jspinsider.com > > > > > > Esta mensagem foi verificada pelo E-mail Protegido Terra. > > > Scan engine: VirusScan / Atualizado em 19/02/2003 / Versão: 1.3.13 > > > Proteja o seu e-mail Terra: http://www.emailprotegido.terra.com.br/ > > > > > > > > > > > > Jaime Marcondes - Desenvolvedor Delphi/Java > > Objetto Tecnologia em Informação Ltda. > > Av. Abrão João Francisco, 850 - Ap. 09 > > Itajaí/SC - 88304-101 > > Fone/Cel: 47 349-1538 / 47 9953-9783 > > > > > ==========================================================================To > > unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > JSP-INTEREST". > > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST > > DIGEST". > > > > Some relevant archives, FAQs and Forums on JSPs can be found at: > > > > http://java.sun.com/products/jsp > > http://archives.java.sun.com/jsp-interest.html > > http://forums.java.sun.com > > http://www.jspinsider.com > > > > > =========================================================================== > > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > JSP-INTEREST". > > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST > DIGEST". > > > > Some relevant archives, FAQs and Forums on JSPs can be found at: > > > > http://java.sun.com/products/jsp > > http://archives.java.sun.com/jsp-interest.html > > http://forums.java.sun.com > > http://www.jspinsider.com > > > > Esta mensagem foi verificada pelo E-mail Protegido Terra. > > Scan engine: VirusScan / Atualizado em 19/02/2003 / Versão: 1.3.13 > > Proteja o seu e-mail Terra: http://www.emailprotegido.terra.com.br/ > > > > > > > > > Jaime Marcondes - Desenvolvedor Delphi/Java > Objetto Tecnologia em Informação Ltda. > Av. Abrão João Francisco, 850 - Ap. 09 > Itajaí/SC - 88304-101 > Fone/Cel: 47 349-1538 / 47 9953-9783 > > ==========================================================================To > unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST > DIGEST". > > Some relevant archives, FAQs and Forums on JSPs can be found at: > > http://java.sun.com/products/jsp > http://archives.java.sun.com/jsp-interest.html > http://forums.java.sun.com > http://www.jspinsider.com > > =========================================================================== > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". > > Some relevant archives, FAQs and Forums on JSPs can be found at: > > http://java.sun.com/products/jsp > http://archives.java.sun.com/jsp-interest.html > http://forums.java.sun.com > http://www.jspinsider.com > > Esta mensagem foi verificada pelo E-mail Protegido Terra. > Scan engine: VirusScan / Atualizado em 19/02/2003 / Versão: 1.3.13 > Proteja o seu e-mail Terra: http://www.emailprotegido.terra.com.br/ > > > Jaime Marcondes - Desenvolvedor Delphi/Java Objetto Tecnologia em Informação Ltda. Av. Abrão João Francisco, 850 - Ap. 09 Itajaí/SC - 88304-101 Fone/Cel: 47 349-1538 / 47 9953-9783
==========================================================================To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant archives, FAQs and Forums on JSPs can be found at: http://java.sun.com/products/jsp http://archives.java.sun.com/jsp-interest.html http://forums.java.sun.com http://www.jspinsider.com