Thank you. Thank you.
It worked. thanks a lot.
Ramesh Kadirisani.
"It, Cockpit (CAP, Contractor)" wrote:
>
> Dear Ramesh,
> You are missing ":" next to thin...
> If you give as follows it will work....
>
> try this...
>
> conn =
>
> DriverManager.getConnection("jdbc:oracle:[EMAIL PROTECTED]:1521:BIST
> 1",
> "oaxapr","oaxapr");
>
> Yogaraj
>
> -----Original Message-----
> From: Ramesh Kadirisani [mailto:[EMAIL PROTECTED]]
> 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
>
> "THIS E-MAIL MESSAGE ALONG WITH ANY ATTACHMENTS IS INTENDED ONLY FOR THE
> ADDRESSEE and may contain confidential and privileged information.
> If the reader of this message is not the intended recipient,
> you are notified that any dissemination, distribution or copy of this
> communication is strictly Prohibited.
> If you have received this message by error, please notify us
> immediately, return the original mail to the sender and delete the
> message from your system."
>
> ===========================================================================
> 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
