Examples of net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData

Package net.sourceforge.squirrel_sql.fw.sql

Examples of net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData

net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData
This class represents the metadata for a database. It is essentially a wrapper around java.sql.DatabaseMetaData.
Some data can be cached on the first retrieval in order to speed up subsequent retrievals. To clear this cache call clearCache().
From the JavaDoc for java.sql.DatabaseMetaData. "Some methods take arguments that are String patterns. These arguments all have names such as fooPattern. Within a pattern String, "%" means match any substring of 0 or more characters, and "_" means match any one character. Only metadata entries matching the search pattern are returned. If a search pattern argument is set to null, that argument's criterion will be dropped from the search."
Additionally, it should be noted that some JDBC drivers (like Oracle) do not handle multi-threaded access to methods that return ResultSets very well. It is therefore highly recommended that methods in this class that return a ResultSet, should not be called outside of this class where this class' monitor has no jurisdiction. Furthermore, methods that are meant to be called externally that create a ResultSet should package the data in some container object structure for use by the caller, and should always be synchronized on this class' monitor. @author Colin Bell

         }


         st.nextToken(); // remove the function name


         String catalog = _session.getSQLConnection().getCatalog();
         SQLDatabaseMetaData jdbcMetaData = _session.getSQLConnection().getSQLMetaData();
         Vector<String> tables = new Vector<String>();
         HashMap<String, String> schemas = new HashMap<String, String>();
         while(st.hasMoreTokens())
         {
            String[] catSchemTab = st.nextToken().trim().split("\\.");

View Full Code Here

        throws SQLException
  {
    final List<ObjectTreeNode> childNodes = new ArrayList<ObjectTreeNode>();
    final IDatabaseObjectInfo parentDbinfo = parentNode.getDatabaseObjectInfo();
    final ISQLConnection conn = session.getSQLConnection();
    final SQLDatabaseMetaData md = session.getSQLConnection().getSQLMetaData();
    final String catalogName = parentDbinfo.getCatalogName();
    final String schemaName = parentDbinfo.getSchemaName();
    final ObjFilterMatcher filterMatcher = new ObjFilterMatcher(session.getProperties());


    PreparedStatement pstmt = null;

View Full Code Here

    if (conn == null)
    {
      throw new IllegalArgumentException("SQLConnection == null");
    }


    SQLDatabaseMetaData md = conn.getSQLMetaData();
    try
    {
      _targetDBMS = md.getDatabaseProductName();
    }
    catch (Throwable ignore)
    {
      _targetDBMS = UNSUPPORTED;
    }
    try
    {
      // Current version of the validator webservice cannot handle
      // anything greater than 30.
      _targetDBMSVersion = md.getDatabaseProductVersion();
      if (_targetDBMSVersion.length() > 30)
      {
        _targetDBMSVersion = _targetDBMSVersion.substring(0, 30);
      }
    }
    catch (Throwable ignore)
    {
      _targetDBMSVersion = UNSUPPORTED;
    }
    _connTechnology = "JDBC";
    try
    {
      _connTechnologyVersion = String.valueOf(md.getJDBCVersion());
    }
    catch (Throwable ignore)
    {
      _connTechnologyVersion = UNSUPPORTED;
    }

View Full Code Here

  public List<ObjectTreeNode> createChildren(ISession session, ObjectTreeNode parentNode)
    throws SQLException
  {
    final List<ObjectTreeNode> childNodes = new ArrayList<ObjectTreeNode>();
    final ISQLConnection conn = session.getSQLConnection();
    final SQLDatabaseMetaData md = session.getSQLConnection().getSQLMetaData();
    final IDatabaseObjectInfo parentDbinfo = parentNode.getDatabaseObjectInfo();
    final String schemaName = parentDbinfo.getSchemaName();


    PreparedStatement pstmt = null;
    ResultSet rs = null;

View Full Code Here

   */
  public List<ObjectTreeNode> createChildren(ISession session, ObjectTreeNode parentNode)
  {
    final List<ObjectTreeNode> childNodes = new ArrayList<ObjectTreeNode>();
    final IDatabaseObjectInfo parentDbinfo = parentNode.getDatabaseObjectInfo();
    final SQLDatabaseMetaData md = session.getSQLConnection().getSQLMetaData();
    final String catalogName = parentDbinfo.getCatalogName();
    final String schemaName = parentDbinfo.getSimpleName();


    IDatabaseObjectInfo dbinfo = new DatabaseObjectInfo(catalogName,
                      schemaName, "PACKAGE",

View Full Code Here


    Vector<String> dataTypes = new Vector<String>();
    try
    {
      final ISQLConnection conn = _session.getSQLConnection();
      SQLDatabaseMetaData dmd = conn.getSQLMetaData();
      DataTypeInfo[] infos = dmd.getDataTypes();
            for (int i = 0; i < infos.length; i++) {
                dataTypes.add(infos[i].getSimpleName());
            }
    }
    catch (SQLException ex)

View Full Code Here


    String primaryKey = "";
    try
    {
      ISQLConnection con = _session.getSQLConnection();
      SQLDatabaseMetaData db = con.getSQLMetaData();
            PrimaryKeyInfo[] infos = db.getPrimaryKey(getTableInfo());
            for (int i=0; i < infos.length; i++) {
                primaryKey = infos[i].getColumnName();
            }
    }
    catch (SQLException ex)

View Full Code Here

    throws SQLException
  {
    final List<ObjectTreeNode> childNodes = new ArrayList<ObjectTreeNode>();
    final IDatabaseObjectInfo parentDbinfo = parentNode.getDatabaseObjectInfo();
    final ISQLConnection conn = session.getSQLConnection();
    final SQLDatabaseMetaData md = session.getSQLConnection().getSQLMetaData();
    final IDatabaseObjectInfo tableInfo = ((TriggerParentInfo)parentDbinfo).getTableInfo();
    final PreparedStatement pstmt = conn.prepareStatement(SQL);
    try
    {
      pstmt.setString(1, tableInfo.getSchemaName());

View Full Code Here

    throws SQLException
  {
    final List<ObjectTreeNode> childNodes = new ArrayList<ObjectTreeNode>();
    final IDatabaseObjectInfo parentDbinfo = parentNode.getDatabaseObjectInfo();
    final ISQLConnection conn = session.getSQLConnection();
    final SQLDatabaseMetaData md = session.getSQLConnection().getSQLMetaData();
    final String catalogName = parentDbinfo.getCatalogName();
    final String schemaName = parentDbinfo.getSchemaName();
      ObjFilterMatcher filterMatcher = new ObjFilterMatcher(session.getProperties());

View Full Code Here

    throws SQLException {
    
    final List<ObjectTreeNode> childNodes = new ArrayList<ObjectTreeNode>();
    final IDatabaseObjectInfo parentDbinfo = parentNode.getDatabaseObjectInfo();
    final ISQLConnection conn = session.getSQLConnection();
    final SQLDatabaseMetaData md = session.getSQLConnection().getSQLMetaData();
    final IDatabaseObjectInfo tableInfo = ((ConstraintParentInfo)parentDbinfo).getTableInfo();
    final String schemaName = parentDbinfo.getSchemaName();
    final PreparedStatement pstmt = conn.prepareStatement(SQL);
    
    try  {

View Full Code Here

0 1 2 3 4 5 6 7

TOP

Related Classes of net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData

net.sourceforge.squirrel_sql.client.session.action.DeleteTablesCommand$DeleteExecuter

net.sourceforge.squirrel_sql.client.session.action.DumpSessionCommand

net.sourceforge.squirrel_sql.client.session.DataSetUpdateableTableModelImpl

net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.DatabaseExpander

net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.IndexParentExpander

net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.SchemaExpander

net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.SequenceParentExpander

net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.TableWithChildNodesExpander

net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.TriggerParentExpander

net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTreePanel

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.