How to use JDBC and transactions in Spring with BTM
This howto is intended for developers using Spring wanting to take advantage of distributed transactions when using JDBC code.
Spring and BTM versions used in this document:
- Spring 2.x
- BTM 1.0
Database used for this document:
- Derby version 10.2.2.0
- This requires JDK 1.5+
Ensure that you strictly follow these instructions as variations can cause problems.
You need to create two databases, each one with a single users table.
Create a file named derby-create.sql with this content:
Then run this command:
Project directory structure
Below is a list of required jars. You have to copy them under the lib/ folder:
Create a file named
beans.xml in the
PROJECT_HOME/ folder with this content:
Create these Java classes in the
PROJECT_HOME/src/jtatest folder. Note: this code isn't anywhere near production ready - it's only supposed to be used as a simple test !
Now you have to run those commands from the
Compile these classes using this command line:
Lastly, run your application using this command line: