Problems with moving app from Netbeans to Tomcat

[aymane chetibi]

hi all,
When I run my applicaton on netbeans it runs fine.
When I move it in tomcat (by moving the content of the build directory) in tomcatHome/webapps/myApp I got a nullpointer exception in line 1 indicated bellow:

  ResultSet rs=null;
        try {
             Class.forName("com.mysql.jdbc.Driver").newInstance();
             myConn = DriverManager.getConnection ( url, "root", "pass" );  
             PreparedStatement stat = myConn.prepareStatement("SELECT * FROM member where username = ?");
             stat.setString(1,user);
             rs = stat.executeQuery();
        }catch(Exception f){
            out.print("First Exception Error:" + f.getMessage() );
        }    
        ServletContext sc=this.getServletContext();
        boolean exists = false;
        boolean passConfirmation=true;
        boolean blank=false;
       try{
         if(rs.next()){  //line1  

the result set in still null in Tomcat ?
anybody knows why ??
thank you.

[Ben Souther]

Where did you put the JDBC driver?

[aymane chetibi]

C:\jdk1.5.0_06\jre\lib\ext\mysql-connector-java-3.1.12-bin.jar
and I have this on the path environment variable.
What can be wrong ?

thank you....
regards,

[Ben Souther]

Are you sure that's the JRE directory Tomcat is looking in?

As a policy, unless I'm using container managed connection pooling, I always pack all of the needed libraries inside the web application ({your webapp/WEB-INF/lib/{needed jar files}. Then, I put the jars in Tomcat/shared/lib.

[aymane chetibi]

Thank you.
How can I know what is the directory Tomcat is looking in?

I am developping the application in netBeans IDE (easier) and then to deploy it I just move it to Tomcat. (by simply moving the content of build directory)

Is this a bad idea.
Is there any other alternatives on how to move?

regards,

[Ben Souther]

This has really become Tomcat specific so I'm going to move the thread to Apache Tomcat.
Will pick up there....

[Ben Souther]

What OS are you using and how did you install Tomcat?

[aymane chetibi]

I am using Windows XP professional.
I installed tomcat 5.5.17 by double clicking on the .exe installation file.

regards,

[Sivaraman Lakshmanan]

Hi,
Try to run the select query seperately in the databse and check if it returns any rows. Moreover please post the stack trace to help you better.

[aymane chetibi]

well the same application using Netbeans (when I click build) it runs correctly .
so the query is correct.

here is the stack trace:
java.lang.NullPointerException
signupServlet.processRequest(signupServlet.java:53)
signupServlet.doPost(signupServlet.java:132)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

I think it's the driver.
How can I make sure Tomcat is reaching the driver ??
thank you.

regards,

[Ben Souther]

Originally posted by aymane chetibi:

I think it's the driver.
How can I make sure Tomcat is reaching the driver ??
thank you.

regards,

The best way, in my opinion, is to put it under {your app}/WEB-INF/lib unless you are using container managed connection pooling, in which case, you need to make the driver available to Tocmat itself.
If that's the case, put it in
{tomcat home}/common/lib

[aymane chetibi]

yes it's working ...
thank you sooo much.


regards,