hi,
thanx for giving me the guidance.
myhost is actually the machine name of mine..
>From: Christopher Kirk <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
>Subject: RE: TOMCAT and ORACLE
>Date: Wed, 2 May 2001 11:15:11 +0100
>MIME-Version: 1.0
>Received: from [64.208.42.41] by hotmail.com (3.2) with ESMTP id
>MHotMailBCB929EF00424004310840D02A2907300; Wed May 02 03:18:23 2001
>Received: (qmail 13251 invoked by uid 500); 2 May 2001 10:15:35 -0000
>Received: (qmail 13214 invoked from network); 2 May 2001 10:15:31 -0000
>Received: from smtp.gtl.com (HELO ?194.203.31.196?) (194.203.31.196) by
>h31.sny.collab.net with SMTP; 2 May 2001 10:15:31 -0000
>From tomcat-user-return-33337-siewlinglim Wed May 02 03:18:27 2001
>Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
>Precedence: bulk
>list-help: <mailto:[EMAIL PROTECTED]>
>list-unsubscribe: <mailto:[EMAIL PROTECTED]>
>list-post: <mailto:[EMAIL PROTECTED]>
>Delivered-To: mailing list [EMAIL PROTECTED]
>Message-ID: <[EMAIL PROTECTED]>
>X-Mailer: Internet Mail Service (5.5.2650.21)
>X-Spam-Rating: h31.sny.collab.net 1.6.2 0/1000/N
>
>From my experience there are 2 things that are worth checking.
>
>
>1) Make sure that the database has an instance named orcl in the TNA lookup
>(test the connection using Oracle tools, Net8 assistent will do).
>
>2) If you are using 8i, then make sure that orcl is not a Service Name..
>people often get SIDs and Service Names confused.
>
>- Chris.
>
>
>(Also, does 'myhost' actually exist.. or did you just change that when you
>posted it so we didn't know your machine name?)
>
>-----Original Message-----
>From: Lim SiewLing [mailto:[EMAIL PROTECTED]]
>Sent: 02 May 2001 11:07
>To: [EMAIL PROTECTED]
>Subject: RE: TOMCAT and ORACLE
>
>
>
>The connection string that I used is as follow:
>
>Class.forName("oracle.jdbc.driver.OracleDriver);
>
>Connection connection =
>DriverManager.getConnection("jdbc:oracle:thin:@myhost:1521:orcl");
>
>where: myhost is the PC Name where the oracle database is resided
>
>Josephine
>
>
>
> >From: John Towell
> >Reply-To: [EMAIL PROTECTED]
> >To: "'[EMAIL PROTECTED] '"
> >Subject: RE: TOMCAT and ORACLE
> >Date: Tue, 1 May 2001 14:34:00 -0500
> >MIME-Version: 1.0
> >Received: from [64.208.42.41] by hotmail.com (3.2) with ESMTP id
>MHotMailBCB85AA400C0400438AC40D02A29080E0; Tue May 01 12:33:56 2001
> >Received: (qmail 90123 invoked by uid 500); 1 May 2001 19:33:45 -0000
> >Received: (qmail 90094 invoked from network); 1 May 2001 19:33:43 -0000
> >Received: from cscexchange.cc.edu (140.104.1.155) by h31.sny.collab.net
>with SMTP; 1 May 2001 19:33:43 -0000
> >Received: by cscexchange.cc.edu with Internet Mail Service
>(5.5.2653.19)id
>; Tue, 1 May 2001 14:34:05 -0500
> >From tomcat-user-return-33265-siewlinglim Tue May 01 12:35:14 2001
> >Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
> >Precedence: bulk
> >list-help:
> >list-unsubscribe:
> >list-post:
> >Delivered-To: mailing list [EMAIL PROTECTED]
> >Message-ID: <[EMAIL PROTECTED]>
> >X-Mailer: Internet Mail Service (5.5.2653.19)
> >X-Spam-Rating: h31.sny.collab.net 1.6.2 0/1000/N
> >
> >Hi Lim
> >
> >It would help to see the connection string you're using ...
> >
> >John
> >
> >-----Original Message-----
> >From: Lim SiewLing
> >To: [EMAIL PROTECTED]
> >Sent: 5/1/01 2:22 PM
> >Subject: TOMCAT and ORACLE
> >
> >Hi,
> >I'm currently engaged on a school project which uses Tomcat3.2.1, ORACLE
> >and Java to develop an intranet application.
> >My program run smoothly when retrieving data in Access database but the
> >data could not be retrieve using ORACLE. The error message that I get is
> >"The Network adapter could not establish a connection".
> >Could anyone please help me by telling me what is the problems of
> >connecting the Tomcat to the ORACLE? I had start the listener and the
> >ORACLE database but still got the same error.
> >Do I need to configure the server.xml or web.xml file? Please help
> >me....Your help will be very much appreciated.
> >
> >Regards,
> >Josephine
> >
> > _____
> >
> >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
> > .
> >
> >
>
> _____
>
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
><http://www.hotmail.com> .
>
>
>
>
>
>
>-----------------------------------------------------------------
>This e-mail is intended only for the addressee(s) named above. It
>may contain confidential or privileged information and if you are
>not the intended addressee you are not authorized to disclose,
>copy, distribute or place any reliance on it whatsoever and we
>request that you inform our postmaster ([EMAIL PROTECTED]) that
>you have received this e-mail. Any attachment(s) to this message
>has been checked for viruses, but please rely on your own virus
>checker and procedures. If you contact us by e-mail, we will
>store your name and address to facilitate communications.
>-----------------------------------------------------------------
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
