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 back-c

Re: Compatability Problem OSX to Windows 7 Port

2011-12-12 Thread Pid *
On 13 Dec 2011, at 04:31, Glyn Thomas 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.

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 th

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 wrote: > On Mon, 12 Dec 2011 08:07:31 -0500, Glyn Thomas wrote: > > The following test JSP shows the problem: >> > > Does the

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 - To unsubs