Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v7.1
  HXTT Cobol v5.0
  HXTT DBF v7.1
  HXTT Excel v6.1
  HXTT Json v1.0
  HXTT Paradox v7.1
  HXTT PDF v2.0
  HXTT Text(CSV) v7.1
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Word v1.1
  HXTT XML v4.0
Offshore Outsourcing
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
   
   
   
Heng Xing Tian Tai Lab of Xi'an City (abbr, HXTT)

HXTT Text(CSV)
Temp files are not get deleted
Shant Jain
2017-11-09 03:16:14
Hi,

We are Using "com.hxtt.sql.text.TextDriver". When we create connection it create TEMP file. Do we have any configuration that will delete all TEMP files
Re:Temp files are not get deleted
HXTT Support
2017-11-09 03:34:39
What's the file name format of temporary files? Usually unused temporary files will be deleted when there's many temp files or Java VM exits.
Re:Re:Temp files are not get deleted
Shant Jain
2017-11-09 04:02:19
TEMP6943242452255324555.bin
TEMP6943242452253535355.bin
file. It have created hundreds of this file with different names. it is running on web server so there is no possibility for Java VM exits. What do you mean by "iles will be deleted when there's many temp files" Is there any particular value or it is configurable?
Re:Re:Re:Temp files are not get deleted
Shant Jain
2017-11-09 04:25:01
it is...

TMPP6943242452255324555.bin
Re:Re:Re:Re:Temp files are not get deleted
HXTT Support
2017-11-09 05:46:19
TMPP???.bin file should be produced by PACK TABLE sql. Have you gotten "Failed to pack table ..." error message?
Re:Re:Re:Re:Re:Temp files are not get deleted
Shant Jain
2017-11-09 06:00:19
Hi,

I am not sure we are getting error message but content of these files are same as the csv files.
Re:Re:Re:Re:Re:Re:Temp files are not get deleted
HXTT Support
2017-11-10 22:49:06
Then those files should be produced by PACK TABLE operation. But in my test, those file should be deleted automatically. What's the released time of your driver package?
Re:Re:Re:Re:Re:Re:Re:Temp files are not get deleted
Shant Jain
2017-11-11 19:27:02
Hi,

We have a multi thread and multi server system that are trying to update same file and it get into race condition and due that file get corrupt. Do we have any option so that file get locked till one thread perform operation and other should not able to get access. We have tried Synchronize block then it works with one server (JVM) but with multi server (multi JVM) it still fails. we are getting java.sql.SQLException: java.lang.NegativeArraySizeException
at com.hxtt.global.az.if(Unknown Source)
at com.hxtt.concurrent.n.do(Unknown Source)
at com.hxtt.sql.text.l.try(Unknown Source)
at com.hxtt.sql.text.l.a(Unknown Source)
at com.hxtt.sql.text.a.a(Unknown Source)
at com.hxtt.sql.text.f.do(Unknown Source)
at com.hxtt.sql.bz.a(Unknown Source)
at com.hxtt.sql.bz.a(Unknown Source)
at com.hxtt.sql.bz.a(Unknown Source)
at com.hxtt.sql.am.a(Unknown Source)
at com.hxtt.sql.am.a(Unknown Source)
at com.hxtt.sql.am.execute(Unknown Source)
at


Can you please help for this error.
Re:Re:Re:Re:Re:Re:Re:Re:Temp files are not get deleted
HXTT Support
2017-11-12 20:50:48
HXTT Text (CSV) supports only multi thread in on JVM. Since you need to supports multi JVM, we will provides such a feather in the latest package soon.
Re:Re:Re:Re:Re:Re:Re:Re:Temp files are not get deleted
HXTT Support
2017-11-12 21:48:55
Now you can use lockType=MultiJVM connection property.
Re:Re:Re:Re:Re:Re:Re:Re:Temp files are not get deleted
Shant Jain
2017-11-12 22:47:50
HI,

Can lockType=MultiJVM work with Text_JDBC40.jar and 1.6 JVM?
Re:Re:Re:Re:Re:Re:Re:Re:Temp files are not get deleted
HXTT Support
2017-11-12 22:51:41
Yeah. The package will be released in 24 hours.
Re:Re:Re:Re:Re:Re:Re:Re:Temp files are not get deleted
Shant Jain
2017-11-12 23:00:13
So we need to download it after 24 hours?
Re:Re:Re:Re:Re:Re:Re:Re:Temp files are not get deleted
HXTT Support
2017-11-12 23:17:29
Yeah. It should be useful for your multi servers.
Re:Re:Re:Re:Re:Re:Re:Re:Temp files are not get deleted
Shant Jain
2017-11-13 00:55:32
Ok.. Thanks.. Can you please update this question thread once package available for download.
Re:Re:Re:Re:Re:Re:Re:Re:Temp files are not get deleted
HXTT Support
2017-11-13 00:56:52
Now it's available.
Re:Re:Re:Re:Re:Re:Re:Re:Temp files are not get deleted
Shant Jain
2017-11-13 05:05:28
HI,

Can you send me the download link. Do we need additional licence for the same. What is the version that support supports multi JVM?
Re:Re:Re:Re:Re:Re:Re:Re:Temp files are not get deleted
HXTT Support
2017-11-14 03:01:56
It's at http://www.hxtt.com/download.jsp?product=Text , and you should use the order email to download it.

Search Key   Search by Last 50 Questions




Google
 

Email: webmaster@hxtt.com
Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Sitemap