DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://nagoya.apache.org/bugzilla/show_bug.cgi?id=23026>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE.
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=23026 DB JNDI Datasource does not work with SAP DB Summary: DB JNDI Datasource does not work with SAP DB Product: Tomcat 4 Version: 4.1.27 Platform: PC OS/Version: Windows NT/2K Status: NEW Severity: Normal Priority: Other Component: Webapps:Administration AssignedTo: [EMAIL PROTECTED] ReportedBy: [EMAIL PROTECTED] 1. JDBC driver in $CATALINA_HOME/common/lib/sapdbc.jar 2. server.xml configuration: <Context path="/Test" docBase="Test" debug="5" reloadable="true" crossContext="true"> <Logger className="org.apache.catalina.logger.FileLogger" prefix="localhost_TestDB_log." suffix=".txt" timestamp="true"/> <Resource name="jdbc/TestDB" auth="Container" type="javax.sql.DataSource"/> <ResourceParams name="jdbc/TestDB"> <parameter> <name>factory</name> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> </parameter> <parameter> <name>maxActive</name> <value>45</value> </parameter> <parameter> <name>maxIdle</name> <value>5</value> </parameter> <parameter> <name>maxWait</name> <value>15000</value> </parameter> <parameter> <name>username</name> <value>DBA</value> </parameter> <parameter> <name>password</name> <value>PASSWORD</value> </parameter> <parameter> <name>driverClassName</name> <value>com.sap.dbtech.jdbc.DriverSapDB</value> </parameter> <parameter> <name>url</name> <value>jdbc:sapdb:///TestDB</value> </parameter> </ResourceParams> </Context> 3. web.xml configuration: <web-app> ... <servlet> <servlet-name>Test</servlet-name> <servlet-class>Test</servlet-class> </servlet> ... <servlet-mapping> <servlet-name>Test</servlet-name> <url-pattern>/Test</url-pattern> </servlet-mapping> ... <resource-ref> <description>Test DB Connection</description> <res-ref-name>jdbc/TestDB</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> ... </web-app> 4. Test Servlet: ... Context initContext = new InitialContext(); if (initContext != null) { out.println("<p>OK. Got InitialContext()</p>"); } // if Context envContext = (Context)initContext.lookup("java:/comp/env"); if (envContext != null) { out.println("<p>OK. Got initContext.lookup(\"java:/comp/env\")</p>"); } // if DataSource ds = (DataSource) envContext.lookup("jdbc/TestDB"); if (ds != null) { out.println("<p>OK. Got envContext.lookup(\"jdbc/TestDB\")</p>"); } // if Connection con = ds.getConnection(); if (con != null) { out.println("<p>OK. ds.getConnection()</p>"); } // if } catch (Exception e) { out.println("<p>"); e.printStackTrace(out); out.println("</p>"); } // catch ... Result: OK. Got InitialContext() OK. Got initContext.lookup("java:/comp/env") OK. Got envContext.lookup("jdbc/TestDB") java.sql.SQLException: Cannot load JDBC driver class 'null' at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.jav a:529) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:3 12) at Test.processRequest(Test.java:79) at Test.doGet(Test.java:104) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja va:256) ... --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]