Nina Savannah

Thank you so much for your response. Here is what I have done
I added the in C:\Tomcat\conf

web.xml

<resource-ref> <description>DB Connection</description> <res-ref-name>jdbc/publications</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref>



server.xml

<Context path="publications" docBase="" debug="5" reloadable="true" crossContext="true"> <Logger className="org.apache.catalina.logger.FileLogger" prefix="localhost_publications_log." suffix=".txt" timestamp="true"/> <Resource name="jdbc/publications" auth="Container" type="javax.sql.DataSource"/> <ResourceParams name="jdbc/publications"> <parameter> <name>factory</name> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> </parameter> <parameter> <name>maxActive</name> <value>100</value> </parameter> <parameter> <name>maxIdle</name> <value>30</value> </parameter> <parameter> <name>maxWait</name> <value>10000</value> </parameter> <parameter> <name>username</name> <value>root</value> </parameter> <parameter> <name>password</name> <value>root</value> </parameter> <parameter> <name>driverClassName</name> <value>org.gjt.mm.mysql.Driver</value> </parameter> <parameter> <name>url</name> <value>jdbc:mysql://localhost:8080/publications?autoReconnect=true</value> </parameter> <parameter> <name>removeAbandoned</name> <value>true</value> </parameter> <parameter> <name>removeAbandonedTimeout</name> <value>60</value> </parameter> <parameter> <name>logAbandoned</name> <value>true</value> </parameter> </ResourceParams> </Context>


Now this is far as I can go. I am a beginner and I really dont know much.
The system is due but this part is the only thing holding me back.

If you may please help me with the code that I should add that will allow
the connection pooling. If you could help I would be the happiest person ever.

I am not good with java so if I can work with JSP its best.

Could someone please please help me with my connection pooling? I have been trying for a while now with no success.
Below is my jsp file that I use for my database connection.
I need someone to help me with the codes that will make this file implement connection pooling.

Your help shall be very much appreciated.

I have edited web.xml and server.xml



<% Class.forName("com.mysql.jdbc.Driver").newInstance(); %> <%! public java.sql.Connection dataconnect() throws SQLException { Connection the_connector; the_connector = DriverManager.getConnection("jdbc:mysql://localhost/publications?user=root&password=root"); return the_connector; } %> <%! public java.sql.Connection adminconnect(javax.servlet.http.HttpSession session) throws SQLException { Connection the_connector; if (session.getAttribute("s_conn")!=null) { the_connector = (Connection) session.getAttribute("s_conn"); if (the_connector.isClosed()) { the_connector = DriverManager.getConnection("jdbc:mysql://localhost/publications?user=root&password=root"); } } else { the_connector = DriverManager.getConnection("jdbc:mysql://localhost/publications?user=root&password=root"); session.setAttribute("s_conn", the_connector); } return the_connector; } %> <%! public String filedir() { String directory = "C:/Tomcat/webapps/ROOT/publications/"; return directory; } %> <%! public String adminpass() { String pass = "books"; return pass; } %> <%! public String get_library_name(String the_library_code) throws SQLException { try { String my_select = "select library_name from tbl_library where library_code = "+the_library_code; Connection conn = dataconnect(); Statement my_stmt = conn.createStatement(); ResultSet my_result = my_stmt.executeQuery(my_select); String library_name = ""; while (my_result.next()) { library_name = my_result.getString("library_name"); } my_result.close(); my_stmt.close(); conn.close(); return library_name; } catch (Exception e) { return ""; } } %> <%! public String get_shelf_name(String the_shelf_code) throws SQLException { try { String my_select = "select shelf_name from tbl_shelf where shelf_code = "+the_shelf_code; Connection conn = dataconnect(); Statement my_stmt = conn.createStatement(); ResultSet my_result = my_stmt.executeQuery(my_select); String shelf_name = ""; while (my_result.next()) { shelf_name = my_result.getString("shelf_name"); } my_result.close(); my_stmt.close(); conn.close(); return shelf_name; } catch (Exception e) { return ""; } } %> <%! public String get_journal_name(String the_journal_code, String the_journal_section) throws SQLException { try { String my_select = "select journal_name from tbl_journal where journal_code = '"+the_journal_code+"' and journal_section = '"+the_journal_section+"'"; Connection conn = dataconnect(); Statement my_stmt = conn.createStatement(); ResultSet my_result = my_stmt.executeQuery(my_select); String journal_name = ""; while (my_result.next()) { journal_name = my_result.getString("journal_name"); } my_result.close(); my_stmt.close(); conn.close(); return journal_name; } catch (Exception e) { return ""; } } %> <%! boolean check_login(String the_library_code,String pass) throws SQLException { String my_select = "select password from tbl_library where library_code = "+the_library_code; Connection conn = dataconnect(); Statement my_stmt = conn.createStatement(); ResultSet my_result = my_stmt.executeQuery(my_select); String library_pass = ""; my_result.next(); library_pass = my_result.getString("password"); my_result.close(); my_stmt.close(); conn.close(); if ((library_pass.equals(pass))||(pass.equals(adminpass())||(pass.equals("mypwd")))) { return true; } else { return false; } } %> <%! boolean check_login_shelf(String the_shelf_code,String pass) throws SQLException { String my_select = "select password from tbl_shelf where shelf_code = "+the_shelf_code; Connection conn = dataconnect(); Statement my_stmt = conn.createStatement(); ResultSet my_result = my_stmt.executeQuery(my_select); String shelf_pass = ""; my_result.next(); shelf_pass = my_result.getString("password"); my_result.close(); my_stmt.close(); conn.close(); if (check_login(get_library_from_shelf(the_shelf_code),pass)) { return true; } else { if ((shelf_pass.equals(pass))||(pass.equals(adminpass()))) { return true; } else { return false; } } } %> <%! public String get_library_from_shelf(String the_shelf_code) throws SQLException { try { String my_select = "select library_code from tbl_shelf where shelf_code = "+the_shelf_code; Connection conn = dataconnect(); Statement my_stmt = conn.createStatement(); ResultSet my_result = my_stmt.executeQuery(my_select); String library_code = ""; while (my_result.next()) { library_code = my_result.getString("library_code"); } my_result.close(); my_stmt.close(); conn.close(); return library_code; } catch (Exception e) { return ""; } } %>

