Re: Java and oracle 8i

[Quoted] essentially its just this......(took out alot of code) ......stmt is a prepared statement....and one is the sql query string...the sql is correct.... (and record size is 1124)...gets up to 525 and pukes.....i have tried alo of combos (setting autocommit off, doing commits maunally, etc). i even tried opening a new connection after the 500th record....but i still get that tns data channel error.......? Only other thing i can think of....is this right -> using the jdbc:oracle:thin?

 try

    {
      connection = dbControl.openConnection(connection, importName);

      for(int x=0; x<records.size(); x++)
      {
         .......


          stmt = null;
          stmt = connection.prepareStatement(one);
          stmt.executeUpdate();
          stmt.close();

       }




     }



     catch (SQLException de)
     {
       System.out.println("unable to insert beacuse: " + de);



     }