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