RE: CF webservice consumed via .NET
My thoughts - I *think* if you were to create a .NET object that mirrors the structure of the query object, .NET would probably be able to use the query type returned from CF. However, it would probably be easiest to serialize the output of the query into an XML string and just pass it via the webservice as a string, which could easily be read by .NET. - Matt Small -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Thursday, November 03, 2005 4:58 PM To: CF-Talk Subject: CF webservice consumed via .NET Hey All, I've read lots of old posts saying the WDSL datatype of QueryBean (which is what CF queries get passed as from CF web services). I can't find anything recent.. One old post says nothing but CF can convert that datatype back into a query So...can .NET consume CF web service that returns a query? If so...please shed some light ;-) TIA Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223178 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF webservice consumed via .NET
I *think* if you were to create a .NET object that mirrors the structure of the query object, .NET would probably be able to use the query type returned from CF. However, it would probably be easiest to serialize the output of the query into an XML string and just pass it via the webservice as a string, which could easily be read by .NET. - Matt Small Thanks Matt... I'm trying to avoid looping over the query to convert it to an XML stringwhen you return thousands of records it sure slows down the service ;-) I'll do it if I have to though. Anybody else have 2 cents to addI know you're out there and I know you've bumped into thiswhere's Barney B. and Dave W.?? ;-) How about structures returned from CF web servicesdoes .NET choke on those as well? TIA Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223216 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF webservice consumed via .NET
Looping over thousands of records to pass over a webservice is probably going to be slow anyway, isn't it? I ran into this exact same situation - I serialized about 14000 records returned from the DB into XML to pass to a .NET webservice. It took forever to process. I was never sure whether it was the fact that I was serializing it, or the fact that I was passing 14000 records across the network to a webservice to process. Perhaps you could send each row, one at a time? Might that be faster than serialization/deserialization? I was going to quote Joe Rinehart on doing this kind of stuff, but I think you'd be better of reading it yourself. http://webservices.sys-con.com/read/47199.htm - Matt Small; -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Friday, November 04, 2005 11:50 AM To: CF-Talk Subject: Re: CF webservice consumed via .NET I *think* if you were to create a .NET object that mirrors the structure of the query object, .NET would probably be able to use the query type returned from CF. However, it would probably be easiest to serialize the output of the query into an XML string and just pass it via the webservice as a string, which could easily be read by .NET. - Matt Small Thanks Matt... I'm trying to avoid looping over the query to convert it to an XML stringwhen you return thousands of records it sure slows down the service ;-) I'll do it if I have to though. Anybody else have 2 cents to addI know you're out there and I know you've bumped into thiswhere's Barney B. and Dave W.?? ;-) How about structures returned from CF web servicesdoes .NET choke on those as well? TIA Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223234 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF webservice consumed via .NET
Looping over thousands of records to pass over a webservice is probably going to be slow anyway, isn't it? If you have to pass the result as an XML stringthen yes the above is true and why I'm asking for alternative solutions (like why the hell can't CF return something useful to languages other than CF) ;-) I ran into this exact same situation - I serialized about 14000 records returned from the DB into XML to pass to a .NET webservice. It took forever to process. I was never sure whether it was the fact that I was serializing it, or the fact that I was passing 14000 records across the network to a webservice to process. Perhaps you could send each row, one at a time? Might that be faster than serialization/deserialization? I'm curious what you mean by serialized? are you using a function to do this (if so it's looping anyways)? or looping and converting each row to XML? BTW..in my tests...the conversion of a query to an XML string was 100% the cause of major slow down (like 5 times slower than just returning the query) Thans Matt Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223235 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF webservice consumed via .NET
Serialization is just another term for conversion to XML. From Wikipedia: Serialization involves taking a data structure or object and encoding it into a regular and usually architecture-independent form... However, on this note, perhaps there's a faster way to serialize using the underlying java engine, using something like stringbuilder rather than looping in CF. Anyone out there know? Maybe this would be an incredibly useful custom tag? Even better, I know that a WDDX add-in for .NET exists, I've not used it though. Is there a chance that CFWDDX tag would be faster? - Matt Small -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Friday, November 04, 2005 1:04 PM To: CF-Talk Subject: Re: CF webservice consumed via .NET Looping over thousands of records to pass over a webservice is probably going to be slow anyway, isn't it? If you have to pass the result as an XML stringthen yes the above is true and why I'm asking for alternative solutions (like why the hell can't CF return something useful to languages other than CF) ;-) I ran into this exact same situation - I serialized about 14000 records returned from the DB into XML to pass to a .NET webservice. It took forever to process. I was never sure whether it was the fact that I was serializing it, or the fact that I was passing 14000 records across the network to a webservice to process. Perhaps you could send each row, one at a time? Might that be faster than serialization/deserialization? I'm curious what you mean by serialized? are you using a function to do this (if so it's looping anyways)? or looping and converting each row to XML? BTW..in my tests...the conversion of a query to an XML string was 100% the cause of major slow down (like 5 times slower than just returning the query) Thans Matt Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223236 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF webservice consumed via .NET
Thanks Mattjust makin sure we were talkin the same language...we are ;-) and yep...if there's a fatser way to serialize (convert to XML)...BRING IT!! ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223239 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF webservice consumed via .NET
-Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Friday, November 04, 2005 1:15 PM To: CF-Talk Subject: Re: CF webservice consumed via .NET Thanks Mattjust makin sure we were talkin the same language...we are ;-) and yep...if there's a fatser way to serialize (convert to XML)...BRING IT!! ;-) Which database are you using? Might it not be fastest to construct the XML as part of the query itself? You can format your results using string parsing in most DBs, but some modern ones may be able to do the XML conversion themselves (SQL Server 2005 touts this for example). In other words why fetch, convert and send? Just fetch and send. Jim Davis ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223243 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF webservice consumed via .NET
Which database are you using? Might it not be fastest to construct the XML as part of the query itself? You can format your results using string parsing in most DBs, but some modern ones may be able to do the XML conversion themselves (SQL Server 2005 touts this for example). In other words why fetch, convert and send? Just fetch and send. Jim Davis DOH!there's a damn fine idea Jim ;-) It's Oracle 9i...any idea if it will return XML...and example would be great? Thanks Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223245 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF webservice consumed via .NET
-Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Friday, November 04, 2005 1:48 PM To: CF-Talk Subject: Re: CF webservice consumed via .NET Which database are you using? Might it not be fastest to construct the XML as part of the query itself? You can format your results using string parsing in most DBs, but some modern ones may be able to do the XML conversion themselves (SQL Server 2005 touts this for example). In other words why fetch, convert and send? Just fetch and send. Jim Davis DOH!there's a damn fine idea Jim ;-) It's Oracle 9i...any idea if it will return XML...and example would be great? Sorry - I've not actually DONE this (and I don't have any experience with Oracle)... it was just a thought. I know that I could do it SQL Server using string concatenation (just building the XML manually) - I assume the same is true for Oracle. In SQL Server you can also use COM objects or (in 2005) built SPs using JavaScript, perhaps you can do the same (or similar) in Oracle? Now that I'm thinking about it maybe I should work on a YODEL serializer for SQL Server 2005... Jim Davis ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223252 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF webservice consumed via .NET
I know next to nothing about Oracle, but here's an interesting thing I found via Google: http://www.oracle.com/technology/oramag/oracle/03-may/o33xml.html - Matt Small -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Friday, November 04, 2005 2:28 PM To: CF-Talk Subject: RE: CF webservice consumed via .NET -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Friday, November 04, 2005 1:48 PM To: CF-Talk Subject: Re: CF webservice consumed via .NET Which database are you using? Might it not be fastest to construct the XML as part of the query itself? You can format your results using string parsing in most DBs, but some modern ones may be able to do the XML conversion themselves (SQL Server 2005 touts this for example). In other words why fetch, convert and send? Just fetch and send. Jim Davis DOH!there's a damn fine idea Jim ;-) It's Oracle 9i...any idea if it will return XML...and example would be great? Sorry - I've not actually DONE this (and I don't have any experience with Oracle)... it was just a thought. I know that I could do it SQL Server using string concatenation (just building the XML manually) - I assume the same is true for Oracle. In SQL Server you can also use COM objects or (in 2005) built SPs using JavaScript, perhaps you can do the same (or similar) in Oracle? Now that I'm thinking about it maybe I should work on a YODEL serializer for SQL Server 2005... Jim Davis ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223253 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF webservice consumed via .NET
Jim I think transforming the columns returned using string functions might not quite do it (as you're missing nodes and headers etc.)...so not a complete and valid XML string. That said, I know that some DBs will return XML (and consume it) instead of a standard recordset (but I don't know if Oracle can or how to do it if it does). Anybody? Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223256 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF webservice consumed via .NET
BINGO! Mattthat would do the trick. The bummer is I can't use it given the application structure I'm working withbut for the future...that would work nicely (like the very next project). Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com - Original Message - From: Matthew Small [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, November 04, 2005 11:34 AM Subject: RE: CF webservice consumed via .NET I know next to nothing about Oracle, but here's an interesting thing I found via Google: http://www.oracle.com/technology/oramag/oracle/03-may/o33xml.html - Matt Small -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Friday, November 04, 2005 2:28 PM To: CF-Talk Subject: RE: CF webservice consumed via .NET -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Friday, November 04, 2005 1:48 PM To: CF-Talk Subject: Re: CF webservice consumed via .NET Which database are you using? Might it not be fastest to construct the XML as part of the query itself? You can format your results using string parsing in most DBs, but some modern ones may be able to do the XML conversion themselves (SQL Server 2005 touts this for example). In other words why fetch, convert and send? Just fetch and send. Jim Davis DOH!there's a damn fine idea Jim ;-) It's Oracle 9i...any idea if it will return XML...and example would be great? Sorry - I've not actually DONE this (and I don't have any experience with Oracle)... it was just a thought. I know that I could do it SQL Server using string concatenation (just building the XML manually) - I assume the same is true for Oracle. In SQL Server you can also use COM objects or (in 2005) built SPs using JavaScript, perhaps you can do the same (or similar) in Oracle? Now that I'm thinking about it maybe I should work on a YODEL serializer for SQL Server 2005... Jim Davis ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223258 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54