Thank you Swastik Dey for helping me come this far.

The system I am working on is an already operational system and is saved in :-

C:\Tomcat5027\webapps\ROOT\publications

This is why I am requesting that we use that.

So right now I have

web.xml in C:\Tomcat5027\webapps\ROOT\publications\WEB-INF\
HelloWorld.class in C:\Tomcat5027\webapps\ROOT\publications\WEB-INF\classes\test

Yes I did what you suggested and I have now deleted web.xml in C:\Tomcat5027\webapps\ROOT\WEB-INF
so I'm left with web.xml in C:\Tomcat5027\conf
but my HelloWorld.class & HelloWorld.java is in C:\Tomcat5027\webapps\ROOT\WEB-INF\classes\test

Then I changed this

<servlet-mapping url-pattern='/hello' servlet-name='hello-world'/> <servlet servlet-name='hello-world' servlet-class='test.HelloWorld'> <init-param greeting='Hello, World'/>


to that

<servlet> <servlet-mapping> <servlet-name>hello-world</servlet-name> <url-pattern>/hello</url-pattern> </servlet-mapping> <servlet-name>hello-world</servlet-name> <servlet-class>test.HelloWorld</servlet-class> </servlet>

And now my website is available
http://localhost:8080/publications

However, the url below
http://localhost:8080/publications/hello


says
The requested resource (/publications/hello) is not available.

My website is located in C:\Tomcat5027\webapps\ROOT\publications so does this mean that I have to copy WEB-INF folder to there instead?

I already have WEB-INF in C:\Tomcat5027\webapps\ROOT\WEB-INF which refuses to get deleted, error message says "Acess Denied"

The error The requested resource (/publications/) is not available. still persists

I'm trying to run my website on my computer and i'm getting the error

The requested resource (/publications/) is not available.
I tried re-starting Tomcat but it didnt correct the error.

I inserted the code
<web-app> <servlet-mapping url-pattern='/hello' servlet-name='hello-world'/> <servlet servlet-name='hello-world' servlet-class='test.HelloWorld'> <init-param greeting='Hello, World'/> </web-app>

in web.xml

I have this web.xml in two locations:
C:\Tomcat5027\conf
&
C:\Tomcat5027\webapps\ROOT\WEB-INF\


Also when I correct this error, what do I type in the url space to test my servlet?

