DatabaseDocument.java

    {
      Connection conn = getConnection();
      int row = 0;

      for(int i = 0; i < sql.size(); i++)
      {
        ChadoTransaction tsn = (ChadoTransaction) sql.get(i);
        String[] sql_array = tsn.getSqlQuery();

        for(int j = 0; j < sql_array.length; j++)
        {
          System.out.println(sql_array[j]);

          Statement st = conn.createStatement();
          row += st.executeUpdate(sql_array[j]);
        }
      }

      conn.close();
    }
    catch (java.sql.SQLException sqlExp)
    {
      sqlExp.printStackTrace();
    }
    catch (java.net.ConnectException conn)
    {
      JOptionPane.showMessageDialog(null, "Problems connecting...",
                                    "Database Connection Error - Check Server",
                                    JOptionPane.ERROR_MESSAGE);
      conn.printStackTrace();
    }

  }

/*
  public static void main(String args[])
  {
    try
    {
      DbSqlConfig.init(new JPasswordField());
      SqlMapClient sqlMap = DbSqlConfig.getSqlMapInstance();

      SchemaCVList schema_CVlist = new SchemaCVList();
      schema_CVlist.setSchema("lbraziliensis");

      List list = sqlMap.queryForList("getResidueType", "lbraziliensis");

      schema_CVlist.setCvlist(list);
      List list_residue_features = sqlMap.queryForList("getSchemaResidueFeatures",
                                                       schema_CVlist);
    }
    catch(SQLException sqle)
    {
      sqle.printStackTrace();
    }
  }
*/
}