[Seasar-user:15047] Re: 複数DBへの接続
r.m
[E-MAIL ADDRESS DELETED]
2008年 7月 16日 (水) 15:58:34 JST
$B?e_7$H?=$7$^$9!#(B
$B0JA0!"<+J,$,$d$C$?%^%k%A%G!<%?%=!<%9$[E-MAIL ADDRESS DELETED]$@$H(B
#############################dao-my.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 namespace="dao">
$B!!!!!!(B<include path="daodicon"/>
<include path="daotims.dicon"/>
<include path="daooldcas.dicon"/>
</components>
#############################app.dicon#############################
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE components PUBLIC "-//SEASAR2.1//DTD S2Container//EN"
"http://www.seasar.org/dtd/components21.dtd">
<components>
---$B>JN,(B----
$B!!!!!!(B<include path="dao-my.dicon"/>
---$B>JN,(B----
</components>
$B$=$l0J30$[E-MAIL ADDRESS DELETED]$"$C$F$$$k$+$H;W$$$^$9!#(B
$B5l(BVer$B$N(BS2DAO$B$@$H!"(BDao.dicon$B$NItJ,$[E-MAIL ADDRESS DELETED]$,0c$&!J(Bjar$B$K$O(Bj2ee.dicon$B$,4^$^$l$F$$$?!K(B
$B$O$:$J$N$G!"(Bwiki$B$N$H$O$A$g$C$H0c$&$+$b$7$l$^$;$s!#(B
$B?7$7$$(BVer$B$N$@$H(BDao.dicon$B$O(Bjar$B$K4^$^$l$F$$$^$9!#(B
$BE*30$l$G$7$?$i!"?=$7Lu$"$j$^$;$s!#(B
$B;29M$K$J$l$P$H;W$$$^$9!#(B
> $B7,86$G$9!#(B
>
> $B$9$$$^$;$s!"4D6-$r5-:\$9$k$N$rK:$l$F$$$^$7$?!#(B
> s2-dao-1.0.48
> s2-dao-tiger-1.0.48
> teeda-core-1.0.13
> s2-framework-2.4.24
>
>
>
> $BzI86!!51M:(B $B$5$s$O=q$-$^$7$?(B:
>> $B7,86$G$9!#$*@$OC$K$J$j$^$9!#(B
>>
>> $B!V(BSMART deploy$B$GJ#?t%G!<%?%=!<%9$KBP1~$9$k$K$O(B?$B!W(B
>> http://www.seasar.org/wiki/index.php?FAQ%2FS2DAO#w7da6e0e
>>
>> $B$r;29M$K(Bjdbc.dicon$B$d(Bdao.dicon$B$[E-MAIL ADDRESS DELETED]$7$?$N$G$9$,!"#2$D$NFb(B1$B$D$N(B
>> DB$B$K$7$+%"%/%;%9$7$^$;$s!#(B
>> dao-my.dicon$B$K5-:\$9$k#2$D$N(BDB$B$N(Binclude$B$N=gHV$rJQ$($k$H!"$b$&(B
>> $B0lJ}$N(BDB$B$K%"%/%;%9$G$-$^$9!#$I$&$d$i!"#1HVL\$KMh$k(Binclude$B$N(Bdicon$B$K(B
>> $BDj5A$5$l$?(BDB$B$N$_%"%/%;%9$G$-$k$h$&$G$9!#(B
>>
>> $B%G!<%?%=!<%9$[E-MAIL ADDRESS DELETED]$jBX$($NDj5A$r%=!<%9$K=q$/I,MW$,$"$k$N$+L5$$$N$+J,$+$j$^(B
>> $B$;$s$N$G!"$465<(2<$5$$!#(B
>>
>>
>> #############################dao-my.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 namespace="dao">
>> <include path="daotims.dicon"/>
>> <include path="daooldcas.dicon"/>
>>
>> <include path="j2ee.dicon"/>
>> </components>
>>
>>
>> #############################daooldcas.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 namespace="daooldcas">
>> <include path="jdbcoldcas.dicon"/>
>> <component class="org.seasar.dao.impl.AnnotationReaderFactoryImpl"/>
>> <component class="org.seasar.dao.impl.DaoMetaDataFactoryImpl"/>
>> <component
>> name="interceptor"
>> class="org.seasar.dao.pager.PagerS2DaoInterceptorWrapper">
>> <arg>
>> <component class="org.seasar.dao.interceptors.S2DaoInterceptor"/>
>> </arg>
>> </component>
>> <component class="org.seasar.dao.impl.ValueTypeFactoryImpl"/>
>> <component
>> name="stringClobType"
>> class="org.seasar.extension.jdbc.types.StringClobType"
>> />
>> <component class="org.seasar.dao.impl.BeanMetaDataFactoryImpl"/>
>> <component class="org.seasar.dao.impl.DaoNamingConventionImpl"/>
>> <component class="org.seasar.dao.impl.NullBeanEnhancer"/>
>> <component class="org.seasar.dao.impl.ResultSetHandlerFactoryImpl"/>
>> <component class="org.seasar.dao.impl.DtoMetaDataFactoryImpl"/>
>> <component class="org.seasar.dao.impl.PropertyTypeFactoryBuilderImpl"/>
>> <component
>> class="org.seasar.dao.impl.RelationPropertyTypeFactoryBuilderImpl"/>
>> <component class="org.seasar.dao.impl.DefaultTableNaming"/>
>> <component class="org.seasar.dao.impl.DefaultColumnNaming"/>
>> <component class="org.seasar.dao.impl.ProcedureMetaDataFactoryImpl"/>
>> </components>
>>
>> #############################daotims.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 namespace="daotims">
>> <include path="jdbctims.dicon"/>
>> <component class="org.seasar.dao.impl.AnnotationReaderFactoryImpl"/>
>> <component class="org.seasar.dao.impl.DaoMetaDataFactoryImpl"/>
>> <component
>> name="interceptor"
>> class="org.seasar.dao.pager.PagerS2DaoInterceptorWrapper">
>> <arg>
>> <component class="org.seasar.dao.interceptors.S2DaoInterceptor"/>
>> </arg>
>> </component>
>> <component class="org.seasar.dao.impl.ValueTypeFactoryImpl"/>
>> <component
>> name="stringClobType"
>> class="org.seasar.extension.jdbc.types.StringClobType"
>> />
>> <component class="org.seasar.dao.impl.BeanMetaDataFactoryImpl"/>
>> <component class="org.seasar.dao.impl.DaoNamingConventionImpl"/>
>> <component class="org.seasar.dao.impl.NullBeanEnhancer"/>
>> <component class="org.seasar.dao.impl.ResultSetHandlerFactoryImpl"/>
>> <component class="org.seasar.dao.impl.DtoMetaDataFactoryImpl"/>
>> <component class="org.seasar.dao.impl.PropertyTypeFactoryBuilderImpl"/>
>> <component
>> class="org.seasar.dao.impl.RelationPropertyTypeFactoryBuilderImpl"/>
>> <component class="org.seasar.dao.impl.DefaultTableNaming"/>
>> <component class="org.seasar.dao.impl.DefaultColumnNaming"/>
>> <component class="org.seasar.dao.impl.ProcedureMetaDataFactoryImpl"/>
>> </components>
>>
>>
>> #############################jdbc.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="jdbcoldcas.dicon"/>
>> <include path="jdbctims.dicon"/>
>> </components>
>>
>>
>>
>> #############################jdbcoldcas.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 namespace="jdbcoldcas">
>> <include path="jta.dicon"/>
>> <include path="jdbc-extension.dicon"/>
>>
>> <component class="org.seasar.extension.jdbc.impl.BasicResultSetFactory"/>
>> <component
>> class="org.seasar.extension.jdbc.impl.ConfigurableStatementFactory">
>> <arg>
>> <component class="org.seasar.extension.jdbc.impl.BasicStatementFactory"/>
>> </arg>
>> <property name="fetchSize">100</property>
>> <!--
>> <property name="maxRows">100</property>
>> -->
>> </component>
>> <!-- for PostgreSQL -->
>>
>> <component name="xaDataSource"
>> class="org.seasar.extension.dbcp.impl.XADataSourceImpl">
>> <property name="driverClassName">
>> "org.postgresql.Driver"
>> </property>
>> <property name="URL">
>> "jdbc:postgresql://localhost:5432/oldcss"
>> </property>
>> <property name="user">"postgres"</property>
>> <property name="password">"postgres"</property>
>> </component>
>> <component name="connectionPool"
>> class="org.seasar.extension.dbcp.impl.ConnectionPoolImpl">
>> <property name="timeout">600</property>
>> <property name="maxPoolSize">10</property>
>> <property name="allowLocalTx">true</property>
>> <destroyMethod name="close"/>
>> </component>
>>
>> <component name="dataSource"
>> class="org.seasar.extension.dbcp.impl.DataSourceImpl"
>> />
>> </components>
>>
>>
>>
>>
>> #############################jdbctims.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 namespace="jdbctims">
>> <include path="jta.dicon"/>
>> <include path="jdbc-extension.dicon"/>
>>
>> <component class="org.seasar.extension.jdbc.impl.BasicResultSetFactory"/>
>> <component
>> class="org.seasar.extension.jdbc.impl.ConfigurableStatementFactory">
>> <arg>
>> <component class="org.seasar.extension.jdbc.impl.BasicStatementFactory"/>
>> </arg>
>> <property name="fetchSize">100</property>
>> <!--
>> <property name="maxRows">100</property>
>> -->
>> </component>
>>
>> <!-- for PostgreSQL -->
>>
>> <component name="xaDataSource"
>> class="org.seasar.extension.dbcp.impl.XADataSourceImpl">
>> <property name="driverClassName">
>> "org.postgresql.Driver"
>> </property>
>> <property name="URL">
>> "jdbc:postgresql://localhost:5432/e3lp20"
>> </property>
>> <property name="user">"postgres"</property>
>> <property name="password">"postgres"</property>
>> </component>
>> <component name="connectionPool"
>> class="org.seasar.extension.dbcp.impl.ConnectionPoolImpl">
>> <property name="timeout">600</property>
>> <property name="maxPoolSize">10</property>
>> <property name="allowLocalTx">true</property>
>> <destroyMethod name="close"/>
>> </component>
>>
>> <component name="dataSource"
>> class="org.seasar.extension.dbcp.impl.DataSourceImpl"
>> />
>> </components>
>>
>>
>>
>> #############################custmizer.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>s2DaoCustomizer</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>".*Dao"</arg>
>> </initMethod>
>> </component>
>> <component name="daotimsSupportAspectCustomizer"
>> class="org.seasar.framework.container.customizer.AspectCustomizer">
>> <property name="interceptorName">"daotims.interceptor"</property>
>> <initMethod name="addClassPattern">
>> <arg>"ordersheet.dao.daotims"</arg>
>> <arg>".*Dao"</arg>
>> </initMethod>
>> </component>
>>
>> </components>
>>
>>
>> #############################s2container.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 condition="#ENV == 'ut'" path="warmdeploy.dicon"/>
>> <include condition="#ENV == 'ct'" path="hotdeploy.dicon"/>
>> <include condition="#ENV != 'ut' and #ENV != 'ct'"
>> path="cooldeploy.dicon"/>
>>
>> <component
>> class="org.seasar.framework.container.factory.SimplePathResolver">
>> <initMethod name="addRealPath">
>> <arg>"dao.dicon"</arg>
>> <arg>"dao-my.dicon"</arg><!-- $B<B:]$K;HMQ$9$kDj5A%U%!%$%k(B -->
>> </initMethod>
>> </component>
>>
>> </components>
>>
>>
>>
>>
>>
>> ###########################$B%(%i!<%a%C%;!<%8(B#############################
>> 2008-07-16 15:05:35,187 [http-8080-1] DEBUG
>> org.seasar.framework.aop.interceptors.TraceInterceptor - BEGIN
>> ordersheet.dao.V_userDao#getUserByUsercd(el00001)
>> 2008-07-16 15:05:35,265 [http-8080-1] DEBUG
>> org.seasar.extension.dbcp.impl.ConnectionPoolImpl - $BJ*M}E*$J%3%M%/%7%g%s(B
>> $B$r<hF@$7$^$7$?(B
>> 2008-07-16 15:05:35,265 [http-8080-1] DEBUG
>> org.seasar.extension.dbcp.impl.ConnectionPoolImpl - $[E-MAIL ADDRESS DELETED]}E*$J%3%M%/%7%g%s(B
>> $B$r<hF@$7$^$7$?!#(Btx=[FormatId=4360, GlobalId=1216186452953/6, BranchId=]
>> 2008-07-16 15:05:35,265 [http-8080-1] DEBUG
>> org.seasar.extension.dbcp.impl.ConnectionWrapperImpl - $[E-MAIL ADDRESS DELETED]}E*$J%3%M%/(B
>> $B%7%g%s$rJD$8$^$7$?!#(Btx=[FormatId=4360, GlobalId=1216186452953/6, BranchId=]
>> 2008-07-16 15:05:35,265 [http-8080-1] DEBUG
>> org.seasar.extension.dbcp.impl.ConnectionPoolImpl - $[E-MAIL ADDRESS DELETED]}E*$J%3%M%/%7%g%s(B
>> $B$r<hF@$7$^$7$?!#(Btx=[FormatId=4360, GlobalId=1216186452953/6, BranchId=]
>> 2008-07-16 15:05:35,312 [http-8080-1] WARN
>> org.seasar.dao.impl.PropertyTypeFactoryImpl - $B%F!<%V%k(B(v_user)$B$,8+$D$+$j(B
>> $B$^$;$s(B
>> 2008-07-16 15:05:35,312 [http-8080-1] DEBUG
>> org.seasar.extension.dbcp.impl.ConnectionWrapperImpl - $[E-MAIL ADDRESS DELETED]}E*$J%3%M%/(B
>> $B%7%g%s$rJD$8$^$7$?!#(Btx=[FormatId=4360, GlobalId=1216186452953/6, BranchId=]
>> 2008-07-16 15:05:35,312 [http-8080-1] DEBUG
>> org.seasar.extension.dbcp.impl.ConnectionPoolImpl - $[E-MAIL ADDRESS DELETED]}E*$J%3%M%/%7%g%s(B
>> $B$r<hF@$7$^$7$?!#(Btx=[FormatId=4360, GlobalId=1216186452953/6, BranchId=]
>> 2008-07-16 15:05:35,328 [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-16 15:05:35,328 [http-8080-1] DEBUG
>> org.seasar.extension.dbcp.impl.ConnectionWrapperImpl - $[E-MAIL ADDRESS DELETED]}E*$J%3%M%/(B
>> $B%7%g%s$rJD$8$^$7$?!#(Btx=[FormatId=4360, GlobalId=1216186452953/6, BranchId=]
>> 2008-07-16 15:05:35,328 [http-8080-1] DEBUG
>> org.seasar.framework.aop.interceptors.TraceInterceptor - END
>> ordersheet.dao.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-16 15:05:35,359 [http-8080-1] DEBUG
>> org.seasar.extension.jta.TransactionImpl - $B%H%i%s%6%/%7%g%s$r%m!<%k%P%C(B
>> $B%/$7$^$7$?!#(Btx=[FormatId=4360, GlobalId=1216186452953/6, BranchId=]
>> 2008-07-16 15:05:35,359 [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-16 15:05:35,375 [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$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.V_userDao$$EnhancedByS2AOP$$1bb747a$$MethodInvocation$$getUserByUsercd0.proceed(MethodInvocationClassGenerator.java)
>> at
>> org.seasar.framework.aop.interceptors.TraceInterceptor.invoke(TraceInterceptor.java:73)
>> at
>> ordersheet.dao.V_userDao$$EnhancedByS2AOP$$1bb747a$$MethodInvocation$$getUserByUsercd0.proceed(MethodInvocationClassGenerator.java)
>> at
>> ordersheet.dao.V_userDao$$EnhancedByS2AOP$$1bb747a.getUserByUsercd(V_userDao$$EnhancedByS2AOP$$1bb747a.java)
>> at
>> ordersheet.web.NewentrustPage.doItakukanriseiSearch(NewentrustPage.java:89)
>> at
>> ordersheet.web.NewentrustPage$$EnhancedByS2AOP$$56681b.$$doItakukanriseiSearch$$invokeSuperMethod$$(NewentrustPage$$EnhancedByS2AOP$$56681b.java)
>> at
>> ordersheet.web.NewentrustPage$$EnhancedByS2AOP$$56681b$$MethodInvocation$$doItakukanriseiSearch5.proceed(MethodInvocationClassGenerator.java)
>>
>>
>>
>> ###########################$B%=!<%9(B#############################
>>
>> SingletonS2ContainerFactory.setConfigPath("dao.dicon");
>> SingletonS2ContainerFactory.init();
>> S2Container container = SingletonS2ContainerFactory.getContainer();
>> V_userDao dao = (V_userDao) container.getComponent(V_userDao.class);
>>
>> List<V_user> userinfo = dao.getUserByUsercd(itakukanriseiid);//$B!!"+$3$3$G(B
>> $B%(%i!<$K$J$k(B
>> itakukanriseitel = "";
>> itakukanriseimail = "";
>> for (int i = 0; i < userinfo.size(); ++i) {
>> // $B8!:w$,%R%C%H$7$?;~(B
>> itakukanriseiname = userinfo.get(i).getName_family() + " " +
>> userinfo.get(i).getName_first();
>> itakukanriseiorg = userinfo.get(i).getCompany() + " " +
>> userinfo.get(i).getOrganization() + " " + userinfo.get(i).getPost();
>> return null;
>> }
>>
>>
>>
>>
>> _______________________________________________
>> Seasar-user mailing list
>> [E-MAIL ADDRESS DELETED]
>> https://ml.seasar.org/mailman/listinfo/seasar-user
>>
>
>
> _______________________________________________
> Seasar-user mailing list
> [E-MAIL ADDRESS DELETED]
> https://ml.seasar.org/mailman/listinfo/seasar-user
>
>
Seasar-user メーリングリストの案内