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 --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@cocoon.apache.org For additional commands, e-mail: users-h...@cocoon.apache.org
