Spool

<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE web-app
  PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
  "http://java.sun.com/dtd/web-app_2_3.dtd">


  <!-- E-Comerce Desenvolvido por Lc - Software -->
  <!-- Responsaveis Tecnicos Alexandre de Almeida e Leandro Alves -->

<web-app>
  <!-- Definindo o Servlet Controlador -->

  <servlet>

  <!-- Criando um Alias -->

    <servlet-name></servlet-name>
    <servlet-class>ControllerServlet</servlet-class>

    <!-- Definindo variaveis Iniciais a serem carregadas com o ServletContext -->

    <init-param>
      <param-name>page</param-name>
      <param-value>/jsp/</param-value>
    </init-param>
    <init-param>
      <param-name>base</param-name>
      <param-value>http://localhost:8080/criativa/servlet/</param-value>
    </init-param>
    <init-param>
      <param-name>classDriver</param-name>
      <param-value>org.gjt.mm.mysql.Driver</param-value>
    </init-param>
    <init-param>
      <param-name>bannerUrl</param-name>
      <param-value>http://localhost:8080/criativa/banners/</param-value>
    </init-param>
    <init-param>
      <param-name>imageUrl</param-name>
      <param-value>http://localhost:8080/criativa/imagens/</param-value>
    </init-param>
    <init-param>
      <param-name>livroUrl</param-name>
      <param-value>http://localhost:8080/criativa/livros/</param-value>
    </init-param>
    <init-param>
      <param-name>jspUrl</param-name>
      <param-value>http://localhost:8080/criativa/jsp/</param-value>
    </init-param>
    <init-param>
      <param-name>dbUrl</param-name>
      <param-value>jdbc:mysql://localhost/Criativa</param-value>
    </init-param>
    <init-param>
      <param-name>dbUserName</param-name>
      <param-value>root</param-value>
    </init-param>
    <init-param>
      <param-name>dbPassword</param-name>
      <param-value>120582</param-value>
    </init-param>
  </servlet>


  <!-- Criando um Spool de Conexoes para o Banco -->

  <resource-ref>
      <description>SPOOL DO BANCO</description>
      <res-ref-name>jdbc/Banco_Criativa</res-ref-name>
      <res-type>javax.sql.DataSource</res-type>
      <res-auth>Container</res-auth>
  </resource-ref>

</web-app>

package com.classes.criativa;

import javax.mail.internet.*;
import javax.mail.*;

import javax.servlet.*;
import javax.servlet.http.*;

import javax.sql.*;
import javax.naming.*;
       
import java.util.*;
import java.sql.*;
import java.io.*;
import java.util.Date;
import java.text.DecimalFormat;

public class DbBean extends lc{
	
	public DecimalFormat f = new DecimalFormat("#,##0.00");
	public String[] formato = {"", "Pequeno", "Medio", "Grande"};;
		
  	public String dbUrl = "";
  	public String dbUserName = "";
  	public String dbPassword = "";
  	public String dbbannerUrl = "";
  	public String dbjspUrl = "";
  	public String dbpath = "";
  	
  	public DataSource ds = null;
  	
  	public static String path;
  	public static int codigo_banner;
  	public static int codigo_titulo;
 	
 	
  	public void setjspUrl(String jspUrl) {
	    dbjspUrl = jspUrl;
  	}
	public void setbannerUrl(String bannerurl) {
	    dbbannerUrl = bannerurl;
  	}
  	public void setDbUrl(String url) {
	    dbUrl = url;
  	}
  	public void setDbUserName(String userName) {
    	dbUserName = userName;
  	}
  	public void setDbPassword(String password) {
    	dbPassword = password;
  	}
  	
  	
  	public void init(){
		try{
      		Context ctx = new InitialContext();
      		if(ctx == null ) 
          		throw new Exception("Boom - No Context");

	      	ds = (DataSource)ctx.lookup("java:comp/env/jdbc/Banco_Criativa");
	      	
    	}catch(Exception e) {
      		e.printStackTrace();
    	}	
	
  	}//init

<Context path="/DBTest" docBase="DBTest"
        debug="5" reloadable="true" crossContext="true">

  <Logger className="org.apache.catalina.logger.FileLogger"
             prefix="localhost_DBTest_log." suffix=".txt"
             timestamp="true"/>

  <Resource name="jdbc/TestDB"
               auth="Container"
               type="javax.sql.DataSource"/>

  <ResourceParams name="jdbc/TestDB">
    <parameter>
      <name>factory</name>
      <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
    </parameter>

    <!-- Maximum number of dB connections in pool. Make sure you
         configure your mysqld max_connections large enough to handle
         all of your db connections. Set to 0 for no limit.
         -->
    <parameter>
      <name>maxActive</name>
      <value>100</value>
    </parameter>

    <!-- Maximum number of idle dB connections to retain in pool.
         Set to 0 for no limit.
         -->
    <parameter>
      <name>maxIdle</name>
      <value>30</value>
    </parameter>

    <!-- Maximum time to wait for a dB connection to become available
         in ms, in this example 10 seconds. An Exception is thrown if
         this timeout is exceeded.  Set to -1 to wait indefinitely.
         -->
    <parameter>
      <name>maxWait</name>
      <value>10000</value>
    </parameter>

    <!-- MySQL dB username and password for dB connections  -->
    <parameter>
     <name>username</name>
     <value>javauser</value>
    </parameter>
    <parameter>
     <name>password</name>
     <value>javadude</value>
    </parameter>

    <!-- Class name for mm.mysql JDBC driver -->
    <parameter>
       <name>driverClassName</name>
       <value>org.gjt.mm.mysql.Driver</value>
    </parameter>

    <!-- The JDBC connection url for connecting to your MySQL dB.
         The autoReconnect=true argument to the url makes sure that the
         mm.mysql JDBC Driver will automatically reconnect if mysqld closed the
         connection.  mysqld by default closes idle connections after 8 hours.
         -->
    <parameter>
      <name>url</name>
      <value>jdbc:mysql://localhost:3306/javatest?autoReconnect=true</value>
    </parameter>
  </ResourceParams>
</Context>