Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>If you're using <code>Swing</code>, the <code>SwingWorker</code> provides capabilities for this, and you don't have to deal with the thread pool yourself.</p> <p>Fire off a <code>SwingWorker</code> for each request. If a new request comes in and the worker is not done, you can <code>cancel()</code> it, and just start a new <code>SwingWorker</code>. Regarding what the other poster said, I don't think <code>publish()</code> and <code>process()</code> are what you are looking for (although they are also very useful), since they are meant for a case where the worker might fire off events faster than the GUI can process it.</p> <pre><code>ThingyWorker worker; public void actionPerformed(ActionEvent e) { if( worker != null ) worker.cancel(); worker = new ThingyWorker(); worker.execute(); } class ThingyWorker extends SwingWorker&lt;YOURCLASS, Object&gt; { @Override protected YOURCLASS doInBackground() throws Exception { return doSomeComputation(); // Should be interruptible } @Override protected void done() { worker = null; // Reset the reference to worker YOURCLASS data; try { data = get(); } catch (Exception e) { // May be InterruptedException or ExecutionException e.printStackTrace(); return; } // Do something with data } } </code></pre> <p>Both the action and the <code>done()</code> method are executed on the same thread, so they can effectively check the reference to whether there is an existing worker.</p> <p>Note that effectively this is doing the same thing that allows a GUI to cancel an existing operation, except the cancel is done automatically when a new request is fired.</p>
    singulars
    1. This table or related slice is empty.
    1. POClever asynchronous repaint in Java
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USAndrew Mao
    1. USAndrew Mao
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POClever asynchronous repaint in Java
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COgood solution. but it's unclear to me whether there's a small chance that after `worker1.cancel()`, `worker1.done()` is still executed, and it can be executed after `worker2.done()`, i.e. an older result overwrites a newer result. need a bit more investigation here.
      singulars
      1. PO
      1. USZhongYu
    2. COThis doesn't solve the problem of how to batch the requests, to avoid the situation where you're cancelling and restarting the thread many times over some short period.
      singulars
      1. PO
      1. USRichard Sitze
    3. COI don't think you can ever avoid canceling the requests, because you never know if some request is the last one. Sure, you can wait a bit before firing off workers, to see if more requests are coming, but that would just make the update slower.
      singulars
      1. PO
      1. USAndrew Mao
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload