This is getting weirder and weirder. I modified the table and transfer config changing the field name to session_token, instead of token. No luck, same results.
I then tried to see the sql being sent to oracle when using listByProperty, and readByProperty. To do this I modified transfer configuration to point to the wrong table and provoke a "table or view does not exist" error that shows the sql that failed. - For the readByProperty method, the query is: select PERSON_ID from NW_SESSIONS where SESSION_TOKEN = (param 1) - For the listByProperty method, the query is: select SESSION_TOKEN as SessionToken, PERSON_ID as PersonId from NW_SESSIONS where SESSION_TOKEN = (param 1) The param 1 in both cases is just fine: (param 1) = [type='IN', class='java.lang.String', value='4B85F89A-D1AF- E4E2-13148E6984C1271F', sqltype='cf_sql_varchar'] If I run both queries directly, they both work as expected, both return 1 row, on the other hand if transfer runs them, they return no rows... WTF? I am at a loss here, I don't know what else to try. This doesn't make any sense!! Pedro. On Jan 4, 12:30 pm, pedrobl <[email protected]> wrote: > On Jan 4, 12:18 pm, Mark Mandel <[email protected]> wrote: > > > So that doesn't make sense... If the sql debug says that nothing is > > returned, but it returns values when you copy and paste it into a sql > > editor? > > > Is that right? > > Exactly, it does not make sense. I do similar things all over the > application. I don't understand why this is not working... I'm > changing the field name "TOKEN" to "SESSION_TOKEN", maybe that has > something to do with it. I'll post the results in a minute. > > Thanks for your patience, > > Pedro. -- Before posting questions to the group please read: http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer Try out the new Transfer ORM Custom Google Search: http://www.google.com/cse/home?cx=002375903941309441958:2s7wbd5ocb8 You received this message because you are subscribed to the Google Groups "transfer-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/transfer-dev?hl=en
