Archive for category JSP Core

Make MySQL Connector/J Work with Tomcat

Posted by admin in JSP Core on September 16, 2008

I have been using Tomcat with MySQL for a while, I remember when I first started using Tomcat, it took me a while to make my JSP script connect to MySQL using Connector/J.

1. Locate your Tomcat directory. If you have the recent version of Tomcat installed, you should be able to locate your Tomcat webapps folder:

for my Tomcat 5.5 installation, it looks like: tomcat5.5-webapps/

for my previous Tomcat 5 installation, it looks like: tomcat5/webapps/

2. Create a folder in your webapps, for instance: tomcat5.5-webapps/test/ or tomcat5/webapps/test/

3. Download Connector/J at http://dev.mysql.com/downloads/connector/j/5.1.html

4. Create a directory tomcat5.5-webapps/test/WEB-INF/lib/ or tomcat5/webapps/test/WEB-INF/lib/

5. Unzip or Untar the file, and copy the file mysql-connector-java-5.1.6-bin.jar

6. Paste it inside tomcat5.5-webapps/test/WEB-INF/lib/ or tomcat5/webapps/test/WEB-INF/lib/

7. Now create a test file named sql.jsp inside tomcat5.5-webapps/test/ or tomcat5/webapps/test/

8. Point browser to the url http://localhost:8080/test/sql.jsp, you should be able to see if it’s sucessfully connected to the MySQL database.

JSP

1 Comment

Tomcat JSP MySQL Connection Test Script

Posted by admin in JSP Core on September 14, 2008

If you have JSP, MySQL and Jconnector installed, and wanna test if everything works okay, here is a simple script you can use to test.

<%@ page import = "java.sql.*"%>
<html>
<head>
<title>Obtaining a Connection </title>
</head>
<body>
<%
Connection conn=null;
ResultSet result=null;
Statement stmt=null;
ResultSetMetaData rsmd=null;
try
{
Class c=Class.forName("com.mysql.jdbc.Driver");
}
catch(Exception e)
{
out.write("Error!!!!!!" + e);
}
try
{
conn=DriverManager.getConnection("jdbc:mysql://192.168.110.5:3306/databasename","username","password");
out.write("Connected!");
}
catch(SQLException e)
{
System.out.println("Error!!!!!!" + e);
}

Change 192.168.110 from the above script to your url
databasename, username and password to your databasename, username and password.

JSP Core