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.
