if (m_IOThread == null) { try { InstanceQuery InstQ = new InstanceQuery(); InstQ.setDatabaseURL(url); InstQ.setUsername(user); InstQ.setPassword(pw); InstQ.setQuery(query); InstQ.setSparseData(sparse); if (InstQ.isConnected()) InstQ.disconnectFromDatabase(); InstQ.connectToDatabase(); try { addUndoPoint();
System.err.println("Executing query: " + query); connectToDatabase(); if (execute(query) == false) { if (m_PreparedStatement.getUpdateCount() == -1) { throw new Exception("Query didn't produce results"); + " rows affected."); close(); return null; ResultSet rs = getResultSet(); if (m_Debug) { System.err.println("Getting metadata..."); Instances result = retrieveInstances(this, rs); close(rs);
/** * Queries a database to load results from the specified table name. The * database connection must have already made by m_InstanceQuery. * * @param tableName the name of the table containing results to retrieve. */ protected void setInstancesFromDatabaseTable(String tableName) { try { m_FromLab.setText("Reading from database, please wait..."); final Instances i = m_InstanceQuery.retrieveInstances("SELECT * FROM " + tableName); SwingUtilities.invokeAndWait(new Runnable() { @Override public void run() { setInstances(i); } }); m_InstanceQuery.disconnectFromDatabase(); } catch (Exception ex) { m_FromLab.setText(ex.getMessage()); } }
m_InstanceQuery = new InstanceQuery(); String dbaseURL = m_InstanceQuery.getDatabaseURL(); String username = m_InstanceQuery.getUsername(); String passwd = m_InstanceQuery.getPassword(); username = dbd.getUsername(); passwd = dbd.getPassword(); m_InstanceQuery.setDatabaseURL(dbaseURL); m_InstanceQuery.setUsername(username); m_InstanceQuery.setPassword(passwd); m_InstanceQuery.setDebug(dbd.getDebug()); m_InstanceQuery.connectToDatabase(); if (!m_InstanceQuery.experimentIndexExists()) { System.err.println("not found"); m_FromLab.setText("No experiment index"); m_InstanceQuery.disconnectFromDatabase(); return; m_FromLab.setText("Getting experiment index"); Instances index = m_InstanceQuery.retrieveInstances("SELECT * FROM " + InstanceQuery.EXP_INDEX_TABLE); if (index.numInstances() == 0) { m_FromLab.setText("No experiments available"); m_InstanceQuery.disconnectFromDatabase(); return;
checkEnv(); try { InstanceQuery iq = new InstanceQuery(); iq.initialize(m_CustomPropsFile); String realURL = m_URL; try { } catch (Exception ex) { iq.setDatabaseURL(realURL); String realUser = m_User; try { iq.setUsername(realUser); String realPass = m_Password; try { iq.setPassword(realPass); String realQuery = m_query; try { iq.setQuery(realQuery); iq.setSparseData(m_CreateSparseData); result = iq.retrieveInstances(); iq.disconnectFromDatabase();
InstanceQuery iq = new InstanceQuery(); String query = Utils.getOption('Q', args); if (query.length() == 0) { iq.setQuery("select * from Experiment_index"); } else { iq.setQuery(query); iq.setOptions(args); try { Utils.checkForRemainingOptions(args); } catch (Exception e) { System.err.println("Options for weka.experiment.InstanceQuery:\n"); Enumeration<Option> en = iq.listOptions(); while (en.hasMoreElements()) { Option o = en.nextElement(); Instances aha = iq.retrieveInstances(); iq.disconnectFromDatabase();
setSparseData(Utils.getFlag('S', options)); setQuery(tmpStr); setUsername(tmpStr); setPassword(tmpStr); setCustomPropsFile(null); } else { setCustomPropsFile(new File(tmpStr)); setDebug(Utils.getFlag('D', options));
Instances data = null; try { DatabaseUtils utils = new DatabaseUtils(); InstanceQuery query = new InstanceQuery(); query.setUsername(username); query.setPassword(password); query.setQuery(pSql); data = query.retrieveInstances(); data.setRelationName(pInstanceRelationName); if (data.classIndex() == -1) { data.setClassIndex(data.numAttributes() - 1); } // this line will print out your header + data. // add your header information to your question. System.out.println(data) } catch (Exception e) { throw new RuntimeException(e); }
try { if (m_InstanceQuery == null) { m_InstanceQuery = new InstanceQuery(); m_InstanceQuery.setDatabaseURL(dbaseURL); m_InstanceQuery.connectToDatabase(); String tableName = m_InstanceQuery.getResultsTableName(exp.getResultProducer()); setInstancesFromDatabaseTable(tableName); } catch (Exception ex) {
/** * Makes a database query using the query set through the -Q option to convert * a table into a set of instances * * @return the instances contained in the result of the query * @throws Exception if an error occurs */ public Instances retrieveInstances() throws Exception { return retrieveInstances(m_Query); }
m_InstanceQuery = new InstanceQuery(); String dbaseURL = m_InstanceQuery.getDatabaseURL(); String username = m_InstanceQuery.getUsername(); String passwd = m_InstanceQuery.getPassword(); username = dbd.getUsername(); passwd = dbd.getPassword(); m_InstanceQuery.setDatabaseURL(dbaseURL); m_InstanceQuery.setUsername(username); m_InstanceQuery.setPassword(passwd); m_InstanceQuery.setDebug(dbd.getDebug()); m_InstanceQuery.connectToDatabase(); if (!m_InstanceQuery.experimentIndexExists()) { System.err.println("not found"); m_FromLab.setText("No experiment index"); m_InstanceQuery.disconnectFromDatabase(); return; m_FromLab.setText("Getting experiment index"); Instances index = m_InstanceQuery.retrieveInstances("SELECT * FROM " + InstanceQuery.EXP_INDEX_TABLE); if (index.numInstances() == 0) { m_FromLab.setText("No experiments available"); m_InstanceQuery.disconnectFromDatabase(); return;
checkEnv(); try { InstanceQuery iq = new InstanceQuery(); iq.initialize(m_CustomPropsFile); String realURL = m_URL; try { } catch (Exception ex) { iq.setDatabaseURL(realURL); String realUser = m_User; try { iq.setUsername(realUser); String realPass = m_Password; try { iq.setPassword(realPass); String realQuery = m_query; try { iq.setQuery(realQuery); iq.setSparseData(m_CreateSparseData); result = iq.retrieveInstances(); iq.disconnectFromDatabase();
InstanceQuery iq = new InstanceQuery(); String query = Utils.getOption('Q', args); if (query.length() == 0) { iq.setQuery("select * from Experiment_index"); } else { iq.setQuery(query); iq.setOptions(args); try { Utils.checkForRemainingOptions(args); } catch (Exception e) { System.err.println("Options for weka.experiment.InstanceQuery:\n"); Enumeration<Option> en = iq.listOptions(); while (en.hasMoreElements()) { Option o = en.nextElement(); Instances aha = iq.retrieveInstances(); iq.disconnectFromDatabase();
setSparseData(Utils.getFlag('S', options)); setQuery(tmpStr); setUsername(tmpStr); setPassword(tmpStr); setCustomPropsFile(null); } else { setCustomPropsFile(new File(tmpStr)); setDebug(Utils.getFlag('D', options));
try { if (m_InstanceQuery == null) { m_InstanceQuery = new InstanceQuery(); m_InstanceQuery.setDatabaseURL(dbaseURL); m_InstanceQuery.connectToDatabase(); String tableName = m_InstanceQuery.getResultsTableName(exp.getResultProducer()); setInstancesFromDatabaseTable(tableName); } catch (Exception ex) {
/** * Queries a database to load results from the specified table name. The * database connection must have already made by m_InstanceQuery. * * @param tableName the name of the table containing results to retrieve. */ protected void setInstancesFromDatabaseTable(String tableName) { try { m_FromLab.setText("Reading from database, please wait..."); final Instances i = m_InstanceQuery.retrieveInstances("SELECT * FROM " + tableName); SwingUtilities.invokeAndWait(new Runnable() { @Override public void run() { setInstances(i); } }); m_InstanceQuery.disconnectFromDatabase(); } catch (Exception ex) { m_FromLab.setText(ex.getMessage()); } }
/** * Makes a database query using the query set through the -Q option to convert * a table into a set of instances * * @return the instances contained in the result of the query * @throws Exception if an error occurs */ public Instances retrieveInstances() throws Exception { return retrieveInstances(m_Query); }
if (m_IOThread == null) { try { InstanceQuery InstQ = new InstanceQuery(); InstQ.setDatabaseURL(url); InstQ.setUsername(user); InstQ.setPassword(pw); InstQ.setQuery(query); InstQ.setSparseData(sparse); if (InstQ.isConnected()) InstQ.disconnectFromDatabase(); InstQ.connectToDatabase(); try { addUndoPoint();
System.err.println("Executing query: " + query); connectToDatabase(); if (execute(query) == false) { if (m_PreparedStatement.getUpdateCount() == -1) { throw new Exception("Query didn't produce results"); + " rows affected."); close(); return null; ResultSet rs = getResultSet(); if (m_Debug) { System.err.println("Getting metadata..."); Instances result = retrieveInstances(this, rs); close(rs);
@Override public void run() { try { m_Log.statusMessage("Reading from database..."); final Instances i = iq.retrieveInstances(); SwingUtilities.invokeAndWait(new Runnable() { public void run() { setInstances(new Instances(i)); } }); iq.disconnectFromDatabase(); } catch (Exception ex) { m_Log.statusMessage("Problem executing DB query " + m_SQLQ); JOptionPane.showMessageDialog(PreprocessPanel.this, "Couldn't read from database:\n" + ex.getMessage(), "Load Instances", JOptionPane.ERROR_MESSAGE); } m_IOThread = null; } };