Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
  HXTT Cobol v2.1
  HXTT DBF v5.2
  HXTT Excel v4.2
  HXTT Paradox v5.2
  HXTT Text(CSV) v5.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT XML v1.2
Offshore Outsourcing
Oracle Data Import/Export
DB2 Data Import/Export
Sybase Data Import/Export
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
   
   
   
Hongxin Technology & Trade Ltd. of Xiangtan City (abbr, HXTT)

HXTT Text(CSV)
Evaluation HXTT text driver
Frank
2006-05-19 06:57:13.0
Hi,

I am evaluating you driver for my application but update statements always throw a n exception :java.sql.SQLException: Timeout Interrupted Exception: beyond 1000 msecs.
at com.hxtt.global.SQLState.SQLException(Unknown Source)

Is this a limitation of the demo driver or must I do something special to do updates?

Thanks and best regards,
Frank
Re:Evaluation HXTT text driver
HXTT Support
2006-05-19 07:09:00.0
>Timeout Interrupted Exception: beyond 1000 msecs.
It means that HXTT Text failed to open that table in a timeout. What's your code? We can help you to recur and fix that issue.
Re:Re:Evaluation HXTT text driver
Frank
2006-05-19 07:13:19.0
It's a very basic test. I can select the data (now in comment) but not update. I include the source code just below.

Thanks,
Frank

public void run() throws Exception {
Connection oDBCon;
PreparedStatement oStmt;
ResultSet oRS;
Properties oProperties;

// Connect.
System.out.println(new Date() + " connecting");
oProperties = new Properties();
oProperties.put("_CSV_Header", "true");
oProperties.put("_CSV_Separator", "\t");
oProperties.put("_CSV_Quoter", "");
oProperties.put("charSet", "UTF-8");
Class.forName("com.hxtt.sql.text.TextDriver");
oDBCon = DriverManager.getConnection("jdbc:csv:/C:/Temp", oProperties);
oDBCon.setAutoCommit(false);

// Query text file.
// System.out.println(new Date() + " selecting data");
// oStmt = oDBCon.prepareStatement("SELECT * FROM \"test1.txt\"");
// oStmt = oDBCon.prepareStatement("SELECT * FROM \"test1.txt\" WHERE ID IN(232503, 232788, 232679)");
// oStmt = oDBCon.prepareStatement("SELECT * FROM \"test1.txt\" WHERE ID >= '232503' AND STREET_NAME LIKE '%straat' ORDER BY ID");
// for (int nIndex = 1; nIndex <= oStmt.getMetaData().getColumnCount(); nIndex++) {
// System.out.println(oStmt.getMetaData().getColumnName(nIndex));
// }

// oRS = oStmt.executeQuery();
// while (oRS.next()) {
// System.out.println(oRS.getString(1) + " " + oRS.getString(2) + " " + oRS.getString(3) + " " + oRS.getString(4) + " " + oRS.getString(5) + " " + oRS.getString(6) + " " + oRS.getString(7) + " " + oRS.getString(8) + " " + oRS.getString(9) + " " + oRS.getString(10));
// }
// oRS.close();
// oStmt.close();

System.out.println(new Date() + " updating data");
// oStmt = oDBCon.prepareStatement("UPDATE \"test1.txt\" SET STREET_NAME = 'XXX' || STREET_NAME || 'XXX' WHERE ID IN(232503, 232788, 232679)");
oStmt = oDBCon.prepareStatement("UPDATE \"test1.txt\" SET STREET_NAME = CONCAT('XXX', STREET_NAME) WHERE ID IN(232503, 232788, 232679)");
oStmt.executeUpdate();
oStmt.close();

System.out.println(new Date() + " selecting updated data");
oStmt = oDBCon.prepareStatement("SELECT * FROM \"test1.txt\" WHERE ID IN(232503, 232788, 232679)");
oRS = oStmt.executeQuery();
while (oRS.next()) {
System.out.println(oRS.getString(1) + " " + oRS.getString(2) + " " + oRS.getString(3) + " " + oRS.getString(4) + " " + oRS.getString(5) + " " + oRS.getString(6) + " " + oRS.getString(7) + " " + oRS.getString(8) + " " + oRS.getString(9) + " " + oRS.getString(10));
}
oRS.close();
oStmt.close();

// Disconnect.
System.out.println(new Date() + " disconnecting");
oDBCon.close();
}
Re:Re:Re:Evaluation HXTT text driver
HXTT Support
2006-05-19 20:27:37.0
Failed to recur your issue, but found and fixed a bug in update transaction on csv table. Please download and try the latest package.

