[jboss-user] [JBossCache] - Re: Urgent- Socket error when adding object to DB using JDBC

[malek256]

Adding the following additional change allowed for 10,000 consecutive updates without error.

     public NonManagedConnectionFactory(String url, String usr, String pwd)
      {
         this.url = url;
         this.usr = usr;
         this.pwd = pwd;
         
         // what if I do a connection right off?
         // BEGIN MODIFICATION:  GJF - October 10, 2006
         Connection con = getConnection();
         try {
            con.setAutoCommit(false);
         } catch( SQLException e ){
             // don't care
         }
         // END MODIFICATION
      }


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3977285#3977285

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3977285