you are correct. he is missing the ":" on the right side of 'thin'.
"jdbc:oracle:thin:@bis6.xxx.xxxxx.xx.xx:1521:BIST1"
Ben
>>> [EMAIL PROTECTED] 07/11/02 08:54AM >>>
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
