title: Google Web Toolkit (GWT) web app with MySQL working fine in Eclipse but not working on openSUSE server
body: <p>I've written a GWT web app which is hosted on an external openSUSE server. I use Google's GWT RPC to communicate with the server and send data from my client to the server where a MySQL database gets updated. Everything works perfectly fine in Eclipse but as soon as I move my /war directory to the server (including the necessary mysql-connector-java-5.1.18-bin.jar file for the java-connector), the local SQL database on my server is not getting updated. Why is it not working? Is this some kind of mysql config issue?</p>
  
  <p>I have set up a database on the server with the exact same name and table as the one on my local machine (where I was debugging with Eclipse). I do not get any errors from GWT (so the server access works fine) and my SQL log files also show no errors. </p>
  
  <p>I have tried to restart mysql, checked that port 3306 for mysql is open and listening, disabled the firewall, and tried both localhost and 127.0.0.1 for the host. </p>
  
  <p>I cannot figure out what the problem is, PLEASE someone help me! I'm going crazy here! </p>
  
  <p>Here is my server side code which works fine in Eclipse but not on the server!</p>
  
  <pre><code>package com.mycompany.mywebapp.server;
  
  @SuppressWarnings("serial")
  public class GreetingServiceImpl extends RemoteServiceServlet implements
      GreetingService {
  
  public String[] greetServer(String[] input) {
  
      //Data is entered into MySQL database on server side 
      Connection con = null; 
      Statement st = null; 
  
      String url = "jdbc:mysql://127.0.0.1:3306/testdb";
      String user = "username";
      String password = "pass";
  
      try{
          con = DriverManager.getConnection(url,user,password); //establishes connection to database
          st = con.createStatement(); //object for sending SQL statements to database 
  
          for (int i=0;i&lt;input.length;i++){
              String DataToSend = input[i];
              String part1 = DataToSend.substring(0,DataToSend.indexOf("["));
              String part2 = DataToSend.substring(DataToSend.indexOf("["),DataToSend.indexOf("]")+1);
              //store values into mysql database
              String query = "INSERT INTO boundingboxes(name, box) VALUES('"+part1+"','"+part2+"')";
              st.executeUpdate(query);
          }
  
      }catch (SQLException ex){
          Logger lgr = Logger.getLogger(Version.class.getName());
          lgr.log(Level.SEVERE, ex.getMessage(), ex);
  
      }finally{
          //make sure to avoid null pointerexception 
          try{
              if (st !=null){
                  st.close();
              }
              if (con != null){
                  con.close();
              }
          }catch (SQLException ex){
              Logger lgr = Logger.getLogger(Version.class.getName());
              lgr.log(Level.WARNING, ex.getMessage(), ex);
          }
      }
  
      return input; 
  }
  
  
  
  }
  </code></pre>