Connection Pooling : Does anybody have connection pooling code in jsp?

I am using Tomcat 5.0.27, MySQL 4.0, Apache 2.0

I have configured the settings in server.xml and web.xml. Where do I go from here? What do I do to start using the connection pooling.

Please help me out ranchers...

http://tomcat.apache.org/tomcat-4.1-doc/jndi-datasource-examples-howto.html

Thanks, I have seen the guiding info. However I am not sure how to come up with a full code that actually implements the connection pooling. I would be ALL SMILES

if you could give a running jsp code or should I paste the code that I already have even though its not working?

Nina Savannah wrote: I would be ALL SMILES if you could give a running jsp code

I think this post on this forum is your code for connection pooling, am I right ?

Then I suggest, why you are using JSP for defining classes , accessing connection object, its not what recommended i.e java code in JSP. So make class or a servlet which contain all the logic to deal with database ( a pure java code) and forward the result to JSP page to show/display ..

Nina Savannah wrote:or should I paste the code that I already have even though its not working?

Not that JSP code again

I want you to follow this basic setup I provided with that tomcat link. If you faced any problem, post that here..

lol...thanks. I'll work on the info that you have provided and then get back to you with my attempt.

I have done the configurations but I am now stuck at the end.

My system is located at $CATALINA_HOME/webapps/ROOT/publications
I have saved test.jsp in $CATALINA_HOME/webapps/ROOT/publications

I have saved publications.war in $CATALINA_HOME/webapps/

and I have edit the code as follows:

****TEST.JSP****

<html>
  <head>
    <title>publications</title>
  </head>
  <body>

<% out.print("HELLO!!!!");
    foo.publications tst = new foo.publications();
    tst.init();
  %>

<h2>Results</h2>
    Foo <%= tst.getFoo() %><br/>
    Bar <%= tst.getBar() %>

</body>
</html>

****publications.war****

package foo;

import javax.naming.*;
import javax.sql.*;
import java.sql.*;

public class publications {

String foo = "Not Connected";
  int bar = -1;
    
  public void init() {
    try{
      Context ctx = new InitialContext();
      if(ctx == null ) 
          throw new Exception("Boom - No Context");

DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/publications");

if (ds != null) {
        Connection conn = ds.getConnection();
              
        if(conn != null)  
		{
            foo = "Got Connection "+conn.toString();
            Statement stmt = conn.createStatement();
            ResultSet rst = 
                stmt.executeQuery(
                  "select school_code, school_name, bar from out_school");
            if(rst.next()) {
               foo=rst.getString(2);
               bar=rst.getInt(3);
            }
            conn.close();
        }
      }
    }catch(Exception e) {
      e.printStackTrace();
    }
 }

public String getFoo() { return foo; }
 public int getBar() { return bar;}
}

I wasnt so sure of how to save a war file so I opened a new jsp page in macromedia then pasted the code gave at a .war extension when I was saving it.

When I run http://localhost:8080/publications/test.jsp i get the the following errors:-

org.apache.jasper.JasperException: Unable to compile class for JSP

An error occurred at line: 7 in the jsp file: /publications/test.jsp
Generated servlet error:
foo.publications cannot be resolved or is not a type

An error occurred at line: 7 in the jsp file: /publications/test.jsp
Generated servlet error:
foo.publications cannot be resolved or is not a type

Now I dont know how to correct this.... :roll:

[ARG : added code tags]

Nina Savannah wrote:I have done the configurations but I am now stuck at the end.

My system is located at $CATALINA_HOME/webapps/ROOT/publications
I have saved test.jsp in $CATALINA_HOME/webapps/ROOT/publications

Do NOT put anything in the ROOT folder, just create your own web app folder, "publications" inside /webapps directory

Nina Savannah wrote:
I have saved publications.war in $CATALINA_HOME/webapps/

OK

Nina Savannah wrote:
and I have edit the code as follows:

****TEST.JSP****

<html>
<head>
<title>publications</title>
</head>
<body>

<% out.print("HELLO!!!");
foo.publications tst = new foo.publications();
tst.init();
%>

<h2>Results</h2>
Foo <%= tst.getFoo() %>

Bar <%= tst.getBar() %>

</body>
</html>

****publications.war****

package foo;

import javax.naming.*;
import javax.sql.*;
import java.sql.*;

public class publications {

String foo = "Not Connected";
int bar = -1;

public void init() {
try{
Context ctx = new InitialContext();
if(ctx == null )
throw new Exception("Boom - No Context");

DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/publications");

if (ds != null) {
Connection conn = ds.getConnection();

if(conn != null)
{
foo = "Got Connection "+conn.toString();
Statement stmt = conn.createStatement();
ResultSet rst =
stmt.executeQuery(
"select school_code, school_name, bar from out_school");
if(rst.next()) {
foo=rst.getString(2);
bar=rst.getInt(3);
}
conn.close();
}
}
}catch(Exception e) {
e.printStackTrace();
}
}

public String getFoo() { return foo; }
public int getBar() { return bar;}
}

