Hallo,
i trial with your Excel_JDBC30.jar for Purchase.
i get only 100 Records from Resultset.
Is there a restriction for tests?
What is wrong on my code( without Exceptionhandling)?
driver = (Driver) Class.forName ("com.hxtt.sql.excel.ExcelDriver").newInstance();
Connection connExcel = null;
DriverManager.registerDriver(driver);
connExcel = DriverManager.getConnection(DatevToInso.prop_JDBC_Excel.getURL(),properties);
PreparedStatement psExcel_Anschriften = null;
psExcel_Anschriften = connExcel.prepareStatement("SELECT * FROM AnschriftenInso_Anschriften",
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
psExcel_Anschriften.setFetchSize(1000) // no affect in this case;
ResultSet rs = null;
rs = psExcel_Anschriften.executeQuery();
|
|
It's a trial limitation at here.
|
Main
webmaster@hxtt.com