<!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>&nbsp;</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>&lt;!-- 
Component auto regist. --&gt;<BR>&nbsp; 
&lt;component<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
class="org.seasar.framework.container.autoregister.FileSystemComponentAutoRegister"&gt;<BR>&nbsp;&nbsp;&nbsp; 
&lt;property name="autoNaming"&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&lt;component 
class="org.seasar.framework.container.autoregister.DefaultAutoNaming"/&gt;<BR>&nbsp;&nbsp;&nbsp; 
&lt;/property&gt;<BR>&nbsp;&nbsp;&nbsp; &lt;initMethod 
name="addClassPattern"&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&lt;arg&gt;"jp.co.domain.dao.impl"&lt;/arg&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&lt;arg&gt;".*DaoImpl"&lt;/arg&gt;<BR>&nbsp;&nbsp;&nbsp; 
&lt;/initMethod&gt;<BR>&nbsp; &lt;/component&gt;<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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</DIV>
  <DIV><FONT face="$B#M#S(J $B%4%7%C%/(J" size=2>j2ee.dicon 
  <BR>--------------------------------<BR>&lt;?xml version="1.0" 
  encoding="Shift_JIS"?&gt; <BR>&lt;!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>"&gt; 
  <BR>&lt;components namespace="j2ee"&gt; <BR>&lt;!-- Seasar2$B%H%i%s%6%/%7%g%s%^%M!<%8%c(J 
  --&gt; <BR>&lt;component name="transactionManager" 
  <BR>class="org.seasar.extension.jta.TransactionManagerImpl"/&gt; <BR>&lt;!-- 
  $B%H%i%s%6%/%7%g%sB0@-(J --&gt; <BR>&lt;component name="requiredTx" 
  class="org.seasar.extension.tx.RequiredInterceptor"&gt; <BR>&lt;initMethod 
  name="addRollbackRule"&gt; 
  <BR>&lt;arg&gt;@java.lang.RuntimeException@class&lt;/arg&gt; 
  <BR>&lt;/initMethod&gt; <BR>&lt;/component&gt; <BR>&lt;component 
  name="basicResultSetFactory" 
  <BR>class="org.seasar.extension.jdbc.impl.BasicResultSetFactory"/&gt; 
  <BR>&lt;component name="basicStatementFactory" 
  <BR>class="org.seasar.extension.jdbc.impl.BasicStatementFactory"/&gt; 
  <BR>&lt;!-- SQL Server 2005 --&gt; <BR>&lt;component name="sqlConnection" 
  class="org.seasar.extension.dbcp.impl.XADataSourceImpl"&gt; <BR>&lt;property 
  name="driverClassName"&gt;"com.microsoft.jdbc.sqlserver.SQLServerDriver"&lt;/property&gt; 
  <BR>&lt;property 
  name="URL"&gt;"jdbc:microsoft:sqlserver://192.168.1.216:1433;DatabaseName=test"&lt;/property&gt; 
  <BR>&lt;property name="user"&gt;"sa"&lt;/property&gt; <BR>&lt;property 
  name="password"&gt;"sa"&lt;/property&gt; <BR>&lt;/component&gt; 
  <BR>&lt;component name="sqlConnectionPool" 
  class="org.seasar.extension.dbcp.impl.ConnectionPoolImpl"&gt; <BR>&lt;property 
  name="timeout"&gt;600&lt;/property&gt; <BR>&lt;property 
  name="maxPoolSize"&gt;5&lt;/property&gt; <BR>&lt;property 
  name="allowLocalTx"&gt;true&lt;/property&gt; <BR>&lt;property 
  name="XADataSource"&gt;sqlConnection&lt;/property&gt; <BR>&lt;destroyMethod 
  name="close"/&gt; <BR>&lt;/component&gt; <BR>&lt;component name="dataSource" 
  class="org.seasar.extension.dbcp.impl.DataSourceImpl"&gt; 
  <BR>&lt;arg&gt;sqlConnectionPool&lt;/arg&gt; <BR>&lt;/component&gt; 
  <BR>&lt;/components&gt; </FONT></DIV>
  <DIV><FONT face="$B#M#S(J $B%4%7%C%/(J" size=2></FONT>&nbsp;</DIV>
  <DIV><FONT face="$B#M#S(J $B%4%7%C%/(J" size=2>test.dicon 
  <BR>--------------------------------<BR>&lt;components&gt; <BR>&lt;!--Aspect 
  auto regist. --&gt; <BR>&lt;component 
  class="jp.co.business.service.impl.testServiceImpl"&gt; 
  <BR>&lt;aspect&gt;j2ee.requiredTx&lt;/aspect&gt; <BR>&lt;/component&gt; 
  <BR>&lt;/components&gt; </FONT></DIV>
  <DIV><FONT face="$B#M#S(J $B%4%7%C%/(J" size=2></FONT>&nbsp;</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>&nbsp;</DIV>
  <DIV>================================================================<BR>$B>.NS$5$s(J</DIV>
  <DIV>&nbsp;</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>&lt;!-- Component auto regist. 
  --&gt;<BR>&nbsp; &lt;component<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  class="org.seasar.framework.container.autoregister.FileSystemComponentAutoRegister"&gt;<BR>&nbsp;&nbsp;&nbsp; 
  &lt;property name="autoNaming"&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  &lt;component 
  class="org.seasar.framework.container.autoregister.DefaultAutoNaming"/&gt;<BR>&nbsp;&nbsp;&nbsp; 
  &lt;/property&gt;<BR>&nbsp;&nbsp;&nbsp; &lt;initMethod 
  name="addClassPattern"&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  &lt;arg&gt;"jp.co.domain.dao.impl"&lt;/arg&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  &lt;arg&gt;".*DaoImpl"&lt;/arg&gt;<BR>&nbsp;&nbsp;&nbsp; 
  &lt;/initMethod&gt;<BR>&nbsp; &lt;/component&gt;<BR>&nbsp; 
  &lt;component<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  class="org.seasar.framework.container.autoregister.FileSystemComponentAutoRegister"&gt;<BR>&nbsp;&nbsp;&nbsp; 
  &lt;property name="autoNaming"&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  &lt;component 
  class="org.seasar.framework.container.autoregister.DefaultAutoNaming"/&gt;<BR>&nbsp;&nbsp;&nbsp; 
  &lt;/property&gt;<BR>&nbsp;&nbsp;&nbsp; &lt;initMethod 
  name="addClassPattern"&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  &lt;arg&gt;"jp.co.business.service.impl"&lt;/arg&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  &lt;arg&gt;".*ServiceImpl"&lt;/arg&gt;<BR>&nbsp;&nbsp;&nbsp; 
  &lt;/initMethod&gt;<BR>&nbsp; &lt;/component&gt;<BR>&nbsp; 
  &lt;component<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  class="org.seasar.framework.container.autoregister.FileSystemComponentAutoRegister"&gt;<BR>&nbsp;&nbsp;&nbsp; 
  &lt;property name="instanceDef"&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  @org.seasar.framework.container.deployer.InstanceDefFactory@REQUEST<BR>&nbsp;&nbsp;&nbsp; 
  &lt;/property&gt;<BR>&nbsp;&nbsp;&nbsp; &lt;property 
  name="autoNaming"&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;component 
  class="org.seasar.framework.container.autoregister.DefaultAutoNaming"/&gt;<BR>&nbsp;&nbsp;&nbsp; 
  &lt;/property&gt;<BR>&nbsp;&nbsp;&nbsp; &lt;initMethod 
  name="addClassPattern"&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  &lt;arg&gt;"jp.co.web.action"&lt;/arg&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  &lt;arg&gt;".*Action"&lt;/arg&gt;<BR>&nbsp;&nbsp;&nbsp; 
  &lt;/initMethod&gt;<BR>&nbsp; &lt;/component&gt;</DIV>
  <DIV>&nbsp;</DIV>
  <DIV>testService $B$r8F$S=P$7$F$$$k%3!<%I(J<BR>--------------------------------<BR>public 
  class LoginAction extends BaseAction{<BR>&nbsp;private testService 
  service;<BR>&nbsp;public void setTestService(testService service) 
  {<BR>&nbsp;&nbsp;this.service = service;<BR>&nbsp;}<BR>&nbsp;public String 
  doExecute(ActionMapping mapping,<BR>&nbsp;&nbsp;&nbsp;ActionForm 
  form,<BR>&nbsp;&nbsp;&nbsp;HttpServletRequest 
  request,<BR>&nbsp;&nbsp;&nbsp;HttpServletResponse response) 
  {<BR>&nbsp;&nbsp;int iUpdateFlg = -1;<BR>&nbsp;&nbsp;iUpdateFlg = 
  service.updatePassWord("15", "tcl");<BR>&nbsp;&nbsp;return 
  SUCCESS;<BR>&nbsp;}<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>&nbsp;</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>&lt;servlet&gt;<BR>&nbsp;&lt;servlet-name&gt;s2servlet&lt;/servlet-name&gt;<BR>&nbsp;&lt;servlet-class&gt;org.seasar.framework.container.servlet.S2ContainerServlet&lt;/servlet-class&gt;<BR>&nbsp;&lt;init-param&gt;<BR>&nbsp;&nbsp;&lt;param-name&gt;configPath&lt;/param-name&gt;<BR>&nbsp;&nbsp;&lt;param-value&gt;app.dicon&lt;/param-value&gt;<BR>&nbsp;&lt;/init-param&gt;<BR>&nbsp;&lt;init-param&gt;<BR>&nbsp;&nbsp;&lt;param-name&gt;debug&lt;/param-name&gt;<BR>&nbsp;&nbsp;&lt;param-value&gt;false&lt;/param-value&gt;<BR>&nbsp;&lt;/init-param&gt;<BR>&nbsp;&lt;load-on-startup&gt;1&lt;/load-on-startup&gt;<BR>&lt;/servlet&gt;<BR>&lt;servlet-mapping&gt;<BR>&nbsp;&lt;servlet-name&gt;s2servlet&lt;/servlet-name&gt;<BR>&nbsp;&lt;url-pattern&gt;/s2servlet&lt;/url-pattern&gt;<BR>&lt;/servlet-mapping&gt;</DIV>
  <DIV>&nbsp;</DIV>
  <DIV>&gt;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>