OK, update... This is PURELY relateed to my MockDataProvider and goes away when I connect to a real database... Please disregard and see related post: https://groups.google.com/d/msg/jooq-user/h4pfIHjmBpo/U8BezETH5DMJ
On Monday, June 16, 2014 2:13:46 PM UTC-4, Deven Phillips wrote: > > Doh! OK, I added a from() clause, but it didn't change the situation any... > > Record rec = create.select( > > CUSTOMER.NAME.as <http://customer.name.as/>("name"), > > CUSTOMER.CODE.as <http://customer.code.as/>("code"), > concat( > > val("/v3/customer/"), > > CUSTOMER.CODE, > > val("/vdc")).as("vdc")) > > .from(CUSTOMER) > > .where(CUSTOMER.CODE.eq(code)) > > .fetchOne(); > > > Deven > > On Monday, June 16, 2014 2:02:54 PM UTC-4, Lukas Eder wrote: >> >> Hi, >> >> Are you sure you have posted the correct query? There's no FROM clause... >> >> I'd be a bit surprised, if such a critical bug slipped through our >> integration tests :-) so I suspect we'll need a little more information to >> reproduce this issue... >> >> Cheers >> Lukas >> >> >> 2014-06-16 19:26 GMT+02:00 Deven Phillips <[email protected]>: >> >>> I'm fairly new to jOOQ, so please bear with me if I have missed >>> something... >>> >>> I generated the code using the Gradle plugin and jOOQ version 3.2.2. >>> >>> When I attempt to run a query: >>> >>> Record rec = create.select( >>> >>> CUSTOMER.NAME.as("name"), >>> >>> CUSTOMER.CODE.as("code"), >>> concat( >>> >>> val("/v3/customer/"), >>> >>> CUSTOMER.CODE, >>> >>> val("/vdc")).as("vdc")) >>> >>> .where(CUSTOMER.CODE.eq(code)) >>> >>> .fetchOne(); >>> >>> >>> When I try to retrieve values, the values are not correlated properly. >>> Example: >>> >>> rec.getValue("name"); // Contains 'null' >>> rec.getValue("code"); // Contains the 'name' value >>> rec.getValue("vdc"); // Contains the 'code' value >>> rec.getValue(0); // Contains 'null' >>> rec.getValue(1); // Contains the 'name' value >>> rec.getValue(2); // Contains the 'code' value >>> rec.getValue(3); // Throws an exception saying invalid field >>> option >>> >>> Can anyone suggest where I might be going wrong? >>> >>> Thanks in advance!!! >>> >>> Deven >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "jOOQ User Group" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
