On 13 Dec 2011, at 04:31, Glyn Thomas <glynthoma...@gmail.com> wrote:
> 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. Nice. Thanks for posting the solution. p > > 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 >> >> --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org