Hi,
my excel file is corrupted after executing an update statement like below:
public static void main(String[] args) {
try {
Class.forName("com.hxtt.sql.excel.ExcelDriver");
Connection conn = DriverManager.getConnection("jdbc:excel:/EXCEL-Testdaten-lokal.xlsx?maxScanRows=0&delayedClose=0");
String query = "UPDATE MDE SET Bemerkung=? WHERE lfd = 65";
PreparedStatement insertStm = conn.prepareStatement(query);
insertStm.setString(1, "ß837ÄöHg");
insertStm.executeUpdate();
insertStm.close();
conn.close();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
PS: i will send my excel file via mail
thx
|
|
Checked. It seems be a fixed bug, and you should download the latest package.
|
thx for new version!
is it possible to find the path like c:\test\excel.xlsx of excel file that is used in hxtt-driver?
thx
|
>is it possible to find the path like c:\test\excel.xlsx of excel file that is used in hxtt-driver?
What's your want result? If you wish to know the xlsx file at jdbc:excel:/c:/test , you can try
DatabaseMetaData dbmd = con.getMetaData();
ResultSet rs=dbmd.getCatalogs();
|
Main
webmaster@hxtt.com