I have this app that has been working for years. Now, on a new server I can't get it to run.
It's not working with
Tomcat 6 and MySql 5.0. Tomcat 5.5 and MySql 5.0 worked fine on the old server. Both servers are Linux with the Connector/J driver and DBCP connection pooling. The old server is mysql-connector-java-5.0.4 and the new one mysql-connector-java-5.1.13.
It all boils down to this. Any column in a SELECT using an alias does not return a value.
e.g. (the over simplified version)
<sql:query var="viewList">
SELECT id, events.id as evid FROM events LIMIT 10
</sql:query>
<c:forEach items="${viewList.rows}" var="vrow">
${vrow.id}, ${vrow.evid}
</c:forEach>
In this example, vrow.id resolved to the id. vrow.evid does not resolve to anything. No error either. Nothing.
In the real example, I need to use the aliases to resolve ambiguous columns due to several joins.
Can anyone please make suggestions? I'm stumped...
Thanks