<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 style>
$B$O$$!#(B</div><div style>$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" style>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" style>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" style>$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" style>
<br></div><div class="gmail_extra" style>$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" style>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" style>2$B$D$N%a%=%C%I$KBP1~$7$^$9!#(B</div>
<div class="gmail_extra" style>- setupPrimaryKey</div><div class="gmail_extra" style>- 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" style><a href="http://s2dao.seasar.org/ja/daoDicon.html#customizationByComponent">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"><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>_______________________________________________<br>
Seasar-user mailing list<br>
<a href="mailto:Seasar-user@ml.seasar.org">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><br><br clear="all"><div><br></div>-- <br>Toshihiro Nakamura
</div></div>