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:BIST1:oaxapr/oaxapr");
> it should work this way...
> conn =
> DriverManager.getConnection("jdbc:oracle:[EMAIL PROTECTED]:1521:BIST1",
> "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:BIST1: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
