Return-Path: Delivered-To: apmail-cocoon-users-archive@www.apache.org Received: (qmail 44702 invoked from network); 14 Sep 2009 19:28:18 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 14 Sep 2009 19:28:18 -0000 Received: (qmail 27875 invoked by uid 500); 14 Sep 2009 19:28:17 -0000 Delivered-To: apmail-cocoon-users-archive@cocoon.apache.org Received: (qmail 27798 invoked by uid 500); 14 Sep 2009 19:28:17 -0000 Mailing-List: contact users-help@cocoon.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: users@cocoon.apache.org List-Id: Delivered-To: mailing list users@cocoon.apache.org Received: (qmail 27790 invoked by uid 99); 14 Sep 2009 19:28:17 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 14 Sep 2009 19:28:17 +0000 X-ASF-Spam-Status: No, hits=4.0 required=10.0 tests=HTML_FONT_FACE_BAD,HTML_MESSAGE,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: local policy) Received: from [88.156.64.179] (HELO poczta.vectranet.pl) (88.156.64.179) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 14 Sep 2009 19:28:03 +0000 Received: from [172.16.1.7] (088156095209.wroclaw.vectranet.pl [88.156.95.209]) (Authenticated sender: barbara_slupik@wro.vectranet.pl) by poczta.vectranet.pl (Postfix) with ESMTP id 83D0486C27F9 for ; Mon, 14 Sep 2009 21:27:37 +0200 (CEST) Message-Id: <470A0E9E-1DE8-4025-885E-625DEA06ED16@wro.vectranet.pl> From: Barbara Slupik To: users@cocoon.apache.org In-Reply-To: <4AAE7506020000D40001597F@pta-emo.csir.co.za> Content-Type: multipart/alternative; boundary=Apple-Mail-6--228656079 Mime-Version: 1.0 (Apple Message framework v936) Subject: Re: REPOST: Queries in Cocoon 2.1.11 not working with"AS"protocol? Date: Mon, 14 Sep 2009 21:27:30 +0200 References: <4AAE7506020000D40001597F@pta-emo.csir.co.za> X-Mailer: Apple Mail (2.936) X-Virus-Checked: Checked by ClamAV on apache.org --Apple-Mail-6--228656079 Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Hello I had a similar problem with sql meta operations. In one environment the same query would return "foo" and in another one "bar". The reason was that these environments were using different versions of database connector: 5.0 returns alias and 5.1 returns column name. See http://dev.mysql.com/doc/refman/5.1/en/connector-j-installing-upgrading.html#connector-j-installing-upgrading-5-1 . Perhaps your problem is caused by this as well. Barbara On 14 Sep, 2009, at 4:53 pm, Derek Hohls wrote: > 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" 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:dhohls@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" 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:dhohls@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: > > > text > > > instead of: > > > text > > > (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-unsubscribe@cocoon.apache.org > For additional commands, e-mail: users-help@cocoon.apache.org > --Apple-Mail-6--228656079 Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Hello

I had = a similar problem with sql meta operations. In one environment the same = query would return "foo" and in another one "bar". The reason was that = these environments were using different versions of database = connector: 5.0 returns alias and 5.1 returns = column name. See http://dev.mysql.com/doc/= refman/5.1/en/connector-j-installing-upgrading.html#connector-j-installing= -upgrading-5-1. Perhaps your problem is caused by this as = well.

Barbara

On 14 Sep, 2009, at 4:53 pm, Derek Hohls = wrote:

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.pelssers@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:dhohls@csir.co.za] =
Sent: Monday, September 14, 2009 10:35 AM
To: users@cocoon.apache.org
Sub= ject: 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.pelssers@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:dhohls@csir.co.za] =
Sent: Monday, September 14, 2009 9:03 AM
To: users@cocoon.apache.org
Sub= ject: REPOST: Queries in Cocoon 2.1.11 not working with = "AS"protocol?

(=46rom 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/discl= aimer.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-unsubscribe@coco= on.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org<= /a>


= --Apple-Mail-6--228656079--