HXTT Excel
get incorrect data with group-by-clause
Chi Thien Phan
2015-09-28 06:26:15.0
hi,

the sql statement with group-by-clause give us incorrect data. The demo data will be sent to your mail.

------------------------------
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class HTXX_Excel {

public static void main(String[] args) {
try {
Class.forName("com.hxtt.sql.excel.ExcelDriver");
Connection conn = DriverManager.getConnection("jdbc:excel:/C:/Users/pha.GTT-ALLGEMEIN/Desktop/Test123.xlsx?maxScanRows=0&caseInsentive=true&delayedClose=0");

String query = "select * from Tabelle1 group by Prozessschritt";
Statement stmt = conn.createStatement();
ResultSet resultSet = stmt.executeQuery(query);
resultSet.getMetaData();

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

----------------------------------------------------------

Pls fix it!

thx
Re:get incorrect data with group-by-clause
HXTT Support
2015-09-28 07:51:52.0
Supported. Please download the latest package.
Re:Re:get incorrect data with group-by-clause
Chi Thien Phan
2015-09-30 04:48:42.0
thx, it works fine now!


Google