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
