Results 1 to 10 of 10
  1. #1
    jason.3dmagic is offline Member
    Join Date
    Oct 2009
    Posts
    30
    Rep Power
    0

    Question Response from Tomcat Server slow and Invariable to JSP

    Hello,

    I have developed an application which is an INTRANET PORTAL in advanced java. My database is MySQL and Server is Tomcat V5.5

    The problem is server response is very slow and sometimes it stops responding, also when I try accessing it from remote machine I don't get response from my server.

    Please help...

    Thank and Regards

  2. #2
    r035198x is offline Senior Member
    Join Date
    Aug 2009
    Posts
    2,388
    Rep Power
    8

    Default

    Find a profiling tool and try to pin point the source of the problem.

  3. #3
    jason.3dmagic is offline Member
    Join Date
    Oct 2009
    Posts
    30
    Rep Power
    0

    Default

    Please Clarify the profiling tool :confused:

    I have developed my application in java Eclipse, using MySQL Database and TOMCAT 5.5 Server

  4. #4
    r035198x is offline Senior Member
    Join Date
    Aug 2009
    Posts
    2,388
    Rep Power
    8

    Default

    You'll have to google for it. We can't see any of your codes so we can't say if it's your code that is the problem or perhaps your database is not well indexed, non optimal SQL, connections left unclosed e.t.c.

  5. #5
    jason.3dmagic is offline Member
    Join Date
    Oct 2009
    Posts
    30
    Rep Power
    0

    Thumbs up

    I am a college student, I don't know how to structure the database efficiently
    and also the indexing and optimization of SQL

    I am giving you the project theme::

    It maintains all the information of employees and students, like leave and salaries under which authority the employee or under which the student belongs. Also daily attendance of all, basic finance related issues.

    Also when I try to access my application from remote server it don't work. It was used to work before. Dont know wats the problem is

    :confused::confused::confused:

    Thanks and Regards

  6. #6
    RamyaSivakanth's Avatar
    RamyaSivakanth is offline Senior Member
    Join Date
    Apr 2009
    Location
    Chennai
    Posts
    844
    Rep Power
    6

    Default

    how u have desined the database? how many records are there?
    how u are connecting to remote server?
    Ramya:cool:

  7. #7
    r035198x is offline Senior Member
    Join Date
    Aug 2009
    Posts
    2,388
    Rep Power
    8

    Default

    Read the relevant sections in the MySQL ref manual for making efficient database queries and indexes.
    For the remote connection, you will need to provide details on how you are miking the connection and the error messages you are getting.

  8. #8
    jason.3dmagic is offline Member
    Join Date
    Oct 2009
    Posts
    30
    Rep Power
    0

    Exclamation

    Yes I have designed the database....

    I am not using indexing techniques

    I am using following code for database connection

    Class.forName("com.mysql.jdbc.Driver").newInstance ();
    conn = DriverManager.getConnection("jdbc:mysql://localhost/magicnet?user=isf&password=isf123");


    Is der any other efficient way for connection to the database?
    :confused:

    TO connect to remote server I copy the war file to webapps folder of TOMCAT, then I start the server and write URL into the browser...
    Last edited by jason.3dmagic; 10-27-2009 at 06:36 AM.

  9. #9
    r035198x is offline Senior Member
    Join Date
    Aug 2009
    Posts
    2,388
    Rep Power
    8

    Default

    You can use a datasource. Also make sure you closed all connections in a finally block. Read the MySQL refmanual like I already suggested to find out how to tune your tables for efficiency.
    You don't move the war file to all computers that want to connect to the system. See in that path you have localhost as the database host and the client computers will not be having MySQL installed on them. They shouldn't even have Tomcat on them.
    Keep your war file on the one computer that contains tomcat and make sure to provide the right connection string.

  10. #10
    ideyatech is offline Member
    Join Date
    Apr 2010
    Location
    Philippines
    Posts
    7
    Rep Power
    0

    Default Improve Java Web Development Server Startup Time

    I found this page and it helped me speed up my server.

    Here's the link.

Similar Threads

  1. Server returned HTTP response code: 500.. i need help
    By hardc0d3r in forum Java Servlet
    Replies: 9
    Last Post: 03-12-2012, 09:08 PM
  2. Server returned HTTP response code: 500
    By fuliangQ in forum JavaServer Pages (JSP) and JSTL
    Replies: 1
    Last Post: 04-09-2009, 04:55 AM
  3. Reg Tomcat in Itaniumn Server
    By ars3181 in forum Advanced Java
    Replies: 0
    Last Post: 11-24-2008, 06:53 AM
  4. java.io.Exception: Server returned HTTP response code: 403
    By navishkumarb in forum Advanced Java
    Replies: 1
    Last Post: 01-05-2008, 02:33 PM
  5. Server returned HTTP response code: 500
    By Heather in forum Java Servlet
    Replies: 1
    Last Post: 07-09-2007, 05:32 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •