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">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 E-mail nishimura_hayato@itfrontier.co.jp ----------------------------------------------------