List of supportsCatalogsInTableDefinitions() Examples

Examples of supportsCatalogsInTableDefinitions()

java.sql.DatabaseMetaData.supportsCatalogsInTableDefinitions()
Determine if catalog names may be used in table definition statements. @return true if catalog names can be used in definitionstatements, false otherwise. @throws SQLException a database error occurred
net.sourceforge.squirrel_sql.fw.sql.ISQLDatabaseMetaData.supportsCatalogsInTableDefinitions()
Retrieves whether a catalog name can be used in a table definition statement. Cached on first call. @return true if a catalog name can be used in a tabledefinition statement. @throws SQLException Thrown if an SQL error occurs.
net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.supportsCatalogsInTableDefinitions()
@see net.sourceforge.squirrel_sql.fw.sql.ISQLDatabaseMetaData#supportsCatalogsInTableDefinitions()
org.jpox.store.rdbms.adapter.RDBMSAdapter.supportsCatalogsInTableDefinitions()
Whether this datastore supports the use of the catalog name in SQL table definitions (DDL). @return whether we can use the catalog name in DDL

Examples of java.sql.DatabaseMetaData.supportsCatalogsInTableDefinitions()

        String tablePattern = escapePunctuation(originalTablePattern, isOracle);
        DatabaseMetaData databaseMetaData = getDatabaseMetaData(connection);
        boolean supportsCatalogsInTableDefinitions = true;
        try {
            supportsCatalogsInTableDefinitions =
                databaseMetaData.supportsCatalogsInTableDefinitions();
        }
        catch (SQLException sqlException) { /* ignore*/ }
        String catalogPattern = escapePunctuation(
            supportsCatalogsInTableDefinitions ? originalCatalogPattern : "", isOracle);
        // Make sure table(s) is/are available

View Full Code Here

Examples of java.sql.DatabaseMetaData.supportsCatalogsInTableDefinitions()

        
        assertFalse(dmd.supportsCatalogsInDataManipulation());
        assertFalse(dmd.supportsCatalogsInIndexDefinitions());
        assertFalse(dmd.supportsCatalogsInPrivilegeDefinitions());
        assertFalse(dmd.supportsCatalogsInProcedureCalls());
        assertFalse(dmd.supportsCatalogsInTableDefinitions());
        
        assertTrue(dmd.supportsColumnAliasing());
        
        assertFalse(dmd.supportsConvert());
        // Simple check since convert is not supported.

View Full Code Here

