hi, all,
i've an application works fine with MSAccess, now i want to switch it to MySql. got
the error like in the topic. here below is the detail:
<sql:setDataSource var="food"
driver="com.mysql.jdbc.Driver"
url="jdbc:mysql:foodcoop"
user="myuser" password="mypass"
/>
<sql:query var="valid" dataSource="${food}">
select * from staff;
</sql:query>
error:
javax.servlet.ServletException: Unable to get connection, DataSource invalid: "No
suitable driver"
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:867)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:800)
org.apache.jsp.test_jsp._jspService(test_jsp.java:78)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
************************************
i checked the jar file, it is in the right place, %jboss_home%/server/default/lib/
anyone can help? any comment will be appreciated.
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3831497#3831497
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3831497
-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
