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]
