Sure to do the changes you mentioned. Pls do send the
config file for connection pooling and also guidelines
for how to use it in my program. It will be a great
help.

I'm developing web based application for using it
inhouse. Later part of time, it may grow to a big MRP
application based on the requirement of the company.
If i go ahead with this kind of structure (the one i
sent in my previous mail), does it cause any rpoblems?
Pls advice.

--- Robert F Hall <[EMAIL PROTECTED]> wrote:

> U K,
> 
> "It works" as you said, but there are a couple of
> things I'll recommend:
> 
> First, you should move your Connection, ResultSet
> and Statement 
> declarations before
> the try {} block and add a finally {} block where
> you check for null 
> values and close
> the resources if not null.
> 
>     Connection conn = null;
>      Statement stmt = null;
>      ResultSet res = null;
>       try {
>             ......
>        }
>        catch {
>              ....
>         }
>         finally {
>              if (stmt != null ) {
>                  try {
>                      stmnt.close();
>                  }
>                   catch (SQLException se) {
>                       log.error(se.getMessage);
>                  }
>               }
>               ....
>     
> Second, you should use a connection pool.  I don't
> have a Tomcat config 
> readily
> available.   But can follow up with one if you need
> it.
> 
> -Robert
> 
> U K Laxmi wrote:
> 
> >I tried without GlobalNamingResources. No luck.
> When
> >googled, i found that if we include
> >GlobalNamingResource tag, then it will be available
> in
> >all web context. 
> >
> >After spending enough time on that, now i coded all
> >database related stuff in JSP in the way we do in
> >stand alone application. I mean - 
> >
> >Coding like this in jspo itself.
> >
> >---- code --
> ><%@ page contentType="text/html"
> import="java.sql.*"%>
> >
> > <html>
> >
> > <head><title>simmPlan - simple material planning
> >system</title>
> ><script language="JavaScript"
> >src="/js/default.js"></script>
> >
> > <%
> >
> >  String userid = request.getParameter("userid");
> >  String passwd = request.getParameter("passwd");
> >  System.out.println("Password: " + passwd);
> >  String pwd = "", str = "";
> >  int level = -1, ind = -1;
> >
> >try {
> >                Connection conn = null;
> >                             Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> >                     
>
>conn=DriverManager.getConnection("jdbc:odbc:driver={Microsoft
> >Access Driver
> >(*.mdb)};DBQ=C:/tomcat/webapps/db1/db1.mdb");
> >                Statement stmt =
> >conn.createStatement();
> >                        
> >                String query = "SELECT * FROM user
> >where name = '" + userid + "'";
> >                
> >                ResultSet st =
> >stmt.executeQuery(query);
> >                if (st.next()) {                   
> 
> >                    pwd = st.getString("password");
>   
> >                
> >                                     level = st.getInt("level");
> >                    System.err.println("Query
> >result="+userid+"/"+pwd+"/"+level);
> >                }
> >                             else {
> >                                     ind = -2;
> >                                     System.out.println("No user with name " 
> > +
> userid
> >+ " available in the database");
> >                             }
> >
> >                if (stmt != null) {
> >                    stmt.close();
> >                }
> >
> >                if (conn != null) {
> >                    conn.close();
> >                }
> >                              
> >            } catch (Exception e) {
> >                e.printStackTrace();
> >            }   
> >             if(pwd.equals(passwd)) {
> >                                     ind = level;
> >                             }
> >                // else ind = -1;
> >
> >                              System.out.println("Ind - > " + ind);
> >%>
> >
> ><script language="JavaScript"
> type="text/JavaScript">
> >var ind = <%= ind %>
> >
> >function loadHtml() {
> >     //alert("in loadHtml()");
> >     if(ind == -2) {
> >             alert("Not a valid user");
> >             location.href = "login.jsp";
> >             return;
> >     }
> >     if (ind == -1) {
> >             alert("Incorrect password");
> >             location.href = "login.jsp";
> >             return;
> >     }
> >     else {
> >             //alert("Correct password");
> >             location.href = "Second_Page.html";
> >             return;
> >     }
> >}
> >
> >
> ></script>
> > </head>
> >
> > <body onload="javascript:loadHtml()">
> >
> ><!-- User Name : <%= userid %><br>
> > Password  : <%= passwd %> -->
> >
> > </body>
> >
> > </html>
> >--- code ends here ---
> >
> >It works. But is it the right way to do? Pls
> advice.
> >
> >--- Antony Paul <[EMAIL PROTECTED]> wrote:
> >
> >  
> >
> >>By default server.xml contains have a 
> >><GlobalNamingResources>. You
> >>have to add your resources in there.
> >>
> >>rgds
> >>Antony Paul
> >>
> >>
> >>On Mon, 21 Feb 2005 19:56:23 -0800 (PST), U K
> Laxmi
> >><[EMAIL PROTECTED]> wrote:
> >>    
> >>
> >>>As just moved the GlobalNamingResources inside
> the
> >>>main <server> in my server.xml residing in
> >>>TOMCAT_HOME/conf directory. When i restart tomcat
> >>>5.5.7 it's throwing up following exception.
> >>>INFO: Starting Servlet Engine: Apache
> Tomcat/5.5.7
> >>>Feb 22, 2005 11:51:46 AM
> >>>org.apache.catalina.realm.UserDatabaseRealm start
> >>>SEVERE: Exception looking up UserDatabase under
> >>>      
> >>>
> >>key
> >>    
> >>
> >>>UserDatabase
> >>>javax.naming.NameNotFoundException: Name
> >>>      
> >>>
> 
=== message truncated ===



                
__________________________________ 
Do you Yahoo!? 
Read only the mail you want - Yahoo! Mail SpamGuard. 
http://promotions.yahoo.com/new_mail 

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to