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
