appserver/tests/appserv-tests/devtests/jdbc/v3/README

The tests under jdbc/v3 are run only on web profile (v3/distributions/web/target/web.zip).

Set environment :
export APS_HOME=<appserv-tests> directory
export S1AS_HOME=<GlassFish Installation> directory

$S1AS_HOME/bin/asadmin start-domain domain1
cd $APS_HOME/devtests/jdbc/v3

Execute the script : setup-jdbc-dev-tests.sh

Description of Components:

SetDerbyAuthentication.java 
----------------------------
This is a Java class that executes a Callable Statement for enabling authentication for the database used in 
JDBC devtests pools for Embedded Derby mode. Since the Devtests run using the Embedded Derby, executing this 
file is necessary. Some of the tests require only some users to be authenticated and some others not. Another 
Callable Statement is also executed in this file for this purpose.

Some properties might need a change in this file, in the initializeDataSource() method, like databaseName, 
userName and password. They should correspond to the pool properties. "sun-appserv-samples" is the databaseName
used in this file and in the pool configuration. Th requireAuthentication property would be specified inside this
database.

Make sure that the database (path/directory) specified in this .java file is the one that will be used by appserver


setup-jdbc-dev-tests.sh
-----------------------
Script used to run the devtests manually. The script does jobs like starting domain, creating
required pools for various tests, creating JDBC resources for the various tests, deploying the
war that contains the tests and generating the output html file. 

Embedded Derby is used for all the tests. This script assumes that "firefox", "javac", "java", "GET" and
"wget" are on the system path.

Before running this script, a "build" is required to be done on the project "v3_jdbc_dev_tests" to generate a war.

unsetup-jdbc-dev-tests.sh
-------------------------
Script used to unset the configurations created for the JDBC devtests. Jobs like undeploying the war file, deleting
the connection pools and jdbc resources and stopping the domain are done in this script. 

Before running this script, make sure the domain is up and running.

Overall description
-------------------
The JDBC devtests included in the project named "v3_jdbc_dev_tests" include the following tests:
- Application Authentication Test
- Connection Leak Tracing Test
- Connection Sharing Test
- Container Authentication Test
- Leak Test
- Mark Connection as bad Test
- Max Connection Usage Test
- Multiple Connection Close Test
- Multiple User Credentials Test
- NoTx Connection Test
- Statement Timeout Test
- UserTx Test
- Associate with thread connection pool test
- Reconfig tests for JDBC Connection Pool/ JDBC Resource

TestResultServlet.java is responsible for listing the test results on a html page. 
HtmlUtil.java prints the exceptions (if any) on the result page.
TablesUtil.java creates/deletes tables necessary for the devtests.

This module does not need the startup of Derby manually since it is used in Embedded mode.