error while connecting mysql database using jsp

[menmysql]

i am getting the following error while connecting mysql database using jsp

java.sql.SQLException: Communication link failure: Bad handshake


can any one tell what is the actual problem

[Motoma]

i am getting the following error while connecting mysql database using jsp

java.sql.SQLException: Communication link failure: Bad handshake


can any one tell what is the actual problem

A little Googling told me that this may be resolved by downloading the latest version of the MySQL connector for Java.

[menmysql]

thanks for your reply,

i will do it but is there any post instalation instructions any are there like copying files from one folder to another folder like tools.jar in mysql4.0,17 version. waiting for your reply


regards

A little Googling told me that this may be resolved by downloading the latest version of the MySQL connector for Java.

[Motoma]

thanks for your reply,

i will do it but is there any post instalation instructions any are there like copying files from one folder to another folder like tools.jar in mysql4.0,17 version. waiting for your reply


regards

I would suggest reading the online documentation at the MySQL website.

[menmysql]

i read the documentation and i done what they wrote. but still i am getting the same excetion. any forther sugessions

[Motoma]

i read the documentation and i done what they wrote. but still i am getting the same excetion. any forther sugessions

What version of the driver are you using? What version MySQL database are you connecting to? Could you post the rest of the stack trace, as well as the code that caused the error (in [CODE ][/code] brackets of course)?

[menmysql]

hi

i am using mysql connector/ODBC 3.51 AND MYSQL SEREVER IS MYSQL SERVER 5.0.

What version of the driver are you using? What version MySQL database are you connecting to? Could you post the rest of the stack trace, as well as the code that caused the error (in [CODE ][/code] brackets of course)?

[Motoma]

hi

i am using mysql connector/ODBC 3.51 AND MYSQL SEREVER IS MYSQL SERVER 5.0.

I did some bebopping around on the MySQL support site and it points out that this error can be thrown if the user does not have permissions to the table you are trying to access.

[menmysql]

thanks for your reply

now i reinstalld all softwares as follows
java 6.0, tomcat 6.0, mysql 5.0 and mysql connector/j 5.0


now i am gwttin the following error while running my jsp file

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

what may be the problem

I did some bebopping around on the MySQL support site and it points out that this error can be thrown if the user does not have permissions to the table you are trying to access.

[Motoma]

thanks for your reply

now i reinstalld all softwares as follows
java 6.0, tomcat 6.0, mysql 5.0 and mysql connector/j 5.0


now i am gwttin the following error while running my jsp file

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

what may be the problem

Your application did not find the JDBC driver.

[menmysql]

thanks to all py problem is solved

[Motoma]

Care to post back the solution so other people with this problem will have a solution?