I use tomcat 5.5.16,and my database is Microsoft Access 2000,and I have configured ODBC as SMS in windows,then I configure JNDI like follows:
/*\tomcat\conf\server.xml*/ <Host name="localhost" appBase="webapps" unpackWARs="true" autoDeploy="true" xmlValidation="false" xmlNamespaceAware="false"> <Context path="/" docBase="" debug="5" reloadable="true" crossContext="true"> <Resource name="jdbc/abc" auth="Container" type="javax.sql.DataSource" driverClassName=" sun.jdbc.odbc.JdbcOdbcDriver" url="jdbc:odbc:SMS" username="administrator" password="123" maxActive="20" maxIdle="10" maxWait="-1"/> </Context> </Host> /*\tomcat\webapps\test\WEB-INF\web.xml*/ <?xml version="1.0" encoding="ISO-8859-1"?> <web-app xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd" version="2.4"> <display-name>Welcome to Tomcat</display-name> <description> Welcome to Tomcat </description> <!-- JSPC servlet mappings start --> <servlet> <servlet-name>org.apache.jsp.index_jsp</servlet-name> <servlet-class>org.apache.jsp.index_jsp</servlet-class> </servlet> <servlet-mapping> <servlet-name>org.apache.jsp.index_jsp</servlet-name> <url-pattern>/index.jsp</url-pattern> </servlet-mapping> <resource-ref> <description>DB Connection</description> <res-ref-name>jdbc/abc</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> <!-- JSPC servlet mappings end --> </web-app> My jsp file is follows: <[EMAIL PROTECTED] import="java.sql.*"%> <[EMAIL PROTECTED] import="javax.sql.DataSource"%> <[EMAIL PROTECTED] import="javax.naming.*"%> <html> <body> <% try{ Context initCtx=new InitialContext(); System.out.println("ok1"); DataSource db = (DataSource)initCtx.lookup("java:comp/env/jdbc/abc"); System.out.println("db="+db); Connection conn = db.getConnection(); System.out.println("conn="+conn); Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery("SELECT * FROM abc"); out.println("User-list"+"<br>"); while(rs.next()){ out.print(rs.getString(1)+"<br>"); } rs.close(); stmt.close(); conn.close(); }catch(Exception e){ out.print(e); } %> </body> </html> When I run my jsp,it raise following error: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' I want to know where is error? How to correct it?