NetBeans Forums

cliveswan · Joined: 30 Nov 2009 Posts: 4

Hi,

I have spent 2 days trying to get this working. Going round in circles.
I would really appreciate some assistance!!

Error: Invalid Oracle URL specified

I added the oracle thin driver
Services> Database> Driver> oracle.jdbc.driver.OracleDriver

<%@ page import="java.sql.*" %>
<%@taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>

<html>
<body>

<%
Connection con = null;
Statement st;
ResultSet rs;
String sql = "";
String ProjectID = "";

sql = "SELECT * FROM Project";

try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin@localhost:1521:orcl","test","test");
st = con.createStatement();
rs = st.executeQuery(sql);
%>
<table border=2>
<%
while(rs.next())
{
%> <tr>
<td><%=rs.getString("ProjID")%></td>
<td><%=rs.getString("SubID")%></td>
<td><%=rs.getString("AsID")%></td>
<td><%=rs.getString("Name")%></td>
</tr>

<% } %>
</table>
<%
rs.close();
con.close();
}

catch(Exception ex)
{
out.print(ex.getMessage());
}
%>
</body>
</html>

cliveswan · Joined: 30 Nov 2009 Posts: 4

Hi

Eventually noticed it was missing a :
con = DriverManager.getConnection("jdbc:oracle:thin@localhost:1521:orcl","test","test");

Should be
("jdbc:oracle:thin:@localhost:1521:orcl","test","test");