I have created a JSP which queries an access database. Unfortunately, an
error comes up when the JSP is running. This error comes up in the browser
and says something like this: HTTP 500 Intenale Service Error.
I don't really know what's the problem. I hope somebody can help me.
Because of that, I'm right now stuck.
Please don't hesitate to contact me.
Thank you
Rafael
Here is the JSP:
<html>
<head>
<title>Searching.....</title>
</head>
<body bgcolor="white">
<%@ page language="java" import="java.sql.*", import="java.util.*",
import="java.io.*" %>
<jsp:useBean id="DbBean" scope="session" class="sessions.DBinquire" />
<%! String search; %>
<%! String search_1; %>
<%! String[] data; %>
<%! String result_data; %>
<%! int column_count; %>
<center>
<h2> Searching Result </h2>
<table width=80% bgcolor=lightblue border=1>
<%
String input = null;
String search_content = " from JVSApp";
search = "SELECT * ";
search_1 = "SELECT ";
search = search + search_content;
DbBean.query(search);
column_count = DbBean.colCount();
data = DbBean.retrieveColumn();
if (column_count > 0)
{
%>
<tr>
<%
for(int i=0; i<column_count; i++)
{
if (i < column_count - 1)
{
search_1 = search_1 + data[i] + ",";
}
else
search_1 = search_1 + data[i] +
search_content;
System.out.println(search_1);
%>
<th>
<%=data[i] %>
</th>
<%
}
%>
</tr>
<%
while(DbBean.nextdata())
{
%>
<tr>
<%
for(int i=0; i<column_count; i++)
{
result_data=DbBean.getdata(data[i]);
%>
<td>
<%=result_data %>
</td>
<%
}
%>
</tr>
<%
}
}
%>
<font color=blue>
<h5>SQL STATEMENT: <%=search_1 %><h5>
</font>
</table>
</center>
</body>
</html>