Brian--
These links look great! The ExportDbToXml.cfc is actually just what I needed.
Unfortunately, I am still receiving an error when performing this function:
Stream closed:
The error occurred in \com\FileWriter.cfc: line 118
Called from \com\ExportDbToXml.cfc: line 272
Called from \com\ExportDbToXml.cfc: line 55
Called from \reports\alldata.cfm: line 5
Called from \reports.cfm: line 173
Called from \reports.cfm: line 1
116 : <cfargument name="strIn" type="string" required="No" default="" hint="a
string to write to the file" />
117 :
118 : <cfset variables.joBufferedWriter.write(javaCast("string",
arguments.strIn)) />
119 : <cfset variables.joBufferedWriter.newLine() />
120 : </cffunction>
Now into Java, I am completely out of my knowledge set, so your continuing help
would be greatly appreciated!
Thanks!
Joel Watson
>How are you creating the XML variable? Becuase if you are building it up
>manually by concatenating strings together this is common. This is because
>every time you concatenate a string it creates a new Java String instance,
>which means you have (depending on how many columns you have) hundreds of
>thousands or even millions of String instances that won't be garbage
>collected until after the request is over and all references to them are
>gone.
>
>Use a Java StringBuffer (or if you're on Java 5 or 6, a StringBuilder) to
>build up the XML string, as these are specifically for building up large
>strings without constantly creating new instances. You can find easy CFC
>wrappers for these and other Java classes at
>http://www.informationsavvy.com/coldfusion/.
>
>On Tue, Apr 15, 2008 at 10:51 AM, Joel Watson <[EMAIL PROTECTED]>
>wrote:
>
>>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303429
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
