Hi there:
I am using tomcat 5.5.17 and SQL Server 2000 database with SQL Server 2005 JDBC
Driver. OS is Windows XP professional. I have configured web.xml in WEB-INF
directory and context.xml in META-INF directory of my application. Both are
attached below with this email. I have a login.jsp page that asks for username
and password... and when submit is hit, it gives the following error.
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of
class '' for connect URL 'null'
I tried to google and tried the suggestion given but any of them doesn't seem
to work. Is there anything wrong with my configuration? PLEASE HELP...it is
higly appreciated. If something is not clear, please get back to me. Thank you
so much.
context.xml file looks like this...
<?xml version="1.0" encoding="UTF-8"?>
<Context debug="0" displayName="ISOTracking"
docBase="C:\Java\TomcatTestServer\apache-tomcat-5.5.17\webapps\ISOTrackingTest"
path="/ISOTracking" reloadable="true">
<Logger className="org.apache.catalina.logger.FileLogger"
prefix="ISOTRackingTest_Log." suffix=".txt" timestamp="true"/>
<!-- Define a database connection pool for SQL SERVER 2000 -->
<Resource name="jdbc/sqlserver" auth="Container"
factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"
type="javax.sql.DataSource"
driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
url="jdbc:sqlserver://localhost:1433" username="xxx"
password="xxx"maxActive="100" maxIdle="30" maxWait="10000"
removeAbandoned="true" removeAbandonedTimeout="60" logAbandoned="true"/>
<ResourceLink name="jdbc/sqlserver" type="javax.sql.DataSource"
global="jdbc/sqlserver"/>
</Context>
web.xml looks like this...
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application
2.3//EN" "http://java.sun.com/dtd/web-app_2_3.dtd";>
<web-app>
<display-name>ISOTracking</display-name>
<description>
Welcome TO ISO Tracking Application
</description>
<!-- JSPC servlet mappings start -->
<servlet>
<servlet-name>ISOTracking.Login_jsp</servlet-name>
<servlet-class>ISOTracking.Login_jsp</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>ISOTracking.Login_jsp</servlet-name>
<url-pattern>/Login.jsp</url-pattern>
</servlet-mapping>
<session-config>
<session-timeout>30</session-timeout>
</session-config>
<!-- JSPC servlet mappings end -->
<resource-ref>
<res-ref-name>jdbc/sqlserver</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app>
---------------------------------------------------------------------
To start a new topic, e-mail: [email protected]
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
