How to make the JSTL access my database and some syntax question.

User_DTTUY

Hi,

I've been trying and trying to make my jstl work but still not working.

Have added the resource references in tomcat.

jdbc/WebApplication1 javax.sql.DataSource Container Shareable database for WebApplication1

Not sure what other things I must do in order for my jsp page to display a table using jstl.

Hope some one can share with me.

<jsp:useBean id="Tutors" scope="session" class="databaseAccess.TutorsBean"/>
<jsp:setProperty name ="Tutors" property="*"/>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%>
<%@ taglib prefix="x" uri="http://java.sun.com/jsp/jstl/xml" %>

<%@page language="java" import ="java.sql.*" %>

<sql:setDataSource driver="com.mysql.jdbc.Driver" url="jdbc:mysql://
localhost:3306/pract1" user="root" password="123"/>

<sql:query var="tutors" maxRows="5">
Select *, GROUP_CONCAT(subject.subjectName SEPARATOR \", \") AS Subj from tutors LEFT JOIN subinter ON subinter.tutorsID = tutors.id LEFT JOIN subject ON subinter.subjectID = subject.id GROUP BY tutors.id");

</sql:query>


In MySQL I have created 3 tables by the name of tutors, subject and subinter

But, netbean IDE gave me an error on <sql:query var="tutors" maxRows="5">

So, hope someone can advise me where have I gone wrong with the syntax or what?

Tks.

EJP

'An error'?

DrClap

What's with the backslashes in the SQL statement?

User_DTTUY

Yes. The error message is:

org.apache.jasper.JasperException: An exception occurred processing JSP page /DisplayData.jsp at line 30

What's wrong with my code?