Hi,
Can you provide support for cache in mysql database in DatabaseTable Model.? Currently its showing out of memory exception while we try to load huge records from mysql.
Thanks,
Sudha.
Moderator: JIDE Support
return new DatabaseTableModel(_connection, "*", "sales") {
private Statement prepareStatement(String sql) throws SQLException {
Statement statement = adjustStatement(_statement, sql);
if (statement == null) {
statement = _statement;
}
return statement;
}
public void refreshData(SortItemSupport sortItemSupport, FilterItemSupport filterItemSupport) throws SQLException {
String countStatement = createCountStatement(filterItemSupport);
if (_statement == null) {
_statement = createStatement();
}
Statement statement = prepareStatement(countStatement);
ResultSet countRs = statement.executeQuery(countStatement);
countRs.next();
int rowCount = countRs.getInt(1);
StringBuffer s = createSqlStatement(_preStatement, _selectStatement, _fromStatement, sortItemSupport, filterItemSupport);
String sql = s.toString();
statement = prepareStatement(sql);
ResultSet resultSet = statement.executeQuery(sql);
if (_resultSetTableModel != null) {
_resultSetTableModel.close();
}
_resultSetTableModel = createResultSetTableModel(resultSet, rowCount);
configureConverterContexts();
fireTableDataChanged();
}
};
Users browsing this forum: No registered users and 12 guests