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

[Ri.Kyoukun]

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
>