Test data sample in test1.txt:
ID FIRST_NAME LAST_NAME SEX COUNTRY PROVINCE CITY STREET_NAME STREET_NAME2 POSTCODE
232503 Tom Cat M US NJ NJ 9 Wall Rd 1001
232504 Tom2 Cat2 M US NJ NJ 9 Wall Rd 1001

Test code in testText17.java:
import java.sql.*;
import java.util.Properties;

public class testText17 {

public void run() throws Exception {
Connection oDBCon;
PreparedStatement oStmt;
ResultSet oRS;
Properties oProperties;

// Connect.
System.out.println(new java.util.Date() + " connecting");
oProperties = new Properties();
oProperties.put("_CSV_Header", "true");
oProperties.put("_CSV_Separator", "\t");
oProperties.put("_CSV_Quoter", "");
oProperties.put("charSet", "UTF-8");
Class.forName("com.hxtt.sql.text.TextDriver");
oDBCon = DriverManager.getConnection("jdbc:csv:/C:/Temp", oProperties);
oDBCon.setAutoCommit(false);

// Query text file.
System.out.println(new java.util.Date() + " selecting data");
//oStmt = oDBCon.prepareStatement("SELECT * FROM \"test1.txt\"");
oStmt = oDBCon.prepareStatement("SELECT * FROM \"test1.txt\" WHERE ID IN(232503, 232788, 232679)");
//oStmt = oDBCon.prepareStatement("SELECT * FROM \"test1.txt\" WHERE ID >= '232503' AND STREET_NAME LIKE '%straat' ORDER BY ID");
for (int nIndex = 1; nIndex <= oStmt.getMetaData().getColumnCount(); nIndex++) {
System.out.println(oStmt.getMetaData().getColumnName(nIndex));
}

oRS = oStmt.executeQuery();
while (oRS.next()) {
System.out.println(oRS.getString(1) + " " + oRS.getString(2) + " " + oRS.getString(3) + " " + oRS.getString(4) + " " + oRS.getString(5) + " " + oRS.getString(6) + " " + oRS.getString(7) + " " + oRS.getString(8) + " " + oRS.getString(9) + " " + oRS.getString(10));
}
oRS.close();
oStmt.close();

System.out.println(new java.util.Date() + " updating data");
// oStmt = oDBCon.prepareStatement("UPDATE \"test1.txt\" SET STREET_NAME = 'XXX' || STREET_NAME || 'XXX' WHERE ID IN(232503, 232788, 232679)");
oStmt = oDBCon.prepareStatement("UPDATE \"test1.txt\" SET STREET_NAME = CONCAT('XXX', STREET_NAME) WHERE ID IN(232503, 232788, 232679)");
oStmt.executeUpdate();
oStmt.close();

System.out.println(new java.util.Date() + " selecting updated data");
oStmt = oDBCon.prepareStatement(
"SELECT * FROM \"test1.txt\" WHERE ID IN(232503, 232788, 232679)");
oRS = oStmt.executeQuery();
while (oRS.next()) {
System.out.println(oRS.getString(1) + " " + oRS.getString(2) + " " +
oRS.getString(3) + " " + oRS.getString(4) + " " +
oRS.getString(5) + " " + oRS.getString(6) + " " +
oRS.getString(7) + " " + oRS.getString(8) + " " +
oRS.getString(9) + " " + oRS.getString(10));
}
oRS.close();
oStmt.close();

//oDBCon.commit();

// Disconnect.
System.out.println(new java.util.Date() + " disconnecting");
oDBCon.close();
}

public static void main(String argv[]) {
try {
new testText17().run();

}
catch (SQLException sqle) {
do {
System.out.println(sqle.getMessage());
System.out.println("Error Code:" + sqle.getErrorCode());
System.out.println("SQL State:" + sqle.getSQLState());
sqle.printStackTrace();
}
while ( (sqle = sqle.getNextException()) != null);
}
catch (Exception e) {
System.out.println(e.getMessage());
e.printStackTrace();
}
}
}
Re:Re:Re:Re:Evaluation HXTT text driver
frank
2006-05-23 03:17:11.0
Hi,

