App freeze during MySQL connestion

[meiilax]

Hi !

I need help with MySQL connection. I have this code:

public static void main(String[] args) throws SQLException {
      getTitleFromDB(); 
 }
 
 public static void getTitleFromDB() {
     try { 
         Class.forName("com.mysql.jdbc.Driver"); 
     }

     catch(Exception e) { 
         
         System.out.println("Driver error");
         System.out.println(e.toString());
     }

     try {
         Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/cz_lomnice", "adam", "1234");
         Statement st = conn.createStatement();
         ResultSet rs = st.executeQuery("SELECT title FROM lomnice_notams");

         while (rs.next()) {
             System.out.println(rs.getString("title"));
         }
     } 

     catch(Exception e) { 
         System.out.println("DB connection error");
         System.out.println(e.toString());
     }
 }

This works fine and I get DB results. But when I added GUI and I call getTitleFromDB () method via button action

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                         
      getTitleFromDB ();
}

it does not work in Win7 and app frozen (I found on line 17 above, button is pressed down and nothing work, even app closing is impossible). No error, no exception ! I tried to call method in SwingWorker and result is the same – no DB connection and no exception. I don't know where is problem. Is important to say that code above works in WinXP 32b completely (without and with GUI as well), in Win7 32b it works only without GUI (as I wrote above - with GUI app will freeze after button pressing). Does anybody know cause ?

Thanks Milan

[Tolls]

I'm going to hazard a guess at MySQL and the JDBC driver.
I'd have a look at those two for possible problems on Win7...I do know there can be setup differences on a Win7 system, but don't ask me exactly what.

[clydedoris]

for now, create a separate thread for the connection so that the GUI would not be affected.

[Tolls]

From the OP:
"
No error, no exception ! I tried to call method in SwingWorker and result is the same
"

What's with resurrecting old threads?
Trying to advertise your site?