<html dir="ltr"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-2022-jp"> <style type="text/css" id="owaParaStyle"></style> </head> <body fpstyle="1" ocsi="0"> <div style="direction: ltr;font-family: MS$B%4%7%C%/(B;color: #000000;font-size: 10pt;">$B$R$,$G$9!#(B <div> </div> <div>$B%H%i%s%6%/%7%g%s$HO"F0$7$F$$$l$P!"<+F0$G(Bautocommit$B$O(Boff$B$K$J$k$O$:$J$N$G!"(B</div> <div>$B$^$:$O!"%H%i%s%6%/%7%g%s$N@_Dj$r8+D>$7$F$_$F$/$@$5$$!#(B <div style="font-family: Times New Roman; color: #000000; font-size: 16px"> <hr tabindex="-1"> <div id="divRpF361875" style="direction: ltr; ">$B:9=P?M(B: seasar-user-bounces@ml.seasar.org [seasar-user-bounces@ml.seasar.org] $B$,<!$N?M$NBeM}$GAw?.$7$^$7$?(B: saraki@pacific-systems.co.jp [saraki@pacific-systems.co.jp] $BAw?.F|;~(B: 2012$BG/(B11$B7n(B6$BF|(B 11:45 $B08@h(B: seasar-user@ml.seasar.org $B7oL>(B: [Seasar-user:21491] jdbc.dicon$B$K$*$1$k(BPostgreSQL$B$N(BautoCommit$B@_Dj$K$D$$$F(B </div> <div></div> <div> $B$O$8$a$^$7$F!#9SLZ$H?=$7$^$9!#(B PostgreSQL + S2Dao + Teeda$B$N3+H/$r$7$F$$$^$9!#(B $BF0:n4D6-(B jdk1.6.0_34 tomcat-6.0.35 eclipse3.4.2 Teeda 1.0.12 S2Dao 1.0.47 PostgreSQL 9.1.5 jdbc.dicon$B$G0J2<$NDL$j(BautoCommit$B$rL58z$K$7$F$$$k$N$G$9$,!"(Bupdate$BJ8$J$I$,<B9T$5$l$F$b<+F0E*$K%3%_%C%H$5$l$F$7$^$$$^$9!#(B         <component name="xaDataSource"                 class="org.seasar.extension.dbcp.impl.XADataSourceImpl">                 <property name="driverClassName">                         "org.postgresql.Driver"                 </property>                 <property name="URL">                         "jdbc:postgresql://PORTAL_IFRS_IT_DB/test"                 </property>                 <property name="user">"test"</property>                 <property name="password">"test"</property>                 <initMethod name="addProperty">                         <arg>"autoCommit"</arg>                         <arg>"false"</arg>                 </initMethod>         </component> jdbc.dicon$B$G(BautoCommit$B$rL58z$K$9$k$K$O$I$&$7$?$i$h$$$N$G$7$g$&$+!#(B $B$J$*!"(BS2Dao+jdbc.dicon$B$G$O$J$/!"0J2<$NDL$j(BsetAutoCommit$B%a%=%C%I$rL@<(E*$K5-=R$9$k$H(BautoCommit$B$,L58z$K$J$j$^$7$?!#(B         try {             // JDBC$B%I%i%$%P$NEPO?(B             String driver = "org.postgresql.Driver";             // $B%G!<%?%Y!<%9$N;XDj(B             String url = "jdbc:postgresql://PORTAL_IFRS_IT_DB/test";             String user     = "test";         //$B%G!<%?%Y!<%9:n@.%f!<%6L>(B             String password = "test";     //$B%G!<%?%Y!<%9:n@.%f!<%6%Q%9%o!<%I(B             Class.forName (driver);             // $B%G!<%?%Y!<%9$H$N@\B3(B             Connection con = DriverManager.getConnection(url, user, password);             con.setAutoCommit (false);             Statement stmt = con.createStatement ();             String sql = "UPDATE m_kanri_kengen SET update_dt = now() WHERE kanri_kengen_cd = 'G110'";             stmt.executeUpdate(sql);             stmt.close();             con.close();         } catch (SQLException e) {             System.err.println("SQL failed.");             e.printStackTrace ();         } catch (ClassNotFoundException ex) {             ex.printStackTrace ();         } $B0J>e!"59$7$/$*4j$$CW$7$^$9!#(B</div> </div> </div> </div> </body> </html>