I downloaded the latest version of Text_JDBC30.jar. The file I'm working on has about 150.000 rows. Just below is a small snippet of the data. I can not send the whole file since the data is confidential.

>>>
ID NAME BUILDING_NAME SUB_BUILDING_NAME STREET_NAME HOUSE_NUM HOUSE_NUM_ALPHA STD_HOUSE_NUM POBOX SUB_STREET_NAME SUB_CITY TOWN_CITY COUNTY_PROVINCE_STATE POSTCODE_ZIPCODE MAIN SUB PRINCIPALITY COUNTRY TEL_NBR INTDIAL_NBR TPREFIX_NBR ACODE_NBR SUB_NBR SOURCE_FLAG LANGUAGE_ID CODE01 CODE02 CODE03 CODE04 CODE05 CODE06
293436 Pieren/R. della Faillelaan 14 14 Schoten Antwerpen 2900 2900 Belgium 036584897 32 0 3 6584897 NL 021310
293542 Pierre/D. R. Borremansstraat 17 17 Huldenberg Vlaams Brabant 3040 3040 Belgium 026881715 32 0 2 6881715 NL 021310
409765 Zwart/D. Koedaalstraat 15 15 Hoeilaart Vlaams Brabant 1560 1560 Belgium 026573249 32 0 2 6573249 NL 021310
407562 Xpragma Mechelsesteenweg 254 254 Bonheiden Antwerpen 2820 2820 Belgium 015340845 32 0 15 340845 NL 021310
409023 Zenith International Lindendreef 10 10 Sint-Martens-Bodegem Vlaams Brabant 1700 1700 Belgium 024634545 32 0 2 4634545 NL 021310
409273 Zigavest sprl Pont al Plantche(AYE) 4 4 Ayeneux Li��ge 4630 4630 Belgium 043772529 32 0 4 3772529 FR 021310
407444 Xedum bvba Voortstraat 84 84 Beringen Limburg 3580 3580 Belgium 011429525 32 0 11 429525 NL 021310
407447 Xeleos Consulting Rue Emile Wittmann 33 33 Schaerbeek Bruxelles 1030 1030 Belgium 027338768 32 0 2 7338768 FR 021310
407999 Ypfac Holding Promenade Dewalque 16 16 Spa Li��ge 4900 4900 Belgium 087776471 32 0 87 776471 FR 021310
408028 Ysebaert/Berdhy Rooigemstraat 44 nullA 44 Balegem Oost Vlaanderen 9860 9860 Belgium 93622375 32 0 9 3622375 NL 021310
406795 Wuestenberg Johann Wauwerdries(LUB) 2 2 Lubbeek Vlaams Brabant 3210 3210 Belgium 016633787 32 0 16 633787 NL 021310
405638 Withof I. Rode-Rokstraat 4 4 3 Kuringen Limburg 3511 3511 Belgium 011254365 32 0 11 254365 NL 021310
404995 WIL NV Winterslagstraat 195 A 195 Genk Limburg 3600 3600 Belgium 89243373 32 0 89 243373 NL 021310
403859 Wilfried D'Haese bvba Nederkouter 31 31 Gent Oost Vlaanderen 9000 9000 Belgium 092231150 32 0 9 2231150 NL 021310
402562 Wergifosse/P. Rue de H��vremont 195 a 195 Stembert Li��ge 4801 4801 Belgium 087681200 32 0 87 681200 FR 021310
165820 Goffinet/H. Reux 4 4 Conneux Namur 5590 5590 Belgium 083220244 32 0 83 220244 FR 021345
70954 Claeys/V. Rue Grimb��rieux 86 86 Saint-Nicolas Li��ge 4420 4420 Belgium 042392866 32 0 4 2392866 FR 021345
76195 Columat sprl Rue Gilles Magn��e 92 92 3 Ans Li��ge 4430 4430 Belgium 042222474 32 0 4 2222474 FR 021345
9543 Ad Lumino Dendermondestraat 29 29 Schelle Antwerpen 2627 2627 Belgium 038870303 32 0 3 8870303 NL 021345 021324
21589 Artemide Benelux Beemdstraat 25 25 Ruisbroek Vlaams Brabant 1601 1601 Belgium 023348474 32 0 2 3348474 NL 021345 023110
378219 Van Meerhaeghe-Goffin/A. Avenue A.J. Slegers 156 156 Woluwe-Saint-Lambert Bruxelles 1200 1200 Belgium 027727200 32 0 2 7727200 FR 111237
362552 Van Den Bossche/Geert Strijp 23 23 Wichelen Oost Vlaanderen 9260 9260 Belgium 52424292 32 0 52 424292 NL 111237
367528 Van Der Stichel-De Clercq/R. Collegebaan 97 97 Melle Oost Vlaanderen 9090 9090 Belgium 092524842 32 0 9 2524842 NL 111237
356651 Van Acker/E. Pastoor Annaertstraat 3 3 Stekene Oost Vlaanderen 9190 9190 Belgium 037797372 32 0 3 7797372 NL 111237
304661 Ramast Atelier nv Perksesteenweg 33 33 Kampenhout Vlaams Brabant 1910 1910 Belgium 016659090 32 0 16 659090 NL 111237
307558 Renotec nv Acaciastraat 14 C 14 Geel Antwerpen 2440 2440 Belgium 014866021 32 0 14 866021 NL 111237 111238 212329 212330
239115 Mawet-Gigounon/B. Rue du Château de Tongrenelle 2 2 Tongrinne Namur 5140 5140 Belgium 071886066 32 0 71 886066 FR 111237 111246
210798 Lallemand/Philippe Avenue des Tilleuls 7 7 Rochefort Namur 5580 5580 Belgium 084213428 32 0 84 213428 FR 111237 110315 110354 111227 212305
178972 Het Zonnebloemhof/Nathalie Gistelsteenweg 402 402 Jabbeke West Vlaanderen 8490 8490 Belgium 50816320 32 0 50 816320 NL 111237 111238 112128 212330
293564 Pierre/R. Rue du Roussart 124 124 Waterloo Brabant Wallon 1410 1410 Belgium 023542676 32 0 2 3542676 FR 110133
406827 Wuillem/J. Rue des Sarts 18 18 Loverval Hainaut 6280 6280 Belgium 071432388 32 0 71 432388 FR 110133
404949 Wilmotte/J. Rue Crebeyck 33 33 Perwez Brabant Wallon 1360 1360 Belgium 081655106 32 0 81 655106 FR 110133
405516 Wirtz Champellaan 2 2 Sint-Genesius-Rode Vlaams Brabant 1640 1640 Belgium 023581882 32 0 2 3581882 NL 110133
403052 Weyens-Lambregts/E. Ubbelstraat 157 157 Zolder Limburg 3550 3550 Belgium 011538442 32 0 11 538442 NL 110133
403315 Wiame/S. Rue du Pont au Lin 45 45 Grez-Doiceau Brabant Wallon 1390 1390 Belgium 010866138 32 0 10 866138 FR 110133
400696 Wargnies & De Keghel Avenue Brugmann 328 328 1 Uccle Bruxelles 1180 1180 Belgium 023811424 32 0 2 3811424 FR 110133
402662 Werner Jose sprl Route de l'Ambl��ve 71 71 Stoumont Li��ge 4987 4987 Belgium 080785980 32 0 80 785980 FR 110133
400464 Walth��ry & Mar��chal Rue de Vis�� 43 43 Dalhem Li��ge 4607 4607 Belgium 043794555 32 0 4 3794555 FR 110133
401079 Watelet/A. Rue Grand'Rue 32 32 C��roux-Mousty Brabant Wallon 1341 1341 Belgium 010613049 32 0 10 613049 FR 110133
399859 Waegheman-Van Houte/Theo Vuurkruisenlaan 14 14 Hamme Oost Vlaanderen 9220 9220 Belgium 52470441 32 0 52 470441 NL 110133
396727 Vlassak/R. O.L.Vrouwestraat 33 33 Leuven Vlaams Brabant 3000 3000 Belgium 016231045 32 0 16 231045 NL 110133
397874 Voos/P. Rue de la Chapelle 88 88 Verviers Li��ge 4800 4800 Belgium 087330435 32 0 87 330435 FR 110133
393699 Verwimp/J. Anemoonstraat 12 12 Geel Antwerpen 2440 2440 Belgium 014588838 32 0 14 588838 NL 110133
393610 Verwacht/P. Metsijsdreef 8 8 Overijse Vlaams Brabant 3090 3090 Belgium 026872450 32 0 2 6872450 NL 110133
293569 Pierre Aim�� Chemin des Voiturons 100 100 Braine-l'Alleud Brabant Wallon 1420 1420 Belgium 023845710 32 0 2 3845710 FR 110133
293651 Pierret/M. Rue des Petits-Enclos 13 13 Bastogne Luxembourg 6600 6600 Belgium 061216787 32 0 61 216787 FR 110133
406553 Wouters/Patrick Lindeveld 22 22 Peer Limburg 3990 3990 Belgium 11791533 32 0 11 791533 NL 110133
405406 Winssinger & Associates Avenue Louise 380 380 Bruxelles Bruxelles 1050 1050 Belgium 026290290 32 0 2 6290290 FR 110133 014404 014412
400563 Wanlin/J.-L. Rue de Saupont 26 26 Bertrix Luxembourg 6880 6880 Belgium 061413752 32 0 61 413752 FR 110133
400784 Warnez/K. Statiestraat 29 29 Dentergem West Vlaanderen 8720 8720 Belgium 051634883 32 0 51 634883 NL 110133
400340 Walraet/D. Haagstraat 9 9 Spiere West Vlaanderen 8587 8587 Belgium 056455681 32 0 56 455681 NL 110133
398554 Vreys/J. Bruggeske 50 50 Mol Antwerpen 2400 2400 Belgium 014315027 32 0 14 315027 NL 110133
396728 Vlassak/Werner Dorpsstraat 20 20 Bierbeek Vlaams Brabant 3360 3360 Belgium 016461476 32 0 16 461476 NL 110133
395433 Vinck/H. Kapelleommegang 33 33 Herdersem Oost Vlaanderen 9310 9310 Belgium 053784934 32 0 53 784934 NL 110133
394256 Viale/J. Route de l'Etat 170 170 Lasne Brabant Wallon 1380 1380 Belgium 026333450 32 0 2 6333450 FR 110133
393976 Vetsuypens/A.-M. Karel Keymolenstraat 65 65 Sint-Kwintens-Lennik Vlaams Brabant 1750 1750 Belgium 025320287 32 0 2 5320287 NL 110133
394862 Vieusart/A.-D. Avenue Emile Van Becelaere 150 150 Watermael-Boitsfort Bruxelles 1170 1170 Belgium 026731914 32 0 2 6731914 FR 110133
395107 Villa Des Fagnes Chemin Henrotte 94 94 Spa Li��ge 4900 4900 Belgium 087775474 32 0 87 775474 FR 110133
407320 Wyseur/I. Zeger van Heulestraat(Heu) 14 14 Heule West Vlaanderen 8501 8501 Belgium 056374060 32 0 56 374060 NL 110133
408390 Zakenkantoor Deschepper bvba Kiekenstraat 16 16 Diksmuide West Vlaanderen 8600 8600 Belgium 051501615 32 0 51 501615 NL 110133 014203
409462 Zone/J. Chauss��e de Charleroi 75 75 Gembloux Namur 5030 5030 Belgium 081611707 32 0 81 611707 FR 110133
406981 Wuyts Hof Savelkoul 41 41 Mortsel Antwerpen 2640 2640 Belgium 034552539 32 0 3 4552539 NL 110133
407009 Wuyts/Veerle Brugstraat 26 26 Rijmenam Antwerpen 2820 2820 Belgium 15518506 32 0 15 518506 NL 110133
407314 Wypychowska/M. Avenue Andr�� Drouart 8 8 Auderghem Bruxelles 1160 1160 Belgium 026606025 32 0 2 6606025 FR 110133
406978 Wuyts/J. Sint-Bavoplein 12 12 Boechout Antwerpen 2530 2530 Belgium 034540023 32 0 3 4540023 NL 110133
406520 Wouters/K. Poederleese weg 80 80 Lille Antwerpen 2275 2275 Belgium 014882845 32 0 14 882845 NL 110133
404892 Wilmart-Cuvelier/A. Rue Bout-d'en-Haut 9 9 Aublain Namur 5660 5660 Belgium 060345708 32 0 60 345708 FR 110133
405336 Winkeler/J. Achterbroeksteenweg 60 60 Kalmthout Antwerpen 2920 2920 Belgium 036665762 32 0 3 6665762 NL 110133
400365 Walrave/E. Waverstraat 55 55 Moorsel Oost Vlaanderen 9310 9310 Belgium 053773151 32 0 53 773151 NL 110133
401492 Wauters/Christiaan Kapellenkouter 52 52 Zwijndrecht Antwerpen 2070 2070 Belgium 032527074 32 0 3 2527074 NL 110133
395443 Vinck/M. De Naeyerstraat(LEB) 57 57 Lebbeke Oost Vlaanderen 9280 9280 Belgium 052214891 32 0 52 214891 NL 110133
395242 Vilret/R. Rue de Saint-Denis 33 33 Rhisnes Namur 5080 5080 Belgium 081566407 32 0 81 566407 FR 110133 014412
393177 Vert��/Guy Akkerstraat 17 17 Sint-Kruis (Brugge) West Vlaanderen 8310 8310 Belgium 50362812 32 0 50 362812 NL 110133
387373 Verdiluce bvba Nijverheidslaan 1 A 1 Geluwe West Vlaanderen 8940 8940 Belgium 056531285 32 0 56 531285 NL 021345
408335 Zajfman/J. Avenue Hamoir 37 C 37 Uccle Bruxelles 1180 1180 Belgium 023754234 32 0 2 3754234 FR 021345
283180 Ottevaere bvba Kleine Waregemsestraat(Har) 33 33 Harelbeke West Vlaanderen 8530 8530 Belgium 056719992 32 0 56 719992 NL 021345
306541 Rel-Scan bvba Mgr. Van Waeyenberghlaan 34 34 2 Leuven Vlaams Brabant 3000 3000 Belgium 016233041 32 0 16 233041 NL 021345
314467 R-Tech sa Rue de Mons 3 3 Li��ge Li��ge 4000 4000 Belgium 042247140 32 0 4 2247140 FR 021345
175145 Hediger-Koob/B. Rue de Velaine 86 86 Tamines Namur 5060 5060 Belgium 071742082 32 0 71 742082 FR 021345 023119 112101
223894 Lichtateljee Torhoutse Steenweg 45 45 Sint-Andries West Vlaanderen 8200 8200 Belgium 050388847 32 0 50 388847 NL 021345
393741 Very Dynamic Services bvba Waterstraat 121 121 Stabroek Antwerpen 2940 2940 Belgium 036601760 32 0 3 6601760 NL 111237 111238
351641 Translab nv, Asbestinventarisatie Meersstraat 8 8 Laarne Oost Vlaanderen 9270 9270 Belgium 093693837 32 0 9 3693837 NL 111237
340022 Svaldi/J. Ham 83 83 Gent Oost Vlaanderen 9000 9000 Belgium 092333872 32 0 9 2333872 NL 111237
253791 Naert/Cedric Kortrijkstraat 361 361 Oudenaarde Oost Vlaanderen 9700 9700 Belgium 55610043 32 0 55 610043 NL 111237 111238
234438 MARCHAND Torenvenstraat(Kessel) 61 61 Nijlen Antwerpen 2560 2560 Belgium 495354892 32 0 495 354892 NL 111237 110319
239743 M.D.P. Rue Hennet 6 B 6 Li��ge Li��ge 4000 4000 Belgium 042786868 32 0 4 2786868 FR 111237
194922 Janssens/R. Klein Heiken 16 16 Kapellen Antwerpen 2950 2950 Belgium 036641656 32 0 3 6641656 NL 111237
16491 ANCY Turkeyenlaan 19 19 Bredene West Vlaanderen 8450 8450 Belgium 059269197 32 0 59 269197 NL 111237
403017 Wevers/R. Neeroeterenstraat 57 57 Opoeteren Limburg 3680 3680 Belgium 089865289 32 0 89 865289 NL 021229 021317
335692 Steegmans Sint-Jozefsstraat 13 13 1 Hasselt Limburg 3500 3500 Belgium 011261280 32 0 11 261280 NL 021229 027210
338810 Studio Deco & Event Rue du Grand P��ril 108 108 Hennuy��res Hainaut 7090 7090 Belgium 067895899 32 0 67 895899 FR 021229 021240
317999 Sannen-Jonas/R. Postbaan 241 241 Schaffen Vlaams Brabant 3290 3290 Belgium 013334849 32 0 13 334849 NL 021229
321746 Schorkops/R. Rue de la Dr��ve 3 3 Bossi��re Namur 5032 5032 Belgium 081200916 32 0 81 200916 FR 021229
334621 Stageco nv Kapelleweg(TIL) 6 6 Tildonk Vlaams Brabant 3150 3150 Belgium 016608471 32 0 16 608471 NL 021229
303854 Racor nv Lil 53 53 Meerhout Antwerpen 2450 2450 Belgium 014303997 32 0 14 303997 NL 021229 110303 110348 015229
313743 Roudelet Equipements Sport sa Rue de l'Avenir 8 8 Thimister-Clermont Li��ge 4890 4890 Belgium 087321717 32 0 87 321717 FR 021229 212101 024109 015143 015144
242618 Mertens-De Ceuster/J. Ericastraat 19 A 19 Geel Antwerpen 2440 2440 Belgium 014586944 32 0 14 586944 NL 021229
164667 Gobo bvba Koning Albertstraat 102 102 Walem Antwerpen 2800 2800 Belgium 015286969 32 0 15 286969 NL 021229
117337 Devaux/F. Rue du Pont Couwez 3 3 Bassilly Hainaut 7830 7830 Belgium 068456802 32 0 68 456802 FR 021229

