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

[houjyou]

$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