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