class not found exception

[menmysql]

hi

i am using mysql as database while connecting to database using jsp i am getting the following exception


"java.lang.Clas sNotFoundExcept ion:com.mysql.j dbc.Driver"


can any one tell wha tis the actual problem



regards

[Ganon11]

Did you retype this on the site, or did you copy and paste? There is a space in the middle of the word Driver - you may have mistakenly typed an extra space when typing the import statement.

[dmjpro]

did u include the JDBC library?????

[sicarie]

hi

i am using mysql as database while connecting to database using jsp i am getting the following exception

"java.lang.Clas sNotFoundExcept ion:com.mysql.j dbc.Driver"

can any one tell wha tis the actual problem

regards

My guess would be that the problem lies in your 1) classpath, or 2) declaration.

Did you include the JDBC driver in your classpath, or attach it to your project? If so, can wee see your declaration (the classforname, etc...)?

[menmysql]

i copyed the exception what i got from my jsp page thats why

Did you retype this on the site, or did you copy and paste? There is a space in the middle of the word Driver - you may have mistakenly typed an extra space when typing the import statement.

[menmysql]

thanks for your reply,

i downloaded mysql connector/j from mysql.com ,i copied the .jar file in to ./tomcat 5.0/common/lib and i set path at environment variables. i tryed at two different systems. in one system which is upgraded from mysql 4.0.17 to 5.0 and webserver is tomcat 5x, at this system i am getting java.sql.SQLExc eption: Communication link failure: Bad handshake


then i went to my friends place and i freshely installed java 6.0, tomcat 6x, mysql 5.0 and mysql connector/j 5.0 and i set path as above i mentiond. but this time i am getting different exception that is "java.lang.Clas sNotFoundExcept ion:com.mysql.j dbc.Dr iver"

can any one tell how to solve my problem
.

My guess would be that the problem lies in your 1) classpath, or 2) declaration.

Did you include the JDBC driver in your classpath, or attach it to your project? If so, can wee see your declaration (the classforname, etc...)?

[sicarie]

thanks for your reply,

i downloaded mysql connector/j from mysql.com ,i copied the .jar file in to ./tomcat 5.0/common/lib and i set path at environment variables. i tryed at two different systems. in one system which is upgraded from mysql 4.0.17 to 5.0 and webserver is tomcat 5x, at this system i am getting java.sql.SQLExc eption: Communication link failure: Bad handshake


then i went to my friends place and i freshely installed java 6.0, tomcat 6x, mysql 5.0 and mysql connector/j 5.0 and i set path as above i mentiond. but this time i am getting different exception that is "java.lang.Clas sNotFoundExcept ion:com.mysql.j dbc.Dr iver"

can any one tell how to solve my problem
.

Ok, can we see the code where you do the declaration?

[menmysql]

thanks for your reply

i am keeping my program as follows

<%@ page import="java.sql.*"%>
<%! String Name;%>
<%
	try
	{
		Class.forName("com.mysql.jdbc.Driver");
		Connection con=DriverManager.getConnection("jdbc:mysql://localhost/cheer","root","");
		Statement st=con.createStatement();
		String Q="select name from how";
		ResultSet rs=st.executeQuery(Q);
		while(rs.next())
		{
			Name=rs.getString(1);
			out.println(Name);
		}
		rs.close();
		st.close();
		con.close();
	}
	catch(Exception e)
	{
		out.println(e);
	}
	
	%>

can you tell me where i did mistake

regards

Ok, can we see the code where you do the declaration?

[itsraghz]

in case of 'Communication Link Failure' means the database might not have started propertly.

With MySQL 5.0 version, you might have installed it as an Windows Executable Service. In that case, you need to ensure whether the MySQL Service is started or not.

Go to Run
type "services.m sc"
There check "MySQL" service is running or not. Also check whether its Manual or Automatic. Manual means you need to start it everytime.

Hope this helps....

[sicarie]

Yeah, good call itsragz - the code looks right... but I'll check it when I get back to my compiler.

[menmysql]

thanks for your reply,

i checked, it is set to automatic only

in case of 'Communication Link Failure' means the database might not have started propertly.

With MySQL 5.0 version, you might have installed it as an Windows Executable Service. In that case, you need to ensure whether the MySQL Service is started or not.

Go to Run
type "services.m sc"
There check "MySQL" service is running or not. Also check whether its Manual or Automatic. Manual means you need to start it everytime.

Hope this helps....

[sicarie]

thanks for your reply,

i checked, it is set to automatic only

And it is started?

What version of mysql.jdbc driver are you using?

[menmysql]

i am using mysql connector/j 5.0

And it is started?

What version of mysql.jdbc driver are you using?

[menmysql]

thanks to all

at last i got sucess. my jsp program retriving record from my data base. thanks a lot to all who gave sugessions all these days.


thanks thanks a lot


regards

Narasimha Raju Naidu

[itsraghz]

thanks to all

at last i got sucess. my jsp program retriving record from my data base. thanks a lot to all who gave sugessions all these days.


thanks thanks a lot


regards

Narasimha Raju Naidu

thats gr8.. keep going..