Why is the file I uploaded locked by ColdFusion 10? -


i'm trying delete file if not spreadsheet, keep getting following error when uploaded testfile.text: coldfusion not delete file d:\coldfusion10\cfusion\runtime\work\catalina\localhost\tmp\testfile.text

i verified not permission issue, because if go , execute code try delete file again, work.

<cffile action="upload" destination="#dest#" filefield="xlsfile" result="upload" nameconflict="makeunique">   <cfif upload.filewassaved>     <cfset thefile = dest & upload.serverfile>      <cfif isspreadsheetfile(thefile)>         <cfspreadsheet action="read" src="#thefile#" query="data" headerrow="1">         <cfset showform = false>     <cfelse>         <cfscript>             thisfile = thefile;             fileread = createobject("java", "java.io.fileinputstream");             thisthread = createobject("java", "java.lang.thread");             loopct = 1;             while(1 eq 1) {     try     {         fileread.init(thisfile);         break;     }     catch(any ecpt)     {         thisthread.sleep(1000);     }     incrementvalue(loopct);     if(loopct gt 60)     {         fileread.close();         return;     } }  loopct = 1; while(1 eq 1) {     sizea = fileread.available();     thisthread.sleep(1000);     sizeb = fileread.available();     if(sizea eq sizeb)     {         thisthread.sleep(1000);         sizec = fileread.available();         if(sizec eq sizeb)         {             break;         }     }     incrementvalue(loopct);      if(loopct gt 60)     {         fileread.close();         return;     } } fileread.close();  <script type="text/javascript">  </script>           </cfscript>          <!--cffile action="delete" file="#thefile#"-->         <cfset errors = "the file not excel file.">         <span style="font-size:medium;font-weight:bold; color:red"><p>the file not excel file!<p></span>         <input type="button" value="try again" class="button" onclick="window.location='bulk_upload.cfm'">         <br><br><br>     </cfif>     <cfset errors = "the file not uploaded.">  </cfif>

i ran exact same issue regards cfimage locking file , preventing deletion. solution came follows. maybe can adapt situation:

<cflock name="[lockname]" timeout="5" >     <cfcache action="flush">      <!---[] replace cfimage read function (cf bug work around)  --->    <cfscript>        imageobj   = createobject( "java", "java.awt.toolkit" );       imagetools = imageobj.getdefaulttoolkit();       objimage   = imagetools.getimage( "#fullpath#" );       <!---whatever image need image, or file...--->       <!---such ---- myimagestruct["width"] = objimage.getwidth();--->        <!--- , flush object--->       objimage.flush();    </cfscript>  </cflock>

-

Comments

Post a Comment

Popular posts from this blog

php - regexp cyrillic filename not matches -

i take list of files php glob(."*.pdf") . files have cyrillic names. example: ООО «Рога и копыта» then load company names database , try find them in file names: preg_match("/$firm_name/ui", $file_name, $match); i have problem: firms if $firm_name visually similar $file_name , preg_match says there no match. mb_detect_encoding both variables return utf-8. there problem in file name, or maybe there encoding or something, can not understand, ask help. upd: $file_name='ООО «Рога и копыта»'; preg_match("/... .Рога и копыта./ui", $file_name, $match); as result, ОО «Рога и копыта» , 1 О missing
Read more

c# - OpenXML hanging while writing elements -

Image
i have program pulls data database, caches file , exports data multiple formats (excel, excel 2003, csv). i'm using openxml sdk 2.0 excel work. these export processes run in parallel (using parallel.foreach ), , amount of data can pretty large - e.g. csvs 800mb. during these larger exports, i've noticed writing of xml documents hang. instance, if have 8 exporting in parallel, @ point "pause". hang around same point: //this.writer openxmlwriter created worksheetpart. this.writer.writeelement(new cell() { cellvalue = new cellvalue(value), datatype = cellvalues.string }); when happens, pause debugger (vs2013 in case) , notice threads blocking around same portion of code - bit deeper in openxml sdk - stem call openxmlwriter.writeelement . i dug through source using justdecompile didn't find answers. appears there intermediary stream in use writing isolated storage , is, reason, blocking. underlying stream each of these filestream . here screenshot ...
Read more

sql - Select Query has unexpected multiple records (MS Access) -

i may tired, can't seem figure out happening. have 2 queries. query 1 has 10 fields. query 2 has 5 fields. fields 1 through 3 same in both queries. trying write select query , simple add field 5 query2 query1 result should query1 additional field (query2.field5). i join first 3 fields both queries , choose select records in query1 , in query2 match. don't know sql, use query designer. expect same number of records have query 1 instead have 3 times or more. can tell me doing wrong. tried reversing joins still seem same records. thanks in advance. here query: the fields in common divisionname , supplierid = vendorid , commodityname . select [part revenue exposed query p1].divisionname, [part revenue exposed query p1].commodityname, [part revenue exposed query p1].suppliername, [part revenue exposed query p1].partnumber, [part revenue exposed query p1].partdescription, [part revenue exposed query p1].bucode, ...
Read more