Hi Mark,
> So in the debug output - when you see the Transfer generated SQL, how many
> rows does it return?
>
None.
The table actually has just one row, that I dump using the
transfer.list("...Session") query. But none using the listByQuery method
(after the proper setParam, of course), or listByProperty.
Still researching...
Pedro.
2011/1/3 Mark Mandel <mark.man...@gmail.com>
> 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 <pe...@bezunartea.net> 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 transfer-dev@googlegroups.com
>> To unsubscribe from this group, send email to
>> transfer-dev+unsubscr...@googlegroups.com<transfer-dev%2bunsubscr...@googlegroups.com>
>> For more options, visit this group at
>> http://groups.google.com/group/transfer-dev?hl=en
>>
>
>
>
> --
> E: mark.man...@gmail.com
> 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 transfer-dev@googlegroups.com
> To unsubscribe from this group, send email to
> transfer-dev+unsubscr...@googlegroups.com<transfer-dev%2bunsubscr...@googlegroups.com>
> For more options, visit this group at
> http://groups.google.com/group/transfer-dev?hl=en
>
--
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 transfer-dev@googlegroups.com
To unsubscribe from this group, send email to
transfer-dev+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/transfer-dev?hl=en
