> Is ther any to set a timeout when execute a sql stmt??
I believe this depends on the interface...for example, in JDBC, it
is this:
Statement s = new Statement();
s.setQueryTimeout(20); // Sets query timeout to 20 seconds.
...
I don't know what other interfaces offer timeouts, but that's where
you should look to find out.
--Jeremy