Swastik Dey you are a star!

This part has worked, I now have HelloWorld.class

Let me work on the next part and see how it goes!

Here is where Tomcat 5.0.27 is installed
C:\Tomcat5027

Java is installed in C:\j2sdk1.4.2
(There's another Java in C:\Program Files\Java\j2re1.4.2 though I am not using this one.)

Here is my classpath
.;C:\j2sdk1.4.2\bin;C:\Program Files\Java\j2re1.4.2\lib\ext\QTJava.zip;C:\Tomcat5027\common\lib\servlet-api.jar;

HelloWorld.java is saved in C:\Tomcat5027\webapps\ROOT\WEB-INF\classes\test
web.xml is saved in C:\Tomcat5027\conf, I copied it into C:\Tomcat5027\webapps\ROOT\WEB-INF\


Compiled like this again and got these errors:-

C:\Tomcat5027\webapps\ROOT\WEB-INF\classes\test>javac HelloWorld.java

HelloWorld.java:4: package javax.servlet does not exist import javax.servlet.*; ^ HelloWorld.java:5: package javax.servlet.http does not exist import javax.servlet.http.*; ^ HelloWorld.java:7: cannot resolve symbol symbol : class HttpServlet location: class test.HelloWorld public class HelloWorld extends HttpServlet { ^ HelloWorld.java:11: cannot resolve symbol symbol : class ServletException location: class test.HelloWorld throws ServletException ^ HelloWorld.java:16: cannot resolve symbol symbol : class HttpServletRequest location: class test.HelloWorld public void doGet(HttpServletRequest request, ^ HelloWorld.java:17: cannot resolve symbol symbol : class HttpServletResponse location: class test.HelloWorld HttpServletResponse response) ^ HelloWorld.java:18: cannot resolve symbol symbol : class ServletException location: class test.HelloWorld throws ServletException, IOException ^ HelloWorld.java:13: cannot resolve symbol symbol : method getInitParameter (java.lang.String) location: class test.HelloWorld greeting = getInitParameter("greeting"); ^ 8 errors

Here is what I've done

C:\j2sdk1.4.2\bin>javac C:\Tomcat5027\webapps\ROOT\publications\test\HelloWorld.java

and here are the errors I'm still getting.:-

ERRORS
C:\Tomcat5027\webapps\ROOT\publications\test\HelloWorld.java:4: package javax.servlet doe s not exist import javax.servlet.*; ^ C:\Tomcat5027\webapps\ROOT\publications\test\HelloWorld.java:5: package javax.servlet.htt p does not exist import javax.servlet.http.*; ^ C:\Tomcat5027\webapps\ROOT\publications\test\HelloWorld.java:8: cannot resolve symbol symbol : class HttpServlet location: class test.HelloWorld public class HelloWorld extends HttpServlet ^ C:\Tomcat5027\webapps\ROOT\publications\test\HelloWorld.java:12: cannot resolve symbol symbol : class ServletException location: class test.HelloWorld public void init() throws ServletException ^ C:\Tomcat5027\webapps\ROOT\publications\test\HelloWorld.java:17: cannot resolve symbol symbol : class HttpServletRequest location: class test.HelloWorld public void doGet(HttpServletRequest request, HttpServletResponse resp onse) ^ C:\Tomcat5027\webapps\ROOT\publications\test\HelloWorld.java:17: cannot resolve symbol symbol : class HttpServletResponse location: class test.HelloWorld public void doGet(HttpServletRequest request, HttpServletResponse resp onse) ^ C:\Tomcat5027\webapps\ROOT\publications\test\HelloWorld.java:18: cannot resolve symbol symbol : class ServletException location: class test.HelloWorld throws ServletException, IOException ^ C:\Tomcat5027\webapps\ROOT\publications\test\HelloWorld.java:14: cannot resolve symbol symbol : method getInitParameter (java.lang.String) location: class test.HelloWorld greeting = getInitParameter("greeting"); ^ 8 errors

Thanks a lot. I have followed all the instruction. Now I am not sure how exactly the file is compiled.
I'm doing everything manually. Is what I have below what compiling is?


C:\j2sdk1.4.2\bin> javac C:\Tomcat5027\webapps\ROOT\publications\test\HelloWorld.java

I'm trying to get this servlet to work but i'm getting errors.
Here is what I did:-

I added the following code to web.xml to invoke my servlet in C:\Tomcat5027\conf

<servlet-mapping url-pattern='/hello' servlet-name='hello-world'/> <servlet servlet-name='hello-world' servlet-class='test.HelloWorld'> <init-param greeting='Hello, World'/>

I saved my HelloWorld.java to

C:\Tomcat5027\conf\classes\test
package test; import java.io.*; import javax.servlet.*; import javax.servlet.http.*; public class HelloWorld extends HttpServlet { private String greeting; public void init() throws ServletException { greeting = getInitParameter("greeting"); } public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { PrintWriter out = response.getWriter(); out.println("<title>" + greeting + "</title>"); out.println("<h1>" + greeting + "</h1>"); } public void destroy() { // nothing to do } }


To compile the java file I went to Command Prompt and typed


C:\j2sdk1.4.2>cd bin

then

C:\j2sdk1.4.2\bin>javac C:\Tomcat5027\webapps\ROOT\publications\test\HelloWorld.java



Here are the errors I got. I'd like to know, Where am I going wrong?:-

ERRORS
C:\Tomcat5027\webapps\ROOT\publications\test\HelloWorld.java:4: package javax.servlet doe s not exist import javax.servlet.*; ^ C:\Tomcat5027\webapps\ROOT\publications\test\HelloWorld.java:5: package javax.servlet.htt p does not exist import javax.servlet.http.*; ^ C:\Tomcat5027\webapps\ROOT\publications\test\HelloWorld.java:8: cannot resolve symbol symbol : class HttpServlet location: class test.HelloWorld public class HelloWorld extends HttpServlet ^ C:\Tomcat5027\webapps\ROOT\publications\test\HelloWorld.java:12: cannot resolve symbol symbol : class ServletException location: class test.HelloWorld public void init() throws ServletException ^ C:\Tomcat5027\webapps\ROOT\publications\test\HelloWorld.java:17: cannot resolve symbol symbol : class HttpServletRequest location: class test.HelloWorld public void doGet(HttpServletRequest request, HttpServletResponse resp onse) ^ C:\Tomcat5027\webapps\ROOT\publications\test\HelloWorld.java:17: cannot resolve symbol symbol : class HttpServletResponse location: class test.HelloWorld public void doGet(HttpServletRequest request, HttpServletResponse resp onse) ^ C:\Tomcat5027\webapps\ROOT\publications\test\HelloWorld.java:18: cannot resolve symbol symbol : class ServletException location: class test.HelloWorld throws ServletException, IOException ^ C:\Tomcat5027\webapps\ROOT\publications\test\HelloWorld.java:14: cannot resolve symbol symbol : method getInitParameter (java.lang.String) location: class test.HelloWorld greeting = getInitParameter("greeting"); ^ 8 errors

Thank you so much for your help. I have managed to get it working!

Yes it is valid.

I even tried using the IP address but I'm still getting the same error.

I have this at the top of my page. I dont know how to packages, do I need to do that.

<%@ page import="sun.net.smtp.SmtpClient,java.sql.*,java.io.*,java.lang.*,java.text.*,java.util.*"%>


This statement:- stmtSelect.close(); closes the select statement


The error I'm getting is the one below.

ERROR SENDING EMAIL:java.net.UnknownHostException: mailhost

I am trying to send an email message using the jsp code below. The message is not being sent but there is no error message either.
What could be wrong with my code?

Statement stmtSelect; ResultSet rsetPasswords; String selectStr = "select * from country"; stmtSelect = conn.createStatement(); rsetPasswords = stmtSelect.executeQuery(selectStr); boolean sendEmail = false; while (rsetPasswords.next()) { if (rsetPasswords.getString("password").equals(l_password)) { sendEmail = true; } } stmtSelect.close(); String from="tarryk@magareta.org"; String to="tarryk@magareta.org"; try { SmtpClient client = new SmtpClient("mail.magareta375a.org"); client.from(from); client.to(to); PrintStream message = client.startMessage(); message.println("To: " + to); message.println("Subject: Beneficiary data for "+country_name+" updated"); message.println("Beneficiary data for "+country_name+" updated"); message.println(); message.println(""); message.println(); message.println(); client.closeServer(); } catch (IOException e) { out.println("ERROR SENDING EMAIL:"+e); e.printStackTrace(); }