OW2 Consortium xapool

Rev

Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | RSS feed

#
#
# Test Suite
#
#

Scenario:
---------

Setup:
------

o A database:
        - MySQL
        - PostgreSQL

Database Setup:
---------------

The test expects:
o a database named javatest
o a user of login "mojo" and password "jojo"
o a table named testdata which is like 

+----+-------+
| ID | FOO   |
+----+-------+
|  1 | 1     |
+----+-------+
        
        o id being an int (primary key)
        o foo being an int
        
For test on MySQL:
mysql> GRANT ALL PRIVILEGES ON *.* TO mojo
    ->   IDENTIFIED BY 'jojo' WITH GRANT OPTION;
mysql> create database javatest;
mysql> use javatest;
mysql> create table testdata (
    ->   id int not null auto_increment primary key,
    ->   foo int)type=bdb;
mysql> insert into testdata values(null, 1);

Database configuration are stored in properties file (spy.properties) 
which contains the following properties:
o realdriver - Name of the JDBC driver
o url - URL to connect to the data base

Compilation:
------------

Go to output/dist/test/testsuite

Type

   $ ant compile

to compile the test

Run the test:
----------------
o To run the test, first check that only RMI protocol will be
activated (in the ../../config/carol.properties, carol.rmi.activated
should be set to jrmp); then type 

   $ rmiregistry -J-classpath -Jjotm.jar:jotm_jrmp_stubs.jar -J-Djava.security.policy=../config/java.policy &

to start a RMI registry on default port (i.e. 1099).

o Set the classpath

   $ export CLASSPATH=../../lib/ow_util_log_wrp_log4j.jar:../../lib/jta-spec1_0_1.jar:../../lib/jotm.jar:../../lib/jotm_jrmp_stubs.jar:../../config:.:../../lib/xapool.jar:.:../../lib/commons-logging.jar:../../lib/commons-logging-api.jar:../../lib/p6spy.jar:../../lib/junit.jar:$JDBC_JARS

where  JDBC_JARS is the location of the JDBC driver jar file(s) you want to use.

o Modify ../../config/spy.properties to setup your jdbc properties

o Start the test 

   $ java junit.textui.TestRunner XAPoolTestSuite

Usage:
------

   $ java junit.textui.TestRunner XAPoolTestSuite 

Enjoy!