Can you provide some debug log output? I'd be interested in what kind of query is really generated. Information about logging can be seen here: http://www.jooq.org/doc/latest/manual/sql-execution/logging/
2014-06-16 20:13 GMT+02:00 Deven Phillips <[email protected]>: > 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. > -- 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.
