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