JSP - MySQL - Connection

Home Answers Viewqa JSP-Interview-Questions JSP - MySQL - Connection

Aghil krishna

JSP - MySQL - Connection
2 Answer(s) 2 years and 2 months ago
Posted in : JSP-Interview Questions

I can't connect mysql using jsp in my server.It shows some error like this.

""" com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet successfully received from the server was 1,300,257,595,704 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago. """"

Can you help me to resolve this problem.I set classpath for the mysql connector jar (/home/aghiltu/apache-tomcat-6.0.26/lib/mysql-connector-java-5.1.8-bin.jar).....

And i also tried that kept the this jar in my WEB-INF/classes but no use , same error.

Regards, Krrish

View Answers

March 16, 2011 at 2:35 PM

Put mysql-connector-java-5.0.5.jar in the lib folder of apache tomcat.

For more information, visit the following links:

http://www.roseindia.net/jsp/connect-jsp-mysql.shtml

http://www.roseindia.net/jsp/Accessingdatabase-fromJSP.shtml

March 16, 2011 at 6:53 PM

Hi, Thanks for your help.... I tried it myself and it connects the database when I gave the hostname as ""localhost"" but not in the case of hostname as ""aghiltu""..... I'm using this for my web app ..... when i use my apps on another system,the database will get fail to connect due to the "localhost"......

What is the solution for this?

Regards, Krrish

jsp
jsp how jsp translated into servlets

JSP
JSP How to run jsp program in eclipse

jsp
jsp how to create jsp page

Jsp
Jsp Can I implement interface in jsp

JSP
what is JSP forward tag for what is JSP forward tag for It forwards the current request to another JSP page. Below is the syntax for the same:- <jsp:forward page="...url..." /> We can also forward parameter

jsp
jsp how to include two jsp page

jsp
jsp how to create a table in oracle using jsp and the table name is entered in text feild of jsp page

jsp
jsp write a code for jsp file generator to generate a jsp page automatically taking html page as input

JSP
JSP Hi, What is JSP? What is the use of JSP? Thanks Hi, JSP Stands for Java Server Pages. It is Java technology for developing web applications. JSP is very easy to learn and it allows the developers to use Java

jsp
jsp what is the basic necessities reguired for running jsp using JDBC bridge?? and how to write a jsp code to access the detail present in microsoft access pls send link regarding above

jsp
jsp how to include google map in our jsp page

JSP
JSP How to create CAPTCHA creation by using JSP? I need an code for CAPTCHA creation by using JSP... You can create a captcha validation using jsp. Have a look at the following tutorial: Captcha Creation

jsp
jsp how to write a servlet and jsp program for user login form

jsp
jsp how to pass jsp variable to an html page

JSP
JSP relevant difference between servlet and jsp in 1 line

jsp
jsp why jsp is translated into servlet?pls describe precisly

jsp
jsp code for jsp automatic genration using html

jsp
jsp how to write hindi in jsp and store in database as unicode

JSP
JSP FILE UPLOAD-DOWNLOAD code USING JSP

jsp
jsp how to delete data from database using jsp

JSP
What are JSP directives, page directives and include directives? what are jsp directives? and what are page directives? and what are include directives? can you explain taglib directives? JSP directives JSP

JSP
Can you explain jsp page life cycle what is el how does el search for an attribute in JSP Can you explain jsp page life cycle what is el how does el...://www.roseindia.net/jsp/simple-jsp-example/LifeCycleOfJspPage.shtml http

JSP
JSP what are the different scopes an object can have in a jsp page JSP Scope Variables: Page scope-It makes the data available... the following links: http://www.roseindia.net/jsp/simple-jsp-example

JSP
what is jstl in JSP what is jstl JSTL is also called as JSP tag libraries. They are collection of custom actions which canbe accessed as JSP tags. For more information, visit the following link: JSTL Tutorials

JSP
access application data stored in JavaBeans components. The jsp expression...). Before JSP 2.0, we could use only a scriptlet, JSP expression, or a custom tag to include server state in the jsp page output. For more information, visit

JSP
JSP public opinion poll Develop a JSP for a news channel to conduct public opinion poll on any topic. Users will respond through yes or no options. Later display the result in percentage

JSP
JSP What is JSP? JavaServer Pages (JSP) is a server-side Java technology an extension to the Java servlet technology that helps... document types. Hi, Here is the answer. JavaServer Pages (JSP

jsp
jsp Hi all..I am new in jsp. I have a question. I want develope a jsp page it contain two part for two different user group. i want to hide some information from user1 group and same as user2 group. can i do this in single jsp

jsp
jsp hai please give me the table grid code code for jsp

jsp
jsp how to create multiple tables in oracle 9i using jsp program

jsp
jsp Dear deepak, wat is the purpose of converting jsp into servlet and how the process takes place.. with regards, praveen

jsp
jsp how to assign javascript varible to java method in jsp without using servlet

JSP
JSP why we use preparedstatement while saving data from jsp to data base table

jsp
jsp In any jsp all implicit objects are available directly, in such a case why we need PageContext object again

JSP
JSP how does jsp engines instantiae tag handler classes instances JSP engines will always instantiate a new tag handler instance every time a tag is encounteredin a JSP page. A pool of tag instances are maintained

jsp
jsp Hi in my dao class some exception is there then how can i display in jsp page

JSP
JSP How to include the same jsp page dynamically to a number of times automatically

jsp
jsp in my project i have following jsp in this jsp the pagesize=30 but i have to create drop down box with values 10,20,30. and i have to pass them to pagesize how can i do this please help me

JSP
JSP Develop a JSP to keep track number of users and display a message â??You are nth visitorâ?? where n is number of user

JSP
JSP Consider that we need to have a text, combo, radio & checkbox in JSP page and the page data's are retrieved from

JSP
objects in jsp Implicit objects in jsp are the objects... and are created at the conversion time of a jsp into a servlet. But we can pass.../o/jsp-implicit-objects.shtml

JSP
objects in jsp Implicit objects in jsp are the objects... and are created at the conversion time of a jsp into a servlet. But we can pass.../jsp-implicit-objects.shtml

JSP
how can we use beans in jsp how can we use beans in jsp JSP provides three tags to work with beans:- <jsp:useBean id="bean name... that defines the bean. <jsp:setProperty name = "id" property = "someProperty" value

JSP
JSP what are different implicit objects of jsp mplicit objects in jsp are the objects that are created by the container automatically... time of a jsp into a servlet. But we can pass them to our own method if we wish

JSP
JSP how did you implement caching in jsp OSCache... organization. OSCache has a set of JSP tags that make it easy to implement page caching in your JSP application. Following are some Cache techniques

JSP
JSP i need coding for auto text and auto complete of my database for my JSP with out using plugin if any one know answer if any one know's coding for it give me some suggestion

jsp
jsp Hi One Help... I want to develop like that using jsp/javascript but nothing is striking in mind... Please give some suggestions to design first Thanks in advance---- Vanchinathan.R

Jsp
Jsp how can we compile the jsp file in dos command prompt. when i enter the jspc filename.jsp in cmd i got the error like 'jspc' is not recognized... to my file and compilation for the jsp file

Ask Questions?

If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.

Ask your questions, our development team will try to give answers to your questions.

Tutorial Topics