The contents of my TnsName.ora is as follow:
HRPDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(PORT = 1521)(HOST = myhost))
)
(CONNECT_DATA =
(SERVICE_NAME = oracle)
)
)
beside, I could connect to the database using SQL+.
Regards,
Josephine
>From: "Herrick, Chuck" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
>Subject: RE: TOMCAT and ORACLE
>Date: Tue, 1 May 2001 14:40:53 -0500
>MIME-Version: 1.0
>Received: from [64.208.42.41] by hotmail.com (3.2) with ESMTP id MHotMailBCB8622100324004324F40D02A290EFB0; Tue May 01 13:05:53 2001
>Received: (qmail 44949 invoked by uid 500); 1 May 2001 20:05:40 -0000
>Received: (qmail 44931 invoked from network); 1 May 2001 20:05:39 -0000
>Received: from hqfirex1.agedwards.com (192.52.184.62) by h31.sny.collab.net with SMTP; 1 May 2001 20:05:39 -0000
>Received: from hqmswpn1.agedwards.com by hqfirex1.agedwards.com via smtpd (for h31.sny.collab.net [64.208.42.41]) with SMTP; 1 May 2001 20:05:43 UT
>Received: from hqhampn2.agedwards.com (hqhampn2.agedwards.com) by hqmswpn1.agedwards.com (Content Technologies SMTPRS 4.2.1) with ESMTP id <[EMAIL PROTECTED]>for <[EMAIL PROTECTED]>; Tue, 1 May 2001 15:00:06 -0500
>Received: from hqexchn2.agedwards.com (unverified) by hqhampn2.agedwards.com (Content Technologies SMTPRS 2.0.15) with ESMTP id <[EMAIL PROTECTED]>for <[EMAIL PROTECTED]>; Tue, 01 May 2001 14:35:27 -0500
>Received: by hqexchn2.agedwards.com with Internet Mail Service (5.5.2650.21)id
; Tue, 1 May 2001 14:35:27 -0500
>From tomcat-user-return-33269-siewlinglim Tue May 01 13:07:19 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.2650.21)
>X-Spam-Rating: h31.sny.collab.net 1.6.2 0/1000/N
>
>It would also help to know if you've been able to connect to your Oracle
>using SQL+. And, the contents of your TNSNames.ora file.
>
> > -----Original Message-----
> > From: John Towell [SMTP:[EMAIL PROTECTED]]
> > Sent: Tuesday, May 01, 2001 2:34 PM
> > To: '[EMAIL PROTECTED] '
> > Subject: RE: TOMCAT and ORACLE
> >
> > 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
> > .
> >
>
>
>***************************************************************************************
>WARNING: All e-mail sent to and from this address will be received or
>otherwise recorded by the A.G. Edwards corporate e-mail system and is
>subject to archival, monitoring or review by, and/or disclosure to,
>someone other than the recipient.
>***************************************************************************************
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
