[Seasar-user:15079] Re: 複数DBへの接続

=?ISO-2022-JP?B?GyRCekk4NiEhNTFNOhsoQg==?= [E-MAIL ADDRESS DELETED]
2008年 7月 17日 (木) 19:24:26 JST


$B7,86$G$9!#$*@$OC$K$J$C$F$*$j$^$9!#(B

$B$4CzG+$[E-MAIL ADDRESS DELETED]$7$FD:$-!"M-Fq$&8f:B$$$^$9!#$h$&$d$/!">.NSMM(B
$B$N9M$($F$$$i$C$7$c$k;v$H!"(Bcustomizer.dicon$B$K5-:\$9$Y$-(B
$B;v$,8+$($F$-$^$7$?!#(B

customizer.dicon$B$G$[E-MAIL ADDRESS DELETED]!J;XDj$7$?%Q%C%1!<%8$N2<$N%/%i%9$K3:Ev$9$k$b$N!K(B
$B$,$&$^$/=PMh$F$$$J$$$N$G$O!)$H;W$$!"(B
$B;d$J$j$K;n$7$?;v$O(B<arg>$B$N%Q%i%a!<%?!<$rJQ$($F$$$m$$$m;n$7$^$7$?!#(B
$B-!!!(B<arg>".V_userDao"</arg>
$B-"!!(B<arg>"V_userDao"</arg>
$B-#!!(B<arg>".V_user*"</arg>
$B-$!!(B<arg>".*Dao"</arg>

$B-!!A-$$N7k2L$OF1$8%(%i!<$G$7$?!#(B

##########################customizer.dicon##########################
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE components PUBLIC "-//SEASAR//DTD S2Container 2.4//EN"
	"http://www.seasar.org/dtd/components24.dtd">
<components>
  <include path="default-customizer.dicon"/>
  <component name="pageCustomizer" class="org.seasar.framework.container.customizer.CustomizerChain">
    <initMethod name="addCustomizer">
      <arg>traceCustomizer</arg>
    </initMethod>
    <initMethod name="addCustomizer">
      <arg>
        <component class="org.seasar.framework.container.customizer.AspectCustomizer">
          <initMethod name="addInterceptorName">
            <arg>"app_aop.appFacesExceptionThrowsInterceptor"</arg>
          </initMethod>
          <property name="pointcut">"do.*, initialize, prerender"</property>
        </component>
      </arg>
    </initMethod>
    <initMethod name="addCustomizer">
      <arg>
        <component class="org.seasar.framework.container.customizer.AspectCustomizer">
          <initMethod name="addInterceptorName">
            <arg>"j2ee.requiredTx"</arg>
          </initMethod>
          <property name="pointcut">"do.*, initialize, prerender"</property>
        </component>
      </arg>
    </initMethod>
  </component>
  <component name="actionCustomizer" class="org.seasar.framework.container.customizer.CustomizerChain">
    <initMethod name="addCustomizer">
      <arg>traceCustomizer</arg>
    </initMethod>
    <initMethod name="addCustomizer">
      <arg>
        <component class="org.seasar.framework.container.customizer.AspectCustomizer">
          <initMethod name="addInterceptorName">
            <arg>"app_aop.actionSupportInterceptor"</arg>
          </initMethod>
          <property name="pointcut">"do.*, initialize, prerender"</property>
        </component>
      </arg>
    </initMethod>
  </component>
  <component name="serviceCustomizer" class="org.seasar.framework.container.customizer.CustomizerChain">
    <initMethod name="addCustomizer">
      <arg>traceCustomizer</arg>
    </initMethod>
    <initMethod name="addCustomizer">
      <arg>requiredTxCustomizer</arg>
    </initMethod>
  </component>
  <component name="logicCustomizer" class="org.seasar.framework.container.customizer.CustomizerChain">
    <initMethod name="addCustomizer">
      <arg>traceCustomizer</arg>
    </initMethod>
  </component>
  <component name="daoCustomizer" class="org.seasar.framework.container.customizer.CustomizerChain">
    <initMethod name="addCustomizer">
      <arg>traceCustomizer</arg>
    </initMethod>

 	<initMethod name="addCustomizer">
		<arg>daotimsSupportAspectCustomizer</arg>
	</initMethod>
	<initMethod name="addCustomizer">
		<arg>daooldcasSupportAspectCustomizer</arg>
	</initMethod>

  </component>
  <component name="dxoCustomizer" class="org.seasar.framework.container.customizer.CustomizerChain">
    <initMethod name="addCustomizer">
      <arg>traceCustomizer</arg>
    </initMethod>
    <initMethod name="addCustomizer">
      <arg>s2DxoCustomizer</arg>
    </initMethod>
  </component>
  <component name="helperCustomizer" class="org.seasar.framework.container.customizer.CustomizerChain">
    <initMethod name="addCustomizer">
      <arg>traceCustomizer</arg>
    </initMethod>
  </component>
  <component name="daooldcasSupportAspectCustomizer" class="org.seasar.framework.container.customizer.AspectCustomizer">
	<property name="interceptorName">"daooldcas.interceptor"</property>
	<initMethod name="addClassPattern">
		<arg>"ordersheet.dao.daooldcas"</arg>
		<arg>".V_userDao"</arg>
	</initMethod>
  </component>
  <component name="daotimsSupportAspectCustomizer" class="org.seasar.framework.container.customizer.AspectCustomizer">
	<property name="interceptorName">"daotims.interceptor"</property>

  </component>

</components>

##########################$B%9%?%C%/%H%l!<%9(B##########################
2008-07-17 18:40:50,984 [http-8080-1] DEBUG org.seasar.extension.jta.TransactionImpl - $B%H%i%s%6%/%7%g%s$r3+;O$7$^$7$?!#(Btx=[FormatId=4360, GlobalId=1216287647890/2, BranchId=]
2008-07-17 18:40:51,000 [http-8080-1] DEBUG org.seasar.framework.container.util.S2ContainerUtil - $B%/%i%9(B(ordersheet.dao.daooldcas.V_userDao[daooldcas_v_userDao])$B$N%3%s%]!<%M%s%HDj5A$rEPO?$7$^$9(B
2008-07-17 18:40:51,000 [http-8080-1] DEBUG org.seasar.framework.aop.interceptors.TraceInterceptor - BEGIN ordersheet.dao.daooldcas.V_userDao#getUserByUsercd(el00001)
2008-07-17 18:40:51,250 [http-8080-1] DEBUG org.seasar.extension.dbcp.impl.ConnectionPoolImpl - $BJ*M}E*$J%3%M%/%7%g%s$r<hF@$7$^$7$?(B
2008-07-17 18:40:51,265 [http-8080-1] DEBUG org.seasar.extension.dbcp.impl.ConnectionPoolImpl - $[E-MAIL ADDRESS DELETED]}E*$J%3%M%/%7%g%s$r<hF@$7$^$7$?!#(Btx=[FormatId=4360, GlobalId=1216287647890/2, BranchId=]
2008-07-17 18:40:51,296 [http-8080-1] DEBUG org.seasar.extension.dbcp.impl.ConnectionWrapperImpl - $[E-MAIL ADDRESS DELETED]}E*$J%3%M%/%7%g%s$rJD$8$^$7$?!#(Btx=[FormatId=4360, GlobalId=1216287647890/2, BranchId=]
2008-07-17 18:40:51,296 [http-8080-1] DEBUG org.seasar.extension.dbcp.impl.ConnectionPoolImpl - $[E-MAIL ADDRESS DELETED]}E*$J%3%M%/%7%g%s$r<hF@$7$^$7$?!#(Btx=[FormatId=4360, GlobalId=1216287647890/2, BranchId=]
2008-07-17 18:40:51,406 [http-8080-1] WARN  org.seasar.dao.impl.PropertyTypeFactoryImpl - $B%F!<%V%k(B(v_user)$B$,8+$D$+$j$^$;$s(B
2008-07-17 18:40:51,546 [http-8080-1] DEBUG org.seasar.extension.dbcp.impl.ConnectionWrapperImpl - $[E-MAIL ADDRESS DELETED]}E*$J%3%M%/%7%g%s$rJD$8$^$7$?!#(Btx=[FormatId=4360, GlobalId=1216287647890/2, BranchId=]
2008-07-17 18:40:51,656 [http-8080-1] DEBUG org.seasar.extension.dbcp.impl.ConnectionPoolImpl - $[E-MAIL ADDRESS DELETED]}E*$J%3%M%/%7%g%s$r<hF@$7$^$7$?!#(Btx=[FormatId=4360, GlobalId=1216287647890/2, BranchId=]
2008-07-17 18:40:51,671 [http-8080-1] DEBUG org.seasar.extension.jdbc.impl.BasicHandler - SELECT user_cd,name_family,name_first,post,company_cd,company,organization_cd,organization,password FROM v_user where login_ok = '1' and user_cd = 'el00001'
2008-07-17 18:40:51,703 [http-8080-1] DEBUG org.seasar.extension.dbcp.impl.ConnectionWrapperImpl - $[E-MAIL ADDRESS DELETED]}E*$J%3%M%/%7%g%s$rJD$8$^$7$?!#(Btx=[FormatId=4360, GlobalId=1216287647890/2, BranchId=]
2008-07-17 18:40:51,703 [http-8080-1] DEBUG org.seasar.framework.aop.interceptors.TraceInterceptor - END ordersheet.dao.daooldcas.V_userDao#getUserByUsercd(el00001) Throwable:org.seasar.framework.exception.SQLRuntimeException: [ESSR0072]SQL$B$GNc30(B(SQL=[SELECT
user_cd,name_family,name_first,post,company_cd,company,organization_cd,organization,password FROM v_user where login_ok = '1' and user_cd = ?], Message=[[ESSR0072]SQL$B$GNc30(B(SQL=[SELECT user_cd,name_family,name_first,post,company_cd,company,organization_cd,organization,password FROM v_user where
login_ok = '1' and user_cd = ?], Message=[0], ErrorCode=42P01, SQLState={3})$B$,H/@8$7$^$7$?(B : [SQL$B$GNc30(B(Message=[ERROR: relation "v_user" does not exist], ErrorCode=0, SQLState=42P01)$B$,H/@8$7$^$7$?!#(B], [ERROR: relation "v_user" does not exist], ErrorCode=0, SQLState=42P01)$B$,H/@8$7$^$7$?(B
2008-07-17 18:40:51,703 [http-8080-1] DEBUG org.seasar.extension.jta.TransactionImpl - $B%H%i%s%6%/%7%g%s$r%m!<%k%P%C%/$7$^$7$?!#(Btx=[FormatId=4360, GlobalId=1216287647890/2, BranchId=]
2008-07-17 18:40:51,703 [http-8080-1] DEBUG org.seasar.framework.aop.interceptors.TraceInterceptor - END ordersheet.web.NewentrustPage#doItakukanriseiSearch() Throwable:org.seasar.framework.exception.SQLRuntimeException: [ESSR0072]SQL$B$GNc30(B(SQL=[SELECT
user_cd,name_family,name_first,post,company_cd,company,organization_cd,organization,password FROM v_user where login_ok = '1' and user_cd = ?], Message=[[ESSR0072]SQL$B$GNc30(B(SQL=[SELECT user_cd,name_family,name_first,post,company_cd,company,organization_cd,organization,password FROM v_user where
login_ok = '1' and user_cd = ?], Message=[0], ErrorCode=42P01, SQLState={3})$B$,H/@8$7$^$7$?(B : [SQL$B$GNc30(B(Message=[ERROR: relation "v_user" does not exist], ErrorCode=0, SQLState=42P01)$B$,H/@8$7$^$7$?!#(B], [ERROR: relation "v_user" does not exist], ErrorCode=0, SQLState=42P01)$B$,H/@8$7$^$7$?(B
2008-07-17 18:40:51,718 [http-8080-1] DEBUG org.seasar.teeda.extension.util.TeedaExtensionErrorPageManagerImpl - [ESSR0072]SQL$B$GNc30(B(SQL=[SELECT user_cd,name_family,name_first,post,company_cd,company,organization_cd,organization,password FROM v_user where login_ok = '1' and user_cd = ?],
Message=[[ESSR0072]SQL$B$GNc30(B(SQL=[SELECT user_cd,name_family,name_first,post,company_cd,company,organization_cd,organization,password FROM v_user where login_ok = '1' and user_cd = ?], Message=[0], ErrorCode=42P01, SQLState={3})$B$,H/@8$7$^$7$?(B : [SQL$B$GNc30(B(Message=[ERROR: relation "v_user" does not
exist], ErrorCode=0, SQLState=42P01)$B$,H/@8$7$^$7$?!#(B], [ERROR: relation "v_user" does not exist], ErrorCode=0, SQLState=42P01)$B$,H/@8$7$^$7$?(B
org.seasar.framework.exception.SQLRuntimeException: [ESSR0072]SQL$B$GNc30(B(SQL=[SELECT user_cd,name_family,name_first,post,company_cd,company,organization_cd,organization,password FROM v_user where login_ok = '1' and user_cd = ?], Message=[[ESSR0072]SQL$B$GNc30(B(SQL=[SELECT
user_cd,name_family,name_first,post,company_cd,company,organization_cd,organization,password FROM v_user where login_ok = '1' and user_cd = ?], Message=[0], ErrorCode=42P01, SQLState={3})$B$,H/@8$7$^$7$?(B : [SQL$B$GNc30(B(Message=[ERROR: relation "v_user" does not exist], ErrorCode=0, SQLState=42P01)$B$,H/@8(B
$B$7$^$7$?!#(B], [ERROR: relation "v_user" does not exist], ErrorCode=0, SQLState=42P01)$B$,H/@8$7$^$7$?(B
	at org.seasar.framework.util.PreparedStatementUtil.executeQuery(PreparedStatementUtil.java:48)
	at org.seasar.extension.jdbc.impl.BasicResultSetFactory.createResultSet(BasicResultSetFactory.java:44)
	at org.seasar.extension.jdbc.impl.BasicSelectHandler.createResultSet(BasicSelectHandler.java:281)
	at org.seasar.extension.jdbc.impl.BasicSelectHandler.execute(BasicSelectHandler.java:257)
	at org.seasar.extension.jdbc.impl.BasicSelectHandler.execute(BasicSelectHandler.java:210)
	at org.seasar.extension.jdbc.impl.BasicSelectHandler.execute(BasicSelectHandler.java:184)
	at org.seasar.dao.impl.SelectDynamicCommand.execute(SelectDynamicCommand.java:69)
	at org.seasar.dao.interceptors.S2DaoInterceptor.invoke(S2DaoInterceptor.java:53)
	at org.seasar.dao.pager.PagerS2DaoInterceptorWrapper.invoke(PagerS2DaoInterceptorWrapper.java:71)
	at ordersheet.dao.daooldcas.V_userDao$$EnhancedByS2AOP$$fa4f5b$$MethodInvocation$$getUserByUsercd0.proceed(MethodInvocationClassGenerator.java)
	at org.seasar.framework.aop.interceptors.TraceInterceptor.invoke(TraceInterceptor.java:73)
	at ordersheet.dao.daooldcas.V_userDao$$EnhancedByS2AOP$$fa4f5b$$MethodInvocation$$getUserByUsercd0.proceed(MethodInvocationClassGenerator.java)
	at ordersheet.dao.daooldcas.V_userDao$$EnhancedByS2AOP$$fa4f5b.getUserByUsercd(V_userDao$$EnhancedByS2AOP$$fa4f5b.java)
	at ordersheet.web.NewentrustPage.doItakukanriseiSearch(NewentrustPage.java:90)
	at ordersheet.web.NewentrustPage$$EnhancedByS2AOP$$ed73fd.$$doItakukanriseiSearch$$invokeSuperMethod$$(NewentrustPage$$EnhancedByS2AOP$$ed73fd.java)
	at ordersheet.web.NewentrustPage$$EnhancedByS2AOP$$ed73fd$$MethodInvocation$$doItakukanriseiSearch5.proceed(MethodInvocationClassGenerator.java)
	at org.seasar.extension.tx.DefaultTransactionCallback.execute(DefaultTransactionCallback.java:58)
	at org.seasar.extension.tx.adapter.JTATransactionManagerAdapter.required(JTATransactionManagerAdapter.java:65)
	at org.seasar.extension.tx.RequiredInterceptor.invoke(RequiredInterceptor.java:41)
	at ordersheet.web.NewentrustPage$$EnhancedByS2AOP$$ed73fd$$MethodInvocation$$doItakukanriseiSearch5.proceed(MethodInvocationClassGenerator.java)
	at org.seasar.framework.aop.interceptors.ThrowsInterceptor.invoke(ThrowsInterceptor.java:77)
	at ordersheet.web.NewentrustPage$$EnhancedByS2AOP$$ed73fd$$MethodInvocation$$doItakukanriseiSearch5.proceed(MethodInvocationClassGenerator.java)
	at org.seasar.framework.aop.interceptors.TraceInterceptor.invoke(TraceInterceptor.java:73)
	at ordersheet.web.NewentrustPage$$EnhancedByS2AOP$$ed73fd$$MethodInvocation$$doItakukanriseiSearch5.proceed(MethodInvocationClassGenerator.java)
	at ordersheet.web.NewentrustPage$$EnhancedByS2AOP$$ed73fd.doItakukanriseiSearch(NewentrustPage$$EnhancedByS2AOP$$ed73fd.java)


##########################V_userDao.java##########################
package ordersheet.dao.daooldcas;

import java.util.List;

import ordersheet.entity.V_user;

public interface V_userDao {
	public Class BEAN = V_user.class;
	public static final String getUserByUsercd_SQL = "SELECT user_cd,name_family,name_first,post,company_cd,company,organization_cd,organization,password FROM v_user where login_ok = '1' and user_cd = ?";
	public List<V_user> getUserByUsercd(String usercd);
}


Seasar-user メーリングリストの案内