$B$O$8$a$^$7$F!#B?ED$H?=$7$^$9!#(B S2 + S2Dao + SQL Server 2000 $B$G%H%i%s%6%/%7%g%s=hM}$K:$$C$F$$$^$9!#(B $B2r7h:v$,$"$j$^$7$?$i$465<x$*4j$$$$$?$7$^$9!#(B $B4D6-$O(B s2-2.3.10 s2dao-1.0.35 SQL Server 2000 SQL Server$B$N(BJDBC$B%I%i%$%P$O!"(B Microsoft SQL Server 2005 JDBC Driver$B!J(Bsqljdbc.jar$B!K(BVersion 1.0 <a href="http://msdn.microsoft.com/data/ref/jdbc/">http://msdn.microsoft.com/data/ref/jdbc/</a> $B$r;HMQ$7$F$$$^$9!#(B $B>e5-4D6-$K$F!"(B Seasar$B$N%H%i%s%6%/%7%g%s!J(Bj2ee.requiredTx$B!K$r$&$^$/E,MQ$G$-$^$;$s$G$7$?!#(B $BFbMF$H$7$F$O!"%F%9%HE*$KF1$8%F!<%V%k$KO"B3$GF1$8%G!<%?$rA^F~$7$F(B PRIMARY KEY $B0cH?(B $B"*(B $B%m!<%k%P%C%/(B $B"*(B $B%G!<%?;D$i$J$$(B $B$H$$$&$h$&$J$b$N$G!"(B $B%m%0>e$O!V%H%i%s%6%/%7%g%s$r%m!<%k%P%C%/$7$^$7$?!W$H=P$k$N$G$9$,!"(B DB$B>e$K$O%G!<%?$,;D$C$F$7$^$$$^$9!#(B $B%3!<%I$O0J2<$N$h$&$K$J$C$F$*$j$^$9!#(B ////////////////////////////////////////////////// @S2Dao(bean= User.class) public interface UserDao {         int insert(User user);     int update(User user);     int delete(User user);     List<User> getAll();     List<User> getUser(User user); } public interface TransactTestClient {         void add(); } public class TransactTestClientImpl implements TransactTestClient {         private UserDao userDao;         public TransactTestClientImpl(UserDao userDao) {         this.userDao = userDao;     }         public void add() {         User user = new User();         user.setName("testName");         user.setPassword("testPass");         user.setFullname("testFullName");         userDao.insert(user);                 // $B!z(B $B"-$3$3$G=EJ#H/@8(B $B",$3$l(B(1$B7oL\(B)$B$,%m!<%k%P%C%/$5$l$k$h$&$K$7$?$$(B $B!z(B         userDao.insert(user);     } } public class TransactTestMain {         private static String PATH = "tranClient.dicon";         public static void main(String[] args) {                 S2Container container = S2ContainerFactory.create(PATH);         container.init();         try {             TransactTestClient cl =                 (TransactTestClient) container.getComponent(TransactTestClient.class);             cl.add();         } finally {             container.destroy();         }     } } /// tranClient.dicon ///////////////////////////// <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE components PUBLIC "-//SEASAR//DTD S2Container 2.3//EN"     "<a href="http://www.seasar.org/dtd/components23.dtd">http://www.seasar.org/dtd/components23.dtd</a>"> <components>     <include path="tranDao.dicon"/>     <include path=" j2ee.dicon"/>     <component class="XXX.TransactTestClientImpl">         <arg>UserDao</arg>         <aspect>j2ee.requiredTx</aspect>     </component> </components> /// tranDao.dicon //////////////////////////////// <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE components PUBLIC "-//SEASAR//DTD S2Container 2.3//EN"     " <a href="http://www.seasar.org/dtd/components23.dtd">http://www.seasar.org/dtd/components23.dtd</a>"> <components>     <include path="dao.dicon"/>     <component name="UserDao" class=" XXX.UserDao">         <aspect>dao.interceptor</aspect>     </component> </components> /// $B%G!<%?%Y!<%9@_Dj!JH4?h!K(B ///////////////////// <component name="xaDataSource"     class="org.seasar.extension.dbcp.impl.XADataSourceImpl">     <property name="driverClassName">         "com.microsoft.sqlserver.jdbc.SQLServerDriver"     </property>     <property name="URL">         "jdbc:sqlserver://IP:Port;DatabaseName=DbName;SelectMethod=cursor"     </property>     <property name="user">"xxx"</property>     <property name="password">"xxx"</property> </component> <component name="connectionPool"     class="org.seasar.extension.dbcp.impl.ConnectionPoolImpl ">     <property name="timeout">600</property>     <property name="maxPoolSize">3</property>     <property name="allowLocalTx">true</property>     <destroyMethod name="close"/> </component> <component name="dataSource"     class="org.seasar.extension.dbcp.impl.DataSourceImpl"/> /// $B%m%0(B ///////////////////////////////////////// [main] $B%H%i%s%6%/%7%g%s$r3+;O$7$^$7$?(B [main] $BJ*M}E*$J%3%M%/%7%g%s$r<hF@$7$^$7$?(B [main] $BO@M}E*$J%3%M%/%7%g%s$r<hF@$7$^$7$?(B [main] $BO@M}E*$J%3%M%/%7%g%s$rJD$8$^$7$?(B [main] $BO@M}E*$J%3%M%/%7%g%s$r<hF@$7$^$7$?(B [main] INSERT INTO USERS (password, fullname, name) VALUES ('testPass', 'testFullName', 'testName') [main] $BO@M}E*$J%3%M%/%7%g%s$rJD$8$^$7$?(B [main] $BO@M}E*$J%3%M%/%7%g%s$r<hF@$7$^$7$?(B [main] INSERT INTO USERS (password, fullname, name) VALUES ('testPass', 'testFullName', 'testName') [main] $BO@M}E*$J%3%M%/%7%g%s$rJD$8$^$7$?(B [main] $B%H%i%s%6%/%7%g%s$r%m!<%k%P%C%/$7$^$7$?(B [main] $BJ*M}E*$J%3%M%/%7%g%s$rJD$8$^$7$?(B ////////////////////////////////////////////////// $B2?$+@_Dj$,B-$j$J$$!&4V0c$C$F$$$kEy$"$j$^$9$G$7$g$&$+!)(B $B%"%I%P%$%9!"$h$m$7$/$*4j$$$$$?$7$^$9!#(B