Cannot create JDBC driver of class ''for connect URL 'null'
In Tomcat 5.5.xx, this problem occurs when the previous configuration method is used.
Solution:
Insert the resource description in the following format into <context> </context> of server. xml:
<Resource Name = "JDBC/DB" type = "javax. SQL. datasource "username =" sa "Password =" admin "driverclassname =" com. microsoft. JDBC. sqlserver. sqlserverdriver "maxidle =" 2 "maxwait =" 5000 "url =" JDBC: Microsoft: sqlserver: // localhost: 1433; databasename = jspdev "maxactive =" 4 "/>
To replace the previous configuration method:
<Resource Name = "JDBC/DB" type = "javax. SQL. datasource"/>
<Resourceparams name = "JDBC/DB">
<Parameter>
<Name> maxwait </Name>
<Value> 5000 </value>
</Parameter>
<Parameter>
<Name> maxactive </Name>
<Value> 20 </value>
</Parameter>
<Parameter>
<Name> password </Name>
<Value> admin </value>
</Parameter>
<Parameter>
<Name> URL </Name>
<Value> JDBC: Microsoft: sqlserver: // localhost: 1433; databasename = jspdev </value>
</Parameter>
<Parameter>
<Name> driverclassname </Name>
<Value> com. Microsoft. JDBC. sqlserver. sqlserverdriver </value>
</Parameter>
<Parameter>
<Name> maxidle </Name>
<Value> 20 </value>
</Parameter>
<Parameter>
<Name> removeabandoned </Name>
<Value> true </value>
</Parameter>
<Parameter>
<Name> removeabandonedtimeout </Name>
<Value> 180 </value>
</Parameter>
<Parameter>
<Name> username </Name>
<Value> SA </value>
</Parameter>
</Resourceparams>