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]
