[Seasar-user:19240] EntityRowHandler#handle()におけるデータ操作について
[E-MAIL ADDRESS DELETED]
[E-MAIL ADDRESS DELETED]
2010年 2月 5日 (金) 16:09:41 JST
$B!!$*@$OC$K$J$C$F$*$j$^$9!%>>86$G$9!%(B
$B7GBj$N7o(B,$B0J2<$N<BAu$G%(%i!<$,H/@8$7$F$7$^$$$^$9(B.
$B2r7hJ}K!$J$I$"$j$^$7$?$i!"$465<($7$FD:$1$J$$$G$7$g$&$+!%(B
$B!c4D6-!d(B
$B!!(BJava $B!'(BJRE 1.6.0_13
$B!!(BDBFlute$B!'(BDBFlute 0.9.6
$B!cL\E*!d(B
EntityRowHandler#handle()$BFb$G%G!<%?EPO?(B/$B99?7$r9T$$$?$$(B.
$B!cM}M3!d(B
$BBgNL%G!<%?$+$iJL$N%F!<%V%k$X$NEPO?!?:o=|$r9T$&$h$&$J=hM}(B
$B$r9T$$$?$$(B.
$B!c8=>]!d(B
EntityRowHandler#handle()$BFb$GJL$N(BBehavior$B$+$i%G!<%?EPO?(B
$B$r9T$&$H(B,$B#12sL\$N(BInsert$B$[E-MAIL ADDRESS DELETED]>o$K%m%0=PNO$5$l$k$,(B,$B%+!<%=%k(B
$B$N<!%G!<%?<hF@$G%(%i!<$,H/@8$7$F$$$k(B.
$B!c<ALd!d(B
EntityRowHandler#handle()$BFb$GJL$N(BBehavior$B$r;HMQ$9$k$3$H$O(B
$B$G$-$J$$$N$G$7$g$&$+(B?
$B$G$-$J$$>l9g(B,
$B!!-!BgNL%G!<%?$N(BPrimaryKey$B$N$_$r<hF@$7(B,PrimaryKey$B$+$i$N%k!<%W(B
$B!!!!=hM}Fb$G>\:Y%G!<%?<hF@!\%G!<%?EPO?$r9T$&(B
$B!!-"(BEntityRowHandler#handle()$BFb$GEPO?%G!<%?$rG[Ns$GJ];}$7(B,
$B!!!!(BBehavior#batchInsert()$B$G0l5$$K%G!<%?EPO?(B
$B$N#2J}<0$7$+$J$$$N$G$7$g$&$+(B?
$BBgJQ?=$7Lu$4$6$$$^$;$s$,(B,$B$465<($NDx(B,$B59$7$/$*4j$$CW$7$^$9(B.
$B!c<BAuNc!d(B
final EntityRowHandler<YyyXxx> xxxHandler = new EntityRowHandler<YyyXxx>() {
@Override
public void handle(YyyXxx xxx) {
TestYyyXxx dt = new TestYyyXxx();
dt.setXxxId(xxx.getXxxId());
testYyyXxxBhv.insert(dt); // $B%G!<%?EPO?(B
ArrayList<String[]> data = new ArrayList<String[]>();
data.add(new String[] {xxx.getXxxId(), xxx.getPoleId()});
}
};
final YyyXxxCB cb = new YyyXxxCB();
cb.query().setXxxType_Equal("620000001923");
yyyXxxBhv.selectCursor(cb, xxxHandler);
$B!c%m%0!d(B
DEBUG 2010.02.05 11:24:13.062,/==============================================================================
DEBUG 2010.02.05 11:24:13.062, YyyXxxBhv.selectCursor()
DEBUG 2010.02.05 11:24:13.062, ========================/
DEBUG 2010.02.05 11:24:13.062,
DEBUG 2010.02.05 11:24:13.125,$[E-MAIL ADDRESS DELETED]}E*$J%3%M%/%7%g%s$r<hF@$7$^$7$?!#(Btx=[FormatId=4360, GlobalId=1265336652375/0, BranchId=]
DEBUG 2010.02.05 11:24:13.125,
$B!J(B***$B!K"((B1
DEBUG 2010.02.05 11:24:13.421,...Setting up column columns of CNETS_OCW_JBOX before INSERT!
DEBUG 2010.02.05 11:24:13.421,...Initializing sqlExecution for the key 'CNETS_OCW_JBOX:insert(TestYyyXxx)'
DEBUG 2010.02.05 11:24:13.421,$[E-MAIL ADDRESS DELETED]}E*$J%3%M%/%7%g%s$r<hF@$7$^$7$?!#(Btx=[FormatId=4360, GlobalId=1265336652375/0, BranchId=]
DEBUG 2010.02.05 11:24:13.421,$[E-MAIL ADDRESS DELETED]}E*$J%3%M%/%7%g%s$rJD$8$^$7$?!#(Btx=[FormatId=4360, GlobalId=1265336652375/0, BranchId=]
DEBUG 2010.02.05 11:24:13.468,SqlExecution Initialization Cost: [00m00s047ms]
DEBUG 2010.02.05 11:24:13.468,/=============================================================================
DEBUG 2010.02.05 11:24:13.468, TestYyyXxxBhv.insert()
DEBUG 2010.02.05 11:24:13.468, =======================/
DEBUG 2010.02.05 11:24:13.468,
DEBUG 2010.02.05 11:24:13.468,$[E-MAIL ADDRESS DELETED]}E*$J%3%M%/%7%g%s$r<hF@$7$^$7$?!#(Btx=[FormatId=4360, GlobalId=1265336652375/0, BranchId=]
DEBUG 2010.02.05 11:24:13.468,
$B!J(B***$B!K"((B2
DEBUG 2010.02.05 11:24:13.484,$[E-MAIL ADDRESS DELETED]}E*$J%3%M%/%7%g%s$rJD$8$^$7$?!#(Btx=[FormatId=4360, GlobalId=1265336652375/0, BranchId=]
DEBUG 2010.02.05 11:24:13.484,===========/ [00m00s016ms result=1]
DEBUG 2010.02.05 11:24:13.484,
WARN 2010.02.05 11:24:13.500,SQLException occurred while ResultSet Handling: target=YyyXxx.xxxType
DEBUG 2010.02.05 11:24:13.515,$[E-MAIL ADDRESS DELETED]}E*$J%3%M%/%7%g%s$rJD$8$^$7$?!#(Btx=[FormatId=4360, GlobalId=1265336652375/0, BranchId=]
DEBUG 2010.02.05 11:24:13.531,$B%H%i%s%6%/%7%g%s$r%m!<%k%P%C%/$7$^$7$?!#(Btx=[FormatId=4360, GlobalId=1265336652375/0, BranchId=]
ERROR 2010.02.05 11:24:13.578,BATCH,BridgeBatchApplication,run,CDL-E-00007,$BNc30$,H/@8$7$^$7$?!#>\:Y$O%m%0$r3NG'$7$F$/$@$5$$!#(B
org.seasar.dbflute.exception.SQLFailureException: Look! Read the message below.
/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
The SQL failed to execute!
[Advice]
Please confirm the SQLException message.
[SQLState]
null
[ErrorCode]
17006
[SQLException]
java.sql.SQLException
$BNsL>$,L58z$G$9!#(B
[Statement]
org.seasar.extension.jdbc.impl.PreparedStatementWrapper
[Display SQL]
$B!J(B***$B!K"((B3
* * * * * * * * * */
at org.seasar.dbflute.resource.SQLExceptionHandler.throwSQLFailureException(SQLExceptionHandler.java:199)
at org.seasar.dbflute.resource.SQLExceptionHandler.handleSQLException(SQLExceptionHandler.java:57)
at org.seasar.dbflute.s2dao.sqlhandler.TnBasicHandler.handleSQLException(TnBasicHandler.java:235)
at org.seasar.dbflute.s2dao.sqlhandler.TnBasicHandler.handleSQLException(TnBasicHandler.java:230)
at org.seasar.dbflute.s2dao.sqlhandler.TnBasicSelectHandler.execute(TnBasicSelectHandler.java:77)
at org.seasar.dbflute.s2dao.sqlhandler.TnBasicSelectHandler.execute(TnBasicSelectHandler.java:63)
at org.seasar.dbflute.bhv.core.execution.SelectCBExecution.execute(SelectCBExecution.java:74)
at org.seasar.dbflute.bhv.core.BehaviorCommandInvoker.executeSql(BehaviorCommandInvoker.java:320)
at org.seasar.dbflute.bhv.core.BehaviorCommandInvoker.dispatchInvoking(BehaviorCommandInvoker.java:174)
at org.seasar.dbflute.bhv.core.BehaviorCommandInvoker.invoke(BehaviorCommandInvoker.java:140)
at org.seasar.dbflute.bhv.AbstractBehaviorReadable.invoke(AbstractBehaviorReadable.java:923)
at jp.co.kyuden.cnets.batch.sample.TestDao2Batch.execute(TestDao2Batch.java:76)
at com.anygis.ri.client.startup.StartupUtils.runApplications(StartupUtils.java:302)
at com.anygis.ri.client.startup.StartupUtils.runBatchApplication(StartupUtils.java:116)
at com.anygis.ri.client.batch.DefaultBatchApplication.run(DefaultBatchApplication.java:137)
at com.anygis.ri.client.batch.AnyGISBatchApplication.<init>(AnyGISBatchApplication.java:57)
at com.anygis.ri.client.batch.AnyGISBatchApplication.main(AnyGISBatchApplication.java:31)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.anygis.components.client.BatchApplication.main(BatchApplication.java:39)
Caused by: java.sql.SQLException: $BNsL>$,L58z$G$9!#(B
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:208)
at oracle.jdbc.driver.OracleStatement.getColumnIndex(OracleStatement.java:3296)
at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:1914)
at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:1515)
at org.seasar.dbflute.s2dao.valuetype.registered.StringType.getValue(StringType.java:42)
at org.seasar.dbflute.s2dao.extension.TnRowCreatorExtension.getValue(TnRowCreatorExtension.java:169)
at org.seasar.dbflute.s2dao.extension.TnRowCreatorExtension.createRow(TnRowCreatorExtension.java:124)
at org.seasar.dbflute.s2dao.rshandler.TnAbstractBeanMetaDataResultSetHandler.createRow(TnAbstractBeanMetaDataResultSetHandler.java:85)
at org.seasar.dbflute.s2dao.rshandler.TnBeanListMetaDataResultSetHandler.mappingBean(TnBeanListMetaDataResultSetHandler.java:108)
at org.seasar.dbflute.s2dao.rshandler.TnBeanCursorMetaDataResultSetHandler.handle(TnBeanCursorMetaDataResultSetHandler.java:56)
at org.seasar.dbflute.s2dao.sqlhandler.TnBasicSelectHandler.execute(TnBasicSelectHandler.java:91)
at org.seasar.dbflute.s2dao.sqlhandler.TnBasicSelectHandler.execute(TnBasicSelectHandler.java:75)
... 21 more
$B"(#1!'(BSelect$BJ8!J%+!<%=%k%*!<%W%s!K(B
$B"(#2!'(BInsert$BJ8!J(BtestYyyXxxBhv.insert(dt);$B!K(B
$B"(#3!'"(#1$HF1MM$N(BSQL
$B0J>e!%D9J8$G?=$7Lu$4$6$$$^$;$s(B.
Seasar-user メーリングリストの案内