>>>

I reduced the program to it's bare essentials for doing the update and still get the exception in the output:

Tue May 23 12:01:29 CEST 2006 connecting
Tue May 23 12:01:30 CEST 2006 updating data
Timeout Interrupted Exception: beyond 1000 msecs.
Error Code:721152
SQL State:S1T00
java.sql.SQLException: Timeout Interrupted Exception: beyond 1000 msecs.
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.concurrent.y.cN(Unknown Source)
at com.hxtt.concurrent.an.cN(Unknown Source)
at com.hxtt.concurrent.n.a(Unknown Source)
at com.hxtt.concurrent.n.if(Unknown Source)
at com.hxtt.sql.text.a.do(Unknown Source)
at com.hxtt.sql.text.a.do(Unknown Source)
at com.hxtt.sql.text.a.int(Unknown Source)
at com.hxtt.sql.text.a.do(Unknown Source)
at com.hxtt.concurrent.n.if(Unknown Source)
at com.hxtt.concurrent.n.a(Unknown Source)
at com.hxtt.sql.text.l.a(Unknown Source)
at com.hxtt.sql.cb.a(Unknown Source)
at com.hxtt.sql.dx.a(Unknown Source)
at com.hxtt.sql.dx.a(Unknown Source)
at com.hxtt.sql.cx.a(Unknown Source)
at com.hxtt.sql.be.a(Unknown Source)
at com.hxtt.sql.ab.a(Unknown Source)
at com.hxtt.sql.cy.char(Unknown Source)
at com.hxtt.sql.cy.executeUpdate(Unknown Source)
at be.landc.tests.frank.TestHXTT.run(TestHXTT.java:52)
at be.landc.tests.frank.TestHXTT.main(TestHXTT.java:72)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.intellij.rt.execution.application.AppMain.main(AppMain.java:90)


