All, In case anyone has the same problem, here is the solution. The behavior is controlled by the J/Connector flag useOldAliasMetadataBehavior, which needs to be set to 'true' for the query to work correctly on recent J/Connector versions. To set this parameter, use the following construct for the url parameter on the resource tag in your context.xml:
url="jdbc:mysql://[hostname]/[dbname]?useOldAliasMetadataBehavior=true" Hope this helps. Glyn On Mon, Dec 12, 2011 at 8:18 AM, Mikolaj Rydzewski <m...@ceti.pl> wrote: > On Mon, 12 Dec 2011 08:07:31 -0500, Glyn Thomas wrote: > > The following test JSP shows the problem: >> > > Does the problem occur only in JSP? Are you able to run the query using > regular SQL client? > > -- > Mikolaj Rydzewski <m...@ceti.pl> > > ------------------------------**------------------------------**--------- > To unsubscribe, e-mail: > users-unsubscribe@tomcat.**apache.org<users-unsubscr...@tomcat.apache.org> > For additional commands, e-mail: users-h...@tomcat.apache.org > >