DaniWeb Forum Index > Web Development > JSP

connecting jsp with mysql database

Please support our JSP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Sep 2005

Posts: 139

Reputation: aarya is an unknown quantity at this point

Solved Threads: 0

aarya

Offline

Junior Poster

connecting jsp with mysql database

Apr 20th, 2006

i m trying to connect jsp page to mysql. i have insatlled jsp-mysql connector. but still not able to connect to mysql. pla anybody help me.
thanks

•

Join Date: Sep 2005

Posts: 139

Reputation: aarya is an unknown quantity at this point

Solved Threads: 0

aarya

Offline

Junior Poster

Re: connecting jsp with mysql database

Apr 20th, 2006

•

Originally Posted by aarya

i m trying to connect jsp page to mysql. i have insatlled jsp-mysql connector. but still not able to connect to mysql. pla anybody help me.
thanks

i also tried with thsi code
but i am getting the exception as
javax.servlet.ServletException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.io.EOFException
the code is
<%@ page import="java.sql.*" %>
<%
String connectionURL = "jdbc:mysql://localhost:8080/login?user=user;password=pass";
Connection connection = null;
Statement statement = null;
ResultSet rs = null;
%>

<html><body>

<%
Class.forName("com.mysql.jdbc.Driver").newInstance();
connection = DriverManager.getConnection(connectionURL, "", "");
statement = connection.createStatement();
rs = statement.executeQuery("SELECT * FROM contact");

while (rs.next()) {
out.println(rs.getString("id")+"<br>");
}

rs.close();
%>

</body></html>

•

Join Date: Jul 2006

Posts: 2

Reputation: mishu007 is an unknown quantity at this point

Solved Threads: 0

mishu007

Offline

Newbie Poster

Re: connecting jsp with mysql database

Jul 26th, 2006

First of all try to match jsp-mysql connector with MYSQL version.. because it tooks me 15 days to match that... Atlast with the help of MYSQL4.0 i can accomplish my connection.