How to make each SQL query is a thread?

Question

I'm writing a program in Java GUI. I have a main JFrame from which released with SQL queries buttons and also a JFrame with gif. For SQL queries, I've created a class that provides connection to the database and has a method for each type of query. The fact is that while doing the query, the new JFrame with gif freezes. I know that is because the query is not a Thread. But inherit from Thread is not the solution at all.

I want every method of consultation is like a Thread. To also be able to launch it from anywhere in the main JFrame JFrame without any freezing.

Thank you very much.

This should be a good start: http://stackoverflow.com/questions/1531073/is-java-sql-connection-thread-safe — AhDev, Mar 14 '14 at 12:45
I understand what the connection pool. But that does not solve my problem. thanks — York Xtrem, Mar 14 '14 at 12:51

score 1 · Answer 1 · answered Mar 14 '14 at 12:56

1

Since your application is using swing you should take a look at the SwingWorker class that is designed just for jobs like that.

While you're about it take your time to study the swing threading model, e.g. starting from here.

answered Mar 14 '14 at 12:56

piet.t

11,718
21
43
52

Thanks, I will look: swing threading model and SwingWorker. Let's see if I find solution. – York Xtrem Mar 14 '14 at 13:04

score 0 · Accepted Answer · answered Mar 28 '14 at 10:27

0

Solution: Use SwingWorker - DoInBackground () Make check here. - Done () Ask here showing a JTable.

answered Mar 28 '14 at 10:27

York Xtrem

58
1
10

How to make each SQL query is a thread?

2 Answers2