<!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.2800.1605" name=GENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=#ffffff> <DIV><SPAN class=212011203-18012008><FONT color=#0000ff> <DIV><FONT face="$B#M#S(J $B%4%7%C%/(J" color=#000000 size=2>$B$3$s$K$A$O!#(J</FONT></DIV> <DIV><FONT face="$B#M#S(J $B%4%7%C%/(J" color=#000000 size=2>$B:#ED$H?=$7$^$9!#(J</FONT></DIV> <DIV><FONT face="$B#M#S(J $B%4%7%C%/(J" color=#000000 size=2></FONT> </DIV> <DIV><FONT face="$B#M#S(J $B%4%7%C%/(J" color=#000000 size=2><SPAN class=063090503-18012008>******************************************************</SPAN></FONT></DIV> <DIV><FONT face="$B#M#S(J $B%4%7%C%/(J"><FONT size=2><FONT color=#000000>dao $B$rDj5A$7$F$$$k(J dicon $B%U%!%$%k$O2<5-$NDL$j$G$9!#(J<BR>test.dicon <BR>--------------------------------<BR><BR>  <component<BR>      class="org.seasar.framework.container.autoregister.FileSystemComponentAutoRegister"><BR>    <property name="autoNaming"><BR>      <component class="org.seasar.framework.container.autoregister.DefaultAutoNaming"/><BR>    </property><BR>    <initMethod name="addClassPattern"><BR>      <arg>"jp.co.domain.dao.impl"</arg><BR>      <arg>".*DaoImpl"</arg><BR>    </initMethod><BR>  </component><BR><SPAN class=063090503-18012008>*******************************************************</SPAN></FONT></FONT></FONT></DIV> <DIV><FONT face="$B#M#S(J $B%4%7%C%/(J" color=#000000 size=2></FONT> </DIV> <DIV><FONT face="$B#M#S(J $B%4%7%C%/(J" color=#000000 size=2>$B$H=q$$$F$$$i$C$7$c$k$H$$$&$3$H$O!"(J</FONT></DIV> <DIV><FONT face="$B#M#S(J $B%4%7%C%/(J" color=#000000 size=2></FONT> </DIV> <DIV><FONT face="$B#M#S(J $B%4%7%C%/(J" color=#000000 size=2><SPAN class=063090503-18012008>*******************************************************</SPAN></FONT></DIV> <DIV><FONT face="$B#M#S(J $B%4%7%C%/(J" color=#000000 size=2>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>} </FONT></DIV> <DIV><SPAN class=063090503-18012008><FONT face="$B#M#S(J $B%4%7%C%/(J" color=#000000 size=2>*******************************************************</FONT></SPAN></DIV> <DIV><FONT face="$B#M#S(J $B%4%7%C%/(J" color=#000000 size=2></FONT> </DIV> <DIV><FONT face="$B#M#S(J $B%4%7%C%/(J"><FONT size=2><FONT color=#000000>$B$G;HMQ$7$F$$$k(J<SPAN class=063090503-18012008>testDao$B%$%s%?%U%'!<%9!J!)!K$N<BAu%/%i%9(JtestDaoImpl$B%/%i%9$r<+J,$G(J</SPAN></FONT></FONT></FONT></DIV> <DIV><FONT face="$B#M#S(J $B%4%7%C%/(J" color=#000000 size=2><SPAN class=063090503-18012008>$B%3!<%G%#%s%0$5$l$F$$$k$H$$$&$3$H$G$9$+!)(J</SPAN></FONT></DIV> <DIV><FONT face="$B#M#S(J $B%4%7%C%/(J" color=#000000 size=2><SPAN class=063090503-18012008></SPAN></FONT> </DIV> <DIV><FONT face="$B#M#S(J $B%4%7%C%/(J" color=#000000 size=2><SPAN class=063090503-18012008>$B$b$7$=$&$G$"$k$J$i!"(J</SPAN></FONT></DIV> <DIV><FONT face="$B#M#S(J $B%4%7%C%/(J" color=#000000 size=2><SPAN class=063090503-18012008><SPAN class=212011203-18012008>testDaoImpl.java$B$N%3!<%I$r8+$;$F$b$i$($J$$$G$7$g$&$+!)(J</SPAN></SPAN></FONT></DIV> <DIV><FONT face="$B#M#S(J $B%4%7%C%/(J" color=#000000 size=2><SPAN class=063090503-18012008><SPAN class=212011203-18012008>$B$=$NCf$G<+J,$G%H(J$B%i%s%6%/%7%g%s$r%3%_%C%H$7$?$j$7$F$$$J$$$G$7$g$&$+!)(J</SPAN></SPAN></FONT></DIV></FONT></SPAN></DIV> <BLOCKQUOTE dir=ltr style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px"> <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> seasar-user-bounces@ml.seasar.org [mailto:seasar-user-bounces@ml.seasar.org]<B>On Behalf Of </B>Tidever Chenglong Tian<BR><B>Sent:</B> Friday, January 18, 2008 11:48 AM<BR><B>To:</B> seasar-user<BR><B>Subject:</B> [Seasar-user:12553]Seasar2$B%H%i%s%6%/%7%g%s%m!<%k%P%C%/$K$D$$$F(J<BR><BR></FONT></DIV> <DIV><FONT face="$B#M#S(J $B%4%7%C%/(J" size=2>tomcat6.0 <BR>Seasar2.3.19 <BR>SqlServer2005 <BR>JDK1.6 </FONT></DIV> <DIV><FONT face="$B#M#S(J $B%4%7%C%/(J" size=2></FONT> </DIV> <DIV><FONT face="$B#M#S(J $B%4%7%C%/(J" size=2>Seasar2 $B$O(Jtomcat$B%5!<%P!<$G(JSqlServer$B$r@\B3$9$k;~!"0l$D$N(JService$B$G(J2$B7o$N(JUpdate$BJ8$r<B9T$9$k$H!"0lHVL\$O@.8y$9$k$,!"(J2$BHVL\$O<:GT$9$k!#(J <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$?$,!"(JDB$B$G0lHVL\$N(JUpdate$BJ8$O99?7$7$?FbMF$,0MA3$H$7$FB8:_(J <BR>$B$7$F$$$F!"@5>o$K%m!<%k%P%C%/$7$J$$!#$3$l$O2?8N$+(J</FONT></DIV> <DIV><FONT face="$B#M#S(J $B%4%7%C%/(J" size=2></FONT> </DIV> <DIV><FONT face="$B#M#S(J $B%4%7%C%/(J" size=2>$B%0$O2<5-$NDL$j!#(J <BR>2008/01/10 09:26:27.812 [DEBUG] $B%H%i%s%6%/%7%g%s$r3+;O$7$^$7$?(J <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$?(J <BR>2008/01/10 09:26:28.375 [DEBUG] $BO@M}E*$J%3%M%/%7%g%s$r<hF@$7$^$7$?(J <BR>2008/01/10 09:26:28.531 [DEBUG] $BO@M}E*$J%3%M%/%7%g%s$rJD$8$^$7$?(J <BR>2008/01/10 09:26:28.531 [DEBUG] $BJ*M}E*$J%3%M%/%7%g%s$rJD$8$^$7$?(J <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$?(J <BR>2008/01/10 09:26:28.625 [DEBUG] $BO@M}E*$J%3%M%/%7%g%s$r<hF@$7$^$7$?(J <BR>2008/01/10 09:26:28.625 [DEBUG] $BO@M}E*$J%3%M%/%7%g%s$rJD$8$^$7$?(J <BR>2008/01/10 09:26:28.625 [DEBUG] $BJ*M}E*$J%3%M%/%7%g%s$rJD$8$^$7$?(J <BR>2008/01/10 09:26:28.625 [DEBUG] $B%H%i%s%6%/%7%g%s$r%m!<%k%P%C%/$7$^$7$?(J <BR>2008/01/10 09:26:28.671 [ERROR] org.seasar.framework.exception.SQLRuntimeException: <BR>[ESSR0071]SQL$B$GNc30(J(ErrorCode=208, SQLState=42S02)$B$,H/@8$7$^$7$?!#M}M3$O(J <BR>org.seasar.framework.exception.SSQLException: [ESSR0072]SQL$B$GNc30(J(SQL=[UPDATE dbo.test <BR>....</FONT></DIV> <DIV><FONT face="$B#M#S(J $B%4%7%C%/(J" size=2></FONT> </DIV> <DIV><FONT face="$B#M#S(J $B%4%7%C%/(J" 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(J $B%4%7%C%/(J" size=2></FONT> </DIV> <DIV><FONT face="$B#M#S(J $B%4%7%C%/(J" size=2>test.dicon <BR>--------------------------------<BR><components> <BR> <BR><component class="jp.co.business.service.impl.testServiceImpl"> <BR><aspect>j2ee.requiredTx</aspect> <BR></component> <BR></components> </FONT></DIV> <DIV><FONT face="$B#M#S(J $B%4%7%C%/(J" size=2></FONT> </DIV><FONT face="$B#M#S(J $B%4%7%C%/(J" size=2> <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(J</DIV> <DIV> </DIV> <DIV>$B$42sEzBgJQ$"$j$,$H$&$4$6$$$^$7$?!#(J<BR>dao $B$rDj5A$7$F$$$k(J dicon $B%U%!%$%k$O2<5-$NDL$j$G$9!#(J<BR>test.dicon <BR>--------------------------------<BR><BR>  <component<BR>      class="org.seasar.framework.container.autoregister.FileSystemComponentAutoRegister"><BR>    <property name="autoNaming"><BR>      <component class="org.seasar.framework.container.autoregister.DefaultAutoNaming"/><BR>    </property><BR>    <initMethod name="addClassPattern"><BR>      <arg>"jp.co.domain.dao.impl"</arg><BR>      <arg>".*DaoImpl"</arg><BR>    </initMethod><BR>  </component><BR>  <component<BR>      class="org.seasar.framework.container.autoregister.FileSystemComponentAutoRegister"><BR>    <property name="autoNaming"><BR>      <component class="org.seasar.framework.container.autoregister.DefaultAutoNaming"/><BR>    </property><BR>    <initMethod name="addClassPattern"><BR>      <arg>"jp.co.business.service.impl"</arg><BR>      <arg>".*ServiceImpl"</arg><BR>    </initMethod><BR>  </component><BR>  <component<BR>      class="org.seasar.framework.container.autoregister.FileSystemComponentAutoRegister"><BR>    <property name="instanceDef"><BR>      @org.seasar.framework.container.deployer.InstanceDefFactory@REQUEST<BR>    </property><BR>    <property name="autoNaming"><BR>      <component class="org.seasar.framework.container.autoregister.DefaultAutoNaming"/><BR>    </property><BR>    <initMethod name="addClassPattern"><BR>      <arg>"jp.co.web.action"</arg><BR>      <arg>".*Action"</arg><BR>    </initMethod><BR>  </component></DIV> <DIV> </DIV> <DIV>testService $B$r8F$S=P$7$F$$$k%3!<%I(J<BR>--------------------------------<BR>public class LoginAction extends BaseAction{<BR> private testService service;<BR> public void setTestService(testService service) {<BR>  this.service = service;<BR> }<BR> public String doExecute(ActionMapping mapping,<BR>   ActionForm form,<BR>   HttpServletRequest request,<BR>   HttpServletResponse response) {<BR>  int iUpdateFlg = -1;<BR>  iUpdateFlg = service.updatePassWord("15", "tcl");<BR>  return SUCCESS;<BR> }<BR>}<BR>$B!V%H%i%s%6%/%7%g%s$r3+;O$7$F$$$k%3!<%I!W$O%=!<%9$G=q$$$F$$$^$;$s!#(J<BR>$B%H%i%s%6%/%7%g%s$N4IM}$O(JS2$B4pDl$h$j<B9T$5$l$k$N$G$7$g$&$+!"%=!<%9$GL@J8$K5-=R$9$kI,MW$,$"$j$^$9$+!#(J<BR>$B>0!"(JS2Container$B$,:n@.$5$l$?$+$r$I$N$h$&$KH=CG$7$^$9$+!#(J<BR>================================================================<BR>$B$R$,$5$s(J</DIV> <DIV> </DIV> <DIV>$B$42sEzBgJQ$"$j$,$H$&$4$6$$$^$7$?!#(J<BR>web.xml$B$K2<5-$NG[CV$,$"$j$^$9!#(J<BR>web.xml<BR>--------------------------------<BR><servlet><BR> <servlet-name>s2servlet</servlet-name><BR> <servlet-class>org.seasar.framework.container.servlet.S2ContainerServlet</servlet-class><BR> <init-param><BR>  <param-name>configPath</param-name><BR>  <param-value>app.dicon</param-value><BR> </init-param><BR> <init-param><BR>  <param-name>debug</param-name><BR>  <param-value>false</param-value><BR> </init-param><BR> <load-on-startup>1</load-on-startup><BR></servlet><BR><servlet-mapping><BR> <servlet-name>s2servlet</servlet-name><BR> <url-pattern>/s2servlet</url-pattern><BR></servlet-mapping></DIV> <DIV> </DIV> <DIV>>S2Container$B$N@8@.$O!"(JS2ContainerServlet$B$KG$$;$F$/$@$5$$!#(J<BR>$B$=$l$G$O!"4{$K(JS2Container$B$N@8@.$O(JS2ContainerServlet$B$KG$$;$?$3$H$r@bL@$9$k$N$G$7$g$&$+!#(J<BR>$B$[$+$K2?$+$NG[CV$,MW$j$^$9$+!#(J<BR></FONT></DIV></BLOCKQUOTE></BODY></HTML>