jdbc « Tomcat « JSP-Servlet Q&A

1. What is a good strategy for caching prepared statements in Tomcat?    stackoverflow.com

I am looking for a way to cache prepared statements in a servlet environment (specifically, Tomcat 5.5). This is meant to reduce the number of times that prepared statements are created, ...

2. Servlet stops working on Tomcat server after some hits or time    stackoverflow.com

I have a very strange issue with some of my servlets. Below is my configuration:

  • Folder A has X number of servlets deployed in Tomcat directory
  • Folder B has Y number of ...

3. JSP-Access jdbc error: insert into statement- "Number of query values and destination fields are not the same"    stackoverflow.com

My previous JSP files that read from the database 'Prison' had worked well. But my 'add.jsp' file that is supposed to insert values into the database shows this exception:

"SQLException: Number of ...

4. problem with jdbc while using tomcat6    stackoverflow.com

    <%@ page language="java" import="java.sql.*"%>

        String username = request.getParameter("username");
        String password = ...

5. JDBC and JAKARTA TOMCAT 4.01    coderanch.com

class Test { public static void main(String args []) { try { Connection con; Statement stmt; Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con = DriverManager.getConnection ("jdbc :odbc:dbdivx"); stmt = con.createStatement(); String query = "SELECT affiche,titre "+ "FROM Film "; ResultSet rs = stmt.executeQuery(query); while (rs.next()) { System.out.println(rs.getString(2)); } } catch (ClassNotFoundException e) { System.err.println(e); } catch (SQLException e) { System.err.println(e); } } }

6. jsp/jdbc - Tomcat    coderanch.com

My requirement is once i issue a request from my jsp (the request is a sql query) it has to hit the database and should return the number of affected row but should not commit it . In the next request from jsp the user will either hit commit button or rollback button and based on the request it will either ...

7. servlets and JDBC on tomcat 5.5    coderanch.com