Below is the program that produces the error:

import java.sql.*;
import java.util.Date;
import java.util.Properties;

public class TestHXTT {
public void run() throws Exception {
Connection oDBCon;
PreparedStatement oStmt;
Properties oProperties;

// Connect.
System.out.println(new Date() + " connecting");
oProperties = new Properties();
oProperties.put("_CSV_Header", "true");
oProperties.put("_CSV_Separator", "\t");
oProperties.put("_CSV_Quoter", "");
oProperties.put("charSet", "UTF-8");
Class.forName("com.hxtt.sql.text.TextDriver");
oDBCon = DriverManager.getConnection("jdbc:csv:/C:/Temp", oProperties);

System.out.println(new Date() + " updating data");
oStmt = oDBCon.prepareStatement("UPDATE \"test1.txt\" SET STREET_NAME = 'XXX' WHERE ID IN(232503, 232788, 232679)");
oStmt.executeUpdate();
oStmt.close();

// Disconnect.
System.out.println(new Date() + " disconnecting");
oDBCon.close();
}

public static void main(String[] args) throws Exception {
try {
new TestHXTT().run();
}
catch (SQLException sqle) {
do {
System.out.println(sqle.getMessage());
System.out.println("Error Code:" + sqle.getErrorCode());
System.out.println("SQL State:" + sqle.getSQLState());
sqle.printStackTrace();
}
while ((sqle = sqle.getNextException()) != null);
}
catch (Exception e) {
System.out.println(e.getMessage());
e.printStackTrace();
}
}
}

