Java Database Connectivity (JDBC)

Hi there!

I've been struggling with this problem for a while.

I have a database from which I need to read and display some data on a browser. (The database is set up for remote access).

I'm using the following JSP/JDBC code to do that.

----------------------------------------------------------------------------------------------
Class.forName ("com.mysql.jdbc.Driver").newInstance();
out.println("<BR> Connecting to DB...Pls. Wait <BR>");

Connection con = DriverManager.getConnection("url","user","pwd");

if(con.isClosed())
out.println("<BR><BR><BR>" +"Could NOT connect to MySQL Database...");
else out.println("<BR> CONNECTED !!! <BR>");

Statement stmt = con.createStatement();
results = stmt.executeQuery("SELECT * FROM TableName" );

-----------------------------------------------------------------


When I run this of my local machine, it works fine. But when I upload it to a server, it doesn't run through. I dont get either the connected or not connected message.

I tried this piece of code that I found online to check the driver.
----------------------------------------------------------------------------------------------------------------
/*Driver d = (Driver)Class.forName("com.mysql.jdbc.Driver").newInstance();
out.println("<BR>Got a driver instance. ");
if (d.acceptsURL(url)) out.println("<BR>The driver does accept my URL");
else out.println("<BR>The driver doesn't like the URL I'm trying"); */
------------------------------------------------------------------------------------------------------------------

I ran it off the server and it worked. I got the outputs --Got a driver instance and The driver does accept my URL


I'm unable to figure out why this code can be run locally from my machine, but not from a different location. The database is NOT on my machine.

Any inouts will be really appreciated.

I'm using an Apache Tomcat container and the database is MySQL.