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.

----------------------------------------------------------------------------------------------
[B]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" );[/B]

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

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 --[I]Got a
driver instance [/I]and [I]The driver does accept my URL[/I]

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.