Examples of java.sql.DatabaseMetaData.supportsCatalogsInTableDefinitions()

      System.out.println("supportsCatalogsInDataManipulation(): " +
                 met.supportsCatalogsInDataManipulation());
      System.out.println("supportsCatalogsInProcedureCalls(): " +
                 met.supportsCatalogsInProcedureCalls());
      System.out.println("supportsCatalogsInTableDefinitions(): " +
                 met.supportsCatalogsInTableDefinitions());
      System.out.println("supportsCatalogsInIndexDefinitions(): " +
                 met.supportsCatalogsInIndexDefinitions());
      System.out.println("supportsCatalogsInPrivilegeDefinitions(): " +
                 met.supportsCatalogsInPrivilegeDefinitions());
      System.out.println("supportsPositionedDelete(): " +

View Full Code Here

Examples of java.sql.DatabaseMetaData.supportsCatalogsInTableDefinitions()


    assertEquals("Hive", meta.getDatabaseProductName());
    assertEquals("1", meta.getDatabaseProductVersion());
    assertEquals(DatabaseMetaData.sqlStateSQL99, meta.getSQLStateType());
    assertNull(meta.getProcedures(null, null, null));
    assertFalse(meta.supportsCatalogsInTableDefinitions());
    assertFalse(meta.supportsSchemasInTableDefinitions());
    assertFalse(meta.supportsSchemasInDataManipulation());
    assertFalse(meta.supportsMultipleResultSets());
    assertFalse(meta.supportsStoredProcedures());
    assertTrue(meta.supportsAlterTableWithAddColumn());

View Full Code Here

Examples of java.sql.DatabaseMetaData.supportsCatalogsInTableDefinitions()

    assertEquals(System.getProperty("hive.version"), meta.getDatabaseProductVersion());
    assertTrue("verifying hive version pattern. got " + meta.getDatabaseProductVersion(),
        Pattern.matches("\\d+\\.\\d+\\.\\d+.*", meta.getDatabaseProductVersion()) );


    assertEquals(DatabaseMetaData.sqlStateSQL99, meta.getSQLStateType());
    assertFalse(meta.supportsCatalogsInTableDefinitions());
    assertFalse(meta.supportsSchemasInTableDefinitions());
    assertFalse(meta.supportsSchemasInDataManipulation());
    assertFalse(meta.supportsMultipleResultSets());
    assertFalse(meta.supportsStoredProcedures());
    assertTrue(meta.supportsAlterTableWithAddColumn());

View Full Code Here

Examples of java.sql.DatabaseMetaData.supportsCatalogsInTableDefinitions()


    assertEquals("Hive", meta.getDatabaseProductName());
    assertEquals("0", meta.getDatabaseProductVersion());
    assertEquals(DatabaseMetaData.sqlStateSQL99, meta.getSQLStateType());
    assertNull(meta.getProcedures(null, null, null));
    assertFalse(meta.supportsCatalogsInTableDefinitions());
    assertFalse(meta.supportsSchemasInTableDefinitions());
    assertFalse(meta.supportsSchemasInDataManipulation());
    assertFalse(meta.supportsMultipleResultSets());
    assertFalse(meta.supportsStoredProcedures());
    assertTrue(meta.supportsAlterTableWithAddColumn());

View Full Code Here

Examples of net.sourceforge.squirrel_sql.fw.sql.ISQLDatabaseMetaData.supportsCatalogsInTableDefinitions()

    ISQLDatabaseMetaData md = session.getMetaData();
    boolean useSchema = true;
    boolean useCatalog = true;
    try
    {
      useCatalog = md.supportsCatalogsInTableDefinitions();
    } catch (SQLException e)
    {
      log.info("Encountered unexpected exception while attempting to "
            + "determine if catalogs are used in table definitions");
    }

View Full Code Here

Examples of net.sourceforge.squirrel_sql.fw.sql.ISQLDatabaseMetaData.supportsCatalogsInTableDefinitions()

    // with the case, as the case is provided by the driver for the existing
    // table, and doesn't need to be fixed.    
    public void testGetQualifiedObjectName() throws SQLException {
        ISQLDatabaseMetaData md = createNiceMock(ISQLDatabaseMetaData.class);
        expect(md.getCatalogSeparator()).andReturn(".");
        expect(md.supportsCatalogsInTableDefinitions()).andReturn(true);
        expect(md.supportsSchemasInTableDefinitions()).andReturn(true);
        replay(md);
        ISession session = createNiceMock(ISession.class);
        expect(session.getMetaData()).andReturn(md).anyTimes();
        replay(session);

View Full Code Here

Examples of net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.supportsCatalogsInTableDefinitions()

    SQLDatabaseMetaData md = session.getSQLConnection().getSQLMetaData();
    boolean useSchema = true;
    boolean useCatalog = true;
    try
    {
      useCatalog = md.supportsCatalogsInTableDefinitions();
    }
    catch (SQLException e)
    {
      log.info("Encountered unexpected exception while attempting to "
        + "determine if catalogs are used in table definitions");

View Full Code Here

Examples of org.jpox.store.rdbms.adapter.RDBMSAdapter.supportsCatalogsInTableDefinitions()

    throws Exception
    {
        // Initialise the Catalog/Schema names
        PersistenceConfiguration conf = omfContext.getPersistenceConfiguration();
        RDBMSAdapter rdba = (RDBMSAdapter)dba;
        if ((conf.hasProperty("org.jpox.mapping.Catalog") && rdba.supportsCatalogsInTableDefinitions()) ||
            (conf.hasProperty("org.jpox.mapping.Schema") && rdba.supportsSchemasInTableDefinitions()))
        {
            // User-specified catalog/schema
            catalogName = conf.getStringProperty("org.jpox.mapping.Catalog");
            schemaName = conf.getStringProperty("org.jpox.mapping.Schema");

View Full Code Here

0 1 2 3

TOP

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.