473,695 Members | 2,540 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

error while connecting mysql database using jsp

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

java.sql.SQLExc eption: Communication link failure: Bad handshake


can any one tell what is the actual problem
Apr 2 '07 #1
11 5234
Motoma
3,237 Recognized Expert Specialist
i am getting the following error while connecting mysql database using jsp

java.sql.SQLExc eption: 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.
Apr 2 '07 #2
menmysql
53 New Member
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.
Apr 2 '07 #3
Motoma
3,237 Recognized Expert Specialist
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.
Apr 3 '07 #4
menmysql
53 New Member
i read the documentation and i done what they wrote. but still i am getting the same excetion. any forther sugessions
Apr 3 '07 #5
Motoma
3,237 Recognized Expert Specialist
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)?
Apr 3 '07 #6
menmysql
53 New Member
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)?
Apr 3 '07 #7
Motoma
3,237 Recognized Expert Specialist
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.
Apr 3 '07 #8
menmysql
53 New Member
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.Class NotFoundExcepti on: 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.
Apr 3 '07 #9
Motoma
3,237 Recognized Expert Specialist
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.Class NotFoundExcepti on: com.mysql.jdbc. Driver

what may be the problem
Your application did not find the JDBC driver.
Apr 3 '07 #10

Sign in to post your reply or Sign up for a free account.

Similar topics

3
17802
by: Pugi! | last post by:
On a freshly installed Fedora C3 (incl. webserver apache php mysql) i get the following problem when connecting to mysql through a browser (phpMyAdmin): : #2002 Can't connect to local MySQL server through socket /var/lib/mysql/mysql.sock On the website of MySQL this error is mentioned but I found no solution. In /var/log/messages the following log occurs :
0
1557
by: ngiven | last post by:
Hello All, I'm running mysql 4.0.21 on an HP-UNIX machine and I am getting the following error: Got error 12 from Table Handler After looking up this error in the MySQL manual, http://dev.mysql.com/doc/mysql/en/Operating_System_error_codes.html, I've found that it is an "Out of Memory" error.
3
6168
by: kamilla | last post by:
I have a mysql 3.5 server installed on a suse linux 8.1, with address 10.0.0.100. Now I want to access that db from a W2K pc, address 10.0.0.200. I am able to ping 10.0.0.100, but I cannot connect to the db, and get error 2013. I have tried with MySQL Administrator 1.0 and also with ODBC. The db on linux has grant all on *.* to ''@'10.0.0.%' and also tried .... to root@10.0.0.200 and others seen on posted messages. I can access that db...
4
15604
by: 21novembre | last post by:
Hi all, I got a quite strange problem when I tried to setup a database backup shell. I put it this way: "bin/mysqldump --opt --user=xxx --password=xxx DB > DB.bak" However, error 1045 came to me to say "Access denied for user 'xxx'@'localhost' (using password: YES) when trying to connect". None the less, I'm absolutely full of confidence on my correct username and password, simply because if I do it this way: "bin/mysqldump --opt...
3
4144
by: dstewart | last post by:
Situation: One common MySQL database server on SuSE 9.1 with all updates. Uses 'rinetd'. Has entries for the appropriate IP addresses of all servers. NOTE: If the appropirate entries are NOT in rinetd, the error message is: ERROR 2013: Lost connection to MySQL server during query Using the exact same query from prompt on several clients (some are SuSE 9.1, some are older Redhat systems, but none are configured
6
3188
by: Erik H. | last post by:
Trying to connect to MySQL db on localhost, and populate datagrid from a dataset using code inline method. Getting the following compile error: Error Message: "CS0246: The type or namespace name 'CoreLab' could not be found (are you missing a using directive or an assembly reference?)" I downloaded the add on for connecting to MySQL using ADO.NET and installed it, but am still getting this error. Anybody ever run into this before?
2
9435
by: arsisthesis | last post by:
Hi all, I have a curious problem with the ERROR 1044 and 1045: -system: OS X 10.4.3 (bash shell) -bash schell prompt: /~ kssun$ -I have set passwd to 'kssun' -I set path: PATH=${PATH}:/usr/local/mysql/bin - symptom 1
3
2700
by: Paradox Synthesist | last post by:
hi, i am a newbie to asp.net and have started learning mainly from websites. i have a question which IS very silly and trivial. http://msdn2.microsoft.com/en-us/library/system.data.odbc.odbcconnectionstringbuilder.dsn(VS.80).aspx i looked through this url to see how could i connect to a mysql database...where does the dsn figure out? why do i need to give it? i cant see any dsn specified anywhere on the database control panel. i am a...
8
4732
by: Ananthu | last post by:
Hi I have done all the codings part for connecting mysql with java in eclipse environment. Coding Part: import java.sql.Connection; import java.sql.DriverManager; public class MysqlConnect {
8
3662
n8kindt
by: n8kindt | last post by:
hi guys, i am also posting this question in the MySQL forum but am putting the detailed post on here. here is the message i am having problems with: http://i3.photobucket.com/albums/y72/n8kindt/odbcerror.jpg i've done a few experiments on the cause of this error and i've noticed tendancies but do not know of any way to eliminate this problem. this error seemingly occurs at random but i can always make the error occur whenever i add or...
0
8639
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, weíll explore What is ONU, What Is Router, ONU & Routerís main usage, and What is the difference between ONU and Router. Letís take a closer look ! Part I. Meaning of...
0
8582
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9120
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8999
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8832
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
4348
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4586
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3016
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
1980
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.