Re: Compatability Problem OSX to Windows 7 Port

2011-12-15 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Glyn, On 12/12/11 8:07 AM, Glyn Thomas wrote: I am attempting to port a Tomcat/MySql application from OSX to Windows 7 (I previously ported it from Vista to OSX, so it shouldn't be as difficult as it sounds), and am having problems with

Compatability Problem OSX to Windows 7 Port

2011-12-12 Thread Glyn Thomas
I am attempting to port a Tomcat/MySql application from OSX to Windows 7 (I previously ported it from Vista to OSX, so it shouldn't be as difficult as it sounds), and am having problems with back-compatibity on some queries. The application works correctly on OSX, with Tomcat 5.5, JRE 1.5.0 R12,

Re: Compatability Problem OSX to Windows 7 Port

2011-12-12 Thread Mikolaj Rydzewski
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

Re: Compatability Problem OSX to Windows 7 Port

2011-12-12 Thread Glyn Thomas
Mikolaj, if I run the same query in the MySql client it works correctly (column names correctly aliased). Thanks 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:

Re: Compatability Problem OSX to Windows 7 Port

2011-12-12 Thread Glyn Thomas
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

Re: Compatability Problem OSX to Windows 7 Port

2011-12-12 Thread Pid *
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