Update statement not executing

[saurav sarkar]

Hi All,

I am facing an unique problem.I am firing an Update statement, but the executions gets hang there in the statement.

Please find the code below.

 
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
 
public class BobfSqlUpdateTest {

private static Connection con;

public static void main(String a[])
    {
 try
 {
 PreparedStatement stmt=null;
 ResultSet rs=null;
 System.out.println("before getting the driver");
 Class.forName("oracle.jdbc.driver.OracleDriver");
 
 System.out.println("after getting the driver");
 String dsn="myaccess";
 String url="jdbc:odbc:"+dsn;
 con=DriverManager.getConnection(url,"","");
 System.out.println("before updating the database");
 stmt=con.prepareStatement("update emptable set status=? where record_identifier=?");
 stmt.setString(1,"inprogress");
 stmt.setString(2,"140657");
 int i=stmt.executeUpdate();
 System.out.println("the i:"+i);
 System.out.println("after updating the database");
 
 }
 catch(Exception e)
 {
 System.out.println("the exception occurred:"+e.getMessage());
 e.printStackTrace();
 }
 
    }
}

In the abive program SOP after the executeUpdate() statement is not printing.

[saurav sarkar]

i have solved the problem

cheers

[David O'Meara]

what was the problem?

[Ashok Mash]

Yeah, what was it? Was the original table locked by another application?

[saurav sarkar]

i dont know the exact reason for it........but i did the commit on the table.Then it started working.
Then now i have put con.commit() in the code.So, its working fine.