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
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Json v1.0
  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 Excel
Trial version for HXTT Excel and HXTT Access
Chi Thien Phan
2014-10-09 01:22:23
Hi,

we are interested in your products HXTT Excel and HXTT Access. At the moment we have just trial versions of them. With following limitations the trial versions we can not test how performance your products are. We would like another trial versions without these limitations, if it's possible.

- The trial version of the driver allows executing not more than 50 queries once.
- SELECT queries return the first 100 rows in the result set.

Thank you very much!
Best regards,
Chi Thien Phan
Software Developer by Gtt from Germany www.gtt-online.de
Re:Trial version for HXTT Excel and HXTT Access
HXTT Support
2014-10-09 02:02:59
Please check your mailbox.
Re:Re:Trial version for HXTT Excel and HXTT Access
Chi Thien Phan
2014-10-09 05:10:57
Hi,

thanks for new driver. We got it now for testing. After testing phase we will contact you as soon as posible.

Best regards,
Chi Thien Phan
Software Developer by Gtt from Germany www.gtt-online.de
Re:Re:Re:Trial version for HXTT Excel and HXTT Access
Chi Thien Phan
2014-10-17 03:00:42
Hi,

we would like to buy licenses of this products HXTT Access v5.2, HXTT Excel v4.2, HXTT Text(CSV) v5.2 and HXTT XML v1.2 with unlimited re-distribute option for 5000 USD. How do you think about this offer?

We have another questions about license and support:

1. How does the re-distribute option? Must we install your license file in every our swing standlone application?
2. Is the license valid for 1 year with update option? How about the support when we buy licenses with unlimited re-distribute option?

best regards,
Chi Thien Phan
Software Developer by Gtt from Germany www.gtt-online.de
Re:Re:Re:Re:Trial version for HXTT Excel and HXTT Access
HXTT Support
2014-10-17 07:17:41
> we would like to buy licenses of this products HXTT Access v5.2, HXTT Excel
> v4.2, HXTT Text(CSV) v5.2 and HXTT XML v1.2 with unlimited re-distribute option
> for 5000 USD. How do you think about this offer?
You can get a discount if you buy these as a bundle. But your quote is far away for the normal Unlimited Application License price. You can contact sales @ hxtt.com .

> 1. How does the re-distribute option? Must we install your license file in every our swing standlone application?
You needn't.

>2. Is the license valid for 1 year with update option?
After 1 year, you can continue using the older version for re-distribute.

>How about the support when we buy licenses with unlimited re-distribute option?
One year free support/upgrade service.
critical issue for reading data from excel
Chi Thien Phan
2014-10-20 04:44:56
Hi,

before we decide to buy your products, we must test it thoroughly. In the test phase we have found an critical issue. In a number column we got a wrong value from jdbc driver. You can reproduce this problem like below:

Data
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
0.50

we got 0 at the line number 12 instead 0.50. We got just the correct value 0.50 if we changed the value of line number 10 from 1.00 to 1.10.

How should we fix this problem now?
Thank you very much!
Best regards,
Chi Thien Phan
Software Developer by Gtt from Germany www.gtt-online.de
Re:Re:Re:Re:Re:Re:Trial version for HXTT Excel and HXTT Access
Chi Thien Phan
2014-10-21 01:29:31
Hi,

via ResultSetMetaData i could find out which problem we got. The column type was just changed from BIGINT to NUMERIC when the value of line number 10 was changed from 1.00 to 1.10. Therefore i have tried to set the property maxScanRows to 0 to determine the correct column type. But it was not help to solve our problem. Is it a bug? Or cant we use this property maxScanRows for the trial version?

Best regards,
Chi Thien Phan
Re:Re:Re:Re:Re:Re:Re:Trial version for HXTT Excel and HXTT Access
HXTT Support
2014-10-21 02:56:03
>We got just the correct value 0.50 if we changed the value of line number 10 from 1.00 to 1.10.
For Excel,
maxScanRows: Indicates how many rows should be scanned when determining the column types. If you set maxScanRows to 0, the entire file is scanned. If you set maxScanRows to a negative value, the file won't be scanned. The default value is 10.

