Not sure if this is the place to ask but hopefully someone can help me
here. I am setting an application system and have successfully setup
MySQL 5.0.15 and Tomcat 5.5.12. However, I cannot seem to get a
connection object from my servlet and for the life of me, I can't figure
out why. Here is what I have done:
Downloaded mysql-connector-java-3.1.11-bin.jar into
$CATALINA_HOME/common/lib
Added mysql-connector-java-3.1.11-bin.jar to my classpath
and I created the following servlet, TestSQL:
import java.sql.*;
import javax.naming.InitialContext;
import javax.sql.DataSource;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.naming.*;
public class TestSQL extends HttpServlet {
private Connection conn = null;
public void doGet(HttpServletRequest request,
HttpServletResponse response)
throws IOException, ServletException {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
try {
if (conn == null) {
Class.forName("com.mysql.jdbc.Driver").newInstance();
connW =
DriverManager.getConnection("jdbc:mysql://localhost/hostname", <id>,
<password>);
}
} catch (Exception e) {
e.printStackTrace();
}
if (conn != null) {
out.println("Connection read successful");
} else {
out.println("Cannot get connection");
}
}
}
I keep getting "Cannot get connection" message in my servlet. I tried
connecting to the database (locally) using mysql client with <id> just
to make sure the account works and it does. I setup a similar system
before and was able to connect to the database successfully so I can't
figure out what's wrong.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
