What are the param values? Looks like you're passing a string to something that is expecting a number.
http://ora-01722.ora-code.com/ Mark On Thu, Sep 2, 2010 at 3:29 AM, Moni <rebs...@media-solutions.de> wrote: > Hi, > > I'm using Transfer 1.1 with Oracle 10 Database on Coldfusion MX 7 with > the Hotfix 2. > > I'm trying to receive a resultset with transfer.get() on two different > server. > On the first server I get the correct resultset but the second server > throws an sql-error. It says "ORA-01722: invalid Number". > It seems that the query wasn't parsed, it still contains (param 1), > (param 2) and so on (see below). > > The configurations (CF and Database) on both servers are indentical > except the OS. The first machine runs with Window Server 2000, the > other with Windows XP. > > Does anyone have any suggestions? > > Here is the transfer.xml > > <transfer> > <objectDefinitions> > <object name="mandant" table="besuv.mandant"> > <id name="mid" type="numeric" /> > <property name="mandant_sts" type="numeric" > column="sts"/> > <property name="mandant" type="string" /> > </object> > <object name="besucher" table="besuv.besucher"> > <compositeid> > <manytoone name="mid" /> > <property name="bid" /> > </compositeid> > <manytoone name="mid"> > <link column="mid" to="mandant"/> > </manytoone> > <property name="bid" type="numeric" /> > <property name="sts" type="numeric" /> > <property name="nname" type="string" /> > <property name="vname" type="string" /> > </object> > </objectDefinitions> > </transfer> > > And this is the CF-Code: > > <cfset key = StructNew()> > <cfset tmp = StructInsert( key, "mid", 1)> > <cfset tmp = StructInsert( key, "bid", 1000)> > > <cfset oBesucher = application.transfer.get( "besucher", key )> > > > SQL-Query from the SQL-Error: > SELECT NULL AS mandant, > besuv_besucher_1.mid, > besuv_besucher_1.vname, > besuv_besucher_1.nname, > besuv_besucher_1.sts, > besuv_besucher_1.bid, > besuv_besucher_1.bid > ||'|' > ||besuv_besucher_1.mid > ||'|' AS transfer_compositeid, > NULL AS transfer_parentKey, > 1 AS transfer_orderIndex, > 'besucher' AS transfer_className, > '' AS transfer_parentClassName, > '' AS transfer_parentParentClassName, > '' AS transfer_parentCompositeName, > 'false' AS transfer_isArray, > '' AS transfer_compositeName, > 'false' AS transfer_isProxied > FROM besuv.besucher besuv_besucher_1 > WHERE besuv_besucher_1.bid = (param 1) > AND besuv_besucher_1.mid = (param 2) > UNION ALL > SELECT besuv_mandant_2.mandant, > besuv_mandant_2.mid, > NULL AS vname, > NULL AS nname, > besuv_mandant_2.sts, > NULL AS bid, > '' AS transfer_compositeid, > CAST(besuv_besucher_1.bid > ||'|' > ||besuv_besucher_1.mid > ||'|' AS VARCHAR2(1000)) AS transfer_parentKey, > 2 AS transfer_orderIndex, > 'mandant' AS transfer_className, > 'besucher' AS transfer_parentClassName, > '' AS transfer_parentParentClassName, > '' AS transfer_parentCompositeName, > 'false' AS transfer_isArray, > 'mid' AS transfer_compositeName, > 'false' AS transfer_isProxied > FROM besuv.besucher besuv_besucher_1 > INNER JOIN besuv.mandant besuv_mandant_2 > ON besuv_besucher_1.mid = besuv_mandant_2.mid > WHERE besuv_besucher_1.bid = (param 3) > AND besuv_besucher_1.mid = (param 4) > AND besuv_mandant_2.mid IS NOT NULL > ORDER BY transfer_orderIndex ASC > > -- > 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 For more options, visit this group at http://groups.google.com/group/transfer-dev?hl=en