>Therefore i have tried to set the property maxScanRows to 0 to determine the correct column type. But it was not help to solve our problem.
Checked. maxScanRows=-1 or maxScanRows=0 can show normal value. Maybe you're use a database engine browser, and reconnect it at once, so that HXTT Excel reuse the opening database file according to delayedClose=3 connection property.
Re:Re:Re:Re:Re:Re:Re:Re:Trial version for HXTT Excel and HXTT Access
Chi Thien Phan
2014-10-21 04:14:29
Hi,

thanks for quick response! maxScanRows=-1 or maxScanRows=0 cant help to solve our problem. Here is the code to read data from excel file and write it to console:

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;
import java.util.Properties;


public class HTXX_Excel {

/**
* @param args
*/
public static void main(String[] args) {
try {
Class.forName("com.hxtt.sql.excel.ExcelDriver");
Properties prop = new Properties();
prop.put("maxScanRows",0);

Connection conn = DriverManager.getConnection("jdbc:excel:/C:/TestExcel.xlsx",prop);

String query = "SELECT * FROM Tabelle1";
Statement stmt = conn.createStatement();
ResultSet resultSet = stmt.executeQuery(query);
ResultSetMetaData meta = resultSet.getMetaData();
int rowCounter = 2;

while (resultSet.next()) {
System.out.println("Row " + (rowCounter++));

for (int i = 1 ; i <= meta.getColumnCount(); i++){
System.out.println(meta.getColumnTypeName(i) + " - " + meta.getColumnName(i) + " - " + resultSet.getObject(i).toString());
}
}

resultSet.close();
} catch (Exception e) {
e.printStackTrace();
}

}
}


How can we fix this problem?
Thanks,
Best regards,
Chi Thien Phan


PS: The test file was sent to your mail via support@hxtt.com
Re:Re:Re:Re:Re:Re:Re:Re:Trial version for HXTT Excel and HXTT Access
HXTT Support
2014-10-21 05:47:15
>prop.put("maxScanRows",0);
Please use
prop.setProperty("maxScanRows","0");



Re:Re:Re:Re:Re:Re:Re:Re:Trial version for HXTT Excel and HXTT Access
Chi Thien Phan
2014-10-21 06:29:03
hi,

i got following error:

java.sql.SQLException: Invalid connection string syntax, index: 18.
at rssbus.jdbc.excel.ExcelDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at HTXX_Excel.main(HTXX_Excel.java:20)

best regards,
Chi Thien Phan
Re:Re:Re:Re:Re:Re:Re:Re:Trial version for HXTT Excel and HXTT Access
HXTT Support
2014-10-21 07:22:46
>java.sql.SQLException: Invalid connection string syntax, index: 18.
What's your jdbc url and code?
Re:Re:Re:Re:Re:Re:Re:Re:Trial version for HXTT Excel and HXTT Access
Chi Thien Phan
2014-10-21 21:39:08
the driver which i got from this url http://www.hxtt.com/Excel_JDBC30.jar

> What's your jdbc url and code?

Class.forName("com.hxtt.sql.excel.ExcelDriver");
Properties prop = new Properties();
prop.put("maxScanRows","0");

Connection conn = DriverManager.getConnection("jdbc:excel:/C:/TestExcel.xlsx",prop);

thanks!
best regards,
Chi Thien Phan
Re:Re:Re:Re:Re:Re:Re:Re:Trial version for HXTT Excel and HXTT Access
HXTT Support
2014-10-22 02:35:06
>rssbus.jdbc.excel.ExcelDriver.connect
You're using another jdbc driver.
Re:Re:Re:Re:Re:Re:Re:Re:Trial version for HXTT Excel and HXTT Access
Chi Thien Phan
2014-10-22 02:54:15
Hi,

thx for your reply!

>rssbus.jdbc.excel.ExcelDriver.connect

that's right. It was my fault to forget deleting another jdbc driver in my project build path.

It works perfect now!
Best regards,
Chi Thien Phan
Re:Re:Re:Re:Re:Re:Re:Re:Trial version for HXTT Excel and HXTT Access
Chi Thien Phan
2014-10-22 04:08:03
Hi,

