I deleted the project, created a new project.
Now it has Error: Invalid Oracle URL specified
I have spent 2 days trying to get this working.
I would appreciate any assistance.
Services:
Database Driver: oracle.jdbc.driver.OracleDriver
Driver
<%@ page import="java.sql.*" %>
<%@taglib prefix="sql" uri="
http://java.sun.com/jsp/jstl/sql"%>
<%--
Document : index
Created on : Mar 10, 2010, 4:26:09 PM
Author : Administrator
--%>
<%_at_page contentType="text/html" pageEncoding="UTF-8"%>
<html>
<body>
<%
Connection con = null;
Statement st;
ResultSet rs;
String sql = "";
String ProjectID = "";
//ProjectID= Integer.parseInt(request.getParameter("ProjectID"));
//sql = "SELECT * FROM Project where ProjectID = "+ ProjectID;
sql = "SELECT * FROM Project";
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin_at_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>
[Message sent by forum member 'cliveswan' (clive.swan_at_ntlworld.com)]
http://forums.java.net/jive/thread.jspa?messageID=391229