[Seasar-user:4415] Re: [補足] エラーが出てます(I/O例外です。: End of TNS data channel)

2006年 8月 23日 (水) 22:02:37 JST

Lee$B$G$9!#(B

$B2<5-$N7o2r7h$7$^$7$?!#(B
SQL$BJ8$N(B UNION ALL $B$,$$$1$J$+$C$?$s$G$9!#(B
$B!V(BALL$B!W(B $B$r$J$/$7$?$i$&$^$/F0$-$^$7$?!#(B ^^;
$B%7%9%F%`$H$7$F$O!!(BUNION $B$+(B UNION ALL $B$+$"$s$^$j$+$o$i$J$$$s$@$1$I!A(B

$B860x$O$h$/$o$+$i$J$/$F!"B?J,(Bjdbc$B%I%i%$%P!<$+$J$!!A!)(B
seasar$B$H$O4X78$J$+$C$?$G$9!#(B

$B$R$,$5$s!"$4LBOG3]$1$^$7$F$I$&$b$9$_$^$;$s$G$7$?!#(B
$B$"$j$,$H$&$4$6$$$^$7$?!#(B

$B$^$?$J$K$,$"$C$?$i$h$m$7$/$*4j$$$$$?$7$^$9!#(B

> Lee$B$G$9!#(B
> $B%(%i!<$N7o$G$9$,!"@[E-MAIL ADDRESS DELETED]$G$o$+$jFq$$$+$b$7$l$^$;$s$,!A(B
> $B:#$4$mHs>o$KG:$s$G$^$9!#(B
>
> $B-!F0E*$J(BSELECT$B!!(BSQL$B!!0lK\(B(3000$B%9%F%C%WL$K~(B)
> $B-"%P%$%s%IMQ(BDTO$B$"$j(B
>
> $B:G=i$OLdBj$J$/F0$-$^$7$?$,!"<hF@$7$?%G!<%?$[E-MAIL ADDRESS DELETED]$G!"(B
> $B=$@5$r3]$1$^$7$?!#30It7k9g$,I,MW$G$7$F!"(B(+)$B$r$D$1$?$@$1$G(B
> End of TNS data channel$B!!Nc30$,=P$F$7$^$$$^$7$?!#(B
>
> $B2<5-$h$&$K$$$m$$$m;n$7$F!"7k2L$,!A(B
>    $B!&LdBj$"$j$=$&$JItJ,$r<h$j=P$7$F!"JL$KF0$+$7$?$[E-MAIL ADDRESS DELETED]>o!#!#!#(B
>    $B!&$=$NItJ,$r$J$/$9$H!"F0$-$[E-MAIL ADDRESS DELETED]>o!#(B
>    $B!&$=$NItJ,$N(BSQL$B$r%@%_!<(BSQL$B$GCV$-49$($F!"F0$+$9$H(BORA-01008: $B%P%$%s%I$5$l$F$$$J$$JQ?t$,$"$j$^$9!#(B
>    $B!!(BSQL$B<+BN$r8:$i$7$?$3$H$G!"%P%$%s%IJQ?t$,$?$j$J$$$3$H$H$O!)(B ><;
>
> SQL$BJ8$r;2>H$7$F$/$@$5$$!#(B
> $B!&!&!&N,(B
> (
> SELECT
>    MAIN_TBL.AAA
>    FIRST_COST.BBB FIRST_COST
>    (FIRST_COST.BBB + LEFT_SUM_COST.CCC) SUM_COST
> FROM
>    MAIN_TBL
>    --$B=i2s7W;;(B
>    (
>        SELECT
>            AAA  --$B%-!<(B
>            BBB   --$B%3%9%H(B
>        FROM
>            TLB_001
>   )$B!!(BFIRST_COST
>    --$B9g7W7W;;(B
>    (
>        SELECT
>                AAA
>                CCC
>        FROM
>                TBL_001
>        WHERE
>                $B>r7o!!(B-- /*dto.????*/ $BN,(B
>
>        UNION ALL
>        ---------------------$[E-MAIL ADDRESS DELETED]$j=P$7$?ItJ,(B
>        SELECT
>                AAA
>                CCC
>        FROM
>                YYYY
>        WHERE
>                $B>r7o!!(B/*dto.????*/ $BN,(B
>        ----------------------
> --SELECT -1 AAA, 0 CCC FROM DUAL --$B$KCV$-49$(<B9T(B ORA-01008: $B%P%$%s%I$5$l$F$$$J$$JQ?t$,$"$j$^$9(B
>
>    ) LEFT_SUM_COST
> WHERE
>    MAIN_TBL.AAA = FIRST_COST.AAA
>
> --AND MAIN_TBL.AAA = LEFT_SUM_COSTAAA$B!!(B --$B8m!!F0$[E-MAIL ADDRESS DELETED]>o(B
>
> AND MAIN_TBL.AAA = LEFT_SUM_COST.AAA(+)$B!!(B --$[E-MAIL ADDRESS DELETED]!!(BEnd of TNS data channel$B!!Nc30(B
>
> )
> $B!&!&!&N,(B
>
> $B$^$@$^$@$o$+$jFq$$$H;W$$$^$9$,!"@'HsC/$+$,=u$1$F$/$@$5$$!A(B
> $B$h$m$7$/$*4j$$$7$^$9!#(B
>
>
> ----- Original Message ----- 
> From: "Ri.Kyoukun" <[E-MAIL ADDRESS DELETED]>
> To: <[E-MAIL ADDRESS DELETED]>
> Sent: Monday, August 21, 2006 4:39 PM
> Subject: [Seasar-user:4383] Re:[$BJdB-(B] $B%(%i!<$,=P$F$^$9(B(I/O$BNc30$G$9!#(B: End 
> of
> TNS data channel)
>
>
>> Lee$B$G$9!#(B
>> SQL$B$G$9$,!"(B
>> $B%P%$%s%IJQ?t(B($BJ8;zNsG[Ns(B[1])$B$,6u$N>l9g(B
>> $B:n$i$l$?(BSQL$B$,(B
>>   xxxxx IN ('')  $B"+$K$J$k$s$G!"(B
>> $B$3$$$&>l9g$C$F%(%i!<$K$J$k$N$G$7$g$&$+!A(B
>>
>> $B$h$m$7$/$*4j$$$7$^$9!A(B
>>
>>
>> ----- Original Message ----- 
>> From: "Ri.Kyoukun" <[E-MAIL ADDRESS DELETED]>
>> To: <[E-MAIL ADDRESS DELETED]>
>> Sent: Monday, August 21, 2006 2:45 PM
>> Subject: [Seasar-user:4380]$B%(%i!<$,=P$F$^$9(B(I/O$BNc30$G$9!#(B: End of TNS 
>> data
>> channel)
>>
>>
>>> Lee$B$H?=$7$^$9!#(B
>>>
>>> $B85!9$&$^$/9T$C$F$?(BSQL$B$K(B
>>> $B$A$g$C$H$7$?=$@5$r3]$1$?$N$K!"%(%i!<$,=P$F$7$^$$$^$7$?!#(B
>>>
>>> $B30It7k9g(B(+) $B$D$1$?$@$1$G$9!A(B
>>> (+)$B$C$F(BSQL$B<+BN$N$"$A$3$A$G$9$G$K;H$o$l$F$k$+$i!"LdBj$J$5$=$&$@$1$I!A(B
>>>
>>> $B%(%i!<FbMF(B
>>> ----------------
>>> ], ErrorCode=17002, SQLState=null)$B$,H/@8$7$^$7$?(B
>>> at
>>> org.seasar.extension.dbcp.impl.ConnectionWrapperImpl$PreparedStatementWrapper.wrapException(ConnectionWrapperImpl.java:555)
>>> at
>>> org.seasar.extension.dbcp.impl.ConnectionWrapperImpl$PreparedStatementWrapper.wrapException(ConnectionWrapperImpl.java:550)
>>> at
>>> org.seasar.extension.dbcp.impl.ConnectionWrapperImpl$PreparedStatementWrapper.executeQuery(ConnectionWrapperImpl.java:566)
>>> at
>>> org.seasar.framework.util.PreparedStatementUtil.executeQuery(PreparedStatementUtil.java:35)
>>> ... 96 more
>>> Caused by: java.sql.SQLException: I/O$BNc30$G$9!#(B: End of TNS data channel
>>> at
>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
>>> at
>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
>>> at
>>> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
>>> at
>>> oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:815)
>>> at
>>> oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039)
>>> at
>>> oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839)
>>> at
>>> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)
>>> at
>>> oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4055)
>>> at
>>> oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:10763)
>>> at
>>> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3283)
>>> at
>>> oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)
>>> at
>>> org.seasar.extension.dbcp.impl.ConnectionWrapperImpl$PreparedStatementWrapper.executeQuery(ConnectionWrapperImpl.java:564)
>>> --------------------
>>>
>>> $B$G!"%3%s%=!<%k$G$NF0$-$r$_$k$H(B
>>> $B:G=i$O$A$c$s$HCM$,%P%$%s%I$5$l$?(BSQL$B%m%0$,=P$F$F!"(B
>>> $B$=$l$+$i$A$g$C$H8G$^$C$F$F!"$P$C!<$H(B $B!V(B?$B!WIU$1(BSQL$B$,$G$F%(%i!<$H$J$j$^$7$?!#(B 
>>> 
>>>
>>>
>>>
>>> $B:G=i$K=P$?(BSQL$B$r<h$C$F(BDB$B%D!<%k$G$J$,$9$H!"%(%i!<$J$7$G7k2L$,<h$l$^$7$?!#!#!#(B 
>>> 
>>>
>>>
>>>
>>> Tomcat 5.0.28
>>> s2-struts-1.2.2
>>> struts-1.2.8
>>> j2sdk1.4.2_11
>>>
>>> $B%M%C%H$GD4$Y$F$b$"$s$^$j>pJs$,$"$j$^$;$s$G$7$?$N$G!"(B
>>> $BC/$+$,65$($F$$$?$@$1$^$;$s$+!A(B
>>>
>>>
>>>
>>> _______________________________________________
>>> Seasar-user mailing list
>>> [E-MAIL ADDRESS DELETED]
>>> https://www.seasar.org/mailman/listinfo/seasar-user
>>>
>>
>> _______________________________________________
>> Seasar-user mailing list
>> [E-MAIL ADDRESS DELETED]
>> https://www.seasar.org/mailman/listinfo/seasar-user
>>
>
>


--------------------------------------------------------------------------------


> _______________________________________________
> Seasar-user mailing list
> [E-MAIL ADDRESS DELETED]
> https://www.seasar.org/mailman/listinfo/seasar-user
>