[Seasar-user:21422] Re: s2jdbcGen実行時のエラーについて

2012年 8月 24日 (金) 14:50:42 JST

$BCfB<(B(taedium)$B$G$9!#(B

> [gen-entity] DEBUG 2012-08-24 11:11:24,732 [main] RDBMS(Oracle)$B$KBP$7(BS2JDBC-Gen$BMQ$N%G!<%?%Y!<%9$NJ}8@(B(org.seasar.extension.jdbc.gen.internal.dialect.H2GenDialect)$B$r;HMQ$7$^$9!#(B

$B>e5-$N%m%0$+$i!"@_Dj%U%!%$%k$K;XDj$7$F$$$k(B
$B%@%$%"%l%/%H$, ＠ 5$7$/$J$$$H$$$&$3$H$,$o$+$j$^$9!#(B
$B!J(BH2$BMQ$N%@%$%"%l%/%H$,;H$o$l$F$7$^$C$F$$$^$9!K(B

s2jdbc.dicon$B$K$F(BoracleDialect$B$r;XDj$7$F$_$F$/$@$5$$!#(B
http://s2container.seasar.org/2.4/ja/s2jdbc_setup.html

$B ＠ _Dj$, ＠ 5$7$1$l$P!"(B
$B%m%0$G(BH2GenDialect$B$NBe$o$j$K(BOracleGenDialect$B$,(B
$B=PNO$5$l$k$h$&$K$J$j$^$9!#(B


On Fri, 24 Aug 2012 14:22:20 +0900
$BIpF#!!(B $B>!Li(B <mutojapan2002 ＠ yahoo.co.jp> wrote:

> $B=iJbE*$J<ALd$G?=$7Lu$4$6$$$^$;$s!#(B
> s2jdbcGen$B$r<B9T$7$?:]$KH/@8$7$?(Boracle$B%(%i!<$K$D$$$F<ALd$5$;$F$/$@$5$$!#(B
> $BL\E*$O%(%s%F%#%F%#$N<+F0 ＠ 8@.$G$9!#(B
> 
> $B"#4D6-(B
> JAVA1.6
> TOMCAT6
> Dolteng(SAStruts++S2JDBC)
> Oracle10g
> Eclipse
> 
> $B"#4D6-9=C[$NFbMF(B
> 
> $B-!(BOracle$B$KG$0U$N%F!<%V%k$r:n ＠ .!#(B
> $B-"(BEclipse$B>e$G(BDolteng$B%W%m%8%'%/%H$r:n ＠ .!#(B
> $B-#(Bojdbc6.jar$B$r%S%k%I%Q%9$K ＠ _Dj(B
> $B-$(Bjdbc.dicon$B$r=$@5$7!"8~$- ＠ h$r(BOracle$B$K ＠ _Dj!#(B
> $B-%(Bs2jdbc-gen-build.xml$B$r<B9T(B($B%?!<%2%C%H$O(Bgen-entity)
> 
> 
> $B"#%(%i!<FbMF(B
> Buildfile: C:\pleiades\workspace\s2jdbcGen\s2jdbc-gen-build.xml
> gen-entity:
> [gen-entity] INFO ?2012-08-24 11:11:23,935 [main] $B%P!<%8%g%s(B : S2JDBC-Gen 2.4.45
> [gen-entity] DEBUG 2012-08-24 11:11:23,935 [main] $B%3%^%s%I(B(org.seasar.extension.jdbc.gen.internal.command.GenerateEntityCommand)$B$r<B9T$7$^$9!#(B
> [gen-entity] DEBUG 2012-08-24 11:11:23,935 [main] $B%3%^%s%I$N%W%m%Q%F%#(B(initialValue)$B$K$OCM(B(null)$B$, ＠ _Dj$5$l$F$$$^$9!#(B
> [gen-entity] DEBUG 2012-08-24 11:11:23,935 [main] $B%3%^%s%I$N%W%m%Q%F%#(B(entityPackageName)$B$K$OCM(B(entity)$B$, ＠ _Dj$5$l$F$$$^$9!#(B
> [gen-entity] DEBUG 2012-08-24 11:11:23,935 [main] $B%3%^%s%I$N%W%m%Q%F%#(B(entityTemplateFileName)$B$K$OCM(B(java/entity.ftl)$B$, ＠ _Dj$5$l$F$$$^$9!#(B
> [gen-entity] DEBUG 2012-08-24 11:11:23,935 [main] $B%3%^%s%I$N%W%m%Q%F%#(B(javaFileDestDir)$B$K$OCM(B(C:\pleiades\workspace\s2jdbcGen\src\main\java)$B$, ＠ _Dj$5$l$F$$$^$9!#(B
> [gen-entity] DEBUG 2012-08-24 11:11:23,935 [main] $B%3%^%s%I$N%W%m%Q%F%#(B(javaFileEncoding)$B$K$OCM(B(UTF-8)$B$, ＠ _Dj$5$l$F$$$^$9!#(B
> [gen-entity] DEBUG 2012-08-24 11:11:23,935 [main] $B%3%^%s%I$N%W%m%Q%F%#(B(overwrite)$B$K$OCM(B(false)$B$, ＠ _Dj$5$l$F$$$^$9!#(B
> [gen-entity] DEBUG 2012-08-24 11:11:23,935 [main] $B%3%^%s%I$N%W%m%Q%F%#(B(rootPackageName)$B$K$OCM(B(dp)$B$, ＠ _Dj$5$l$F$$$^$9!#(B
> [gen-entity] DEBUG 2012-08-24 11:11:23,935 [main] $B%3%^%s%I$N%W%m%Q%F%#(B(schemaName)$B$K$OCM(B(null)$B$, ＠ _Dj$5$l$F$$$^$9!#(B
> [gen-entity] DEBUG 2012-08-24 11:11:23,935 [main] $B%3%^%s%I$N%W%m%Q%F%#(B(templateFileEncoding)$B$K$OCM(B(UTF-8)$B$, ＠ _Dj$5$l$F$$$^$9!#(B
> [gen-entity] DEBUG 2012-08-24 11:11:23,935 [main] $B%3%^%s%I$N%W%m%Q%F%#(B(templateFilePrimaryDir)$B$K$OCM(B(null)$B$, ＠ _Dj$5$l$F$$$^$9!#(B
> [gen-entity] DEBUG 2012-08-24 11:11:23,935 [main] $B%3%^%s%I$N%W%m%Q%F%#(B(tableNamePattern)$B$K$OCM(B(.*)$B$, ＠ _Dj$5$l$F$$$^$9!#(B
> [gen-entity] DEBUG 2012-08-24 11:11:23,935 [main] $B%3%^%s%I$N%W%m%Q%F%#(B(ignoreTableNamePattern)$B$K$OCM(B((SCHEMA_INFO|.*\$.*))$B$, ＠ _Dj$5$l$F$$$^$9!#(B
> [gen-entity] DEBUG 2012-08-24 11:11:23,935 [main] $B%3%^%s%I$N%W%m%Q%F%#(B(versionColumnNamePattern)$B$K$OCM(B(VERSION([_]?NO)?)$B$, ＠ _Dj$5$l$F$$$^$9!#(B
> [gen-entity] DEBUG 2012-08-24 11:11:23,935 [main] $B%3%^%s%I$N%W%m%Q%F%#(B(pluralFormFile)$B$K$OCM(B(null)$B$, ＠ _Dj$5$l$F$$$^$9!#(B
> [gen-entity] DEBUG 2012-08-24 11:11:23,935 [main] $B%3%^%s%I$N%W%m%Q%F%#(B(showCatalogName)$B$K$OCM(B(false)$B$, ＠ _Dj$5$l$F$$$^$9!#(B
> [gen-entity] DEBUG 2012-08-24 11:11:23,935 [main] $B%3%^%s%I$N%W%m%Q%F%#(B(showSchemaName)$B$K$OCM(B(false)$B$, ＠ _Dj$5$l$F$$$^$9!#(B
> [gen-entity] DEBUG 2012-08-24 11:11:23,935 [main] $B%3%^%s%I$N%W%m%Q%F%#(B(showTableName)$B$K$OCM(B(false)$B$, ＠ _Dj$5$l$F$$$^$9!#(B
> [gen-entity] DEBUG 2012-08-24 11:11:23,935 [main] $B%3%^%s%I$N%W%m%Q%F%#(B(showColumnName)$B$K$OCM(B(false)$B$, ＠ _Dj$5$l$F$$$^$9!#(B
> [gen-entity] DEBUG 2012-08-24 11:11:23,935 [main] $B%3%^%s%I$N%W%m%Q%F%#(B(showColumnDefinition)$B$K$OCM(B(false)$B$, ＠ _Dj$5$l$F$$$^$9!#(B
> [gen-entity] DEBUG 2012-08-24 11:11:23,935 [main] $B%3%^%s%I$N%W%m%Q%F%#(B(showJoinColumn)$B$K$OCM(B(false)$B$, ＠ _Dj$5$l$F$$$^$9!#(B
> [gen-entity] DEBUG 2012-08-24 11:11:23,935 [main] $B%3%^%s%I$N%W%m%Q%F%#(B(genDialectClassName)$B$K$OCM(B(null)$B$, ＠ _Dj$5$l$F$$$^$9!#(B
> [gen-entity] DEBUG 2012-08-24 11:11:23,935 [main] $B%3%^%s%I$N%W%m%Q%F%#(B(generationType)$B$K$OCM(B(null)$B$, ＠ _Dj$5$l$F$$$^$9!#(B
> [gen-entity] DEBUG 2012-08-24 11:11:23,935 [main] $B%3%^%s%I$N%W%m%Q%F%#(B(allocationSize)$B$K$OCM(B(null)$B$, ＠ _Dj$5$l$F$$$^$9!#(B
> [gen-entity] DEBUG 2012-08-24 11:11:23,935 [main] $B%3%^%s%I$N%W%m%Q%F%#(B(entitySuperclassName)$B$K$OCM(B(null)$B$, ＠ _Dj$5$l$F$$$^$9!#(B
> [gen-entity] DEBUG 2012-08-24 11:11:23,935 [main] $B%3%^%s%I$N%W%m%Q%F%#(B(useAccessor)$B$K$OCM(B(false)$B$, ＠ _Dj$5$l$F$$$^$9!#(B
> [gen-entity] DEBUG 2012-08-24 11:11:23,935 [main] $B%3%^%s%I$N%W%m%Q%F%#(B(applyDbCommentToJava)$B$K$OCM(B(false)$B$, ＠ _Dj$5$l$F$$$^$9!#(B
> [gen-entity] DEBUG 2012-08-24 11:11:23,935 [main] $B%3%^%s%I$N%W%m%Q%F%#(B(useTemporalType)$B$K$OCM(B(false)$B$, ＠ _Dj$5$l$F$$$^$9!#(B
> [gen-entity] DEBUG 2012-08-24 11:11:23,935 [main] $B%3%^%s%I$N%W%m%Q%F%#(B(configPath)$B$K$OCM(B(s2jdbc.dicon)$B$, ＠ _Dj$5$l$F$$$^$9!#(B
> [gen-entity] DEBUG 2012-08-24 11:11:23,935 [main] $B%3%^%s%I$N%W%m%Q%F%#(B(env)$B$K$OCM(B(ut)$B$, ＠ _Dj$5$l$F$$$^$9!#(B
> [gen-entity] DEBUG 2012-08-24 11:11:23,935 [main] $B%3%^%s%I$N%W%m%Q%F%#(B(jdbcManagerName)$B$K$OCM(B(jdbcManager)$B$, ＠ _Dj$5$l$F$$$^$9!#(B
> [gen-entity] DEBUG 2012-08-24 11:11:23,935 [main] $B%3%^%s%I$N%W%m%Q%F%#(B(factoryClassName)$B$K$OCM(B(org.seasar.extension.jdbc.gen.internal.factory.FactoryImpl)$B$, ＠ _Dj$5$l$F$$$^$9!#(B
> [gen-entity] DEBUG 2012-08-24 11:11:23,951 [main] $B4D6-JQ?t(B#Env$B$K%U%!%$%k(B(env.txt)$B$+$iCM(B(ct)$B$, ＠ _Dj$5$l$^$7$?(B
> [gen-entity] INFO ?2012-08-24 11:11:23,951 [main] s2-framework$B$N%P!<%8%g%s$O(B2.4.45$B$G$9!#(B
> [gen-entity] INFO ?2012-08-24 11:11:23,951 [main] s2-extension$B$N%P!<%8%g%s$O(B2.4.45$B$G$9!#(B
> [gen-entity] INFO ?2012-08-24 11:11:23,951 [main] s2-tiger$B$N%P!<%8%g%s$O(B2.4.45$B$G$9!#(B
> [gen-entity] DEBUG 2012-08-24 11:11:24,045 [main] S2Container$B$r:n ＠ .$7$^$9!#(Bpath=warmdeploy.dicon
> [gen-entity] DEBUG 2012-08-24 11:11:24,045 [main] S2Container$B$r:n ＠ .$7$^$9!#(Bpath=convention.dicon
> [gen-entity] DEBUG 2012-08-24 11:11:24,107 [main] S2Container$B$r:n ＠ .$7$^$7$?!#(Bpath=convention.dicon
> [gen-entity] DEBUG 2012-08-24 11:11:24,107 [main] S2Container$B$r:n ＠ .$7$^$9!#(Bpath=customizer.dicon
> [gen-entity] DEBUG 2012-08-24 11:11:24,107 [main] S2Container$B$r:n ＠ .$7$^$9!#(Bpath=default-customizer.dicon
> [gen-entity] DEBUG 2012-08-24 11:11:24,107 [main] S2Container$B$r:n ＠ .$7$^$9!#(Bpath=std-customizer.dicon
> [gen-entity] DEBUG 2012-08-24 11:11:24,123 [main] S2Container$B$r:n ＠ .$7$^$9!#(Bpath=std-customizer-tiger.dicon
> [gen-entity] DEBUG 2012-08-24 11:11:24,138 [main] S2Container$B$r:n ＠ .$7$^$7$?!#(Bpath=std-customizer-tiger.dicon
> [gen-entity] DEBUG 2012-08-24 11:11:24,154 [main] S2Container$B$r:n ＠ .$7$^$7$?!#(Bpath=std-customizer.dicon
> [gen-entity] DEBUG 2012-08-24 11:11:24,154 [main] S2Container$B$r:n ＠ .$7$^$7$?!#(Bpath=default-customizer.dicon
> [gen-entity] DEBUG 2012-08-24 11:11:24,170 [main] S2Container$B$r:n ＠ .$7$^$7$?!#(Bpath=customizer.dicon
> [gen-entity] DEBUG 2012-08-24 11:11:24,170 [main] S2Container$B$r:n ＠ .$7$^$9!#(Bpath=creator.dicon
> [gen-entity] DEBUG 2012-08-24 11:11:24,185 [main] S2Container$B$r:n ＠ .$7$^$7$?!#(Bpath=creator.dicon
> [gen-entity] DEBUG 2012-08-24 11:11:24,185 [main] S2Container$B$r:n ＠ .$7$^$7$?!#(Bpath=warmdeploy.dicon
> [gen-entity] DEBUG 2012-08-24 11:11:24,201 [main] S2Container$B$r:n ＠ .$7$^$9!#(Bpath=s2jdbc.dicon
> [gen-entity] DEBUG 2012-08-24 11:11:24,216 [main] S2Container$B$r:n ＠ .$7$^$9!#(Bpath=jdbc.dicon
> [gen-entity] DEBUG 2012-08-24 11:11:24,216 [main] S2Container$B$r:n ＠ .$7$^$9!#(Bpath=jta.dicon
> [gen-entity] DEBUG 2012-08-24 11:11:24,232 [main] S2Container$B$r:n ＠ .$7$^$7$?!#(Bpath=jta.dicon
> [gen-entity] DEBUG 2012-08-24 11:11:24,248 [main] S2Container$B$r:n ＠ .$7$^$7$?!#(Bpath=jdbc.dicon
> [gen-entity] DEBUG 2012-08-24 11:11:24,248 [main] S2Container$B$r:n ＠ .$7$^$9!#(Bpath=s2jdbc-internal.dicon
> [gen-entity] DEBUG 2012-08-24 11:11:24,248 [main] S2Container$B$r:n ＠ .$7$^$9!#(Bpath=convention.dicon
> [gen-entity] DEBUG 2012-08-24 11:11:24,263 [main] S2Container$B$r:n ＠ .$7$^$7$?!#(Bpath=convention.dicon
> [gen-entity] DEBUG 2012-08-24 11:11:24,263 [main] S2Container$B$r:n ＠ .$7$^$7$?!#(Bpath=s2jdbc-internal.dicon
> [gen-entity] DEBUG 2012-08-24 11:11:24,279 [main] S2Container$B$r:n ＠ .$7$^$7$?!#(Bpath=s2jdbc.dicon
> [gen-entity] INFO ?2012-08-24 11:11:24,404 [main] Running on [ENV]ut, [DEPLOY MODE]Warm Deploy
> [gen-entity] DEBUG 2012-08-24 11:11:24,732 [main] $BJ*M}E*$J%3%M%/%7%g%s$r<hF@$7$^$7$?(B
> [gen-entity] DEBUG 2012-08-24 11:11:24,732 [main] $BO ＠ M}E*$J%3%M%/%7%g%s$r<hF@$7$^$7$?!#(Btx=null
> [gen-entity] DEBUG 2012-08-24 11:11:24,732 [main] $BO ＠ M}E*$J%3%M%/%7%g%s$rJD$8$^$7$?!#(Btx=null
> [gen-entity] DEBUG 2012-08-24 11:11:24,732 [main] RDBMS(Oracle)$B$KBP$7(BS2JDBC-Gen$BMQ$N%G!<%?%Y!<%9$NJ}8@(B(org.seasar.extension.jdbc.gen.internal.dialect.H2GenDialect)$B$r;HMQ$7$^$9!#(B
> [gen-entity] DEBUG 2012-08-24 11:11:24,732 [main] $BO ＠ M}E*$J%3%M%/%7%g%s$r<hF@$7$^$7$?!#(Btx=null
> [gen-entity] DEBUG 2012-08-24 11:11:33,012 [main] $BO ＠ M}E*$J%3%M%/%7%g%s$rJD$8$^$7$?!#(Btx=null
> [gen-entity] DEBUG 2012-08-24 11:11:33,027 [main] $BJ*M}E*$J%3%M%/%7%g%s$rJD$8$^$7$?(B
> [gen-entity] Java Result: 1
> 
> BUILD FAILED
> C:\pleiades\workspace\s2jdbcGen\s2jdbc-gen-build.xml:40: Exception in thread "main" org.seasar.extension.jdbc.gen.exception.CommandFailedRuntimeException: [ES2JDBCGen0005]$B%3%^%s%I(B(org.seasar.extension.jdbc.gen.internal.command.GenerateEntityCommand)$B$N<B9T$K<:GT$7$^$7$?!#%P!<%8%g%s$O(B S2JDBC-Gen 2.4.45 $B$G$9!#M}M3$O(Borg.seasar.framework.exception.SQLRuntimeException: [ESSR0072]SQL$B$GNc30(B(SQL=[], Message=[ORA-25191: $B:w0z9=@.I=$N%*!<%P!<%U%m!<I=$r;2>H$G$-$^$;$s(B
> ], ErrorCode=25191, SQLState=99999)$B$,H/@8$7$^$7$?(B
> at org.seasar.extension.jdbc.gen.internal.command.AbstractCommand.execute(AbstractCommand.java:164)
> at org.seasar.extension.jdbc.gen.internal.command.CommandInvokerImpl.invoke(CommandInvokerImpl.java:29)
> at org.seasar.extension.jdbc.gen.command.CommandAdapter.main(CommandAdapter.java:61)
> Caused by: org.seasar.framework.exception.SQLRuntimeException: [ESSR0072]SQL$B$GNc30(B(SQL=[], Message=[ORA-25191: $B:w0z9=@.I=$N%*!<%P!<%U%m!<I=$r;2>H$G$-$^$;$s(B
> ], ErrorCode=25191, SQLState=99999)$B$,H/@8$7$^$7$?(B
> at org.seasar.extension.jdbc.gen.internal.meta.DbTableMetaReaderImpl.getDbUniqueKeyMetaList(DbTableMetaReaderImpl.java:447)
> at org.seasar.extension.jdbc.gen.internal.meta.DbTableMetaReaderImpl.doDbUniqueKeyMeta(DbTableMetaReaderImpl.java:157)
> at org.seasar.extension.jdbc.gen.internal.meta.DbTableMetaReaderImpl.read(DbTableMetaReaderImpl.java:132)
> at org.seasar.extension.jdbc.gen.internal.desc.EntitySetDescFactoryImpl.getEntitySetDesc(EntitySetDescFactoryImpl.java:125)
> at org.seasar.extension.jdbc.gen.internal.command.GenerateEntityCommand.doExecute(GenerateEntityCommand.java:691)
> at org.seasar.extension.jdbc.gen.internal.command.AbstractCommand.execute(AbstractCommand.java:162)
> ... 2 more
> Caused by: java.sql.SQLException: ORA-25191: $B:w0z9=@.I=$N%*!<%P!<%U%m!<I=$r;2>H$G$-$^$;$s(B
> 
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
> at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
> at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
> at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
> at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
> at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:194)
> at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1000)
> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
> at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1814)
> at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1779)
> at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:277)
> at oracle.jdbc.OracleDatabaseMetaData.getIndexInfo(OracleDatabaseMetaData.java:4104)
> at org.seasar.extension.jdbc.gen.internal.meta.DbTableMetaReaderImpl.getDbUniqueKeyMetaList(DbTableMetaReaderImpl.java:426)
> ... 7 more
> 
> Total time: 9 seconds
> 
> 
> $B"#JdB-(B
> $B!&(BDB$B$N8~$- ＠ h$,(BH2$B$G$"$l$PLdBj$J$/F0:n$7$^$9!#(B
> $B!&(BOracle11g$B$G;n$7$F$bF1MM$NLdBj$,H/@8$$$?$7$^$9!#(B
> $B!&I=NN0h$r:F:n ＠ .$7:F<B9T$r;n$_$^$7$?$,!"F1MM$NLdBj$,H/@8$$$?$7$^$9!#(B
> 
> 
> $B"#<ALdFbMF(B
> $B%(%i!<FbMF$O2<5-$NDL$j$G$9!#(B
> 
> >ORA-25191: $B:w0z9=@.I=$N%*!<%P!<%U%m!<I=$r;2>H$G$-$^$;$s(B
> >$B860x(B: $B:w0z9=@.I=$N%*!<%P!<%U%m!<I=$K!"D>@\%"%/%;%9$7$h$&$H$7$F$$$^$9!#(B
> >$B=hCV(B: $B;XDj$7$?%*!<%P!<%U%m!<I=$r4^$s$@?F:w0z9=@.I=$KBP$7$FJ8$rH/9T$7$F$/$@$5$$!#(B
> 
> 
> $B>e5-%(%i!<2sHr$N$?$a$K<B9TA0$KFCDj$N=hM}$r9T$&I,MW$O$"$j$^$9$G$7$g$&$+!#(B
> $BI,MW$G$"$l$PFbMF$N$465<x$r$*4j$$$$$?$7$^$9!#(B
> 
> $B$h$m$7$/$*4j$$$7$^$9!#(B

-- 
Toshihiro Nakamura <nakamura.toshihiro ＠ isid.co.jp>