I also noted something else: in one of my tries I used the following update statement:

oStmt = oDBCon.prepareStatement("UPDATE \"test1.txt\" SET STREET_NAME = CONCAT('XXX', STREET_NAME) WHERE ID IN(232503, 232788, 232679)");

I also got an error but when I opended the file again I saw an endless amount of XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX's on the lines that needed to be updated as if the update was confused by the fact that the update statement used the same column to update in the CONCAT function.

Any help is really appreciated, I would really like to buy the library but of course these issues need to be resolved first.

Best regards,
Frank
Re:Re:Re:Re:Re:Evaluation HXTT text driver
Hxtt Support
2006-05-23 03:27:15.0
>I also got an error but when I opended the file again I saw an endless amount of XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX's
Yeah. That issue has been fixed in my previous post. Maybe you'r using an old package still.
Re:Re:Re:Re:Re:Re:Evaluation HXTT text driver
frank
2006-05-23 03:38:40.0
Could indeed be that this XXXXXXX issue was produced with the old library but the latest SQLException was definitely produced using the last version (848K in size dated 5/20/2006).

Any ideas on that issue?

Best regards,
Frank
Re:Re:Re:Re:Re:Re:Re:Evaluation HXTT text driver
HXTT Supports
2006-05-23 03:46:58.0
>I reduced the program to it's bare essentials for doing the update and
> still get the exception in the output:
>Timeout Interrupted Exception: beyond 1000 msecs.
>I downloaded the latest version of Text_JDBC30.jar. The file I'm working on has about 150.000 rows. Just below is a small snippet of the data.
Passed test with your sample. I'm using insert into test select * from test to get a simulative 150,000 rows and recur your issue. Please wait.
Re:Re:Re:Re:Re:Re:Re:Re:Evaluation HXTT text driver
frank
2006-05-23 04:36:03.0
I meanwhile did a test with the small file sample that I sent you and got the same exception. Meaning it's not size related at all.

