Robby I understand. But, as I said before, the same application is currently running fine on both the Windows machine and the existing Linux server. It is partially working on Cocoon 2.1.11 on the new Linux machine. i.e. the app works OK except for the strange transformer result I detailed below; the only difference I can see seems to be the Cocoon version.
>>> "Robby Pelssers" <robby.pelss...@ciber.com> 09/14/09 11:52 AM >>> Only last week I ran into such an issue where my app was running flawlessly on my development environment but when I deployed it to the QA environment I got following exception: Cannot create handle for transformer "SomeTransformer.xslt" ... This was due to the fact that my file had two capital letters and in my sitemap I referred to "Sometransformer.xslt". on windows this will work so you don't spot the error in time ;-( The same goes for (SQL) tables, columns etc. Your queries run like a charm on windows until you deploy your app on a unix environment. Luckily you'll be able to spot these kinds of mistakes quickly if you keep this in mind. My advise is to use consistently lowercase for your tables/columns so you'll never run into these issues. Cheers. Robby Pelssers -----Original Message----- From: Derek Hohls [mailto:dho...@csir.co.za] Sent: Monday, September 14, 2009 10:35 AM To: users@cocoon.apache.org Subject: RE: REPOST: Queries in Cocoon 2.1.11 not working with"AS"protocol? Thanks Robby; the production machine is running Linux and so I had assumed it was *not* a case-problem but more related to my Cocoon and/or MySQL upgrade - and obviously I do not want to upgrade the production server until its running locally... >>> "Robby Pelssers" <robby.pelss...@ciber.com> 09/14/09 10:20 AM >>> Not sure if this is important to mention but whenever you port a cocoon application from windows to unix... you'll bound to see exceptions.... like * FileNotFoundException * table not Found exception All this due to casesensitivity on unix systems... If this is related to this problem I don't know but it's worthwile checking the tablenames thoroughly and comparing them to your queries. Kind regards, Robby -----Original Message----- From: Derek Hohls [mailto:dho...@csir.co.za] Sent: Monday, September 14, 2009 9:03 AM To: users@cocoon.apache.org Subject: REPOST: Queries in Cocoon 2.1.11 not working with "AS"protocol? (From 2008-08-27 - I'm sure someone can check this error very easily?) I am in the process of porting my applications over from Windows to Linux as my development platform. I am now running Cocoon 2.1.11 and Mysql 5.0.67 (was 2.1.8 and 4.0.23) There is one issue I have encountered so far. When running a query of the form: SELECT foo AS bar from mytable The SQLTransformer gives back: <sq2:row> <sq2:foo>text</sq2:foo> </sq2:row> instead of: <sq2:row> <sq2:bar>text</sq2:bar> </sq2:row> (I have tested the same query using the MySQL Query Browser and it works as expected.) Does anyone know why this is and how I can fix it? Thanks Derek -- This message is subject to the CSIR's copyright terms and conditions, e-mail legal notice, and implemented Open Document Format (ODF) standard. The full disclaimer details can be found at http://www.csir.co.za/disclaimer.html. This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. MailScanner thanks Transtec Computers for their support. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@cocoon.apache.org For additional commands, e-mail: users-h...@cocoon.apache.org
