[seasar-s2dao-dev:661] Re: S2DAOによるCREATE VIEWについて

[Toshihiro Nakamura]

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

seasar-s2dao-dev $B$O!"3+H/<TMQ$N%a!<%j%s%0%j%9%H$G$9!#(B
$B$*<j?t$G$9$,!"<ALd$O(BSeasar-user$B%a!<%j%s%0$KEj9F$$$?$@$1$J$$$G$7$g$&$+!#(B

https://ml.seasar.org/mailman/listinfo/seasar-user

$B$h$m$7$/$*4j$$$7$^$9!#(B

> $B$O$8$a$^$7$F!"KL>r$G$9!#(B
> $BCf!92r7h$7$J$$$N$G#2E@$4AjCL$5$;$F$/$@$5$$!#(B
> 
> s2-dao-1.0.49.jar$B!"(Bs2-dao-tiger-1.0.49.jar$B$r;HMQ$70J2<$N$h$&$J9=@.$G(BCREATE 
> VIEW$B$r9T$C$F$$$^$9!#(B
> 
> $B!V(BDAO$B!W(B
> @S2Dao(bean=Kinds.class)
> public interface KindsDao {
> 
>  public int deleteKinds();
>  public int createKinds();
> }
> 
> $B!V(BSQL$B%U%!%$%k!W(B
> KindsDao_createKinds.sql
> create view kinds as select * from abc_summary($BCf?H(B)
> 
> $B!V(BDAO$B!W$N(BcreateKinds$B%a%=%C%I$r(BKinds(View)$B$,L5$$>uBV$G<B9T$7$?$H$3$m0J2<$N%(%i!<$H$J$C$F$7$^$$$^$9!#(B
> 
> WARN  2009-01-09 08:07:58,718 [main] $B%F!<%V%k(B(kinds)$B$,8+$D$+$j$^$;$s(B
> 
> Exception in thread "main" 
> org.seasar.framework.exception.SQLRuntimeException: [ESSR0071]SQL$B$GNc30(B(ErrorCode=1146, 
> SQLState=42S02)$B$,H/@8$7$^$7$?!#M}M3$O(Bcom.mysql.jdbc.exceptions.MySQLSyntaxErrorException: 
> Table 'vsp.kinds' doesn't exist
>  at 
> org.seasar.extension.jdbc.util.DatabaseMetaDataUtil.addPrimaryKeys(DatabaseMetaDataUtil.java:89)
>  at 
> org.seasar.extension.jdbc.util.DatabaseMetaDataUtil.getPrimaryKeySet(DatabaseMetaDataUtil.java:58)
>  at 
> org.seasar.dao.impl.PropertyTypeFactoryImpl.setupPrimaryKey(PropertyTypeFactoryImpl.java:170)
> 
> $B$3$l$r(BKinds(View)$B$,$"$k>uBV$G(BdeleteKinds()$B"M(B createKinds();$B$N=g$K<B9T$9$k$H:o=|8e!"(BVIEW$B$[E-MAIL ADDRESS DELETED]>o$K:[E-MAIL ADDRESS DELETED]$5$l%(%i!<$O=PNO$5$l$^$;$s$G$7$?!#(B
> $B!J(BView$B>C5nA0$H>C5n8e$N(BcreateView$B$NCf?H$r0c$&$b$N$K$7$?$N$GN>J}@.8y$7$F$$$k$3$H$O3NG':Q$_!K(B
> $B2r7h:v$O$"$k$G$7$g$&$+!)(B
> 
> 
> $B$b$&$R$H$DG:$s$G$$$kItJ,$,$"$C$F(Bkinds(View)$B$,B8:_$9$k>uBV$G0J2<$N=hM}$r<B9T$7$?$H$3$m(BView$B$K4X$7$F$O%m!<%k%P%C%/$5$l$^$;$s$G$7$?!#(B
> 
> 
> 
>  ASummary aSummary = new ASummary();$B"+-!E,Ev$J%$%s%5!<%H=hM}$r<B9T(B
>  ASummary.setCd("40039997");
>  aSummaryDao.insert(aSummary);
> 
>  kindsDao.deleteKinds();$B"+-"(BView$B$N:o=|=hM}$r<B9T(B
> 
> // $B-#$o$6$HNc30$rH/@8$5$;$k(B
>   if(true){
>      throw new NullPointerException("adsdfafda");
>   }
> 
> $B>e$N>l9g!"%$%s%5!<%H$O%m!<%k%P%C%/$5$l$F$$$F(BView$B$N:o=|$O%m!<%k%P%C%/$5$l$^$;$s!#(B 
> 
> $BB>$K$b%$%s%5!<%H#2$DB3$1$F%m!<%k%P%C%/Ey$7$F$_$?$H$3$mLdBj$J$/%m!<%k%P%C%/$5$l$F$?$N$G(Bdicon$B%U%!%$%k$N%H%i%s%6%/%7%g%[E-MAIL ADDRESS DELETED]$O4V0c$C$F$$$J$$$H$O;W$&$N$G$9$,!&!&!&!#(B
> $B$4AjCL$K$N$C$F$$$?$@$1$k$H=u$+$j$^$9!"$h$m$7$/$*4j$$$7$^$9!#(B
> 
> 

-- 
Nakamura Toshihiro <[E-MAIL ADDRESS DELETED]>