Hi Ramesh..
In your connection line,
conn=DriverManager.getConnection("jdbc:oracle:[EMAIL PROTECTED]:1521
:BIST1", "oaxapr","oaxapr");
Pls note the following things..
1)bis6.xxx.xxxxx.xx.xx: This should be your Oracle Server host name/IP
address.
Oracle Listener should run at 1521 port only. Other wise change 1521 to the
given port for Oracle server)
2)If you are using thin driver of Oracle, then you must specify the ORACLE
SID at the place of BIST1, not TNS name.
Find out your Oracle SID and replace BIST1 with Oracle SID name.If you do the above two things, it should work. Please get back to me, if it does not work.. with rgds, Rao -----Original Message----- From: A mailing list about Java Server Pages specification and reference [mailto:[EMAIL PROTECTED]]On Behalf Of Ramesh Kadirisani Sent: Thursday, July 11, 2002 8:27 PM To: [EMAIL PROTECTED] Subject: Re: help needed(java.sql.SQLException: Invalid Oracle URL specified) Hi Ben, thanks for the response. i tried the way you suggested. no luck. is there anything else i have to check? thanks, Ramesh Kadirisani. Ben Steiner wrote: > > instead of > conn = > DriverManager.getConnection("jdbc:oracle:[EMAIL PROTECTED]:1521:BIST 1:oaxapr/oaxapr"); > it should work this way... > conn = > DriverManager.getConnection("jdbc:oracle:[EMAIL PROTECTED]:1521:BIST 1", > "oaxapr","oaxapr"); > > Ben > > >>> [EMAIL PROTECTED] 07/11/02 07:51AM >>> > hi, > i am trying to use oracle jdbc driver in my jsp program to connect to > oracle database and i am getting the following error. > > java.sql.SQLException: Invalid Oracle URL specified > > The following is part of my coding: > > <%@ page import="java.sql.*,java.io.*, oracle.jdbc.driver.*"%> > <% > Connection conn; > try > { > Class.forName ("oracle.jdbc.driver.OracleDriver"); > conn = > DriverManager.getConnection("jdbc:oracle:[EMAIL PROTECTED]:1521:BIST 1:oaxapr/oaxapr"); > ................. > %> > > The following is the set up in my work environment: > > Server1: windows 2000, Webserver, ServletExec, JRE, Oracle client > Server2: windows 2000, Oracle database > tnsnames.ora on server1 has the service name BIST1 that refers to > Oracle database on server2. > i downloaded classes12.zip from oracle site into lib of JRE on > server1. > > Could somebody please let me know.... > the correct syntax to specify the Oracle URL? > if the syntax whatever i used is correct, the reason for getting the > above error? > the way i am using the oracle jdbc drivers is correct or not? > > thanks in advance, > Ramesh Kadirisani. > > =========================================================================== > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > JSP-INTEREST". > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST > DIGEST". > Some relevant FAQs on JSP/Servlets can be found at: > > http://archives.java.sun.com/jsp-interest.html > http://java.sun.com/products/jsp/faq.html > http://www.esperanto.org.nz/jsp/jspfaq.jsp > http://www.jguru.com/faq/index.jsp > http://www.jspinsider.com > > =========================================================================== > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". > Some relevant FAQs on JSP/Servlets can be found at: > > http://archives.java.sun.com/jsp-interest.html > http://java.sun.com/products/jsp/faq.html > http://www.esperanto.org.nz/jsp/jspfaq.jsp > http://www.jguru.com/faq/index.jsp > http://www.jspinsider.com =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
**************************Disclaimer************************************ Information contained in this E-MAIL being proprietary to Wipro Limited is 'privileged' and 'confidential' and intended for use only by the individual or entity to which it is addressed. You are notified that any use, copying or dissemination of the information contained in the E-MAIL in any manner whatsoever is strictly prohibited. *****************************************************************************
