Here is a copy of the little test program I'm trying to get running so that I can make sure that I know how to do this:
<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="" %>
<!-- This is Mark's JSP for loging in. -->
<%-- This is the java code for the JSP. --%>
<%
String commodity = request.getParameter("select_1"
.trim();
String strategy = request.getParameter("select_2"
.trim();
String contractYear = request.getParameter("ContractYear"
.trim();
%>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<form name="form1" method="post" action="">
<p align="center"><font size="5">We are watching strategy "<%= strategy %>" for <%= commodity %></font></p>
<p align="center"><font size="5">in the year <%= contractYear %></font></p>
</form>
<%
String sqlTestForTable = "SELECT Name, type FROM MSysObjects where MSysObjects.Name = \"Table1\" and type = 1";
%>
<%= sqlTestForTable %>
<%
try {
String driverName = "sun.jdbc.odbc.JdbcOdbcDriver";
String connectionURL = "jdbc
dbc:Commodities";
String userName = null;
String password = null;
Class.forName(driverName);
out.println("<br>Before conn <br>"
;
Connection connection = DriverManager.getConnection(connectionURL, userName, password);
out.println("After conn<br>"
;
Statement statement = connection.createStatement();
out.println("Before exec<br>"
;
statement.execute(sqlTestForTable);
out.println("After Exec<br>"
;
ResultSet rs = statement.getResultSet();
ResultSetMetaData rsmd = rs.getMetaData();
int numCol = rsmd.getColumnCount();
out.println("<tr>"
;
if (rs.next())
{
System.out.println("Table found<br>"
;
}
else
{
System.out.println("Table not found<br>"
;
}
rs.close();
statement.close();
connection.close();
}
catch (Exception e ) {
out.println("<br> had this problem: " + e.getMessage());
e.printStackTrace();
}
%>
</table>
</body>
</html>
<p> </p>
</body>
</html>
Does this explain what I'm doing wrong? By the way, I'm logged in as the system administrator for my system, so I would have thought that that would give me the permissions I need. Again, thanks for your help.
