So in the debug output - when you see the Transfer generated SQL, how many rows does it return?
Mark On Tue, Jan 4, 2011 at 2:35 AM, pedrobl <[email protected]> wrote: > > Happy new year everyone! > > I left last year with a strange problem that probably has an easy > solution which I fail to see. I'm using Coldbox, Coldspring, Transfer > and Oracle 10g. I have stumbled upon a few driver issues, and this > probably has something to do with it. > > First, the table: sessions, which just has the following fields: > PersonId (CHAR 32), Token (CHAR 36). > > The use case is simple, a user wants to be authenticated and doesn't > remember her password. She accesses a form where she enters her email > address, the system checks that the email exists, generates a token > using CreateUUID(), persists the session object to the database, and > sends an email with a link containing the token just created. The link > takes the user to a page where all the system has to do is search the > database for the token, and generate a user session accordingly... > pretty simple. > > Second, transfer.xml: > <object name="Session" table="USER_SESSIONS"> > <id name="PersonId" column="PERSON_ID" type="string" generate="false" / > > > <property name="SessionToken" type="string" nullable="false" > column="TOKEN" /> > </object> > > Amazingly, the record is never found. I have tried many transfer > methods, all unsuccessfully, among others: > > - readByProperty: "SessionToken", and the generated token. > - readByPropertyMap: the map consists of a struct with a > "SessionToken" key, and the token as its value. > - listByQuery: the query is simple "FROM ...Session > WHERE ...Session.SessionToken=:sessionToken" > - Change the TOKEN field to varchar2. > > The first two return a new object, and the third returns an empty > query. I also cfdump the whole table, to check that the record exists, > and the sql sent to oracle, and all look just fine... as they do in > many other parts of the application. If I run the query generated > directly in SQLDeveloper, it works fine. I have also tried the same > code using postgresql instead of Oracle, and it works!! > > Sorry for the long post. What else could I try to debug this? Any > ideas? TIA, > > 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]<transfer-dev%[email protected]> > For more options, visit this group at > http://groups.google.com/group/transfer-dev?hl=en > -- E: [email protected] T: http://www.twitter.com/neurotic W: www.compoundtheory.com cf.Objective(ANZ) - Nov 18, 19 - Melbourne Australia http://www.cfobjective.com.au Hands-on ColdFusion ORM Training www.ColdFusionOrmTraining.com -- 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
