RE: TOMCAT and ORACLE

[Christopher Kirk]

Your problem is the service name, the string you used was meant to use a SID.. try the following instead, it uses the service name as specified from your TNS.

 

 

jdbc:oracle:thin:@(description=(address=(host=myhost)(protocol=tcp)(port=1521))(connect_data=(service_name=oracle))))

 

-----Original Message-----
From: Lim SiewLing [mailto:[EMAIL PROTECTED]]
Sent: 02 May 2001 11:14
To: [EMAIL PROTECTED]
Subject: RE: TOMCAT and ORACLE

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.



-----------------------------------------------------------------
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.
-----------------------------------------------------------------