If you followed the tomcat docs you will have no problem in DBCP getting to work. Going for Globalnamingresources is needed if you need to access it will all applications. Try to configure it as per the doc in following URL.
http://jakarta.apache.org/tomcat/tomcat-5.5-doc/jndi-datasource-examples-howto.html follow MySQL config. And no need to put commons*.jar in commons/lib as TC by default comes with it. rgds Antony Paul On Mon, 21 Feb 2005 21:52:13 -0800 (PST), U K Laxmi <[EMAIL PROTECTED]> 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 > > UserDatabase > > > is not bound in this Conte > > > xt > > > at > > > > > > org.apache.naming.NamingContext.lookup(NamingContext.java:769) > > > at > > > > > > org.apache.naming.NamingContext.lookup(NamingContext.java:152) > > > at > > > > > > org.apache.catalina.realm.UserDatabaseRealm.start(UserDatabaseRealm.j > > > ava:222) > > > at > > > > > > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1003) > > > > > > at > > > > > > org.apache.catalina.core.StandardEngine.start(StandardEngine.java:440 > > > ) > > > at > > > > > > org.apache.catalina.core.StandardService.start(StandardService.java:4 > > > 50) > > > at > > > > > > org.apache.catalina.core.StandardServer.start(StandardServer.java:683 > > > ) > > > at > > > > > > org.apache.catalina.startup.Catalina.start(Catalina.java:537) > > > at > > > > > sun.reflect.NativeMethodAccessorImpl.invoke0(Native > > > Method) > > > at > > > > > sun.reflect.NativeMethodAccessorImpl.invoke(Unknown > > > Source) > > > at > > > > > > sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown > > > Source) > > > at java.lang.reflect.Method.invoke(Unknown > > > Source) > > > at > > > > > > org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271) > > > at > > > > > > org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409) > > > Feb 22, 2005 11:51:46 AM > > > org.apache.catalina.startup.Catalina start > > > SEVERE: Catalina.start: > > > LifecycleException: No UserDatabase component > > found > > > under key UserDatabase > > > at > > > > > > org.apache.catalina.realm.UserDatabaseRealm.start(UserDatabaseRealm.j > > > ava:228) > > > at > > > > > > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1003) > > > > > > at > > > > > > org.apache.catalina.core.StandardEngine.start(StandardEngine.java:440 > > > ) > > > at > > > > > > org.apache.catalina.core.StandardService.start(StandardService.java:4 > > > 50) > > > at > > > > > > org.apache.catalina.core.StandardServer.start(StandardServer.java:683 > > > ) > > > at > > > > > > org.apache.catalina.startup.Catalina.start(Catalina.java:537) > > > at > > > > > sun.reflect.NativeMethodAccessorImpl.invoke0(Native > > > Method) > > > at > > > > > sun.reflect.NativeMethodAccessorImpl.invoke(Unknown > > > Source) > > > at > > > > > > sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown > > > Source) > > > at java.lang.reflect.Method.invoke(Unknown > > > Source) > > > at > > > > > > org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271) > > > at > > > > > > org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409) > > > Feb 22, 2005 11:51:46 AM > > > org.apache.catalina.startup.Catalina start > > > INFO: Server startup in 391 ms > > > > > > Pls help to fix the problem. > > > > > > Thanks, > > > Laxmi > > > > > > --- Antony Paul <[EMAIL PROTECTED]> wrote: > > > > > > > It seems you still have problem. You can google > > for > > > > the answer. One > > > > thing I know is GlobalNamingResources should > > come > > > > inside the Server > > > > element and not inside Context element. > > > > > > > > rgds > > > > Antony Paul > > > > > > > > > > > > On Fri, 18 Feb 2005 22:47:06 -0800 (PST), U K > > Laxmi > > > > <[EMAIL PROTECTED]> wrote: > > > > > I could able to get thro' JarperException. > > Thanks > > > > for > > > > > replies. > > > > > > > > > > Now facing new problem. > > > > > > > > > > I'm getting "NameNotFoundException" - Name > > jdbc > > > > is > > > > > not bound in this Context > > > > > > > > > > Environment what i'm using is: Apache 2, > > Tomcat > > > > 5.5, > > > > > Netscape 7.2, MsAccess 2003 on windows 2000 > > > > machine. > > > > > > > > > > I integrated tomcat and apache as apache > > doesn't > > > > > support jsps. I wrote a JSP called test-db.jsp > > > > which > > > > > in turn calls java program TestSQLLoad.java. > > This > > > > > TestSQLLoad.java performs dattabase operation, > > > > fetches > > > > > the data from table and that data is displayed > > on > > > > > Netscape thro' jsp. > > > > > > > > > > 1. test-db.jsp resides ina directory > > > > > TOMCAT_HOME/webapps/web/JSP. Contents are as > > > > follows: > > > > > > > > > > <%@ page contentType="text/html" > > > > > import="testpkg.TestSQLLoad"%> > > > > > > > > > > <html> > > > > > <head> > > > > > <title>DB Test</title> > > > > > </head> > > > > > <body> > > > > > > > > > > <% > > > > > TestSQLLoad tst = new TestSQLLoad(); > > > > > tst.init(); > > > > > %> > > > > > > > > > > <h2>Results</h2> > > > > > User -> <%= tst.getUser() %><br/> > > > > > Pwd -> <%= tst.getPassword() %><br/> > > > > > Id -> <%= tst.getID() %> > > > > > > > > === message truncated === > > __________________________________ > Do you Yahoo!? > Yahoo! Mail - You care about security. So do we. > http://promotions.yahoo.com/new_mail > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
