Connection to mysql using jsp
Posted by: arun chanumalla
Date: April 04, 2005 10:50AM

hi,

i came across a strange problem.
After installing mysql-3.23.58.i tried to test the JDBC connection to mysql with the following program.

it worked fine and gave me all the expected results.
after few days when iam trying to run the same program,i get page cannot be displayed error after about 15 min after the page was loaded.

looks like its trying to process the jsp file and failed.
all other jsp pages without database connections are working fine.

here goes my program.

*********************** Start***************************


<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<%! Connection con=null; %>
<%! Statement st= null; %>
<%! ResultSet rs= null; %>


<html>
<head><title>This is a Jdbc Example</title></head>
<body>

<%
out.println("Arun K Chanumalla");


try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
}catch(ClassNotFoundException ce){out.println(ce);}

try{
con = DriverManager.getConnection("jdbc:mysql://localhost/weather","chanumaa", "arcims");
st = con.createStatement();
rs = st.executeQuery("SELECT name, age FROM arun");
while(rs.next()) {

String name = rs.getString(1);
int age = rs.getInt(2);
out.println(name + " " +age+"<br>");

} // end of whilee
rs.close();
st.close();
con.close();

}catch(SQLException exception){
out.println("<!--");
StringWriter sw = new StringWriter();
PrintWriter pw = new PrintWriter(sw);
exception.printStackTrace(pw);
out.print(sw);
sw.close();
pw.close();
out.println("-->");

}



%>
</body>
</html>

*************************** end**************************


i tried to run the same program by saving it with .java extension by making all necessary changes, the program then worked fine and gave the expected results.

the bottomline is iam using the same database,table,driver for both jsp,java programs.
the .java is working and not the .jsp

i have no clue y..??
any of you database techies may want to throw some suggestions here please..??

Regards
Arun

Options: ReplyQuote


Subject
Written By
Posted
Connection to mysql using jsp
April 04, 2005 10:50AM
November 27, 2005 05:27AM
September 24, 2006 10:26AM
December 27, 2007 11:53PM
December 31, 2007 09:54PM
February 19, 2006 11:57PM
b g
June 09, 2009 04:43AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.