Database problem med servlet
Vores problem er at det tilsyneladende ikke er muligt at komme i kontakt med DB via nedenstående kode. DB kaldet er testet ok i en alm. java app. Er der nogen der har et bud på hvad der kan være galt?import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;
public class TitleListServlet extends HttpServlet
{
public void init(ServletConfig config) throws ServletException
{
super.init(config);
}
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
{
doPost(request, response);
}
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
{
response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.println("<html>\n<body>\n<table border=\"1\" width=\"100%\">");
String search_string = request.getParameter("search_string");
Connection con = null;
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
System.err.println("Getting Connection!");
con =DriverManager.getConnection("jdbc:oracle:thin:@xx.xxx.xxx.xxx:xxxx:x","x","x");
if ( con != null )
{
System.err.println("Got Connection!");
Statement statement = con.createStatement();
ResultSet rs = statement.executeQuery("SELECT * " + "FROM person WHERE navn = '" + search_string + "'");
while ( rs.next() )
{
out.println("<tr>");
out.println("<td>" + rs.getString("navn") + "</td>");
out.println("<td>" + rs.getString("email") + "</td>");
out.println("</tr>");
}
rs.close();
out.println("</table>");
}
}
catch (SQLException sqle)
{
System.err.println(sqle.getMessage());
}
catch (ClassNotFoundException cnfe)
{
System.err.println(cnfe.getMessage());
}
catch (Exception e)
{
System.err.println(e.getMessage());
}
finally
{
try
{
if ( con != null )
{
con.close();
}
}
catch (SQLException sqle)
{
System.err.println(sqle.getMessage());
}
}
out.println("</body></html>");
out.close();
}
public String getServletInfo()
{
return "TitleListServlet Information";
}
}
