$BCfB<MM(B $B$*@$OC$K$J$C$F$*$j$^$9!#(B $B%"%$!&%F%#!&%U%m%s%F%#%"$N@>B<$G$9!#(B $B$42sEz$"$j$,$H$&$4$6$$$^$7$?!#(B SQL$BJ8H/9T%?%$%_%s%0$K$D$$$F!"N;2r$7$^$7$?!#(B $B$^$?!"EvJ}$N%"%W%j%1!<%7%g%s$G$O!"0J2<$N(BDao$B$K$h$C$F!"(B $B<B9T$9$k%a%=%C%I$,J,$+$l$k$HG'<1$$$?$7$^$7$?!#(B $B!&(BJavaBeans$B$K3JG<$5$l$?CM$+$i(BSQL$BJ8$r<+F0@8@.$9$k(BDao         $B2<5-(Bd) $B$KBP1~$7$^$9!#(B         DB$B%F!<%V%k$N%+%i%`L>$KBP1~$7$F$$$k%W%m%Q%F%#$r;}$C$F$$$^$9!#(B         $B"*(BgetColumns$B!"(BgetPrimaryKeys$B$NN>J}$r<B9T$9$k!#(B $B!&30It(BSQL$B%U%!%$%k$K$h$C$F(BSQL$BJ8$rH/9T$9$k(BDao         $B2<5-(Ba)$B$C$^$?$O(Bb) $B$KBP1~$7$^$9!#(B         $BMW7o$K$h$j!"30It%U%!%$%kFb$KF0E*(BSQL$BJ8$,F~$j$^$9!#(B         $B"*(BgetColumns$B$N$_<B9T$9$k!#(B dao.dicon$B$NJQ99$K$D$$$F$b!">pJs$"$j$,$H$&$4$6$$$^$9!#(B $B;29M$K$5$;$F$$$?$@$-$^$9!#(B $B$h$m$7$/$*4j$$$7$^$9!#(B ------------------------------------------------------- $B3t<02q<R!!%"%$!&%F%#!&%U%m%s%F%#%"(B $B@>B<!!M&?M(B ---------------------------------------------------- $BAw?.85(B:        Toshihiro Nakamura <toshihiro.nakamura@gmail.com> $B08@h(B:        seasar-user@ml.seasar.org $BF|IU(B:        2013/07/04 23:32 $B7oL>(B:        [Seasar-user:21642] Re:        S2Dao$B$,(BDB$B%a%?%G!<%?<hF@;~$KH/9T$7$F$$$k$H;W$o$l$k(BSQL$BJ8$K$D$$$F(B $BAw?.<T(B:        seasar-user-bounces@ml.seasar.org <hr noshade> $BCfB<(B(taedium)$B$G$9!#(B $B@h$[$I$N%a!<%k$G!"(B java.sql.DatabaseMetaData$B7PM3$N(BDB$B%"%/%;%9$,H/@8$9$k>r7o$K$D$$$F(B $B$^$A$,$C$?$3$H$r8@$C$F$7$^$$$^$7$?!#(B $BD{@5$5$;$F$/$@$5$$!#(B getColumns$B$O!"(Ba)$B!"(Bb)$B!"(Bc)$B!"(Bd)$B$9$Y$F$N%1!<%9$G8F$S=P$5$l$^$9!#(B getPrimaryKeys$B$O!"(Bd)$B$N%1!<%9$@$1$G8F$S=P$5$l$^$9!#(B 2013$BG/(B7$B7n(B4$BF|(B 21:47 Toshihiro Nakamura <<a href=mailto:toshihiro.nakamura@gmail.com target=_blank>toshihiro.nakamura@gmail.com</a>>: $BCfB<(B(taedium)$B$G$9!#(B > $B!&Ev3:$N(BSQL$BJ8$O!"(BDB$B@\B3;~$N%a%?%G!<%?<hF@$N$?$a$K!"(BS2Dao$B$H(BDB$B$N%I%i%$%P$K$h$C$F(B >$B!!H/9T$5$l$F$$$k$H$$$&G'<1$GLdBj$J$$$+(B $B$O$$!#(B $B$=$l$>$l!"(Bjava.sql.DatabaseMetaData$B%/%i%9$N0J2<$N%a%=%C%I$N8F$S=P$7$KBP1~$7$F$$$^$9!#(B - getPrimaryKeys - getColumns > $B!&Ev3:$N(BSQL$BJ8$NH/9T2s?t$r8+@Q$b$k7W;;<0$J$I$O$"$k$+(B > $B!&Ev3:$N(BSQL$BJ8$NH/9T%?%$%_%s%0!"%H%j%,!<!"$=$NB>5,B'@-$J$I$O$"$k$+(B $B5,B'@-$O$"$j$^$9!#(B $B%=!<%9%3!<%I$rDI$$$+$1$F$_$^$7$?!#(B $B$?$@$7!"Bg$^$+$J>pJs$@$H;W$C$F$/$@$5$$!#(B getColumns$B$O0J2<$NBP>]$4$H$K8F$P$l$^$9!#(B a) Dao$B%a%=%C%I$N%Q%i%a!<%?$KEP>l$9$k%F!<%V%k$KBP1~$7$J$$(BJavaBeans$B!J(BSQL$B$r<+F0@8@.$9$k>l9g!K(B b) Dao$B%a%=%C%I$NLa$jCM$KEP>l$9$k%F!<%V%k$KBP1~$7$J$$(BJavaBeans c) EntityManager$B$N3F<o%a%=%C%I$NBh(B1$B0z?t$KEP>l$9$k(BJavaBeans getPrimaryKeys$B$O>e5-$K2C$(0J2<$NBP>]$4$H$K8F$P$l$^$9(B d) Dao$B%/%i%9$KBP1~$9$k(BJavaBeans$B!J%j%l!<%7%g%s%7%C%W$,$"$k>l9g$O$=$N(BJavaBeans$B$b!K(B a)$B$H(Bd)$B$O(BDao$B$N=i4|2=;~$K0lEY$@$18F$P$l$^$9!#(B b)$B$d(Bc)$B$N(BJavaBeans$B$K$D$$$F$O(BDB$B%"%/%;%9$N7k2L$,%-%c%C%7%e$5$l$k$?$a!"(B $BF1$8(BJavaBeans$B$,$9$G$K=hM}$5$l$F$$$k>l9g$K$O(BDB$B%"%/%;%9$O9T$o$l$^$;$s!#(B $B$b$C$H>\:Y$J>r7o$rGD0.$9$k$K$O!"%m%0$r;E9~$`$N$,$$$$$+$H;W$$$^$9!#(B S2Dao$B$N(BPropertyTypeFactoryImpl$B%/%i%9$N<!$N%a%=%C%I$,>e=R$7$?(BDatabaseMetaData$B%/%i%9$N(B 2$B$D$N%a%=%C%I$KBP1~$7$^$9!#(B - setupPrimaryKey - getColumns PropertyTypeFactoryImpl$B$N%S%k%@$r(Bdao.dicon$B$GJQ99$G$-$^$9!#(B $B$J$*!"@_Dj$r%+%9%?%^%$%:$7$F%"%N%F!<%7%g%s$rIUM?$9$l$P(B DatabaseMetaData$B$r;H$C$?(BDB$B%"%/%;%9$r$J$/$9$3$H$,$G$-$^$9!#(B <a href=http://s2dao.seasar.org/ja/daoDicon.html#customizationByComponent target=_blank>http://s2dao.seasar.org/ja/daoDicon.html#customizationByComponent</a> 2013$BG/(B7$B7n(B4$BF|(B 16:45 <<a href=mailto:nishimura_hayato@itfrontier.co.jp target=_blank>nishimura_hayato@itfrontier.co.jp</a>>: seasar-user$B$N$_$J$5$^(B $B=i$a$FEj9F$5$;$F$$$?$@$-$^$9!#(B $B3t<02q<R%"%$!&%F%#!&%U%m%s%F%#%"$N@>B<$H?=$7$^$9!#(B $B8=:_!"0J2<$N(BS2$B@=IJ!"(BAP$B%5!<%P!"(BDB$B$rMxMQ$7$F!"(B Java$B$H(BLinux$B%7%'%k$G%P%C%A%"%W%j%1!<%7%g%s$N3+H/$r9T$C$F$$$^$9!#(B $B!c(BAP$B%5!<%P!d(B Weblogic Server 10.3.6.0 $B!c(BDB$B!d(B Oracle Database 11g Express Edition $B!c(BS2$B4XO"@=IJ!d(B s2-dao-1.0.49 s2-extension-2.4.40 s2-framework-2.4.40 s2-tiger-2.4.39 $B%"%W%j%1!<%7%g%s$N%F%9%HCf$K!"(BDB$B$KBP$7$FH/9T$5$l$k(BSQL$BJ8$r4F;k$7$F$$$?$H$3$m!"(B S2Container$B=i4|2=!A(BDao$B<B9T$N4V$K!"(B DB$B$KBP$7$F0J2<(B2$B<oN`$N(BSQL$BJ8$,H/9T$5$l$F$$$k$3$H$r3NG'$7$^$7$?!#(B $B"-(B $B!\!\!\!\!\!\!\!\!\!\!\!\!\!\!\!\!\!\!\!\!\!\!\!\!\!\!\!\!\!\(B $B!&%F!<%V%k$N@)Ls>pJs$r<hF@$7$F$$$k$H;W$o$l$k(BSQL$BJ8(B    SELECT NULL AS table_cat,           c.owner AS table_schem,           c.table_name,           c.column_name,           c.position AS key_seq,           c.constraint_name AS pk_name    FROM all_cons_columns c, all_constraints k    WHERE k.constraint_type = 'P'      AND k.table_name = :1      AND k.owner like :2 escape '/'      AND k.constraint_name = c.constraint_name      AND k.table_name = c.table_name      AND k.owner = c.owner    ORDER BY column_name $B!&%F!<%V%k$N%+%i%`>pJs$r<hF@$7$F$$$k$H;W$o$l$k(BSQL$BJ8(B    SELECT NULL AS table_cat,           t.owner AS table_schem,           t.table_name AS table_name,           t.column_name AS column_name,           DECODE (t.data_type, 'CHAR', 1, 'VARCHAR2', 12, 'NUMBER', 3,                   'LONG', -1, 'DATE', 91, 'RAW', -3, 'LONG RAW', -4,                     'BLOB', 2004, 'CLOB', 2005, 'BFILE', -13, 'FLOAT', 6,                   'TIMESTAMP(6)', 93, 'TIMESTAMP(6) WITH TIME ZONE', -101,                   'TIMESTAMP(6) WITH LOCAL TIME ZONE', -102,                   'INTERVAL YEAR(2) TO MONTH', -103,                   'INTERVAL DAY(2) TO SECOND(6)', -104,                   'BINARY_FLOAT', 100, 'BINARY_DOUBLE', 101,                   1111)                  AS data_type,           t.data_type AS type_name,           DECODE (t.data_precision, null, t.data_length, t.data_precision)                  AS column_size,           0 AS buffer_length,           t.data_scale AS decimal_digits,           10 AS num_prec_radix,           DECODE (t.nullable, 'N', 0, 1) AS nullable,           NULL AS remarks,           t.data_default AS column_def,           0 AS sql_data_type,           0 AS sql_datetime_sub,           t.data_length AS char_octet_length,           t.column_id AS ordinal_position,           DECODE (t.nullable, 'N', 'NO', 'YES') AS is_nullable    FROM all_tab_columns t    WHERE t.owner LIKE :1 ESCAPE '/'      AND t.table_name LIKE :2 ESCAPE '/'      AND t.column_name LIKE :3 ESCAPE '/'    ORDER BY table_schem, table_name, ordinal_position $B!\!\!\!\!\!\!\!\!\!\!\!\!\!\!\!\!\!\!\!\!\!\!\!\!\!\!\!\!\!\!\(B $B2<5-(BURL$B$NJ}K!$r$b$H$K!"(BJDBC$B@\B3;~$N%G%P%C%0%m%0$r=PNO$7!"(B $B%G%P%C%0%m%0$H%?%$%_%s%0!"%"%W%j%1!<%7%g%s$,=PNO$7$F$$$k%m%0$N(BDao$B<B9T$N%?%$%_%s%0$rHf3S$7$^$7$?!#(B <a href="http://otndnld.oracle.co.jp/document/products/oracle11g/111/doc_dvd/java.111/E05720-02/diagnose.htm" target=_blank>http://otndnld.oracle.co.jp/document/products/oracle11g/111/doc_dvd/java.111/E05720-02/diagnose.htm</a> $BBg$-$/J,$1$F0J2<(B2$B<oN`$N(BDao$B$,$"$j$^$9$,!"0J2<$N<oJL$K4X78$J$/!"(B SQL$BJ8$,H/9T$5$l$F$$$k(BDao$B!"H/9T$5$l$F$$$J$$(BDao$B$,$"$j$^$9!#(B $B!&(BJavaBeans$B$K3JG<$5$l$?CM$+$i(BSQL$BJ8$r<+F0@8@.$9$k(BDao $B!&30It(BSQL$B%U%!%$%k$K$h$C$F(BSQL$BJ8$rH/9T$9$k(BDao $BK\%a!<%k$K$F!"0J2<$NE@$K$D$$$F$4B8CN$NJ}$,$$$i$C$7$c$$$^$7$?$i!"(B $B$I$&$+$465<($$$?$@$-$?$/;W$$$^$9!#(B $B!&Ev3:$N(BSQL$BJ8$O!"(BDB$B@\B3;~$N%a%?%G!<%?<hF@$N$?$a$K!"(BS2Dao$B$H(BDB$B$N%I%i%$%P$K$h$C$F(B $B!!H/9T$5$l$F$$$k$H$$$&G'<1$GLdBj$J$$$+(B $B!&Ev3:$N(BSQL$BJ8$NH/9T2s?t$r8+@Q$b$k7W;;<0$J$I$O$"$k$+(B $B!&Ev3:$N(BSQL$BJ8$NH/9T%?%$%_%s%0!"%H%j%,!<!"$=$NB>5,B'@-$J$I$O$"$k$+(B $B$h$m$7$/$*4j$$$7$^$9!#(B ------------------------------------------------------- $B3t<02q<R!!%"%$!&%F%#!&%U%m%s%F%#%"(B $B@>B<!!M&?M(B ---------------------------------------------------- _______________________________________________ Seasar-user mailing list <a href="mailto:Seasar-user@ml.seasar.org" target=_blank>Seasar-user@ml.seasar.org</a> <a href="https://ml.seasar.org/mailman/listinfo/seasar-user" target=_blank>https://ml.seasar.org/mailman/listinfo/seasar-user</a> -- Toshihiro Nakamura -- Toshihiro Nakamura <tt>_______________________________________________ Seasar-user mailing list Seasar-user@ml.seasar.org </tt><a href="https://ml.seasar.org/mailman/listinfo/seasar-user"><tt>https://ml.seasar.org/mailman/listinfo/seasar-user</tt></a><tt> </tt>