RE: TOMCAT and ORACLE

[Christopher Kirk]

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 <[EMAIL PROTECTED]>

>Reply-To: [EMAIL PROTECTED]

>To: "'[EMAIL PROTECTED] '" <[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.



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