I am running JRun under Netscape Enterprise server in a Windows NT4.0
environment. I have an access database that I am attempting to connect to
for testing purposes before sending the application to our production
servers which are running Oracle. I can run the jsp once and it will
retrieve the information from the database and display it on the browser.
When I hit refresh, the good Dr. comes and shuts down the javaw.exe and I
get a connector Proxy error and have to restart JRun.
I am new to both Java and jsp, so please try not to laugh too hard when
viewing my code below. I would appreciate any helpful tips or suggestions
regarding this problem.
TIA
Jeff Steiner
<%@ page language="java" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<html>
<body bgcolor="#ffffff">
<br /><br />
<%
// Set default Connection and sql variables
Connection dbCon;
String sql;
// Create the sql statement used to query the database.
sql = "SELECT Content,DateModified,Active,ID FROM HotTopics";
// Try to make a connection with the database through jdbc/odbc
try {
// Name the driver and then the datasource
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
dbCon = DriverManager.getConnection("jdbc:odbc:DealerServices");
// Try to execute the query from above
try {
// Create the statement and recordset
Statement s = dbCon.createStatement();
ResultSet rs = s.executeQuery(sql);
// Thisis a while loop that will iterate through the
// return and display everything to the user.
while (rs.next()) {
%>
<%= rs.getString("Content") %>
<%
}
}
// This catch is used if the sql query was bad when it
executed.
catch (SQLException e) {
//Catch SQL Exceptions here
}
}
// This catch is done if you cannot connect to thedatabase.
catch (ClassNotFoundException e) {
//Catch error here
}
// This catch is done if the sql is bad.
// Might be redundant.
catch (SQLException e) {
//Catch SQL Error here
}
%>
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
FAQs on JSP can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
