<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=Content-Type content="text/html; charset=iso-2022-jp"> <META content="MSHTML 6.00.2900.3243" name=GENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=#ffffff> <DIV><FONT face="$B#M#S(B $B%4%7%C%/(B" size=2>seasar-user$B$N%a!<%j%s%0%j%9%H$r;H$&$3$H$,$G$-$^$;$s$N$G!"2~$a$F0lDL$rAw?.$7$^$9!#(B<BR></FONT></DIV> <DIV><FONT face="$B#M#S(B $B%4%7%C%/(B" size=2>tomcat6.0 <BR>Seasar2.3.19 <BR>SqlServer2005 <BR>JDK1.6 </FONT></DIV> <DIV><FONT face="$B#M#S(B $B%4%7%C%/(B" size=2></FONT> </DIV> <DIV><FONT face="$B#M#S(B $B%4%7%C%/(B" size=2>Seasar2 $B$O(Btomcat$B%5!<%P!<$G(BSqlServer$B$r@\B3$9$k;~!"0l$D$N(BService$B$G(B2$B7o$N(BUpdate$BJ8$r<B9T$9$k$H!"0lHVL\$O@.8y$9$k$,!"(B2$BHVL\$O<:GT$9$k!#(B <BR>$B%m%0$G!"!V%H%i%s%6%/%7%g%s$r%m!<%k%P%C%/$7$^$7$?!W$H$$$&%a%C%;!<%8$r=P$7$?$,!"(BDB$B$G0lHVL\$N(BUpdate$BJ8$O99?7$7$?FbMF$,0MA3$H$7$FB8:_(B <BR>$B$7$F$$$F!"@5>o$K%m!<%k%P%C%/$7$J$$!#$3$l$O2?8N$+(B</FONT></DIV> <DIV><FONT face="$B#M#S(B $B%4%7%C%/(B" size=2></FONT> </DIV> <DIV><FONT face="$B#M#S(B $B%4%7%C%/(B" size=2>$B%0$O2<5-$NDL$j!#(B <BR>2008/01/10 09:26:27.812 [DEBUG] $B%H%i%s%6%/%7%g%s$r3+;O$7$^$7$?(B <BR>2008/01/10 09:26:27.984 [DEBUG] UPDATE dbo.test <BR>SET USER_PWD = 'tcl' <BR>WHERE USER_NO = '15' <BR>2008/01/10 09:26:28.375 [DEBUG] $BJ*M}E*$J%3%M%/%7%g%s$r<hF@$7$^$7$?(B <BR>2008/01/10 09:26:28.375 [DEBUG] $BO@M}E*$J%3%M%/%7%g%s$r<hF@$7$^$7$?(B <BR>2008/01/10 09:26:28.531 [DEBUG] $BO@M}E*$J%3%M%/%7%g%s$rJD$8$^$7$?(B <BR>2008/01/10 09:26:28.531 [DEBUG] $BJ*M}E*$J%3%M%/%7%g%s$rJD$8$^$7$?(B <BR>2008/01/10 09:26:28.609 [DEBUG] UPDATE dbo.test1 <BR>SET USER_PWD = 'abc' <BR>WHERE USER_NO = '16' <BR>2008/01/10 09:26:28.625 [DEBUG] $BJ*M}E*$J%3%M%/%7%g%s$r<hF@$7$^$7$?(B <BR>2008/01/10 09:26:28.625 [DEBUG] $BO@M}E*$J%3%M%/%7%g%s$r<hF@$7$^$7$?(B <BR>2008/01/10 09:26:28.625 [DEBUG] $BO@M}E*$J%3%M%/%7%g%s$rJD$8$^$7$?(B <BR>2008/01/10 09:26:28.625 [DEBUG] $BJ*M}E*$J%3%M%/%7%g%s$rJD$8$^$7$?(B <BR>2008/01/10 09:26:28.625 [DEBUG] $B%H%i%s%6%/%7%g%s$r%m!<%k%P%C%/$7$^$7$?(B <BR>2008/01/10 09:26:28.671 [ERROR] org.seasar.framework.exception.SQLRuntimeException: <BR>[ESSR0071]SQL$B$GNc30(B(ErrorCode=208, SQLState=42S02)$B$,H/@8$7$^$7$?!#M}M3$O(B <BR>org.seasar.framework.exception.SSQLException: [ESSR0072]SQL$B$GNc30(B(SQL=[UPDATE dbo.test <BR>....</FONT></DIV> <DIV><FONT face="$B#M#S(B $B%4%7%C%/(B" size=2></FONT> </DIV> <DIV><FONT face="$B#M#S(B $B%4%7%C%/(B" size=2>j2ee.dicon <BR>--------------------------------<BR><?xml version="1.0" encoding="Shift_JIS"?> <BR><!DOCTYPE components PUBLIC "-//SEASAR//DTD S2Container//EN" <BR>"<A href="http://www.seasar.org/dtd/components.dtd">http://www.seasar.org/dtd/components.dtd</A>"> <BR><components namespace="j2ee"> <BR> <BR><component name="transactionManager" <BR>class="org.seasar.extension.jta.TransactionManagerImpl"/> <BR> <BR><component name="requiredTx" class="org.seasar.extension.tx.RequiredInterceptor"> <BR><initMethod name="addRollbackRule"> <BR><arg>@java.lang.RuntimeException@class</arg> <BR></initMethod> <BR></component> <BR><component name="basicResultSetFactory" <BR>class="org.seasar.extension.jdbc.impl.BasicResultSetFactory"/> <BR><component name="basicStatementFactory" <BR>class="org.seasar.extension.jdbc.impl.BasicStatementFactory"/> <BR> <BR><component name="sqlConnection" class="org.seasar.extension.dbcp.impl.XADataSourceImpl"> <BR><property name="driverClassName">"com.microsoft.jdbc.sqlserver.SQLServerDriver"</property> <BR><property name="URL">"jdbc:microsoft:sqlserver://192.168.1.216:1433;DatabaseName=test"</property> <BR><property name="user">"sa"</property> <BR><property name="password">"sa"</property> <BR></component> <BR><component name="sqlConnectionPool" class="org.seasar.extension.dbcp.impl.ConnectionPoolImpl"> <BR><property name="timeout">600</property> <BR><property name="maxPoolSize">5</property> <BR><property name="allowLocalTx">true</property> <BR><property name="XADataSource">sqlConnection</property> <BR><destroyMethod name="close"/> <BR></component> <BR><component name="dataSource" class="org.seasar.extension.dbcp.impl.DataSourceImpl"> <BR><arg>sqlConnectionPool</arg> <BR></component> <BR></components> </FONT></DIV> <DIV><FONT face="$B#M#S(B $B%4%7%C%/(B" size=2></FONT> </DIV><FONT face="$B#M#S(B $B%4%7%C%/(B" size=2> <DIV><BR>test.dicon <BR>--------------------------------<BR><components> <BR> <BR><component class="jp.co.business.service.impl.testServiceImpl"> <BR><aspect>j2ee.requiredTx</aspect> <BR></component> <BR></components> </DIV> <DIV> </DIV> <DIV><BR>testServiceImpl.java <BR>--------------------------------<BR>public class testServiceImpl extends PagerService implements testService { <BR>private testDao dao; <BR>public void setTestDao(testDao dao) { <BR>this.dao = dao; <BR>} <BR>public int updatePassWord(String strNo, String strPwd) { <BR>int iRtnValue = -1; <BR>iRtnValue = dao.updatePassWord("15", "tcl"); <BR>iRtnValue = dao.updatePassWord1("16", "abc"); <BR>return iRtnValue; <BR>} </DIV> <DIV> </DIV> <DIV>================================<BR>$B>.NS$5$s(B</DIV> <DIV> </DIV> <DIV>$B$42sEzBgJQ$"$j$,$H$&$4$6$$$^$7$?!#(B<BR>$B!V(Bjdbc.dicon$B!W%U%!%$%k$,4{$K:o=|$7$^$7$?$,!"8=:_$bFs$D$N!V%3%M%/%7%g%s%W!<%k!W$,:n@.$5$l$J$/!"(B<BR>$B@5>o$K%m!<%k%P%C%/$G$-$J$$>uBV$G$9!#(B<BR>$B!VJ*M}E*$J%3%M%/%7%g%s$rJD$8$^$7$?!W$H8@$&860x$G$7$g$&$+!#$I$N$h$&$K2r7h$9$k$[$&$,$$$$$G$7$g$&$+!#(B</FONT></DIV></BODY></HTML>