Peter already hit you with the most popular suggestions for both sides:-

Free Stuff:-
Eclipse, NetBeans

Commercial:-
IntelliJ IDEA, MyEclipse, Dreamweaver*

*Dont know if I can call...

Rather than making your own why dont you just try some of the freely available Database Connection Pooling libraries.
Look here (http://java-source.net/open-source/connection-pools) for a list of...

Give us the complete URL on how you are calling it,

Is it like this : http://localhost:8080/<project-name>/myServlet
Also can you access "index.jsp" ?

The problem is occurring where you are constructing your SQL query you need to show us that code, for us to trace the error.

Also Just for your Information, in case one of the values you wish to...

AFAIK you cannot pass values assigned to variables in Javascript to your Server Side JSP pages without putting the actual values inside some form fields viz. the "input" element (eg hidden fields,...

@vishalsnc

Drop the IM speak this is not a chat room, and try to read the rules and search the forums before you post anything.


What do you think does the Sticky which Peter has linked to...

INFO main org.apache.catalina.core.StandardEngine - Starting Servlet Engine: Apache Tomcat/5.5.26

One more thing I forgot to mention last time out. If this is a Linux Server I have a **feeling**...

This is more of a core java question, So it should have been posted in the Java forum.
Anyways take a look at the javadocs of the String (http://java.sun.com/javase/6/docs/api/java/lang/String.html)...

Tomcat by default doesn't have support for JSF (amd definitely Tomcat 5.5 doesn't),
Are you sure the new place has the JSF libraries because the following suggests the JSF libraries are mssing.
...

Most probably the issue is your tomcat running on port 8080, chances are you most probably have a firewall which is blocking that port from being accessed from outside. Also some networks tend to...

Your <select> element (and also any other element eg textfields, checkboxes, etc ) should be inside the <form> </form> tags, if you want your data to get posted (via GET or POST) to the URL...

well if the problem has been solved it would be appreciated if you mark this thread as solved.

In Java null and "" are not the same thing.

null is the actual universal NULL, i. e. nothing.
On the other hand "" is a blank String object.

If an object is "null" calling any method on it...

Ok.. What was the output when you replaced

if (request.getParameter("UserName")!=null)


with the following condition:-


if ((request.getParameter("UserName")!=null) &&...

My first suggestion would be do not this task inside a JSP. JSPs are only for making your user interface, the processing i. e. your "scp" should be inside a Java class.
Second suggestion is instead...

Have you tried by changing the name of the field from "UsrName" to "UserName". Next show us your servlet code and why you feel that the code inside the "if" block is getting executed.
Note when...

There is your problem


<input type="text" name="UsrName" maxlength="15" size="15"/>



Check the Spelling of the name given to the field, you have give "UsrName" it should be "UserName".
...

Thats strange the NullPointerException would be thrown only in case request.getParameter("UserName")
returned NULL, but in your first post you had said request.getParameter("UserName") != null...

Can you show me the code of the page where your text field is located.
Have you set the default value for your text field to a blank string i. e. ("").
In that case the check for (!= null ) would...

From that anyone will assume the query was solved and one of the moderators might have marked it as solved.

Well if the problem was solved then at least mention how it was solved, and mark the thread as solved so other people can use it.
Even previously I have noticed you just do not mention how a...

Try checking out request.getParameterValues() (http://java.sun.com/products/servlet/2.2/javadoc/javax/servlet/ServletRequest.html#getParameterValues(java.lang.String)) method, It should fetch you all...

You **have not** pasted the code which is causing the problem or just displaying one record.
Right now I am just shooting in the dark here and assuming the problem lies in this piece of code, if it...

First run Peter's Query in your DBMS and see how the results are displayed.

Next if your JDBC concepts are good go to my second link first (the one pointing to the javadocs of the ResultSet...

Well welcome to the World of Software Development then, and as far as JSP/Servlets basics are concerned if you would have just look a couple of threads below is a thread mentioned JSP How to Start...

That shows that you have not put in an effort to go through either of my links, why should I help you then, for a guy of average IQ that should be no more than an hours work and what guarantees that...

Yes you are doing this completely wrong.
Have you tried running the query Peter gave directly in your DBMS ?
It gives you three rows(CL,PL and SL) with two columns (m_leavetype, m_bal).
and if you...

Honestly I was just shooting in the dark, Even I think your(Peter) first post answers the question asked(at least what I thought he was asking) perfectly.

Come on Peter use your Crystal Ball to identify the Error !!! ;)

Peter's query would give you three rows each row indicating how many leaves left of that particular type for the given employee. From your posts .. even the last one I feel you needed that.
However...

Try using session.setAttribute() / session.getAttribute() instead of request.

yep ..... you have one witness here, who saw it first hand !!! ;)

That would be as simple as calling request.getParameter("--name-of-text-box--");, in pagina2.jsp .

Also no need to stick to GET you can use POST without any issues. Only difference is GET would...

Now I do not know what to say:
Statement st = null;
ResultSet rs = null;

rs = st.executeQuery("Select description from user ");

Sorry If I sound rude, But do you expect some magic ;) , you...

I suggest you use the Tomcat mentioned on here (http://tomcat.apache.org/).
If my info is correct Apache Tomcat was known as Jakarta Tomcat back in the days when it was a part of the Jakarta Project...

Ehh. . . . . Ok Thanks for informing us about it ;)