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
