1 Replies - 3310 Views - Last Post: 20 September 2012 - 09:16 AM

#1 micro_  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 23
  • Joined: 27-April 11

error Tomcat call Datasource ""No suitable driver found for j

Posted 17 September 2012 - 08:53 AM

I have datasource in context.xml at directory C:\Program Files\Apache Software Foundation\Apache Tomcat 6.0.26\conf\context.xml
---
<?xml version="1.0" encoding="UTF-8"?>
<Context antiJARLocking="true" path="/forum">
<Resource name="jdbc/dvdshop" type="javax.sql.DataSource"
auth="Container" username="sa" password="123456"
driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
url="jdbc:sqlserver://localhost:1433;databaseName=OnlineShop4DVDS"
maxActive="20" maxIdle="10" maxWait="-1"/>
</Context>

---
I get a error when i run Web application
->
Sep 17, 2012 10:41:48 PM org.apache.catalina.core.ApplicationDispatcher invoke
SEVERE: Servlet.service() for servlet jsp threw exception
javax.servlet.jsp.JspException: Unable to get connection, DataSource invalid: "No suitable driver found for jdbc/dvdshop"
at org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.getConnection(QueryTagSupport.java:308)
at org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doStartTag(QueryTagSupport.java:192)
at org.apache.jsp.pages.templates.header_jsp._jspx_meth_sql_005fquery_005f0(header_jsp.java:267)
at org.apache.jsp.pages.templates.header_jsp._jspService(header_jsp.java:123)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
........
-------------------------
please give me a solution or cue !
Thank you much!

Is This A Good Question/Topic? 0
  • +

Replies To: error Tomcat call Datasource ""No suitable driver found for j

#2 rjohn5854  Icon User is offline

  • D.I.C Head

Reputation: 3
  • View blog
  • Posts: 172
  • Joined: 04-October 11

Re: error Tomcat call Datasource ""No suitable driver found for j

Posted 20 September 2012 - 09:16 AM

Do you have the java servlet jar file in place?
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1