I dont whether MS Access is considered as RDBMS. For serious development it is not recommended. Using ODBC have several problems. I will recommend PostgreSQL. Now it runs very well on Windows. But requires Windows 2000 or higher. You can find it at http://www.postgresql.org/ftp/binary/v8.0.1/win32/. I am using it and have no problems. I am posting my configuration that I used to set up DBCP.
server.xml ----------------------------------- <GlobalNamingResources> <!-- Test entry for demonstration purposes --> <Environment name="simpleValue" type="java.lang.Integer" value="30"/> <!-- Editable user database that can also be used by UserDatabaseRealm to authenticate users --> <Resource name="UserDatabase" auth="Container" type="org.apache.catalina.UserDatabase" description="User database that can be updated and saved" factory="org.apache.catalina.users.MemoryUserDatabaseFactory" pathname="conf/tomcat-users.xml" /> <Resource name="jdbc/db1" auth="Container" type="javax.sql.DataSource" factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory" driverClassName="org.postgresql.Driver" url="jdbc:postgresql://192.168.4.248/antony" maxActive="20" maxIdle="10" maxWait="-1" username="benchmark" password="benchmark" /> </GlobalNamingResources> TOMCAT_HOME/conf/context.xml --------------------------------------------------- <ResourceLink global="jdbc/db1" name="jdbc/db1" type="javax.sql.DataSource"/> TOMCAT_HOME/webapps/web/WEB-INF/web.xml ----------------------------------------------------------------------------- <resource-ref> <res-ref-name>jdbc/db1</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> Did you defined your newly created context web in server.xml or at TOMCAT_HOME\conf\Catalina\localhost\some name.xml hope it will help. rgds Antony Paul On Mon, 21 Feb 2005 22:25:59 -0800 (PST), U K Laxmi <[EMAIL PROTECTED]> wrote: > Yes i read and did as per the document. When it didn't > work, i followed the suggetions given to many users in > the mailing lists in the internet and now i guess i > messed up. Actually in the error, it says, no suitable > driver found. > > I'm using Ms Access as it's free. Do we have any free > driver available in the form of jar to use in place of > JDBC-ODBC bridge driver? Or it's not required if > configuration is correct. Pls let me know. I've pasted > all relevant code in my first mail itself. If time > permits, any of you can try & give me the solution. > It'll be a great help. > > I've integrated tomcat 5.5.7 with apache 2. Does this > has any impact on the above. > > --- Antony Paul <[EMAIL PROTECTED]> wrote: > > > 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) > > > > > > > > === message truncated === > > __________________________________ > Do you Yahoo!? > Meet the all-new My Yahoo! - Try it today! > http://my.yahoo.com > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]