has any pattern for column name in excel? Where can i refer such informations about table name, column name, etc. in developer document?

thanks,
best regards,
Chi Thien Phan
Re:Re:Re:Re:Re:Re:Re:Re:Trial version for HXTT Excel and HXTT Access
HXTT Support
2014-10-22 07:11:14
It's at Pseudo Tables
Re:Re:Re:Re:Re:Re:Re:Re:Trial version for HXTT Excel and HXTT Access
HXTT Support
2014-10-22 07:18:20
BTW, you can use a,b,c,...aa,ab,... as column name.
Create Index
Chi Thien Phan
2014-10-23 23:53:25
Hi,

we are testing now the performace of your driver for some large tables in excel file. We want to create some indexes for some large tables with some hundred thousand rows with following statement from developer document:

create index if not exists col1index ON Table1 (col1)

form following code i get always false after executing the create-index-statement:


Class.forName("com.hxtt.sql.excel.ExcelDriver");
Connection conn = DriverManager.getConnection("jdbc:excel:/C:/TestExcel.xlsx");
String query = "create index if not exists col1index ON Table1 (col1)";
Statement stmt = conn.createStatement();

boolean isOK = stmt.execute(query);
System.out.println(isOK);

My question: how oder where can i view my created indexes in excel files oder jdbc-client?

thanks,
best regards,
Chi Thien Phan
Re:Re:Re:Re:Re:Re:Re:Re:Trial version for HXTT Excel and HXTT Access
HXTT Support
2014-10-24 02:56:27
>My question: how oder where can i view my created indexes in excel files oder jdbc-client?
Because MS Excel is a special database file. It won't create index for "create index" sql.

>we are testing now the performace of your driver for some large tables in excel file. We want to create some indexes for some large tables with some hundred thousand rows with following statement from developer document:
Don't worry. In fact, it provide automatical temporary index feature.
delayedClose connection property: Automatic temporary index is disabled when delayedClose<=60s. You can use 0~120 seconds. Default: 3.
When HXTT Excel met PreparedStatement or join table sql with where clause, it maybe create temporary index to quicken the query.

Problem with insert statement for date/timestamp column
Chi Thien Phan
2014-11-11 03:02:04
Hi,

i have tried to insert a new row with one date/datetime column into my excel file without success.

After executing following code the date/datetime column was corrupted:

Class.forName("com.hxtt.sql.excel.ExcelDriver");
Connection conn = DriverManager.getConnection("jdbc:excel:/C:/Users/pha.GTT-ALLGEMEIN/Downloads/ExcelDataSource.xls");

String query = "INSERT INTO Artikel (Datum_Abgang, ID) VALUES ({ts '2014-11-11 09:07:21.193'}, '33')";
Statement stmt = conn.createStatement();
stmt.setEscapeProcessing(true);
stmt.execute(query);
stmt.close();

After executing following code nothing was changed in my excel file:

Class.forName("com.hxtt.sql.excel.ExcelDriver");
Connection conn = DriverManager.getConnection("jdbc:excel:/C:/Users/pha.GTT-ALLGEMEIN/Downloads/ExcelDataSource.xls");

String query = "INSERT INTO Artikel (ABC_GRUPPE, Artikel, Datum_Abgang, Einzelpreis, H, I, ID, Menge, XYZ_GRUPPE) VALUES ('123', '123', ? , '222.0', '22', '2', '2', '222', '2222')";
PreparedStatement insertStm = conn.prepareStatement(query);
SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSS");
Date date = format.parse("2014-11-11 09:07:21.193");
insertStm.setTimestamp(1, new Timestamp(date.getTime()));
insertStm.executeUpdate();
insertStm.close();

HOW CAN I INSERT A NEW ROW WITH DATE/DATETIME OBJECT? CAN YOU GIVE ME AN EXAMPLE?
thanks,
best regards,
Chi Thien Phan
Excel file
Chi Thien Phan
2014-11-11 04:58:29
you can download our demo data with date column via http://bitshare.com/files/nk3bawmu/ExcelDataSource.rar.html