update statement:
oStmt = oDBCon.prepareStatement("UPDATE \"test1.txt\" SET STREET_NAME = 'XXX' WHERE ID IN(293542, 407314, 242618)");

Frank
Re:Re:Re:Re:Re:Re:Re:Re:Evaluation HXTT text driver
frank
2006-05-23 04:38:41.0
Could you please try it with this update statement because these id's are present in the sample file while the others are probably not.

Frank
Re:Re:Re:Re:Re:Re:Re:Re:Evaluation HXTT text driver
HXTT Support
2006-05-23 05:17:57.0
Recurred that issue with 208,744 rows.
Re:Re:Re:Re:Re:Re:Re:Re:Evaluation HXTT text driver
frank
2006-05-23 05:29:19.0
Like I said I can reproduce the error on the small sample set for 100 rows I sent you earlier using the update statement just above. This suggests it's not size related at all.

Frank
Re:Re:Re:Re:Re:Re:Re:Re:Evaluation HXTT text driver
frank
2006-05-23 05:36:49.0
Like I said I can reproduce the error on the small sample set for 100 rows I sent you earlier using the update statement just above. This suggests it's not size related at all.

Frank
Re:Re:Re:Re:Re:Re:Re:Re:Evaluation HXTT text driver
frank
2006-05-23 06:25:43.0
Thanks Daiwei for the latest release. It solves all problems.

I guess I will have to buy the library now:), I'll do so this evening.

Thanks for all the support, you guys are really impressive.

Best regards,
Frank

Search Key   Search by Last 50 Questions




Google
 

Address: 9 Station Rd., Xiangtan City, Hunan Province, P.R. China
Postcode: 411100
Phone: (86)731-58225727
Fax: (86)731-58225727
Email: webmaster@hxtt.com
Copyright © 1999-2011 Hongxin Technology & Trade Ltd. | All Rights Reserved. | Privacy | Legal | Sitemap