Error whiling to fetch data from a MySQL database using jstl in a maven project

Asked Oct 15 '20 at 16:49

Active Oct 15 '20 at 23:32

Viewed 56 times

the same code is working perfectly fine in another non-maven project

errors-img link
maven dependencies-img link

<sql:setDataSource var="db" driver="com.mysql.cj.jdbc.Driver" url="jdbc:mysql://localhost:3306/uu" user="root" password="#Akshpnwr123#"/>

<sql:query var="rs" dataSource="${db}">select * from students</sql:query>

<c:forEach items="${rs.rows}" var="student">

    ${student.id} : ${student.s_name} : ${student.password} : ${student.s_course} <br>

</c:forEach>

edited Oct 15 '20 at 23:32

hiddeneyes02

2,562
1
31
58

asked Oct 15 '20 at 16:49

Akash Panwar

1

Did you check [this](https://stackoverflow.com/questions/5556664/how-to-fix-no-suitable-driver-found-for-jdbcmysql-localhost-dbname-error-w) post ? – Swati Oct 15 '20 at 16:53
What is the error you are getting? – Vivek Jain Oct 15 '20 at 17:02
@VivekJain i added an image link. – Akash Panwar Oct 15 '20 at 17:04
@Swati the same code is working perfectly fine in another project which is not maven based – Akash Panwar Oct 15 '20 at 17:08
1

Please don't use images to show your code. Just copy and past it here respecting formatting. – hiddeneyes02 Oct 15 '20 at 18:08
Just a rule of thumb: Making database connections directly in the JSP file rather than using servlets is a *horrible* practice. – Spectric Oct 16 '20 at 21:41

Error whiling to fetch data from a MySQL database using jstl in a maven project

0 Answers0