Problem with using a <sql:query> JSTL Tag when retrieving using JOIN

[Carlo Reyes]

Good day, everyone!

I need help with a Web Application I'm working on, it's a Mini-Administrator Panel (CRUD some stuff).
Made with: JSP & Servlets (MVC), and MySQL Database

I'm having a problem with the JSTL Tag <sql:query> (by the way I only use this tag when retrieving stuff).

When I make a simple retrieval, i.e.

Database Table: User [id, name, address etc.]

<sql:setDataSource var="db" <!-- Some other database details here -->/> <sql:query var="userList" dataSource="${db}">SELECT * FROM User</sql:query>

And I print the results out in a table, the users are properly retrieved and displayed.

PROBLEM: But when I use the same tag with retrieving from a table with foreign key constraints, i.e. INNER JOIN, LEFT JOIN, etc., with the code:

Database Tables:
   Manager (id, name)
   Employee (that holds an id for his/her manager: managerId column)

(What I wanted was to retrieve a list of employees, along with their respective managers)

<sql:query var="employeeList" dataSource="${db}"> SELECT [ALL COLUMNS FROM Employee Table],    Manager.name AS managerName    FROM Employee        INNER JOIN Manager            ON Employee.managerId = Manager.id </sql:query>

All the User details are printed out fine, except for the managerName field, with the code:

<table>    <thead>         <!-- Headers for every column/field -->         <th>Manager Name</th>    </thead>    <tbody>        <c:forEach items="${employeeList.rows}" var="employee">              <!-- Print out the details -->              <td><c:out value="${employee.managerName}"/></td>        </c:forEach>    </tbody> </table>

Any idea on how I would properly access the column? I would like to avoid using MVC and DAO for retrieving, and have only 1 JSP page handle the retrieving and printing.

Thanks to everyone in advance!