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.
|