DatabaseConnection result = new DatabaseConnection(); checkEnv(); result = new DatabaseConnection(pFile); m_createText = result.getProperties().getProperty("CREATE_STRING"); m_createDouble = result.getProperties().getProperty("CREATE_DOUBLE"); m_createInt = result.getProperties().getProperty("CREATE_INT"); m_createDate = result.getProperties().getProperty("CREATE_DATE", "DATETIME"); m_DateFormat = new SimpleDateFormat(result.getProperties().getProperty("DateFormat", "yyyy-MM-dd HH:mm:ss")); m_idColumn = result.getProperties().getProperty("idColumn");
/** * Opens a connection to the database */ public void connectToDatabase() { try { if (!m_DataBaseConnection.isConnected()) { m_DataBaseConnection.connectToDatabase(); } } catch (Exception ex) { printException(ex); } }
/** * Resets the Loader to the settings in either the default DatabaseUtils.props * or any property file that the user has specified via setCustomPropsFile(). */ public void resetOptions() { resetStructure(); try { if (m_DataBaseConnection != null && m_DataBaseConnection.isConnected()) { m_DataBaseConnection.disconnectFromDatabase(); } m_DataBaseConnection = newDatabaseConnection(); } catch (Exception ex) { printException(ex); } m_URL = m_DataBaseConnection.getDatabaseURL(); if (m_URL == null) { m_URL = "none set!"; } m_User = m_DataBaseConnection.getUsername(); if (m_User == null) { m_User = ""; } m_Password = m_DataBaseConnection.getPassword(); if (m_Password == null) { m_Password = ""; } m_orderBy = new ArrayList<String>(); }
/** * Sets the database url using the DatabaseUtils file * * @throws Exception if something goes wrong */ public void setSource() throws Exception { m_DataBaseConnection = newDatabaseConnection(); m_URL = m_DataBaseConnection.getDatabaseURL(); m_User = m_DataBaseConnection.getUsername(); m_Password = m_DataBaseConnection.getPassword(); }
/** * Counts the number of rows that are loaded from the database * * @throws Exception if the number of rows cannot be calculated * @return the entire number of rows */ private int getRowCount() throws Exception { String query = "SELECT COUNT(*) FROM " + endOfQuery(false); if (m_DataBaseConnection.execute(query) == false) { throw new Exception("Cannot count results tuples."); } ResultSet rs = m_DataBaseConnection.getResultSet(); rs.next(); int i = rs.getInt(1); rs.close(); return i; }
if (m_tabName || m_resolvedTableName.equals("")) { m_resolvedTableName = m_DataBaseConnection.maskKeyword(structure.relationName()); if (m_DataBaseConnection.getUpperCase()) { m_resolvedTableName = m_resolvedTableName.toUpperCase(); m_createInt = m_createInt.toUpperCase(); m_resolvedTableName = m_DataBaseConnection.maskKeyword(m_resolvedTableName); query.append(m_resolvedTableName); if (structure.numAttributes() == 0) { if (m_DataBaseConnection.tableExists(m_resolvedTableName)) { if (!m_truncate) { System.err.println("[DatabaseSaver] Table '" + m_resolvedTableName m_DataBaseConnection.execute(countS); ResultSet countRS = m_DataBaseConnection.getResultSet(); countRS.next(); m_count = countRS.getInt(1); m_DataBaseConnection.execute(trunc); if (m_DataBaseConnection.getUpperCase()) { m_idColumn = m_idColumn.toUpperCase(); query.append(m_DataBaseConnection.maskKeyword(m_idColumn)); query.append(" "); query.append(m_createInt);
if (!m_DataBaseConnection.tableExists(endOfQuery(true))) { throw new IOException( "Table does not exist according to metadata from JDBC driver. " try { String limitQ = limitQuery(m_query, 0, choice); if (m_DataBaseConnection.execute(limitQ) == false) { throw new IOException("Query didn't produce results"); ResultSet rs = m_DataBaseConnection.getResultSet(); m_nominalStrings = Utils.cast(new ArrayList[numAttributes]); for (int i = 1; i <= numAttributes; i++) { switch (m_DataBaseConnection.translateDBColumnType(md .getColumnTypeName(i))) { case DatabaseConnection.STRING: if (m_DataBaseConnection.getUpperCase()) { columnName = columnName.toUpperCase(); if (m_DataBaseConnection.execute(query) == true) { rs1 = m_DataBaseConnection.getResultSet(); rs1.next(); int count = rs1.getInt(1); || m_DataBaseConnection.execute("SELECT DISTINCT ( " + columnName + " ) FROM " + end + " ORDER BY " + columnName) == false) { attributeTypes[i - 1] = Attribute.STRING; break;
if (!m_DataBaseConnection.isConnected()) { connectToDatabase(); if (m_DataBaseConnection.execute(limitQuery(m_query, m_counter, m_choice)) == false) { throw new Exception("Tuple could not be retrieved."); ResultSet rs = m_DataBaseConnection.getResultSet(); rs.next(); Instance current = readInstance(rs); return current; } else { m_DataBaseConnection.disconnectFromDatabase(); resetStructure(); return null;
if (m_DataBaseConnection != null && m_DataBaseConnection.isConnected()) { m_DataBaseConnection.disconnectFromDatabase();
if (!m_DataBaseConnection.isConnected()) { m_DataBaseConnection.connectToDatabase(); DatabaseMetaData dmd = m_DataBaseConnection.getMetaData(); String table = endOfQuery(true);
/** * Sets the database url * * @param url the database url */ public void setSource(String url) { try { m_DataBaseConnection = newDatabaseConnection(); setUrl(url); m_User = m_DataBaseConnection.getUsername(); m_Password = m_DataBaseConnection.getPassword(); } catch (Exception ex) { printException(ex); } }
if (m_tabName || m_resolvedTableName.equals("")) { m_resolvedTableName = m_DataBaseConnection.maskKeyword(structure.relationName()); if (m_DataBaseConnection.getUpperCase()) { m_resolvedTableName = m_resolvedTableName.toUpperCase(); m_createInt = m_createInt.toUpperCase(); m_resolvedTableName = m_DataBaseConnection.maskKeyword(m_resolvedTableName); query.append(m_resolvedTableName); if (structure.numAttributes() == 0) { if (m_DataBaseConnection.tableExists(m_resolvedTableName)) { if (!m_truncate) { System.err.println("[DatabaseSaver] Table '" + m_resolvedTableName m_DataBaseConnection.execute(countS); ResultSet countRS = m_DataBaseConnection.getResultSet(); countRS.next(); m_count = countRS.getInt(1); m_DataBaseConnection.execute(trunc); if (m_DataBaseConnection.getUpperCase()) { m_idColumn = m_idColumn.toUpperCase(); query.append(m_DataBaseConnection.maskKeyword(m_idColumn)); query.append(" "); query.append(m_createInt);
if (!m_DataBaseConnection.tableExists(endOfQuery(true))) { throw new IOException( "Table does not exist according to metadata from JDBC driver. " try { String limitQ = limitQuery(m_query, 0, choice); if (m_DataBaseConnection.execute(limitQ) == false) { throw new IOException("Query didn't produce results"); ResultSet rs = m_DataBaseConnection.getResultSet(); m_nominalStrings = Utils.cast(new ArrayList[numAttributes]); for (int i = 1; i <= numAttributes; i++) { switch (m_DataBaseConnection.translateDBColumnType(md .getColumnTypeName(i))) { case DatabaseConnection.STRING: if (m_DataBaseConnection.getUpperCase()) { columnName = columnName.toUpperCase(); if (m_DataBaseConnection.execute(query) == true) { rs1 = m_DataBaseConnection.getResultSet(); rs1.next(); int count = rs1.getInt(1); || m_DataBaseConnection.execute("SELECT DISTINCT ( " + columnName + " ) FROM " + end + " ORDER BY " + columnName) == false) { attributeTypes[i - 1] = Attribute.STRING; break;
if (!m_DataBaseConnection.isConnected()) { connectToDatabase(); if (m_DataBaseConnection.execute(limitQuery(m_query, m_counter, m_choice)) == false) { throw new Exception("Tuple could not be retrieved."); ResultSet rs = m_DataBaseConnection.getResultSet(); rs.next(); Instance current = readInstance(rs); return current; } else { m_DataBaseConnection.disconnectFromDatabase(); resetStructure(); return null;
if (m_DataBaseConnection != null && m_DataBaseConnection.isConnected()) { m_DataBaseConnection.disconnectFromDatabase();
/** * Sets the database url using the DatabaseUtils file * * @throws Exception if something goes wrong */ public void setSource() throws Exception { m_DataBaseConnection = newDatabaseConnection(); m_URL = m_DataBaseConnection.getDatabaseURL(); m_User = m_DataBaseConnection.getUsername(); m_Password = m_DataBaseConnection.getPassword(); }
if (!m_DataBaseConnection.isConnected()) { m_DataBaseConnection.connectToDatabase(); DatabaseMetaData dmd = m_DataBaseConnection.getMetaData(); String table = endOfQuery(true);
/** * Sets the database url * * @param url the database url */ public void setSource(String url) { try { m_DataBaseConnection = newDatabaseConnection(); setUrl(url); m_User = m_DataBaseConnection.getUsername(); m_Password = m_DataBaseConnection.getPassword(); } catch (Exception ex) { printException(ex); } }
/** * Counts the number of rows that are loaded from the database * * @throws Exception if the number of rows cannot be calculated * @return the entire number of rows */ private int getRowCount() throws Exception { String query = "SELECT COUNT(*) FROM " + endOfQuery(false); if (m_DataBaseConnection.execute(query) == false) { throw new Exception("Cannot count results tuples."); } ResultSet rs = m_DataBaseConnection.getResultSet(); rs.next(); int i = rs.getInt(1); rs.close(); return i; }