public Worksheet generateWorksheetForAllRows() throws SQLException, ClassNotFoundException { /** * Get the data from the database table * */ AbstractJDBCUtil dbUtil = JDBCUtilFactory.getInstance(dbType); ArrayList<ArrayList<String>> data = dbUtil.getDataForQuery(dbType, hostname, portnumber, username, password, query, dBorSIDName); return generateWorksheet(dbUtil, data); }
public Worksheet generateWorksheetForAllRows() throws SQLException, ClassNotFoundException { /** * Get the data from the database table * */ AbstractJDBCUtil dbUtil = JDBCUtilFactory.getInstance(dbType); ArrayList<ArrayList<String>> data = dbUtil.getDataForTable(dbType, hostname, portnumber, username, password, tableName, dBorSIDName); return generateWorksheet(dbUtil, data); }
@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); }
@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.getSQLQueryDataForLimitedRows(dbType, hostname, portnumber, username, password, query, dBorSIDName, 1000); return generateWorksheet(dbUtil, data); } catch (SQLException | ClassNotFoundException e) { //If data could not be imported, delete the empty worksheet Worksheet ws = getWorksheet(); if(ws != null) workspace.removeWorksheet(ws.getId()); throw new KarmaException("Unable to get data for the SQL Query: " + e.getMessage()); } }
VWorkspace vWorkspace) { try { AbstractJDBCUtil dbUtil = JDBCUtilFactory.getInstance(dbType);
AbstractJDBCUtil dbUtil = JDBCUtilFactory.getInstance(dbType); Connection conn = dbUtil.getConnection(hostname, portnumber, username, password, dBorSIDName); conn.setAutoCommit(false);
ArrayList<String> listOfTables = null; try { AbstractJDBCUtil dbUtil = JDBCUtilFactory.getInstance(dbType);
public void generateRDFFromTable(String tablename, String topkrows, List<KR2RMLRDFWriter> writers, R2RMLMappingIdentifier id, ContextIdentifier contextId, String baseURI) throws IOException, JSONException, KarmaException, SQLException, ClassNotFoundException { initializeWriter(id, contextId, writers); AbstractJDBCUtil dbUtil = JDBCUtilFactory.getInstance(dbType); String query = "Select * FROM " + dbUtil.escapeTablename(tablename); if (topkrows != null) { if (dbType == DBType.SQLServer) { query = "Select TOP " + topkrows + " * FROM " + dbUtil.escapeTablename(tablename); } else if (dbType == DBType.MySQL) { query = "Select * FROM " + dbUtil.escapeTablename(tablename) + " LIMIT " + topkrows; } else if (dbType == DBType.Oracle) { query = "Select * FROM " + dbUtil.escapeTablename(tablename) + " WHERE ROWNUM <= " + topkrows; } } generateRDF(tablename, query, writers, id, baseURI); }