Difference between running in Eclipse and as a jar

[Atrus Greyor]

Whenever I run PartsOfSpeechRequest() in Eclipse from the code as shown below, it works fine.

    
package internet;
 

 
import java.sql.Connection;
 
import java.sql.DriverManager;
 
import java.sql.PreparedStatement;
 
import java.sql.ResultSet;
 
import java.sql.SQLException;
 
import java.util.ArrayList;
 

 
import javax.swing.JOptionPane;
 

 
public class MySQLRequests
 
{
 
private Connection c = null;
 

 
private String user = "atrus_user";
 
private String pass = "user";
 
private String url = "jdbc:mysql://berry.arvixe.com/atrus_Worlds";
 

 
public MySQLRequests()
 
{
 
try
 
{
 
Class.forName("com.mysql.jdbc.Driver").newInstance();
 
c = DriverManager.getConnection(url, user, pass);
 
} 
 
catch (InstantiationException e)
 
{
 
e.printStackTrace();
 
} 
 
catch (IllegalAccessException e)
 
{
 
e.printStackTrace();
 
} 
 
catch (ClassNotFoundException e)
 
{
 
e.printStackTrace();
 
} 
 
catch (SQLException e)
 
{
 
e.printStackTrace();
 
}
 
}
 

 
public ArrayList PartsOfSpeechRequest(String word)
 
{
 
JOptionPane.showMessageDialog(null, "At the Begining of tbhe POSR method");
 
ArrayList al = new ArrayList(10);
 
JOptionPane.showMessageDialog(null, "After the ArrayList");
 

 
try
 
{
 
JOptionPane.showMessageDialog(null, "Inside the try");
 
if(c.isClosed())
 
{
 
JOptionPane.showMessageDialog(null, "C was closed >.<");
 
c = DriverManager.getConnection(url, user, pass);
 
}
 

 
JOptionPane.showMessageDialog(null, "Before the PreparedStatement");
 
PreparedStatement ps = c.prepareStatement("SELECT pos FROM PartsOfSpeech WHERE word = ?;");
 
ps.setString(1, word);
 
ResultSet rs = ps.executeQuery();
 
JOptionPane.showMessageDialog(null, "After the PreparedStatement");
 

 
while(rs.next())
 
al.add(rs.getString("pos"));
 
} 
 
catch (SQLException e)
 
{
 
PartsOfSpeechRequest(word);
 
JOptionPane.showMessageDialog(null, "I'm in the catch statement!");
 
}
 
return al;
 
}
 

 
public ArrayList numberOfTimesUsed(String word)
 
{
 
ArrayList a = new ArrayList();
 

 
try 
 
{
 
if(c.isClosed())
 
c = DriverManager.getConnection(url, user, pass);
 

 
PreparedStatement ps = c.prepareStatement("SELECT pos, used FROM PartsOfSpeech WHERE word = ?");
 
ps.setString(1, word);
 

 
ResultSet rs = ps.executeQuery();
 

 
while(rs.next())
 
{
 
String[] foo = new String[2];
 
foo[0] = rs.getString("pos");
 
foo[1] = Integer.toString((rs.getInt("used")));
 
if(foo != null)
 
a.add(foo);
 
}
 
} 
 
catch (SQLException e) 
 
{
 
numberOfTimesUsed(word);
 
}
 

 

 
return a;
 
}
 
}
 

 

However, whenever I put it in a jar, it doesn't work. It will establish a connection, but the method will not work. As you can see, I have put a bunch of JOptionPane.showMessageDialogs, to see exactly where it was breaking. It gets to the try...and then nothing. Neither the JOptionPane that displays "C was closed >.<" nor "Before the PreparedStatement" display.

Does anyone have a suggestion as to why this happens?

[Atrus Greyor]

While I had originally thought that this was a MySQL and JDBC problem, I eventually figured out that it was not. It was a jar Manifest problem, but I have it all worked out now.