jdbc executeupdate bug

[curwen]

hi all,
it seems this normal code for update database using jdbc doesn't work:

//////////////
stmt = conn.createStatement();
//int i = stmt.executeUpdate(s);
flag = stmt.execute(s);
conn.close();
}

catch(SQLException se)
{
System.out.println( se) ;
}
///////////

it's weird because it doesn.t generate any error catched by the exception
it just remains 'freezed' at the executeupdate line

the connection is all right and the sql statements works elsewhere

I'm using oracle 9i and jdev 903
the system library is Oracle JDBC, (classes12.jar)

thanks in advance
Diego

 

[Joe Smith]

it's weird because it doesn.t generate any error catched by the exception
it just remains 'freezed' at the executeupdate line

watch for other connections to the database that might be waiting for a
commit.