Eclipse Community Forums: TMF (Xtext) » Failing Reading column alias in MyEclipse 2016 db2 10

Help

Home

Home » Modeling » TMF (Xtext) » Failing Reading column alias in MyEclipse 2016 db2 10

Show: Today's Messages :: Show Polls :: Message Navigator

Failing Reading column alias in MyEclipse 2016 db2 10 [message #1748118]

Fri, 18 November 2016 15:23

Mike Pietro

Messages: 6
Registered: November 2016

Junior Member

Hi, I'm having trouble looping through a query result set when I use an alias.

For example my original query is SELECT DATE AS MY_DATE FROM ACCC.EMP

when I try to
while (archiveRs.next()) {
AuxInfo auxDetail = newAuxInfo();
auxDetail.setPodI(new Long(archiveRs.getString("MY_DATE")));

}

It doesn't recognize "MY_DATE". I read somewhere you have to choose an option to use COLUMN LABEL not COLUMN HEADER but I can't find it. Does anybody know how I can resolve this?

Any help would be appreciated.

Thanks,

Mike

Report message to a moderator

Re: Failing Reading column alias in MyEclipse 2016 db2 10 [message #1748136 is a reply to message #1748118]

Fri, 18 November 2016 20:08

Christian Dietrich

Messages: 14665
Registered: July 2009

Senior Member

can you please give more context
i dont see how this is related to xtext

Twitter : @chrdietrich
Blog : https://www.dietrich-it.de

Report message to a moderator

Re: Failing Reading column alias in MyEclipse 2016 db2 10 [message #1748137 is a reply to message #1748136]

Fri, 18 November 2016 20:11

Mike Pietro

Messages: 6
Registered: November 2016

Junior Member

No Message Body

Report message to a moderator

Re: Failing Reading column alias in MyEclipse 2016 db2 10 [message #1748138 is a reply to message #1748137]

Fri, 18 November 2016 20:24

Mike Pietro

Messages: 6
Registered: November 2016

Junior Member

Hi Christian, I'm sorry, I'm not sure what xtext is. In my java app I am running a query using an "AS" so for example SELECT NAME AS FIRST_NAME using jdbc drivers. When I iterate through the result set I reference the COLUMN as FIRST_NAME. When I used MyEclipse 2015 32 bit it worked fine. I upgraded to MyEclipse 2016 64 bit and it fails. I need to reference it as NAME and then it works fine. Looking on line it said I need to reference the field as COLUMN LABEL not COLUMN NAME and there was an option to do that somewhere in Eclipse. Sorry if I'm not explaining this well but I'm a little confused too. Hopefully this makes more sense. Thanks for your help.

Report message to a moderator