@Override public Worksheet generateWorksheet() throws KarmaException { /** * Get the data from the database table * */ AbstractJDBCUtil dbUtil = JDBCUtilFactory.getInstance(dbType); // TODO Limiting the number of rows to 1000 for now to avoid all data in memory ArrayList<ArrayList<String>> data; try { data = dbUtil.getDataForLimitedRows(dbType, hostname, portnumber, username, password, tableName, dBorSIDName, 100); } catch (SQLException | ClassNotFoundException e) { throw new KarmaException("Unable to get data for limited rows " + e.getLocalizedMessage()); } return generateWorksheet(dbUtil, data); }
AbstractJDBCUtil dbUtil = JDBCUtilFactory.getInstance(dbType); List<ArrayList<String>> data = dbUtil.getDataForLimitedRows(dbType, hostname, portnumber, username, password, tableName, dBorSIDName, 10);