Query give error once deployed

Hans_001

Hi,

I am developing some BIRT reports within eclipse but when I deploy them they do not display anything. After several hours of trial and errors I found that whenever I use the sql keyword "AS" (ex: select foo1 AS foo from fooTable) in a dataset the report does not run on my server but surprisingly it does execute well from eclipse which uses the database on my server.

The query also runs fine when accessing the database directly through a DB client.

My questions:

1- Is the AS keyword forbidden within BIRT datasets?
2- How can it run within eclipse and not on the j2ee server?

Eclipse: ganymede with birt report designer framework 2.3.0.v200804251
Server where I deploy: jboss 4.0.5GA with birt runtime 2.3

Thanks