You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ibatis.apache.org by cb...@apache.org on 2008/08/08 01:21:58 UTC

svn commit: r683745 [13/22] - in /ibatis/trunk/java/ibatis-3: ./ ibatis-3-compat/ ibatis-3-compat/src/ ibatis-3-compat/src/main/ ibatis-3-compat/src/main/java/ ibatis-3-compat/src/main/java/com/ ibatis-3-compat/src/main/java/com/ibatis/ ibatis-3-compat...

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/log4j.properties
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/log4j.properties?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/log4j.properties (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/log4j.properties Thu Aug  7 16:21:46 2008
@@ -0,0 +1,19 @@
+# Global logging configuration
+log4j.rootLogger=ERROR, stdout
+
+# SqlMap logging configuration...
+#log4j.logger.com.ibatis=DEBUG
+#log4j.logger.com.ibatis.common.jdbc.SimpleDataSource=DEBUG
+#log4j.logger.com.ibatis.sqlmap.engine.cache.CacheModel=DEBUG
+#log4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapClientImpl=DEBUG
+#log4j.logger.com.ibatis.sqlmap.engine.builder.xml.SqlMapParser=DEBUG
+#log4j.logger.com.ibatis.common.util.StopWatch=DEBUG
+#log4j.logger.java.sql.Connection=DEBUG
+#log4j.logger.java.sql.Statement=DEBUG
+#log4j.logger.java.sql.PreparedStatement=DEBUG
+#log4j.logger.java.sql.ResultSet=DEBUG
+
+# Console output...
+log4j.appender.stdout=org.apache.log4j.ConsoleAppender
+log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
+log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/properties/database.properties
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/properties/database.properties?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/properties/database.properties (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/properties/database.properties Thu Aug  7 16:21:46 2008
@@ -0,0 +1,9 @@
+####################################
+# Database Connectivity Properties
+####################################
+
+driver=org.hsqldb.jdbcDriver
+url=jdbc:hsqldb:mem:jpetstore
+username=sa
+password=
+

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/properties/messages.properties
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/properties/messages.properties?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/properties/messages.properties (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/properties/messages.properties Thu Aug  7 16:21:46 2008
@@ -0,0 +1,63 @@
+####################################
+# Typical Struts Resources File
+####################################
+
+account.username.label=Username
+account.password.label=Password
+account.repeatPassword.label=Repeat password
+account.firstName.label=First name
+account.lastName.label=Last name
+account.email.label=Email address
+account.phone.label=Phone
+account.address1.label=Address
+account.city.label=City
+account.state.label=State
+account.zip.label=Zip/Postal Code
+account.country.label=Country
+order.creditCard.label=FAKE (!) credit card number
+order.expiryDate.label=Expiry date
+order.cardType.label=Card type
+account.shipToFirstName.label=Shipping Info: first name
+account.shipToLastName.label=Shipping Info: last name
+account.shipAddress1.label=Shipping Info: address
+account.shipCity.label=Shipping Info: city
+account.shipState.label=Shipping Info: state
+account.shipZip.label=Shipping Info: zip/postal code
+account.shipCountry.label=Shipping Info: country
+account.billToFirstName.label=Billing Info: first name
+account.billToLastName.label=Billing Info: last name
+account.billAddress1.label=Billing Info: address
+account.billCity.label=Billing Info: city
+account.billState.label=Billing Info: state
+account.billZip.label=Billing Info: zip/postal code
+account.billCountry.label=Billing Info: country
+
+# -- standard errors --
+errors.header=<UL>
+errors.prefix=<LI>
+errors.suffix=</LI>
+errors.footer=</UL>
+# -- validator --
+errors.invalid={0} is invalid.
+errors.maxlength={0} can not be greater than {1} characters.
+errors.minlength={0} can not be less than {1} characters.
+errors.range={0} is not in the range {1} through {2}.
+errors.required={0} is required.
+errors.byte={0} must be an byte.
+errors.date={0} is not a date.
+errors.double={0} must be an double.
+errors.float={0} must be an float.
+errors.integer={0} must be an integer.
+errors.long={0} must be an long.
+errors.short={0} must be an short.
+errors.creditcard={0} is not a valid credit card number.
+errors.email={0} is an invalid e-mail address.
+# -- other --
+errors.cancel=Operation cancelled.
+errors.detail={0}
+errors.general=The process did not complete. Details should follow.
+errors.token=Request could not be completed. Operation is not in sequence.
+# -- welcome --
+welcome.title=Struts Blank Application
+welcome.heading=Welcome!
+welcome.message=To get started on your own application, copy the struts-blank.war to a new WAR file using the name for your application. Place it in your container's "webapp" folder (or equivalent), and let your container auto-deploy the application. Edit the skeleton configuration files as needed, restart your container, and you are on your way! (You can find the application.properties file with this message in the /WEB-INF/src/java/resources folder.)

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/scripts/account-init.sql
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/scripts/account-init.sql?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/scripts/account-init.sql (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/scripts/account-init.sql Thu Aug  7 16:21:46 2008
@@ -0,0 +1,29 @@
+-- HSQL DATABASE
+
+-- Dropping Tables
+
+DROP TABLE ACCOUNT;
+
+-- Creating Tables
+
+CREATE TABLE ACCOUNT (
+    ACC_ID             INT NOT NULL,
+    ACC_FIRST_NAME     VARCHAR(255) NOT NULL,
+    ACC_LAST_NAME      VARCHAR(255) NOT NULL,
+    ACC_EMAIL          VARCHAR(255),
+    ACC_AGE						 NUMERIC,
+    ACC_BANNER_OPTION  VARCHAR(255),
+    ACC_CART_OPTION    INT,
+    ACC_DATE_ADDED     DATE,
+    PRIMARY KEY (ACC_ID)
+);
+
+-- Creating Test Data
+
+INSERT INTO ACCOUNT VALUES(1,'Clinton', 'Begin', 'clinton.begin@ibatis.com', 1, 'Aye', 200, CURRENT_DATE);
+INSERT INTO ACCOUNT VALUES(2,'Jim', 'Smith', 'jim.smith@somewhere.com', 2, 'Aye', 200, CURRENT_DATE);
+INSERT INTO ACCOUNT VALUES(3,'Elizabeth', 'Jones', null, 3, 'Nay', 100, CURRENT_DATE);
+INSERT INTO ACCOUNT VALUES(4,'Bob', 'Jackson', 'bob.jackson@somewhere.com', 4, 'Nay', 100, CURRENT_DATE);
+INSERT INTO ACCOUNT VALUES(5,'&manda', 'Goodman', null, 5, 'Aye', 100, CURRENT_DATE);
+
+

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/scripts/derby-proc-init.sql
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/scripts/derby-proc-init.sql?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/scripts/derby-proc-init.sql (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/scripts/derby-proc-init.sql Thu Aug  7 16:21:46 2008
@@ -0,0 +1,8 @@
+DROP PROCEDURE MRESULTSET;
+
+CREATE PROCEDURE MRESULTSET(DP1 INTEGER, DP2 INTEGER, DP3 INTEGER, DP4 INTEGER)
+PARAMETER STYLE JAVA
+LANGUAGE JAVA
+READS SQL DATA
+DYNAMIC RESULT SETS 2
+EXTERNAL NAME 'com.ibatis.sqlmap.proc.DerbyProcs.selectRows';
\ No newline at end of file

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/scripts/docs-init.sql
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/scripts/docs-init.sql?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/scripts/docs-init.sql (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/scripts/docs-init.sql Thu Aug  7 16:21:46 2008
@@ -0,0 +1,41 @@
+DROP TABLE DOCUMENTS;
+DROP TABLE PERSON_DOCUMENTS;
+DROP TABLE DOCUMENT_ATTRIBUTES;
+
+CREATE TABLE DOCUMENTS  (
+   DOCUMENT_ID           INTEGER                          NOT NULL,
+   DOCUMENT_TITLE        VARCHAR(32),
+   DOCUMENT_TYPE         VARCHAR(32),
+   DOCUMENT_PAGENUMBER   INTEGER,
+   DOCUMENT_CITY         VARCHAR(32),
+   PRIMARY KEY (DOCUMENT_ID)
+);
+
+INSERT INTO DOCUMENTS VALUES (1, 'The World of Null-A', 'BOOK', 55, null);
+INSERT INTO DOCUMENTS VALUES (2, 'Le Progres de Lyon', 'NEWSPAPER', null , 'Lyon');
+INSERT INTO DOCUMENTS VALUES (3, 'Lord of the Rings', 'BOOK', 3587, null);
+INSERT INTO DOCUMENTS VALUES (4, 'Le Canard enchaine', 'NEWSPAPER', null , 'Paris');
+INSERT INTO DOCUMENTS VALUES (5, 'Le Monde', 'BROADSHEET', null , 'Paris');
+INSERT INTO DOCUMENTS VALUES (6, 'Foundation', 'MONOGRAPH', 557, null);
+
+CREATE TABLE PERSON_DOCUMENTS (
+  PERSON_ID INTEGER NOT NULL,
+  PERSON_NAME VARCHAR(50),
+  DOCUMENT_ID INTEGER NOT NULL,
+  PRIMARY KEY (PERSON_ID)
+);
+
+insert into person_documents values (1, 'Jeff', 2);
+insert into person_documents values (2, 'Matt', 3);
+insert into person_documents values (3, 'Amy', 6);
+
+create table Document_Attributes (
+  document_id int not null,
+  attribute varchar(50) not null
+);
+
+insert into Document_Attributes values (1, 'English');
+insert into Document_Attributes values (1, 'Sci-Fi');
+insert into Document_Attributes values (2, 'French');
+insert into Document_Attributes values (3, 'English');
+insert into Document_Attributes values (3, 'Fantasy');

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/scripts/jira.sql
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/scripts/jira.sql?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/scripts/jira.sql (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/scripts/jira.sql Thu Aug  7 16:21:46 2008
@@ -0,0 +1,18 @@
+DROP TABLE ARTICLE_INDEX;
+
+CREATE TABLE ARTICLE_INDEX (
+   CATEGORY_ID           INTEGER                          NOT NULL,
+   CATEGORY_TITLE        VARCHAR(32),
+   TOPIC_TITLE           VARCHAR(32),
+   TOPIC_DESCRIPTION     VARCHAR(80),
+   PRIMARY KEY (CATEGORY_ID)
+);
+
+INSERT INTO ARTICLE_INDEX VALUES (1, 'Health', 'Heart', 'Exercises for your heart');
+INSERT INTO ARTICLE_INDEX VALUES (2, 'Health', 'Health', 'General health for people');
+INSERT INTO ARTICLE_INDEX VALUES (3, 'Health', 'Love', 'How love affects your health1');
+INSERT INTO ARTICLE_INDEX VALUES (4, 'Love', 'Heart', 'Language of the heart');
+INSERT INTO ARTICLE_INDEX VALUES (5, 'Love', 'Health', 'How love affects your health2');
+INSERT INTO ARTICLE_INDEX VALUES (6, 'Combat', 'Health', 'Staying alive in combat');
+INSERT INTO ARTICLE_INDEX VALUES (7, 'Love', 'Love', 'Love is all around');
+INSERT INTO ARTICLE_INDEX VALUES (8, 'Health', 'Heart', 'More Exercises for your heart');

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/scripts/jpetstore-hsqldb-dataload.sql
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/scripts/jpetstore-hsqldb-dataload.sql?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/scripts/jpetstore-hsqldb-dataload.sql (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/scripts/jpetstore-hsqldb-dataload.sql Thu Aug  7 16:21:46 2008
@@ -0,0 +1,102 @@
+INSERT INTO sequence VALUES('ordernum', 1000);
+INSERT INTO sequence VALUES('linenum', 1000);
+
+INSERT INTO signon VALUES('j2ee','j2ee');
+INSERT INTO signon VALUES('ACID','ACID');
+
+INSERT INTO account VALUES('j2ee','yourname@yourdomain.com','ABC', 'XYX', 'OK', '901 San Antonio Road', 'MS UCUP02-206', 'Palo Alto', 'CA', '94303', 'USA',  '555-555-5555');
+INSERT INTO account VALUES('ACID','acid@yourdomain.com','ABC', 'XYX', 'OK', '901 San Antonio Road', 'MS UCUP02-206', 'Palo Alto', 'CA', '94303', 'USA',  '555-555-5555');
+
+INSERT INTO profile VALUES('j2ee','english','DOGS',1,1);
+INSERT INTO profile VALUES('ACID','english','CATS',1,1);
+
+INSERT INTO bannerdata VALUES ('FISH','<image src="../images/banner_fish.gif">');
+INSERT INTO bannerdata VALUES ('CATS','<image src="../images/banner_cats.gif">');
+INSERT INTO bannerdata VALUES ('DOGS','<image src="../images/banner_dogs.gif">');
+INSERT INTO bannerdata VALUES ('REPTILES','<image src="../images/banner_reptiles.gif">');
+INSERT INTO bannerdata VALUES ('BIRDS','<image src="../images/banner_birds.gif">');
+
+INSERT INTO category VALUES ('FISH','Fish','<image src="../images/fish_icon.gif"><font size="5" color="blue"> Fish</font>');
+INSERT INTO category VALUES ('DOGS','Dogs','<image src="../images/dogs_icon.gif"><font size="5" color="blue"> Dogs</font>');
+INSERT INTO category VALUES ('REPTILES','Reptiles','<image src="../images/reptiles_icon.gif"><font size="5" color="blue"> Reptiles</font>');
+INSERT INTO category VALUES ('CATS','Cats','<image src="../images/cats_icon.gif"><font size="5" color="blue"> Cats</font>');
+INSERT INTO category VALUES ('BIRDS','Birds','<image src="../images/birds_icon.gif"><font size="5" color="blue"> Birds</font>');
+
+INSERT INTO product VALUES ('FI-SW-01','FISH','Angelfish','<image src="../images/fish1.jpg">Salt Water fish from Australia');
+INSERT INTO product VALUES ('FI-SW-02','FISH','Tiger Shark','<image src="../images/fish4.gif">Salt Water fish from Australia');
+INSERT INTO product VALUES ('FI-FW-01','FISH', 'Koi','<image src="../images/fish3.gif">Fresh Water fish from Japan');
+INSERT INTO product VALUES ('FI-FW-02','FISH', 'Goldfish','<image src="../images/fish2.gif">Fresh Water fish from China');
+INSERT INTO product VALUES ('K9-BD-01','DOGS','Bulldog','<image src="../images/dog2.gif">Friendly dog from England');
+INSERT INTO product VALUES ('K9-PO-02','DOGS','Poodle','<image src="../images/dog6.gif">Cute dog from France');
+INSERT INTO product VALUES ('K9-DL-01','DOGS', 'Dalmation','<image src="../images/dog5.gif">Great dog for a Fire Station');
+INSERT INTO product VALUES ('K9-RT-01','DOGS', 'Golden Retriever','<image src="../images/dog1.gif">Great family dog');
+INSERT INTO product VALUES ('K9-RT-02','DOGS', 'Labrador Retriever','<image src="../images/dog5.gif">Great hunting dog');
+INSERT INTO product VALUES ('K9-CW-01','DOGS', 'Chihuahua','<image src="../images/dog4.gif">Great companion dog');
+INSERT INTO product VALUES ('RP-SN-01','REPTILES','Rattlesnake','<image src="../images/lizard3.gif">Doubles as a watch dog');
+INSERT INTO product VALUES ('RP-LI-02','REPTILES','Iguana','<image src="../images/lizard2.gif">Friendly green friend');
+INSERT INTO product VALUES ('FL-DSH-01','CATS','Manx','<image src="../images/cat3.gif">Great for reducing mouse populations');
+INSERT INTO product VALUES ('FL-DLH-02','CATS','Persian','<image src="../images/cat1.gif">Friendly house cat, doubles as a princess');
+INSERT INTO product VALUES ('AV-CB-01','BIRDS','Amazon Parrot','<image src="../images/bird4.gif">Great companion for up to 75 years');
+INSERT INTO product VALUES ('AV-SB-02','BIRDS','Finch','<image src="../images/bird1.gif">Great stress reliever');
+
+INSERT INTO supplier VALUES (1,'XYZ Pets','AC','600 Avon Way','','Los Angeles','CA','94024','212-947-0797');
+INSERT INTO supplier VALUES (2,'ABC Pets','AC','700 Abalone Way','','San Francisco ','CA','94024','415-947-0797');
+
+INSERT INTO  item (itemid, productid, listprice, unitcost, supplier, status, attr1) VALUES('EST-1','FI-SW-01',16.50,10.00,1,'P','Large');
+INSERT INTO  item (itemid, productid, listprice, unitcost, supplier, status, attr1) VALUES('EST-2','FI-SW-01',16.50,10.00,1,'P','Small');
+INSERT INTO  item (itemid, productid, listprice, unitcost, supplier, status, attr1) VALUES('EST-3','FI-SW-02',18.50,12.00,1,'P','Toothless');
+INSERT INTO  item (itemid, productid, listprice, unitcost, supplier, status, attr1) VALUES('EST-4','FI-FW-01',18.50,12.00,1,'P','Spotted');
+INSERT INTO  item (itemid, productid, listprice, unitcost, supplier, status, attr1) VALUES('EST-5','FI-FW-01',18.50,12.00,1,'P','Spotless');
+INSERT INTO  item (itemid, productid, listprice, unitcost, supplier, status, attr1) VALUES('EST-6','K9-BD-01',18.50,12.00,1,'P','Male Adult');
+INSERT INTO  item (itemid, productid, listprice, unitcost, supplier, status, attr1) VALUES('EST-7','K9-BD-01',18.50,12.00,1,'P','Female Puppy');
+INSERT INTO  item (itemid, productid, listprice, unitcost, supplier, status, attr1) VALUES('EST-8','K9-PO-02',18.50,12.00,1,'P','Male Puppy');
+INSERT INTO  item (itemid, productid, listprice, unitcost, supplier, status, attr1) VALUES('EST-9','K9-DL-01',18.50,12.00,1,'P','Spotless Male Puppy');
+INSERT INTO  item (itemid, productid, listprice, unitcost, supplier, status, attr1) VALUES('EST-10','K9-DL-01',18.50,12.00,1,'P','Spotted Adult Female');
+INSERT INTO  item (itemid, productid, listprice, unitcost, supplier, status, attr1) VALUES('EST-11','RP-SN-01',18.50,12.00,1,'P','Venomless');
+INSERT INTO  item (itemid, productid, listprice, unitcost, supplier, status, attr1) VALUES('EST-12','RP-SN-01',18.50,12.00,1,'P','Rattleless');
+INSERT INTO  item (itemid, productid, listprice, unitcost, supplier, status, attr1) VALUES('EST-13','RP-LI-02',18.50,12.00,1,'P','Green Adult');
+INSERT INTO  item (itemid, productid, listprice, unitcost, supplier, status, attr1) VALUES('EST-14','FL-DSH-01',58.50,12.00,1,'P','Tailless');
+INSERT INTO  item (itemid, productid, listprice, unitcost, supplier, status, attr1) VALUES('EST-15','FL-DSH-01',23.50,12.00,1,'P','With tail');
+INSERT INTO  item (itemid, productid, listprice, unitcost, supplier, status, attr1) VALUES('EST-16','FL-DLH-02',93.50,12.00,1,'P','Adult Female');
+INSERT INTO  item (itemid, productid, listprice, unitcost, supplier, status, attr1) VALUES('EST-17','FL-DLH-02',93.50,12.00,1,'P','Adult Male');
+INSERT INTO  item (itemid, productid, listprice, unitcost, supplier, status, attr1) VALUES('EST-18','AV-CB-01',193.50,92.00,1,'P','Adult Male');
+INSERT INTO  item (itemid, productid, listprice, unitcost, supplier, status, attr1) VALUES('EST-19','AV-SB-02',15.50, 2.00,1,'P','Adult Male');
+INSERT INTO  item (itemid, productid, listprice, unitcost, supplier, status, attr1) VALUES('EST-20','FI-FW-02',5.50, 2.00,1,'P','Adult Male');
+INSERT INTO  item (itemid, productid, listprice, unitcost, supplier, status, attr1) VALUES('EST-21','FI-FW-02',5.29, 1.00,1,'P','Adult Female');
+INSERT INTO  item (itemid, productid, listprice, unitcost, supplier, status, attr1) VALUES('EST-22','K9-RT-02',135.50, 100.00,1,'P','Adult Male');
+INSERT INTO  item (itemid, productid, listprice, unitcost, supplier, status, attr1) VALUES('EST-23','K9-RT-02',145.49, 100.00,1,'P','Adult Female');
+INSERT INTO  item (itemid, productid, listprice, unitcost, supplier, status, attr1) VALUES('EST-24','K9-RT-02',255.50, 92.00,1,'P','Adult Male');
+INSERT INTO  item (itemid, productid, listprice, unitcost, supplier, status, attr1) VALUES('EST-25','K9-RT-02',325.29, 90.00,1,'P','Adult Female');
+INSERT INTO  item (itemid, productid, listprice, unitcost, supplier, status, attr1) VALUES('EST-26','K9-CW-01',125.50, 92.00,1,'P','Adult Male');
+INSERT INTO  item (itemid, productid, listprice, unitcost, supplier, status, attr1) VALUES('EST-27','K9-CW-01',155.29, 90.00,1,'P','Adult Female');
+INSERT INTO  item (itemid, productid, listprice, unitcost, supplier, status, attr1) VALUES('EST-28','K9-RT-01',155.29, 90.00,1,'P','Adult Female');
+
+INSERT INTO inventory (itemid, qty ) VALUES ('EST-1',10000);
+INSERT INTO inventory (itemid, qty ) VALUES ('EST-2',10000);
+INSERT INTO inventory (itemid, qty ) VALUES ('EST-3',10000);
+INSERT INTO inventory (itemid, qty ) VALUES ('EST-4',10000);
+INSERT INTO inventory (itemid, qty ) VALUES ('EST-5',10000);
+INSERT INTO inventory (itemid, qty ) VALUES ('EST-6',10000);
+INSERT INTO inventory (itemid, qty ) VALUES ('EST-7',10000);
+INSERT INTO inventory (itemid, qty ) VALUES ('EST-8',10000);
+INSERT INTO inventory (itemid, qty ) VALUES ('EST-9',10000);
+INSERT INTO inventory (itemid, qty ) VALUES ('EST-10',10000);
+INSERT INTO inventory (itemid, qty ) VALUES ('EST-11',10000);
+INSERT INTO inventory (itemid, qty ) VALUES ('EST-12',10000);
+INSERT INTO inventory (itemid, qty ) VALUES ('EST-13',10000);
+INSERT INTO inventory (itemid, qty ) VALUES ('EST-14',10000);
+INSERT INTO inventory (itemid, qty ) VALUES ('EST-15',10000);
+INSERT INTO inventory (itemid, qty ) VALUES ('EST-16',10000);
+INSERT INTO inventory (itemid, qty ) VALUES ('EST-17',10000);
+INSERT INTO inventory (itemid, qty ) VALUES ('EST-18',10000);
+INSERT INTO inventory (itemid, qty ) VALUES ('EST-19',10000);
+INSERT INTO inventory (itemid, qty ) VALUES ('EST-20',10000);
+INSERT INTO inventory (itemid, qty ) VALUES ('EST-21',10000);
+INSERT INTO inventory (itemid, qty ) VALUES ('EST-22',10000);
+INSERT INTO inventory (itemid, qty ) VALUES ('EST-23',10000);
+INSERT INTO inventory (itemid, qty ) VALUES ('EST-24',10000);
+INSERT INTO inventory (itemid, qty ) VALUES ('EST-25',10000);
+INSERT INTO inventory (itemid, qty ) VALUES ('EST-26',10000);
+INSERT INTO inventory (itemid, qty ) VALUES ('EST-27',10000);
+INSERT INTO inventory (itemid, qty ) VALUES ('EST-28',10000);
+

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/scripts/jpetstore-hsqldb-schema.sql
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/scripts/jpetstore-hsqldb-schema.sql?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/scripts/jpetstore-hsqldb-schema.sql (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/scripts/jpetstore-hsqldb-schema.sql Thu Aug  7 16:21:46 2008
@@ -0,0 +1,158 @@
+drop table lineitem;
+drop table orderstatus;
+drop table orders;
+drop table bannerdata;
+drop table profile;
+drop table signon;
+drop table inventory;
+drop table item;
+drop table product;
+drop table account;
+drop table category;
+drop table supplier;
+drop table sequence;
+
+create table supplier (
+    suppid int not null,
+    name VARCHAR(80),
+    status VARCHAR(2) not null,
+    addr1 VARCHAR(80),
+    addr2 VARCHAR(80),
+    city VARCHAR(80),
+    state VARCHAR(80),
+    zip VARCHAR(5),
+    phone VARCHAR(80),
+    constraint pk_supplier primary key (suppid)
+);
+
+create table signon (
+    username VARCHAR(25) not null,
+    password VARCHAR(25)  not null,
+    constraint pk_signon primary key (username)
+);
+
+create table account (
+    userid VARCHAR(80) not null,
+    email VARCHAR(80) not null,
+    firstname VARCHAR(80) not null,
+    lastname VARCHAR(80) not null,
+    status VARCHAR(2),
+    addr1 VARCHAR(80) not null,
+    addr2 VARCHAR(40),
+    city VARCHAR(80) not  null,
+    state VARCHAR(80) not null,
+    zip VARCHAR(20) not null,
+    country VARCHAR(20) not null,
+    phone VARCHAR(80) not null,
+    constraint pk_account primary key (userid)
+);
+
+create table profile (
+    userid VARCHAR(80) not null,
+    langpref VARCHAR(80) not null,
+    favcategory VARCHAR(30),
+    mylistopt int,
+    banneropt int,
+    constraint pk_profile primary key (userid)
+);
+
+create table bannerdata (
+    favcategory VARCHAR(80) not null,
+    bannername VARCHAR(255),
+    constraint pk_bannerdata primary key (favcategory)
+);
+
+create table orders (
+      orderid int not null,
+      userid VARCHAR(80) not null,
+      orderdate date not null,
+      shipaddr1 VARCHAR(80) not null,
+      shipaddr2 VARCHAR(80),
+      shipcity VARCHAR(80) not null,
+      shipstate VARCHAR(80) not null,
+      shipzip VARCHAR(20) not null,
+      shipcountry VARCHAR(20) not null,
+      billaddr1 VARCHAR(80) not null,
+      billaddr2 VARCHAR(80),
+      billcity VARCHAR(80) not null,
+      billstate VARCHAR(80) not null,
+      billzip VARCHAR(20) not null,
+      billcountry VARCHAR(20) not null,
+      courier VARCHAR(80) not null,
+      totalprice decimal(10,2) not null,
+      billtofirstname VARCHAR(80) not null,
+      billtolastname VARCHAR(80) not null,
+      shiptofirstname VARCHAR(80) not null,
+      shiptolastname VARCHAR(80) not null,
+      creditcard VARCHAR(80) not null,
+      exprdate VARCHAR(7) not null,
+      cardtype VARCHAR(80) not null,
+      locale VARCHAR(80) not null,
+      constraint pk_orders primary key (orderid)
+);
+
+create table orderstatus (
+      orderid int not null,
+      linenum int not null,
+      timestamp date not null,
+      status VARCHAR(2) not null,
+      constraint pk_orderstatus primary key (orderid, linenum)
+);
+
+create table lineitem (
+      orderid int not null,
+      linenum int not null,
+      itemid VARCHAR(10) not null,
+      quantity int not null,
+      unitprice decimal(10,2) not null,
+      constraint pk_lineitem primary key (orderid, linenum)
+);
+
+create table category (
+	catid VARCHAR(10) not null,
+	name VARCHAR(80),
+	descn VARCHAR(255),
+	constraint pk_category primary key (catid)
+);
+
+create table product (
+    productid VARCHAR(10) not null,
+    category VARCHAR(10) not null,
+    name VARCHAR(80),
+    descn VARCHAR(255),
+    constraint pk_product primary key (productid),
+        constraint fk_product_1 foreign key (category)
+        references category (catid)
+);
+
+create table item (
+    itemid VARCHAR(10) not null,
+    productid VARCHAR(10) not null,
+    listprice decimal(10,2),
+    unitcost decimal(10,2),
+    supplier int,
+    status VARCHAR(2),
+    attr1 VARCHAR(80),
+    attr2 VARCHAR(80),
+    attr3 VARCHAR(80),
+    attr4 VARCHAR(80),
+    attr5 VARCHAR(80),
+    constraint pk_item primary key (itemid),
+        constraint fk_item_1 foreign key (productid)
+        references product (productid),
+        constraint fk_item_2 foreign key (supplier)
+        references supplier (suppid)
+);
+
+create table inventory (
+    itemid VARCHAR(10) not null,
+    qty int not null,
+    constraint pk_inventory primary key (itemid)
+);
+
+CREATE TABLE sequence
+(
+    name               VARCHAR(30)  not null,
+    nextid             int          not null,
+    constraint pk_sequence primary key (name)
+);

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/scripts/line_item-init.sql
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/scripts/line_item-init.sql?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/scripts/line_item-init.sql (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/scripts/line_item-init.sql Thu Aug  7 16:21:46 2008
@@ -0,0 +1,40 @@
+-- HSQL DATABASE
+
+-- Dropping Tables
+
+DROP TABLE LINE_ITEM;
+
+-- Creating Tables
+
+CREATE TABLE LINE_ITEM (
+    LIN_ID             INT NOT NULL,
+    LIN_ORD_ID         INT NOT NULL,
+    LIN_ITM_CODE       VARCHAR(255) NOT NULL,
+    LIN_QUANTITY       INT NOT NULL,
+    LIN_PRICE          DECIMAL NOT NULL,
+    PRIMARY KEY (LIN_ID, LIN_ORD_ID)
+);
+
+
+-- Creating Test Data
+
+INSERT INTO LINE_ITEM VALUES (1, 10, 'ESM-34', 1, 45.43);
+INSERT INTO LINE_ITEM VALUES (2, 10, 'QSM-98', 8, 8.40);
+INSERT INTO LINE_ITEM VALUES (1, 9, 'DSM-78', 2, 45.40);
+INSERT INTO LINE_ITEM VALUES (2, 9, 'TSM-12', 2, 32.12);
+INSERT INTO LINE_ITEM VALUES (1, 8, 'DSM-16', 4, 41.30);
+INSERT INTO LINE_ITEM VALUES (2, 8, 'GSM-65', 1, 2.20);
+INSERT INTO LINE_ITEM VALUES (1, 7, 'WSM-27', 7, 52.10);
+INSERT INTO LINE_ITEM VALUES (2, 7, 'ESM-23', 2, 123.34);
+INSERT INTO LINE_ITEM VALUES (1, 6, 'QSM-39', 9, 12.12);
+INSERT INTO LINE_ITEM VALUES (2, 6, 'ASM-45', 6, 78.77);
+INSERT INTO LINE_ITEM VALUES (1, 5, 'ESM-48', 3, 43.87);
+INSERT INTO LINE_ITEM VALUES (2, 5, 'WSM-98', 7, 5.40);
+INSERT INTO LINE_ITEM VALUES (1, 4, 'RSM-57', 2, 78.90);
+INSERT INTO LINE_ITEM VALUES (2, 4, 'XSM-78', 9, 2.34);
+INSERT INTO LINE_ITEM VALUES (1, 3, 'DSM-59', 3, 5.70);
+INSERT INTO LINE_ITEM VALUES (2, 3, 'DSM-53', 3, 98.78);
+INSERT INTO LINE_ITEM VALUES (1, 2, 'DSM-37', 4, 7.80);
+INSERT INTO LINE_ITEM VALUES (2, 2, 'FSM-12', 2, 55.78);
+INSERT INTO LINE_ITEM VALUES (1, 1, 'ESM-48', 8, 87.60);
+INSERT INTO LINE_ITEM VALUES (2, 1, 'ESM-23', 1, 55.40);

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/scripts/more-account-records.sql
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/scripts/more-account-records.sql?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/scripts/more-account-records.sql (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/scripts/more-account-records.sql Thu Aug  7 16:21:46 2008
@@ -0,0 +1,15 @@
+
+
+DELETE ACCOUNT;
+
+INSERT INTO ACCOUNT VALUES(1,'Clinton', 'Begin', 'clinton.begin@ibatis.com');
+INSERT INTO ACCOUNT VALUES(2,'Jim', 'Smith', 'jim.smith@somewhere.com');
+INSERT INTO ACCOUNT VALUES(3,'Elizabeth', 'Jones', null);
+INSERT INTO ACCOUNT VALUES(4,'Bob', 'Jackson', 'bob.jackson@somewhere.com');
+INSERT INTO ACCOUNT VALUES(5,'&manda', 'Goodman', null);
+INSERT INTO ACCOUNT VALUES(6,'Rick', 'Maximum', 'rick@ibatis.com');
+INSERT INTO ACCOUNT VALUES(7,'Steve', 'Todor', 'steve@somewhere.com');
+INSERT INTO ACCOUNT VALUES(8,'Elizabeth', 'Samson', null);
+INSERT INTO ACCOUNT VALUES(9,'Robert', 'Johnson', 'blahblah@somewhere.com');
+INSERT INTO ACCOUNT VALUES(10,'June', 'Willis', null);
+

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/scripts/oracle-proc.sql
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/scripts/oracle-proc.sql?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/scripts/oracle-proc.sql (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/scripts/oracle-proc.sql Thu Aug  7 16:21:46 2008
@@ -0,0 +1,99 @@
+
+-- ORACLE DATABASE
+
+-- Dropping Tables
+
+DROP TABLE ACCOUNT2;
+
+-- Creating Tables
+
+CREATE TABLE ACCOUNT2 (
+    ACC_ID             NUMBER(5,0) NOT NULL,
+    ACC_FIRST_NAME     VARCHAR2 (255) NOT NULL,
+    ACC_LAST_NAME      VARCHAR2 (255) NOT NULL,
+    ACC_EMAIL          VARCHAR2 (255),
+    PRIMARY KEY (ACC_ID)
+);
+
+-- Creating Test Data
+
+INSERT INTO ACCOUNT2 VALUES(1,'Clinton', 'Begin', 'clinton.begin@ibatis.com');
+INSERT INTO ACCOUNT2 VALUES(2,'Jim', 'Smith', 'jim.smith@somewhere.com');
+INSERT INTO ACCOUNT2 VALUES(3,'Bob', 'Jackson', 'bob.jackson@somewhere.com');
+
+-- Create Email Swap Procedure
+CREATE or REPLACE
+PROCEDURE swap_email_address
+  (p_first IN OUT VARCHAR2, p_second IN OUT VARCHAR2, p_status OUT VARCHAR2)
+IS
+  v_id1 NUMBER (5,0);
+  v_id2 NUMBER (5,0);
+  v_email1 VARCHAR2 (255);
+  v_email2 VARCHAR2 (255);
+BEGIN
+
+  SELECT ACC_ID, ACC_EMAIL
+  INTO v_id1, v_email1
+  from ACCOUNT2
+  where ACC_EMAIL = p_first;
+
+  SELECT ACC_ID, ACC_EMAIL
+  INTO v_id2, v_email2
+  from ACCOUNT2
+  where ACC_EMAIL = p_second;
+
+  UPDATE ACCOUNT2
+  set ACC_EMAIL = v_email2
+  where ACC_ID = v_id1;
+
+  UPDATE ACCOUNT2
+  set ACC_EMAIL = v_email1
+  where ACC_ID = v_id2;
+
+  SELECT ACC_EMAIL
+  INTO p_first
+  from ACCOUNT2
+  where ACC_ID = v_id1;
+
+  SELECT ACC_EMAIL
+  INTO p_second
+  from ACCOUNT2
+  where ACC_ID = v_id2;
+
+  SELECT 'success'
+  INTO p_status
+  from DUAL;
+
+END;
+/
+
+-- Create No Param Procedure
+CREATE or REPLACE
+PROCEDURE no_param_proc
+IS
+  v_status VARCHAR2 (255);
+BEGIN
+
+  SELECT 'success'
+  INTO v_status
+  from DUAL;
+
+END;
+
+/
+
+
+-- Call procedure
+
+DECLARE
+  p1 VARCHAR2(255) := 'jim.smith@somewhere.com';
+  p2 VARCHAR2(255) := 'bob.jackson@somewhere.com';
+  p3 VARCHAR2(255) := 'failure';
+BEGIN
+  swap_email_address (p1, p2, p3);
+  no_param_proc;
+  COMMIT;
+  DBMS_OUTPUT.PUT_LINE (p1 || ' <-> ' || p2 || ' (' || p3 || ')');
+END;
+/
+

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/scripts/order-init.sql
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/scripts/order-init.sql?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/scripts/order-init.sql (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/scripts/order-init.sql Thu Aug  7 16:21:46 2008
@@ -0,0 +1,35 @@
+-- HSQL DATABASE
+
+-- Dropping Tables
+
+DROP TABLE ORDERS;
+
+-- Creating Tables
+
+CREATE TABLE ORDERS (
+    ORD_ID               INT NOT NULL,
+    ORD_ACC_ID           INT NOT NULL,
+    ORD_DATE             TIMESTAMP NOT NULL,
+    ORD_CARD_TYPE        VARCHAR(255),
+    ORD_CARD_NUMBER      VARCHAR(255),
+    ORD_CARD_EXPIRY      VARCHAR(255),
+    ORD_STREET           VARCHAR(255),
+    ORD_CITY             VARCHAR(255),
+    ORD_PROVINCE         VARCHAR(255),
+    ORD_POSTAL_CODE      VARCHAR(255),
+    ORD_FAVOURITE_LINE   INT,
+    PRIMARY KEY (ORD_ID)
+);
+
+-- Creating Test Data
+
+INSERT INTO ORDERS VALUES (1, 1, '2003-02-15 8:15:00', 'VISA', '999999999999', '05/03', '11 This Street', 'Victoria', 'BC', 'C4B 4F4',2);
+INSERT INTO ORDERS VALUES (2, 4, '2003-02-15 8:15:00', 'MC', '888888888888', '06/03', '222 That Street', 'Edmonton', 'AB', 'X4K 5Y4',1);
+INSERT INTO ORDERS VALUES (3, 3, '2003-02-15 8:15:00', 'AMEX', '777777777777', '07/03', '333 Other Street', 'Regina', 'SK', 'Z4U 6Y4',2);
+INSERT INTO ORDERS VALUES (4, 2, '2003-02-15 8:15:00', 'MC', '666666666666', '08/03', '444 His Street', 'Toronto', 'ON', 'K4U 3S4',1);
+INSERT INTO ORDERS VALUES (5, 5, '2003-02-15 8:15:00', 'VISA', '555555555555', '09/03', '555 Her Street', 'Calgary', 'AB', 'J4J 7S4',2);
+INSERT INTO ORDERS VALUES (6, 5, '2003-02-15 8:15:00', 'VISA', '999999999999', '10/03', '6 Their Street', 'Victoria', 'BC', 'T4H 9G4',1);
+INSERT INTO ORDERS VALUES (7, 4, '2003-02-15 8:15:00', 'MC', '888888888888', '11/03', '77 Lucky Street', 'Edmonton', 'AB', 'R4A 0Z4',2);
+INSERT INTO ORDERS VALUES (8, 3, '2003-02-15 8:15:00', 'AMEX', '777777777777', '12/03', '888 Our Street', 'Regina', 'SK', 'S4S 7G4',1);
+INSERT INTO ORDERS VALUES (9, 2, '2003-02-15 8:15:00', 'MC', '666666666666', '01/04', '999 Your Street', 'Toronto', 'ON', 'G4D 9F4',2);
+INSERT INTO ORDERS VALUES (10, 1, '2003-02-15 8:15:00', 'VISA', '555555555555', '02/04', '99 Some Street', 'Calgary', 'AB', 'W4G 7A4',1);

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/scripts/person-init.sql
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/scripts/person-init.sql?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/scripts/person-init.sql (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/scripts/person-init.sql Thu Aug  7 16:21:46 2008
@@ -0,0 +1,27 @@
+-- HSQL DATABASE
+
+-- Dropping Tables
+
+DROP TABLE PERSON;
+
+-- Creating Tables
+
+create table person (
+  id int not null, 
+  first_name char(50) not null,
+  last_name char(50) not null,
+  primary key (id)
+);
+
+
+-- Creating Test Data
+
+insert into person values(1, 'Jeff', 'Jones');
+insert into person values(2, 'Matt', 'Jones');
+insert into person values(3, 'Amy', 'Jones');
+insert into person values(4, 'Scott', 'Jones');
+insert into person values(5, 'Wilma', 'Jones');
+insert into person values(6, 'Fred', 'Jones');
+insert into person values(7, 'Jeff', 'Smith');
+insert into person values(8, 'Matt', 'Smith');
+insert into person values(9, 'Amy', 'Smith');

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/Account.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/Account.java?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/Account.java (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/Account.java Thu Aug  7 16:21:46 2008
@@ -0,0 +1,127 @@
+package testdomain;
+
+import java.io.Serializable;
+import java.util.*;
+
+public class Account implements Serializable {
+
+  private int id;
+  private String firstName;
+  private String lastName;
+  private String emailAddress;
+  private int[] ids;
+  private int age;
+  private Date dateAdded;
+  private Account account;
+  private List accountList;
+  private boolean bannerOption;
+  private boolean cartOption;
+
+  public Account() {
+  }
+
+  public Account(int id) {
+    this.id = id;
+  }
+
+  public int getId() {
+    return id;
+  }
+
+  public void setId(int id) {
+    this.id = id;
+  }
+
+  public int[] getIds() {
+    return ids;
+  }
+
+  public void setIds(int[] ids) {
+    this.ids = ids;
+  }
+
+  /**
+   * @return Returns the age.
+   */
+  public int getAge() {
+    return age;
+  }
+
+  /**
+   * @param age The age to set.
+   */
+  public void setAge(int age) {
+    this.age = age;
+  }
+
+  /**
+   * @return Returns the dateAdded.
+   */
+  public Date getDateAdded() {
+    return dateAdded;
+  }
+
+  /**
+   * @param dateAdded The dateAdded to set.
+   */
+  public void setDateAdded(Date dateAdded) {
+    this.dateAdded = dateAdded;
+  }
+
+  public String getFirstName() {
+    return firstName;
+  }
+
+  public void setFirstName(String firstName) {
+    this.firstName = firstName;
+  }
+
+  public String getLastName() {
+    return lastName;
+  }
+
+  public void setLastName(String lastName) {
+    this.lastName = lastName;
+  }
+
+  public String getEmailAddress() {
+    return emailAddress;
+  }
+
+  public void setEmailAddress(String emailAddress) {
+    this.emailAddress = emailAddress;
+  }
+
+  public Account getAccount() {
+    return account;
+  }
+
+  public void setAccount(Account account) {
+    this.account = account;
+  }
+
+  public List getAccountList() {
+    return accountList;
+  }
+
+  public void setAccountList(List accountList) {
+    this.accountList = accountList;
+  }
+
+  public boolean isBannerOption() {
+    return bannerOption;
+  }
+
+  public void setBannerOption(boolean bannerOption) {
+    this.bannerOption = bannerOption;
+  }
+
+
+  public boolean isCartOption() {
+    return cartOption;
+  }
+
+  public void setCartOption(boolean cartOption) {
+    this.cartOption = cartOption;
+  }
+}

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/ArticleIndex.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/ArticleIndex.java?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/ArticleIndex.java (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/ArticleIndex.java Thu Aug  7 16:21:46 2008
@@ -0,0 +1,38 @@
+package testdomain;
+
+import java.io.Serializable;
+import java.util.List;
+
+public class ArticleIndex implements Serializable {
+
+  private String categoryTitle;
+  private List topics;
+
+  /**
+   * @return Returns the categoryTitle.
+   */
+  public String getCategoryTitle() {
+    return categoryTitle;
+  }
+
+  /**
+   * @param categoryTitle The categoryTitle to set.
+   */
+  public void setCategoryTitle(String categoryTitle) {
+    this.categoryTitle = categoryTitle;
+  }
+
+  /**
+   * @return Returns the topics.
+   */
+  public List getTopics() {
+    return topics;
+  }
+
+  /**
+   * @param topics The topics to set.
+   */
+  public void setTopics(List topics) {
+    this.topics = topics;
+  }
+}
\ No newline at end of file

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/ArticleIndexDenorm.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/ArticleIndexDenorm.java?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/ArticleIndexDenorm.java (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/ArticleIndexDenorm.java Thu Aug  7 16:21:46 2008
@@ -0,0 +1,57 @@
+package testdomain;
+
+import java.io.Serializable;
+
+/**
+ * Denormalized version of an toy ArticleIndex object.
+ */
+public class ArticleIndexDenorm implements Serializable {
+
+  private String categoryTitle;
+
+  private String topicTitle;
+
+  private String description;
+
+  /**
+   * @return Returns the categoryTitle.
+   */
+  public String getCategoryTitle() {
+    return categoryTitle;
+  }
+
+  /**
+   * @param categoryTitle The categoryTitle to set.
+   */
+  public void setCategoryTitle(String categoryTitle) {
+    this.categoryTitle = categoryTitle;
+  }
+
+  /**
+   * @return Returns the description.
+   */
+  public String getDescription() {
+    return description;
+  }
+
+  /**
+   * @param description The description to set.
+   */
+  public void setDescription(String description) {
+    this.description = description;
+  }
+
+  /**
+   * @return Returns the topicTitle.
+   */
+  public String getTopicTitle() {
+    return topicTitle;
+  }
+
+  /**
+   * @param topicTitle The topicTitle to set.
+   */
+  public void setTopicTitle(String topicTitle) {
+    this.topicTitle = topicTitle;
+	}
+}
\ No newline at end of file

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/Book.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/Book.java?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/Book.java (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/Book.java Thu Aug  7 16:21:46 2008
@@ -0,0 +1,22 @@
+package testdomain;
+
+/**
+ * Created by IntelliJ IDEA.
+ * User: cbegin
+ * Date: May 14, 2005
+ * Time: 1:39:55 AM
+ * To change this template use File | Settings | File Templates.
+ */
+public class Book extends Document {
+
+  private Integer pages;
+
+  public Integer getPages() {
+    return pages;
+  }
+
+  public void setPages(Integer pages) {
+    this.pages = pages;
+  }
+
+}

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/Category.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/Category.java?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/Category.java (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/Category.java Thu Aug  7 16:21:46 2008
@@ -0,0 +1,53 @@
+package testdomain;
+
+import java.io.Serializable;
+import java.util.List;
+
+public class Category implements Serializable {
+
+  private String categoryId;
+  private Category parentCategory;
+  private String name;
+  private String description;
+  private List productList;
+
+  public String getCategoryId() {
+    return categoryId;
+  }
+
+  public void setCategoryId(String categoryId) {
+    this.categoryId = categoryId;
+  }
+
+  public String getName() {
+    return name;
+  }
+
+  public void setName(String name) {
+    this.name = name;
+  }
+
+  public String getDescription() {
+    return description;
+  }
+
+  public void setDescription(String description) {
+    this.description = description;
+  }
+
+  public List getProductList() {
+    return productList;
+  }
+
+  public void setProductList(List productList) {
+    this.productList = productList;
+  }
+
+  public Category getParentCategory() {
+    return parentCategory;
+  }
+
+  public void setParentCategory(Category parentCategory) {
+    this.parentCategory = parentCategory;
+  }
+}

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/ComplexBean.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/ComplexBean.java?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/ComplexBean.java (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/ComplexBean.java Thu Aug  7 16:21:46 2008
@@ -0,0 +1,18 @@
+package testdomain;
+
+import java.io.Serializable;
+import java.util.Map;
+
+public class ComplexBean implements Serializable {
+
+  private Map map;
+
+  public Map getMap() {
+    return map;
+  }
+
+  public void setMap(Map map) {
+    this.map = map;
+  }
+
+}

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/DocType.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/DocType.java?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/DocType.java (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/DocType.java Thu Aug  7 16:21:46 2008
@@ -0,0 +1,5 @@
+package testdomain;
+
+public enum DocType {
+  BOOK, NEWSPAPER, BROADSHEET, MONOGRAPH
+}

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/Document.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/Document.java?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/Document.java (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/Document.java Thu Aug  7 16:21:46 2008
@@ -0,0 +1,44 @@
+package testdomain;
+
+import java.util.List;
+
+public class Document {
+
+  private int id;
+  private String title;
+  private DocType type;
+  private List attributes;
+
+  public int getId() {
+    return id;
+  }
+
+  public void setId(int id) {
+    this.id = id;
+  }
+
+  public String getTitle() {
+    return title;
+  }
+
+  public void setTitle(String title) {
+    this.title = title;
+  }
+
+  public DocType getType() {
+    return type;
+  }
+
+  public void setType(DocType type) {
+    this.type = type;
+  }
+
+  public List getAttributes() {
+    return attributes;
+  }
+
+  public void setAttributes(List attributes) {
+    this.attributes = attributes;
+  }
+
+}

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/FieldAccount.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/FieldAccount.java?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/FieldAccount.java (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/FieldAccount.java Thu Aug  7 16:21:46 2008
@@ -0,0 +1,52 @@
+package testdomain;
+
+import java.io.Serializable;
+
+public class FieldAccount implements Serializable {
+
+  private int id;
+  private String firstName;
+  private String lastName;
+  private String emailAddress;
+  private FieldAccount account;
+
+  public int id() {
+    return id;
+  }
+
+  public void id(int id) {
+    this.id = id;
+  }
+
+  public String firstName() {
+    return firstName;
+  }
+
+  public void firstName(String firstName) {
+    this.firstName = firstName;
+  }
+
+  public String lastName() {
+    return lastName;
+  }
+
+  public void lastName(String lastName) {
+    this.lastName = lastName;
+  }
+
+  public String emailAddress() {
+    return emailAddress;
+  }
+
+  public void emailAddress(String emailAddress) {
+    this.emailAddress = emailAddress;
+  }
+
+  public FieldAccount account() {
+    return account;
+  }
+
+  public void account(FieldAccount account) {
+    this.account = account;
+  }
+}

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/IItem.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/IItem.java?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/IItem.java (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/IItem.java Thu Aug  7 16:21:46 2008
@@ -0,0 +1,54 @@
+package testdomain;
+
+import java.math.BigDecimal;
+
+/**
+ * Used in testing the ResultObjectFactory
+ *
+ * @author Jeff Butler
+ */
+public interface IItem {
+  String getAttribute1();
+
+  void setAttribute1(String attribute1);
+
+  String getAttribute2();
+
+  void setAttribute2(String attribute2);
+
+  String getAttribute3();
+
+  void setAttribute3(String attribute3);
+
+  String getAttribute4();
+
+  void setAttribute4(String attribute4);
+
+  String getAttribute5();
+
+  void setAttribute5(String attribute5);
+
+  String getItemId();
+
+  void setItemId(String itemId);
+
+  BigDecimal getListPrice();
+
+  void setListPrice(BigDecimal listPrice);
+
+  String getProductId();
+
+  void setProductId(String productId);
+
+  String getStatus();
+
+  void setStatus(String status);
+
+  ISupplier getSupplier();
+
+  void setSupplier(ISupplier supplier);
+
+  BigDecimal getUnitCost();
+
+  void setUnitCost(BigDecimal unitCost);
+}

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/IItemImpl.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/IItemImpl.java?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/IItemImpl.java (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/IItemImpl.java Thu Aug  7 16:21:46 2008
@@ -0,0 +1,118 @@
+package testdomain;
+
+import java.math.BigDecimal;
+
+/**
+ * Used in testing the ResultObjectFactory
+ *
+ * @author Jeff Butler
+ */
+public class IItemImpl implements IItem {
+  private String itemId;
+  private String productId;
+  private BigDecimal listPrice;
+  private BigDecimal unitCost;
+  private String status;
+  private String attribute1;
+  private String attribute2;
+  private String attribute3;
+  private String attribute4;
+  private String attribute5;
+  private ISupplier supplier;
+
+  /**
+   *
+   */
+  public IItemImpl() {
+    super();
+  }
+
+  public String getAttribute1() {
+    return attribute1;
+  }
+
+  public void setAttribute1(String attribute1) {
+    this.attribute1 = attribute1;
+  }
+
+  public String getAttribute2() {
+    return attribute2;
+  }
+
+  public void setAttribute2(String attribute2) {
+    this.attribute2 = attribute2;
+  }
+
+  public String getAttribute3() {
+    return attribute3;
+  }
+
+  public void setAttribute3(String attribute3) {
+    this.attribute3 = attribute3;
+  }
+
+  public String getAttribute4() {
+    return attribute4;
+  }
+
+  public void setAttribute4(String attribute4) {
+    this.attribute4 = attribute4;
+  }
+
+  public String getAttribute5() {
+    return attribute5;
+  }
+
+  public void setAttribute5(String attribute5) {
+    this.attribute5 = attribute5;
+  }
+
+  public String getItemId() {
+    return itemId;
+  }
+
+  public void setItemId(String itemId) {
+    this.itemId = itemId;
+  }
+
+  public BigDecimal getListPrice() {
+    return listPrice;
+  }
+
+  public void setListPrice(BigDecimal listPrice) {
+    this.listPrice = listPrice;
+  }
+
+  public String getProductId() {
+    return productId;
+  }
+
+  public void setProductId(String productId) {
+    this.productId = productId;
+  }
+
+  public String getStatus() {
+    return status;
+  }
+
+  public void setStatus(String status) {
+    this.status = status;
+  }
+
+  public ISupplier getSupplier() {
+    return supplier;
+  }
+
+  public void setSupplier(ISupplier supplier) {
+    this.supplier = supplier;
+  }
+
+  public BigDecimal getUnitCost() {
+    return unitCost;
+  }
+
+  public void setUnitCost(BigDecimal unitCost) {
+    this.unitCost = unitCost;
+  }
+
+}

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/ISupplier.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/ISupplier.java?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/ISupplier.java (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/ISupplier.java Thu Aug  7 16:21:46 2008
@@ -0,0 +1,41 @@
+package testdomain;
+
+/**
+ * Used in testing the ResultObjectFactory
+ *
+ * @author Jeff Butler
+ */
+public interface ISupplier extends ISupplierKey {
+
+  String getAddressLine1();
+
+  void setAddressLine1(String addressLine1);
+
+  String getAddressLine2();
+
+  void setAddressLine2(String addressLine2);
+
+  String getCity();
+
+  void setCity(String city);
+
+  String getName();
+
+  void setName(String name);
+
+  String getPhone();
+
+  void setPhone(String phone);
+
+  String getState();
+
+  void setState(String state);
+
+  String getStatus();
+
+  void setStatus(String status);
+
+  String getZip();
+
+  void setZip(String zip);
+}

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/ISupplierImpl.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/ISupplierImpl.java?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/ISupplierImpl.java (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/ISupplierImpl.java Thu Aug  7 16:21:46 2008
@@ -0,0 +1,89 @@
+package testdomain;
+
+/**
+ * Used in testing the ResultObjectFactory
+ *
+ * @author Jeff Butler
+ */
+public class ISupplierImpl extends ISupplierKeyImpl implements ISupplier {
+  private String name;
+  private String status;
+  private String addressLine1;
+  private String addressLine2;
+  private String city;
+  private String state;
+  private String zip;
+  private String phone;
+
+  /**
+   *
+   */
+  public ISupplierImpl() {
+    super();
+  }
+
+  public String getAddressLine1() {
+    return addressLine1;
+  }
+
+  public void setAddressLine1(String addressLine1) {
+    this.addressLine1 = addressLine1;
+  }
+
+  public String getAddressLine2() {
+    return addressLine2;
+  }
+
+  public void setAddressLine2(String addressLine2) {
+    this.addressLine2 = addressLine2;
+  }
+
+  public String getCity() {
+    return city;
+  }
+
+  public void setCity(String city) {
+    this.city = city;
+  }
+
+  public String getName() {
+    return name;
+  }
+
+  public void setName(String name) {
+    this.name = name;
+  }
+
+  public String getPhone() {
+    return phone;
+  }
+
+  public void setPhone(String phone) {
+    this.phone = phone;
+  }
+
+  public String getState() {
+    return state;
+  }
+
+  public void setState(String state) {
+    this.state = state;
+  }
+
+  public String getStatus() {
+    return status;
+  }
+
+  public void setStatus(String status) {
+    this.status = status;
+  }
+
+  public String getZip() {
+    return zip;
+  }
+
+  public void setZip(String zip) {
+    this.zip = zip;
+  }
+
+}

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/ISupplierKey.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/ISupplierKey.java?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/ISupplierKey.java (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/ISupplierKey.java Thu Aug  7 16:21:46 2008
@@ -0,0 +1,12 @@
+package testdomain;
+
+/**
+ * Used in testing the ResultObjectFactory
+ *
+ * @author Jeff Butler
+ */
+public interface ISupplierKey {
+  Integer getSupplierId();
+
+  void setSupplierId(Integer supplierId);
+}

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/ISupplierKeyImpl.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/ISupplierKeyImpl.java?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/ISupplierKeyImpl.java (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/ISupplierKeyImpl.java Thu Aug  7 16:21:46 2008
@@ -0,0 +1,27 @@
+package testdomain;
+
+/**
+ * Used in testing the ResultObjectFactory
+ *
+ * @author Jeff Butler
+ */
+public class ISupplierKeyImpl implements ISupplierKey {
+
+  private Integer supplierId;
+
+  /**
+   *
+   */
+  public ISupplierKeyImpl() {
+    super();
+  }
+
+  public Integer getSupplierId() {
+    return supplierId;
+  }
+
+  public void setSupplierId(Integer supplierId) {
+    this.supplierId = supplierId;
+  }
+
+}

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/Item.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/Item.java?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/Item.java (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/Item.java Thu Aug  7 16:21:46 2008
@@ -0,0 +1,80 @@
+package testdomain;
+
+import java.io.Serializable;
+import java.math.BigDecimal;
+
+public class Item implements Serializable {
+
+  private String itemId;
+  private String productId;
+  private BigDecimal listPrice;
+  private BigDecimal unitCost;
+  private int supplierId;
+  private String status;
+  private String attribute1;
+  private int quantity;
+
+  public String getItemId() {
+    return itemId;
+  }
+
+  public void setItemId(String itemId) {
+    this.itemId = itemId;
+  }
+
+  public String getProductId() {
+    return productId;
+  }
+
+  public void setProductId(String productId) {
+    this.productId = productId;
+  }
+
+  public BigDecimal getListPrice() {
+    return listPrice;
+  }
+
+  public void setListPrice(BigDecimal listPrice) {
+    this.listPrice = listPrice;
+  }
+
+  public BigDecimal getUnitCost() {
+    return unitCost;
+  }
+
+  public void setUnitCost(BigDecimal unitCost) {
+    this.unitCost = unitCost;
+  }
+
+  public int getSupplierId() {
+    return supplierId;
+  }
+
+  public void setSupplierId(int supplierId) {
+    this.supplierId = supplierId;
+  }
+
+  public String getStatus() {
+    return status;
+  }
+
+  public void setStatus(String status) {
+    this.status = status;
+  }
+
+  public String getAttribute1() {
+    return attribute1;
+  }
+
+  public void setAttribute1(String attribute1) {
+    this.attribute1 = attribute1;
+  }
+
+  public int getQuantity() {
+    return quantity;
+  }
+
+  public void setQuantity(int quantity) {
+    this.quantity = quantity;
+  }
+}

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/LineItem.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/LineItem.java?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/LineItem.java (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/LineItem.java Thu Aug  7 16:21:46 2008
@@ -0,0 +1,54 @@
+package testdomain;
+
+import java.io.Serializable;
+import java.math.BigDecimal;
+
+public class LineItem implements Serializable {
+
+  private int id;
+  private int orderId;
+  private String itemCode;
+  private int quantity;
+  private BigDecimal price;
+
+  public int getId() {
+    return id;
+  }
+
+  public void setId(int id) {
+    this.id = id;
+  }
+
+  public int getOrderId() {
+    return orderId;
+  }
+
+  public void setOrderId(int orderId) {
+    this.orderId = orderId;
+  }
+
+  public String getItemCode() {
+    return itemCode;
+  }
+
+  public void setItemCode(String itemCode) {
+    this.itemCode = itemCode;
+  }
+
+  public int getQuantity() {
+    return quantity;
+  }
+
+  public void setQuantity(int quantity) {
+    this.quantity = quantity;
+  }
+
+  public BigDecimal getPrice() {
+    return price;
+  }
+
+  public void setPrice(BigDecimal price) {
+    this.price = price;
+  }
+
+}

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/Magazine.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/Magazine.java?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/Magazine.java (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/Magazine.java Thu Aug  7 16:21:46 2008
@@ -0,0 +1,22 @@
+package testdomain;
+
+/**
+ * Created by IntelliJ IDEA.
+ * User: cbegin
+ * Date: May 14, 2005
+ * Time: 1:40:08 AM
+ * To change this template use File | Settings | File Templates.
+ */
+public class Magazine extends Document {
+
+  private String city;
+
+  public String getCity() {
+    return city;
+  }
+
+  public void setCity(String city) {
+    this.city = city;
+  }
+
+}

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/MyBean.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/MyBean.java?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/MyBean.java (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/MyBean.java Thu Aug  7 16:21:46 2008
@@ -0,0 +1,42 @@
+package testdomain;
+
+import java.util.List;
+
+/**
+ * Created by IntelliJ IDEA.
+ * User: bgoodin
+ * Date: May 25, 2005
+ * Time: 6:57:01 AM
+ * To change this template use File | Settings | File Templates.
+ */
+public class MyBean {
+
+  public List getMyList() {
+    return myList;
+  }
+
+  public void setMyList(List myList) {
+    this.myList = myList;
+  }
+
+  public Object[] getMyArray() {
+    return myArray;
+  }
+
+  public void setMyArray(Object[] myArray) {
+    this.myArray = myArray;
+  }
+
+  public int[] getIntArray() {
+    return intArray;
+  }
+
+  public void setIntArray(int[] intArray) {
+    this.intArray = intArray;
+  }
+
+  private List myList;
+  private Object[] myArray;
+  private int[] intArray;
+
+}

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/NestedIterateParameterObject.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/NestedIterateParameterObject.java?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/NestedIterateParameterObject.java (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/NestedIterateParameterObject.java Thu Aug  7 16:21:46 2008
@@ -0,0 +1,73 @@
+package testdomain;
+
+import java.util.*;
+
+public class NestedIterateParameterObject {
+
+  private List idList;
+  private List lastNames;
+  private List firstNames;
+  private List orConditions;
+
+  public NestedIterateParameterObject() {
+    super();
+    idList = new ArrayList();
+    orConditions = new ArrayList();
+    lastNames = new ArrayList();
+    firstNames = new ArrayList();
+  }
+
+  public List getIdList() {
+    return idList;
+  }
+
+  public void addId(Integer id) {
+    idList.add(id);
+  }
+
+
+  public List getOrConditions() {
+    return orConditions;
+  }
+
+  public void addOrCondition(AndCondition andCondition) {
+    orConditions.add(andCondition);
+  }
+
+  public static class AndCondition {
+    private List conditions;
+
+    public AndCondition() {
+      super();
+      conditions = new ArrayList();
+    }
+
+    public List getConditions() {
+      return conditions;
+    }
+
+    public void addCondition(String condition, Object value, Boolean include) {
+      Map map = new HashMap();
+      map.put("condition", condition);
+      map.put("value", value);
+      map.put("include", include);
+      conditions.add(map);
+    }
+  }
+
+  public List getFirstNames() {
+    return firstNames;
+  }
+
+  public void addFirstName(String firstName) {
+    firstNames.add(firstName);
+  }
+
+  public List getLastNames() {
+    return lastNames;
+  }
+
+  public void addLastName(String lastName) {
+    lastNames.add(lastName);
+  }
+}

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/Order.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/Order.java?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/Order.java (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/Order.java Thu Aug  7 16:21:46 2008
@@ -0,0 +1,134 @@
+package testdomain;
+
+import java.io.Serializable;
+import java.util.*;
+
+public class Order implements Serializable {
+
+  private int id;
+  private Account account;
+  private Date date;
+  private String cardType;
+  private String cardNumber;
+  private String cardExpiry;
+  private String street;
+  private String city;
+  private String province;
+  private String postalCode;
+  private Collection lineItems;
+  private LineItem[] lineItemArray;
+  private LineItem favouriteLineItem;
+
+  public int getId() {
+    return id;
+  }
+
+  public void setId(int id) {
+    this.id = id;
+  }
+
+  public Account getAccount() {
+    return account;
+  }
+
+  public void setAccount(Account account) {
+    this.account = account;
+  }
+
+  public Date getDate() {
+    return date;
+  }
+
+  public void setDate(Date date) {
+    this.date = date;
+  }
+
+  public String getCardType() {
+    return cardType;
+  }
+
+  public void setCardType(String cardType) {
+    this.cardType = cardType;
+  }
+
+  public String getCardNumber() {
+    return cardNumber;
+  }
+
+  public void setCardNumber(String cardNumber) {
+    this.cardNumber = cardNumber;
+  }
+
+  public String getCardExpiry() {
+    return cardExpiry;
+  }
+
+  public void setCardExpiry(String cardExpiry) {
+    this.cardExpiry = cardExpiry;
+  }
+
+  public String getStreet() {
+    return street;
+  }
+
+  public void setStreet(String street) {
+    this.street = street;
+  }
+
+  public String getCity() {
+    return city;
+  }
+
+  public void setCity(String city) {
+    this.city = city;
+  }
+
+  public String getProvince() {
+    return province;
+  }
+
+  public void setProvince(String province) {
+    this.province = province;
+  }
+
+  public String getPostalCode() {
+    return postalCode;
+  }
+
+  public void setPostalCode(String postalCode) {
+    this.postalCode = postalCode;
+  }
+
+  public List getLineItemsList() {
+    return (List) lineItems;
+  }
+
+  public void setLineItemsList(List lineItems) {
+    this.lineItems = lineItems;
+  }
+
+  public Collection getLineItems() {
+    return lineItems;
+  }
+
+  public void setLineItems(Collection lineItems) {
+    this.lineItems = lineItems;
+  }
+
+  public LineItem getFavouriteLineItem() {
+    return favouriteLineItem;
+  }
+
+  public void setFavouriteLineItem(LineItem favouriteLineItem) {
+    this.favouriteLineItem = favouriteLineItem;
+  }
+
+  public LineItem[] getLineItemArray() {
+    return lineItemArray;
+  }
+
+  public void setLineItemArray(LineItem[] lineItemArray) {
+    this.lineItemArray = lineItemArray;
+  }
+
+}

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/Person.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/Person.java?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/Person.java (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/Person.java Thu Aug  7 16:21:46 2008
@@ -0,0 +1,45 @@
+package testdomain;
+
+public class Person {
+  private Integer id;
+
+  private String firstName;
+
+  private String lastName;
+
+  public String getFirstName() {
+    return firstName;
+  }
+
+  public void setFirstName(String firstName) {
+    this.firstName = firstName;
+  }
+
+  public Integer getId() {
+    return id;
+  }
+
+  public void setId(Integer id) {
+    this.id = id;
+  }
+
+  public String getLastName() {
+    return lastName;
+  }
+
+  public void setLastName(String lastName) {
+    this.lastName = lastName;
+  }
+
+  public String toString() {
+    StringBuffer sb = new StringBuffer();
+    sb.append("id: ");
+    sb.append(id);
+    sb.append(", firstName: ");
+    sb.append(firstName);
+    sb.append(", lastName: ");
+    sb.append(lastName);
+
+    return sb.toString();
+  }
+}

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/PersonDocument.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/PersonDocument.java?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/PersonDocument.java (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/PersonDocument.java Thu Aug  7 16:21:46 2008
@@ -0,0 +1,43 @@
+package testdomain;
+
+/**
+ * @author Jeff Butler
+ */
+public class PersonDocument {
+
+  private Integer id;
+  private String name;
+  private Document favoriteDocument;
+
+  /**
+   *
+   */
+  public PersonDocument() {
+    super();
+  }
+
+  public Document getFavoriteDocument() {
+    return favoriteDocument;
+  }
+
+  public void setFavoriteDocument(Document favoriteDocument) {
+    this.favoriteDocument = favoriteDocument;
+  }
+
+  public Integer getId() {
+    return id;
+  }
+
+  public void setId(Integer id) {
+    this.id = id;
+  }
+
+  public String getName() {
+    return name;
+  }
+
+  public void setName(String name) {
+    this.name = name;
+  }
+
+}

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/PrivateAccount.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/PrivateAccount.java?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/PrivateAccount.java (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/PrivateAccount.java Thu Aug  7 16:21:46 2008
@@ -0,0 +1,123 @@
+package testdomain;
+
+import java.io.Serializable;
+import java.util.*;
+
+public class PrivateAccount implements Serializable {
+
+  private int id;
+  private String firstName;
+  private String lastName;
+  private String emailAddress;
+  private int[] ids;
+  private int age;
+  private Date dateAdded;
+  private PrivateAccount account;
+  private List accountList;
+  private boolean bannerOption;
+  private boolean cartOption;
+
+  private PrivateAccount() {
+  }
+
+  public int getId() {
+    return id;
+  }
+
+  public void setId(int id) {
+    this.id = id;
+  }
+
+  public int[] getIds() {
+    return ids;
+  }
+
+  public void setIds(int[] ids) {
+    this.ids = ids;
+  }
+
+  /**
+   * @return Returns the age.
+   */
+  public int getAge() {
+    return age;
+  }
+
+  /**
+   * @param age The age to set.
+   */
+  public void setAge(int age) {
+    this.age = age;
+  }
+
+  /**
+   * @return Returns the dateAdded.
+   */
+  public Date getDateAdded() {
+    return dateAdded;
+  }
+
+  /**
+   * @param dateAdded The dateAdded to set.
+   */
+  public void setDateAdded(Date dateAdded) {
+    this.dateAdded = dateAdded;
+  }
+
+  public String getFirstName() {
+    return firstName;
+  }
+
+  public void setFirstName(String firstName) {
+    this.firstName = firstName;
+  }
+
+  public String getLastName() {
+    return lastName;
+  }
+
+  public void setLastName(String lastName) {
+    this.lastName = lastName;
+  }
+
+  public String getEmailAddress() {
+    return emailAddress;
+  }
+
+  public void setEmailAddress(String emailAddress) {
+    this.emailAddress = emailAddress;
+  }
+
+  public PrivateAccount getAccount() {
+    return account;
+  }
+
+  public void setAccount(PrivateAccount account) {
+    this.account = account;
+  }
+
+  public List getAccountList() {
+    return accountList;
+  }
+
+  public void setAccountList(List accountList) {
+    this.accountList = accountList;
+  }
+
+  public boolean isBannerOption() {
+    return bannerOption;
+  }
+
+  public void setBannerOption(boolean bannerOption) {
+    this.bannerOption = bannerOption;
+  }
+
+
+  public boolean isCartOption() {
+    return cartOption;
+  }
+
+  public void setCartOption(boolean cartOption) {
+    this.cartOption = cartOption;
+  }
+}

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/PrivateBook.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/PrivateBook.java?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/PrivateBook.java (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/PrivateBook.java Thu Aug  7 16:21:46 2008
@@ -0,0 +1,22 @@
+package testdomain;
+
+/**
+ * Created by IntelliJ IDEA.
+ * User: cbegin
+ * Date: May 14, 2005
+ * Time: 1:39:55 AM
+ * To change this template use File | Settings | File Templates.
+ */
+public class PrivateBook extends Document {
+
+  private Integer pages;
+
+  private Integer getPages() {
+    return pages;
+  }
+
+  private void setPages(Integer pages) {
+    this.pages = pages;
+  }
+
+}

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/ProcBean.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/ProcBean.java?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/ProcBean.java (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/ProcBean.java Thu Aug  7 16:21:46 2008
@@ -0,0 +1,35 @@
+package testdomain;
+
+import java.io.Serializable;
+
+public class ProcBean implements Serializable {
+
+  private String email1;
+  private String email2;
+  private String status;
+
+  public String getEmail1() {
+    return email1;
+  }
+
+  public void setEmail1(String email1) {
+    this.email1 = email1;
+  }
+
+  public String getEmail2() {
+    return email2;
+  }
+
+  public void setEmail2(String email2) {
+    this.email2 = email2;
+  }
+
+  public String getStatus() {
+    return status;
+  }
+
+  public void setStatus(String status) {
+    this.status = status;
+  }
+
+}

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/Product.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/Product.java?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/Product.java (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/Product.java Thu Aug  7 16:21:46 2008
@@ -0,0 +1,53 @@
+package testdomain;
+
+import java.io.Serializable;
+import java.util.List;
+
+public class Product implements Serializable {
+
+  private String productId;
+  private String categoryId;
+  private String name;
+  private String description;
+  private List itemList;
+
+  public String getProductId() {
+    return productId;
+  }
+
+  public void setProductId(String productId) {
+    this.productId = productId;
+  }
+
+  public String getCategoryId() {
+    return categoryId;
+  }
+
+  public void setCategoryId(String categoryId) {
+    this.categoryId = categoryId;
+  }
+
+  public String getName() {
+    return name;
+  }
+
+  public void setName(String name) {
+    this.name = name;
+  }
+
+  public String getDescription() {
+    return description;
+  }
+
+  public void setDescription(String description) {
+    this.description = description;
+  }
+
+  public List getItemList() {
+    return itemList;
+  }
+
+  public void setItemList(List itemList) {
+    this.itemList = itemList;
+  }
+}

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/SimpleNestedParameterObject.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/SimpleNestedParameterObject.java?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/SimpleNestedParameterObject.java (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/SimpleNestedParameterObject.java Thu Aug  7 16:21:46 2008
@@ -0,0 +1,26 @@
+package testdomain;
+
+import java.util.List;
+
+public class SimpleNestedParameterObject {
+
+  private NestedIterateParameterObject nestedIterateParameterObject;
+  private List nestedList;
+
+  public List getNestedList() {
+    return nestedList;
+  }
+
+  public void setNestedList(List nestedList) {
+    this.nestedList = nestedList;
+  }
+
+  public NestedIterateParameterObject getNestedIterateParameterObject() {
+    return nestedIterateParameterObject;
+  }
+
+  public void setNestedIterateParameterObject(NestedIterateParameterObject nestedIterateParameterObject) {
+    this.nestedIterateParameterObject = nestedIterateParameterObject;
+  }
+
+}

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/SuperAccount.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/SuperAccount.java?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/SuperAccount.java (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/SuperAccount.java Thu Aug  7 16:21:46 2008
@@ -0,0 +1,6 @@
+package testdomain;
+
+import java.io.Serializable;
+
+public class SuperAccount extends Account implements Serializable {
+}

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/Topic.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/Topic.java?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/Topic.java (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/Topic.java Thu Aug  7 16:21:46 2008
@@ -0,0 +1,38 @@
+package testdomain;
+
+import java.io.Serializable;
+import java.util.List;
+
+public class Topic implements Serializable {
+
+  private String topicTitle;
+  private List descriptionList;
+
+  /**
+   * @return Returns the descriptionList.
+   */
+  public List getDescriptionList() {
+    return descriptionList;
+  }
+
+  /**
+   * @param descriptionList The descriptionList to set.
+   */
+  public void setDescriptionList(List description) {
+    this.descriptionList = description;
+  }
+
+  /**
+   * @return Returns the topicTitle.
+   */
+  public String getTopicTitle() {
+    return topicTitle;
+  }
+
+  /**
+   * @param topicTitle The topicTitle to set.
+   */
+  public void setTopicTitle(String topicTitle) {
+    this.topicTitle = topicTitle;
+  }
+}
\ No newline at end of file

Added: ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/TopicDescription.java
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/TopicDescription.java?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/TopicDescription.java (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-compat/src/test/java/testdomain/TopicDescription.java Thu Aug  7 16:21:46 2008
@@ -0,0 +1,22 @@
+package testdomain;
+
+import java.io.Serializable;
+
+public class TopicDescription implements Serializable {
+
+  private String description;
+
+  /**
+   * @return Returns the topicDescription.
+   */
+  public String getDescription() {
+    return description;
+  }
+
+  /**
+   * @param topicDescription The topicDescription to set.
+   */
+  public void setDescription(String description) {
+    this.description = description;
+  }
+}
\ No newline at end of file

Added: ibatis/trunk/java/ibatis-3/ibatis-3-core/pom.xml
URL: http://svn.apache.org/viewvc/ibatis/trunk/java/ibatis-3/ibatis-3-core/pom.xml?rev=683745&view=auto
==============================================================================
--- ibatis/trunk/java/ibatis-3/ibatis-3-core/pom.xml (added)
+++ ibatis/trunk/java/ibatis-3/ibatis-3-core/pom.xml Thu Aug  7 16:21:46 2008
@@ -0,0 +1,88 @@
+<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+  xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
+  <parent>
+    <groupId>org.apache.ibatis</groupId>
+    <artifactId>ibatis-3</artifactId>
+    <version>3.0-SNAPSHOT</version>
+  </parent>
+  <modelVersion>4.0.0</modelVersion>
+  <artifactId>ibatis-3-core</artifactId>
+  <packaging>jar</packaging>
+  <name>ibatis-3-core</name>
+  <url>http://maven.apache.org</url>
+  <build>
+    <plugins>
+      <plugin>
+        <groupId>org.apache.maven.plugins</groupId>
+        <artifactId>maven-compiler-plugin</artifactId>
+        <version>2.0.2</version>
+        <configuration>
+          <source>1.5</source>
+          <target>1.5</target>
+        </configuration>
+      </plugin>
+    </plugins>
+    <resources>
+      <resource>
+        <directory>src/main/java</directory>
+      </resource>
+    </resources>
+    <testResources>
+      <testResource>
+        <directory>src/test/java</directory>
+      </testResource>
+    </testResources>
+  </build>
+  <dependencies>
+    <dependency>
+      <groupId>log4j</groupId>
+      <artifactId>log4j</artifactId>
+      <version>1.2.13</version>
+      <scope>compile</scope>
+    </dependency>
+    <dependency>
+      <groupId>commons-logging</groupId>
+      <artifactId>commons-logging</artifactId>
+      <version>1.1.1</version>
+      <scope>compile</scope>
+    </dependency>
+    <dependency>
+      <groupId>cglib</groupId>
+      <artifactId>cglib</artifactId>
+      <version>2.1_3</version>
+      <scope>compile</scope>
+    </dependency>
+    <!-- Test dependencies -->
+    <dependency>
+      <groupId>junit</groupId>
+      <artifactId>junit</artifactId>
+      <version>4.3.1</version>
+      <scope>test</scope>
+    </dependency>
+    <dependency>
+      <groupId>hsqldb</groupId>
+      <artifactId>hsqldb</artifactId>
+      <version>1.8.0.1</version>
+      <scope>test</scope>
+    </dependency>
+    <dependency>
+      <groupId>org.apache.derby</groupId>
+      <artifactId>derby</artifactId>
+      <version>10.3.2.1</version>
+      <scope>test</scope>
+    </dependency>
+    <dependency>
+      <groupId>org.jmock</groupId>
+      <artifactId>jmock-junit4</artifactId>
+      <version>2.1.0</version>
+      <scope>test</scope>
+    </dependency>
+    <dependency>
+      <groupId>org.jmock</groupId>
+      <artifactId>jmock-legacy</artifactId>
+      <version>2.1.0</version>
+      <scope>test</scope>
+    </dependency>
+  </dependencies>
+
+</project>