tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christopher Kirk <Christopher.K...@gtl.com>
Subject RE: TOMCAT and ORACLE
Date Wed, 02 May 2001 10:21:22 GMT
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=152
1))(connect_data=(service_name=oracle))))
 

-----Original Message-----
From: Lim SiewLing [mailto:siewlinglim@hotmail.com]
Sent: 02 May 2001 11:14
To: tomcat-user@jakarta.apache.org
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" 
>Reply-To: tomcat-user@jakarta.apache.org 
>To: "'tomcat-user@jakarta.apache.org'" 
>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 for
; 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
for ; 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 tomcat-user-help@jakarta.apache.org; run by ezmlm 
>Precedence: bulk 
>list-help: 
>list-unsubscribe: 
>list-post: 
>Delivered-To: mailing list tomcat-user@jakarta.apache.org 
>Message-Id: 
>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:jtowell@cscexchange.cc.edu] 
> > Sent: Tuesday, May 01, 2001 2:34 PM 
> > To: 'tomcat-user@jakarta.apache.org ' 
> > 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: tomcat-user@jakarta.apache.org 
> > 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
<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 (postmaster@gtl.com) 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.
-----------------------------------------------------------------

Mime
View raw message