    All Packages  This Package

# Class examples.jdbc.pool.simpleselect

    javax.servlet.GenericServlet
       |
       +----javax.servlet.http.HttpServlet
               |
               +----examples.jdbc.pool.simpleselect

public class simpleselect
extends HttpServlet

This example shows how to use a WebLogic pool driver to make a JDBC connection for a servlet.

### To set up this example:

1. Set up your development shell as described in Setting up your environment.

2. Compile this example by executing the following command in your development shell:

   $ javac -d %SERVLET_CLASSES% simpleselect.java

3. Register the servlet in your `weblogic.properties` file by adding the following property:

         weblogic.httpd.register.pooltest=examples.jdbc.pool.simpleselect

4. Register the connection pool "oraclePool" in your WebLogic Server's `weblogic.properties` file by uncommenting the lines that refer to the connectionPool.oraclePool. Make sure to uncomment the ACLs for this connection pool as well. If you are not using an Oracle database, adjust the connection properties in these lines so that they are appropriate for your database.

5. Start your WebLogic Server.

6. Call the servlet from a browser with a URL like

   http://WebLogicHost:port/pooltest

   Where WebLogicHost:port is the hostname and port number of your WebLogic Server.

Author:
  Copyright (c) 1997-2000 by BEA Systems, Inc. All Rights Reserved.

##

simpleselect()

##

service(HttpServletRequest, HttpServletResponse)
  This implements the service method in HttpServlet.

##

simpleselect

     public simpleselect()

##

service

     public synchronized void service(HttpServletRequest req,
                                      HttpServletResponse res) throws IOException

  This implements the service method in HttpServlet. The method uses a dbKona DataSet along with the pool driver for database access, and htmlKona to generate an HTML page for display.

  Overrides:
    service in class HttpServlet

    All Examples This Package