correct excel file
Chi Thien Phan
2014-11-11 05:04:20
please use this correct excel file http://bitshare.com/files/gd6ogwp7/ExcelDataSource.xls.html
Re:Re:Re:Re:Re:Re:Re:Re:Trial version for HXTT Excel and HXTT Access
HXTT Support
2014-11-11 07:09:47
You should use
conn.close();//Add that statement to release it.
because XLS file is using lazy flush.

BTW, I can't visit bitshare.com, and you can email your sample into supprt at hxtt.com



Re:Re:Re:Re:Re:Re:Re:Re:Trial version for HXTT Excel and HXTT Access
Chi Thien Phan
2014-11-11 22:27:38
Hi,

i have sent it to you via e-mail.

thanks,
best regards,
Chi Thien Phan
Re:Re:Re:Re:Re:Re:Re:Re:Trial version for HXTT Excel and HXTT Access
HXTT Support
2014-11-12 04:10:07
Received an email but haven't seen the attachment.

2014-11-12 will use default format for Date object when use INSERT sql on XLS file.

You can try the latest package.
Re:Re:Re:Re:Re:Re:Re:Re:Trial version for HXTT Excel and HXTT Access
Chi Thien Phan
2014-11-12 05:01:55
hi,

i ve resent it to your mail. Please check your mail box again!

thx
Re:Re:Re:Re:Re:Re:Re:Re:Trial version for HXTT Excel and HXTT Access
Chi Thien Phan
2014-11-12 06:13:10
Hi,

>conn.close();//Add that statement to release it.
>because XLS file is using lazy flush.
>2014-11-12 will use default format for Date object when use INSERT sql on XLS file.

it did not work.


Re:Re:Re:Re:Re:Re:Re:Re:Trial version for HXTT Excel and HXTT Access
HXTT Support
2014-11-13 07:09:10
Supported now.
2014-11-13 fixed a bug on customer cell format of XLS file.
Re:Re:Re:Re:Re:Re:Re:Re:Trial version for HXTT Excel and HXTT Access
Chi Thien Phan
2014-11-13 23:53:48
thx for fixing this bug! Can you provide me the download link for the new Version?

thx
best regards,
Chi Thien Phan
Re:Re:Re:Re:Re:Re:Re:Re:Trial version for HXTT Excel and HXTT Access
HXTT Support
2014-11-14 00:21:36
http://www.hxtt.com/excel.zip
Re:Re:Re:Re:Re:Re:Re:Re:Trial version for HXTT Excel and HXTT Access
Chi Thien Phan
2014-11-14 00:56:42
it works now.

thx
best regards,
Chi Thien Phan
Re:Re:Re:Re:Re:Re:Re:Re:Trial version for HXTT Excel and HXTT Access
Chi Thien Phan
2014-11-24 23:02:38
hi,

our demo-excel-driver is expired. But our test phase is not completed. Can you provide us another demo-excel-driver?

thanks,
best regards,
Chi Thien Phan

Re:Re:Re:Re:Re:Re:Re:Re:Trial version for HXTT Excel and HXTT Access
HXTT Support
2014-11-25 00:00:30
Please visit http://www.hxtt.com/Excel_JDBC30.jar and http://www.hxtt.com/Access_JDBC30.jar
Re:Re:Re:Re:Re:Re:Re:Re:Trial version for HXTT Excel and HXTT Access
Chi Thien Phan
2014-11-25 01:44:25
thanks for your quick reply! I have downloaded the new excel driver via http://www.hxtt.com/Excel_JDBC30.jar and integrated into our app without success. I got following msg:

Evaluation period over, please consider ordering a commercial version of this pr
oduction!

Can you provide us another demo-excel-driver?
Re:Re:Re:Re:Re:Re:Re:Re:Trial version for HXTT Excel and HXTT Access
HXTT Support
2014-11-25 05:39:58
Redownload it.
Re:Re:Re:Re:Re:Re:Re:Re:Trial version for HXTT Excel and HXTT Access
Chi Thien Phan
2014-11-25 22:52:42
Thx for your reply! I can start my program with your new driver via eclipse. But i cant not start it via jar file and got following msg after program start:

java.lang.NoSuchMethodError: com.hxtt.sql.d1.a(ILjava/lang/String;Ljava/util/Properties;)Lcom/hxtt/concurrent/ae;
at com.hxtt.sql.excel.EmbeddedDriver.connect(Unknown Source)
at com.hxtt.global.SQLState.getConnection(Unknown Source)
at com.hxtt.sql.HxttDriver.if(Unknown Source)
at com.hxtt.sql.HxttDriver.connect(Unknown Source)
at org.eclipse.persistence.sessions.DefaultConnector.directConnect(DefaultConnector.java:165)
at org.eclipse.persistence.sessions.DefaultConnector.connect(DefaultConnector.java:117)
at org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:162)
at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.connectInternal(DatasourceAccessor.java:330)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.connectInternal(DatabaseAccessor.java:291)
at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.connect(DatasourceAccessor.java:418)
at org.eclipse.persistence.sessions.server.ConnectionPool.buildConnection(ConnectionPool.java:167)
at org.eclipse.persistence.sessions.server.ConnectionPool.startUp(ConnectionPool.java:453)
at org.eclipse.persistence.sessions.server.ServerSession.connect(ServerSession.java:484)
at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.login(DatabaseSessionImpl.java:640)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:235)
at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:394)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.getServerSession(EntityManagerFactoryImpl.java:185)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:242)
at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:230)
at de.gtt.configDB.EntityManagerHelper.getEntityManager(EntityManagerHelper.java:199)
at de.gtt.configDB.GttDomainModel.createEntityManager(GttDomainModel.java:61)
at de.gtt.appframework.GttApplication$GttApplicationStartAction.do_it(GttApplication.java:1155)
at de.gtt.uibean.extras.SwingWorkerAction$3.run(SwingWorkerAction.java:380)
at java.lang.Thread.run(Unknown Source)
Re:Re:Re:Re:Re:Re:Re:Re:Trial version for HXTT Excel and HXTT Access
HXTT Support
2014-11-25 22:56:14
>But i cant not start it via jar file and got following msg after program start:
Because your classpath contain older Access_JDBC30.jar . Both of them should be the latest package.

Re:Re:Re:Re:Re:Re:Re:Re:Trial version for HXTT Excel and HXTT Access
Chi Thien Phan
2014-11-25 23:22:12
thx for your hint! It works fine now.

best regards,
Chi Thien Phan
Re:Re:Re:Re:Re:Re:Re:Re:Trial version for HXTT Excel and HXTT Access
Chi Thien Phan
2014-12-15 00:38:20
Hi,

with the demo version of excel-driver we have not any problem to load excel data that are created from "excel-random-function". After buying the excel driver and integrating it in our app we get always the same instead new data that may be cached from the driver.

to reproduce this issue you can use following code:

Class.forName("com.hxtt.sql.excel.ExcelDriver");
Connection conn = DriverManager.getConnection("jdbc:excel:/EXCEL-Testdaten-lokal.xlsx?maxScanRows=0&caseInsensitive=true");

String query = "select Ganzzahl,Ganzzahl_pos,Land,Getr��nk from Tabelle1";
Statement stmt = conn.createStatement();
ResultSet resultSet = stmt.executeQuery(query);

while (resultSet.next()) {
System.out.println("-------------------------------------");
for(int i = 1; i < 5; i++){
System.out.println(resultSet.getObject(i));
}
}
resultSet.close();
stmt.close();
conn.close();

How can we solve this problem?
thanks,

PS: I will send you our excel file EXCEL-Testdaten-lokal.xlsx via e-mail

Re:Re:Re:Re:Re:Re:Re:Re:Trial version for HXTT Excel and HXTT Access
HXTT Support
2014-12-15 03:05:52
>we get always the same instead new data that may be cached from the driver.
HXTT Excel and MS Excel can't see each other because MS Excel like to use exclusive mode for read/write. You can use delayedClose=0 connection property to avoid data cache.
Re:Re:Re:Re:Re:Re:Re:Re:Trial version for HXTT Excel and HXTT Access
HXTT Support
2014-12-15 03:13:57
Checked your sample. You're using fomula INT(RANDBETWEEN(-10,10)), and HXTT Excel doesn't support recalculate fomula value for MS Excel file.

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 | Refund | Sitemap