db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <sathe...@Sourcery.Org>
Subject Re: Aborting SQL Statements
Date Fri, 18 Feb 2005 21:58:19 GMT
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Derby's embedded JDBC driver doesn't support setQueryTimeOut() or
cancel(). These are currently implemented to raise exception in <b>EmbedStatement</b>.java.<br>
<br>
&nbsp;&nbsp;&nbsp; public void setQueryTimeout(int seconds) throws SQLException
{<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; if (seconds != 0)<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
throw Util.notImplemented("setQueryTimeout");<br>
&nbsp;&nbsp;&nbsp; }<br>
&nbsp;&nbsp;&nbsp; public void cancel() throws SQLException {<br>
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; throw Util.notImplemented("cancel");<br>
&nbsp;&nbsp;&nbsp; }<br>
<br>
But I think Derby's client JDBC driver, currently the IBM Universal
driver, has some support. (I haven't tested it..) IBM recently
announced contributing a Derby Client to Apache. If this client code is
accepted and has the implementation for setQueryTimeOut() and cancel(),
it might be easy to adapt that code to Embed driver as well.<br>
<br>
Satheesh<br>
<br>
Shreyas Kaushik wrote:
<blockquote cite="mid4215BCFA.1070905@Sun.com" type="cite">Hi all,
  <br>
  <br>
Can anyone let me know whether Derby supports aborting SQL Statements?
And also is anybody working
  <br>
to provide support for setQueryTimeOut() and cancel() in
java.sql.Statement interface.
  <br>
  <br>
thanks
  <br>
Shreyas
  <br>
  <br>
  <br>
  <br>
</blockquote>
</body>
</html>


Mime
View raw message