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]