Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v7.1
  HXTT Cobol v5.0
  HXTT DBF v7.1
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Excel v6.1
  HXTT Paradox v7.1
  HXTT PDF v2.0
  HXTT Text(CSV) v7.1
  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 DBF
HXTT Service crash
Oscar San Martin
2011-10-06 12:19:08.0
Sometimes ( 3 or 4 ) in one day, service crash with message :

java.lang.NullPointerException
at com.hxtt.sql.common.c.writeObject(Unknown Source)
at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect-Method.onvoke(Method.java:324)
at java.io.ObjectStreamClass.invokeWriteObject(ObjectStreamClass.java:809)
at java.io.ObjectOutputStream.writeSerialData(ObjectOutputStream.java:1296)
at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1247)
at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1052)
at java.io.OutputObjectStream.writeObject(ObjectOutputStream.java:278)
at com.hxtt.sql.common.k.a(Unknown Source)
at com.hxtt.sql.common.k.a(Unknown Source)
at com.hxtt.sql.server.c.a(Unknown Source)
at com.hxtt.sql.server.c.for(Unknown Source)
at com.hxtt.sql.server.c.run(Unknown Source)
at com.hxtt.global.b.run(Unknown Source)

HXTT service run on SCO UNIX 5.4


Thanks in advance,
Re:HXTT Service crash
HXTT Support
2011-10-06 23:40:44.0
Checked. Please download the latest package.
Re:Re:HXTT Service crash
Oscar San Martin
2011-10-11 18:34:27.0
Well, the last package downloaded was more unstable than the previous version....so we back to previous package....

Basically there was a lot slower to find key records...and many records were not updated...

Any ideas?...

Thanks in advance....
Re:Re:Re:HXTT Service crash
HXTT Support
2011-10-11 18:50:55.0
>Basically there was a lot slower to find key records...and many records
>were not updated...
Please descript your issue so that we can recur your issue.
Re:Re:Re:Re:HXTT Service crash
Oscar San Martin
2011-10-11 18:57:36.0
When java app try to find a record with primary key, it is very slow.....and some records are definitely not found....this not occurs with previous version....
Re:Re:Re:Re:Re:HXTT Service crash
HXTT Support
2011-10-11 19:00:13.0
>When java app try to find a record with primary key, it is very slow.
>and some records are definitely not found.
Please email us your db and sql sample.
Re:Re:Re:Re:Re:Re:HXTT Service crash
Oscar San Martin
2011-10-28 08:27:55.0
Ok, I just receive DBF + IDX from customer, I'll send you rar + sql sample.


Thanks in advance....
Re:Re:Re:Re:Re:Re:Re:HXTT Service crash
HXTT Support
2011-10-29 06:29:57.0
>When java app try to find a record with primary key, it is very slow..
Thanks. After create a movimien.cgp which contains the following lines:
movfec.idx
movlla.idx
mov.idx
movfac.idx
movitem.idx
movcl.idx
movlibr.idx

Tested your sample. It fetched matched rows in few seconds.

>..and some records are definitely not found.
Please let us know the wrong test value.

String numPresupuesto="4790972";
String fact="2011-06-06";

ResultSet rs= astat.executeQuery("SELECT * FROM movimien " +
"WHERE ndoc = '" + numPresupuesto + "' AND " +
"valepreven = '' AND " +
"(preventa = 'S' OR trasladosn = 'T' ) AND " +
"item <> '999999999' AND " +
"fmov = '" + fact + "' AND " +
"(tpref = '7' OR tpref = '8' OR tpref = '9')" );

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