This class should be inside WEB-INF\classes\

Nina Savannah wrote:
I wasnt so sure of how to save a war file so I opened a new jsp page in macromedia then pasted the code gave at a .war extension when I was saving it.

NO, that's not how .war file is build, its like zip file and unzipped by servlet container.

Nina Savannah wrote:
When I run http://localhost:8080/publications/test.jsp i get the the following errors:-

org.apache.jasper.JasperException: Unable to compile class for JSP

An error occurred at line: 7 in the jsp file: /publications/test.jsp
Generated servlet error:
foo.publications cannot be resolved or is not a type

An error occurred at line: 7 in the jsp file: /publications/test.jsp
Generated servlet error:
foo.publications cannot be resolved or is not a type

Now I dont know how to correct this.... :roll:

import package into a JSP page.

After all this clarification I think you need a simple JSP/Servlet tutorial which taught a step by step procedure to build and run web app. http://www.roseindia.net/jsp/ OR look at JSP/Servlet FAQ on this site.

Please make sure you use code tags while posting your code.Unformatted code is difficult to read and results in less response for your post. Read this for more information. You can edit your current post to add code tags by clicking

button.

Sagar Rohankar wrote:
After all this clarification I think you need a simple JSP/Servlet tutorial which taught a step by step procedure to build and run web app. http://www.roseindia.net/jsp/ OR look at JSP/Servlet FAQ on this site.

If you're new to Java EE, do certainly NOT use roseindia.net.
Read this: http://balusc.blogspot.com/2008/06/what-is-it-with-roseindia.html

Bauke Scholtz wrote:

Sagar Rohankar wrote:
After all this clarification I think you need a simple JSP/Servlet tutorial which taught a step by step procedure to build and run web app. http://www.roseindia.net/jsp/ OR look at JSP/Servlet FAQ on this site.

If you're new to Java EE, do certainly NOT use roseindia.net.
Read this: http://balusc.blogspot.com/2008/06/what-is-it-with-roseindia.html

Ooch, that's hell . I think the best resource is to start with is Sun's tutorial..

Thanks so much guys. Looks like I am getting some where. I have started on the JSP tutorials, thanks.

Before I proceed I would like to clarify one thing. Once I have done the settings in web.xml and server.xml, is that all there is for Connection Pooling or am I supposed to write a jsp code that implements the Connection Pooling?

Also, what is the right way to save a war file? Do I need special software for this?

Nina Savannah wrote:
Before I proceed I would like to clarify one thing. Once I have done the settings in web.xml and server.xml, is that all there is for Connection Pooling or am I supposed to write a jsp code that implements the Connection Pooling?

Why you stuck to JSP for your database connection , why don't you, at least, define a simple Servlet and do whatever database coding you want there..

Nina Savannah wrote:
Also, what is the right way to save a war file? Do I need special software for this?

Yes and No, both, If you are well aware about How the basic folder and file configuration are there in .war file, no problem but I don't suppose you should messed up with those folder structure right now, . About s/w , Yes you can have Eclipse/Netbeans, which take care of all that difficulties, like setting CLASSPATH, tomcat server, and of course building a valid .war file..

I have this code here for database connection and its working well. I am not very familiar with servlets so for now i am coding in jsp. My concern then is how can I make the actual connection pooling work? As long as I am connecting to my database well, does that mean that my connection pooling is also working?

I got the impression that I need a code that implements the actual Connection Pooling from here:
Connection Pooling

Here is my Database Connection File:

<%
Class.forName("com.mysql.jdbc.Driver").newInstance();
%>
<%!
  public java.sql.Connection dataconnect() throws SQLException 
{
  Connection database_connector;
  database_connector = DriverManager.getConnection("jdbc:mysql://localhost/publications?user=books&password=books");
  return database_connector;
}
%>
<%!
public java.sql.Connection adminconnect(javax.servlet.http.HttpSession session) throws SQLException 
{
  Connection database_connector;
  if (session.getAttribute("s_conn")!=null) 
  {
    database_connector = (Connection) session.getAttribute("s_conn");
    if (database_connector.isClosed()) 
	{
      database_connector = DriverManager.getConnection("jdbc:mysql://localhost/publications?user=books&password=books");            
    }
  } 
  else
  {
    database_connector = DriverManager.getConnection("jdbc:mysql://localhost/publications?user=books&password=books");
    session.setAttribute("s_conn", database_connector);
  }

return database_connector;
}
%>
<%!
public String filedir() 
{
  String directory = "C:/Tomcat5027/webapps/ROOT/publications/";
  return directory;
}
%>

:roll: Just wondering on the above...i'm confused.

Ok, If you still want to make it through JSP, fine.. I gave up..

Now look at your JSP code, it's contain three getConnection statement , why ? :roll: A single call is enough to get connection object !!

So it looks like, If corrected,

Ok, would you mind helping me do the servlets. Please dont give up on me.

What should I do? How do I go about it?

I think you should first learn the basic things of servlet like the life cycle method, how to configure url-mappings in web.xml to invoke servlets etc.