Examples of java.sql.DatabaseMetaData.storesMixedCaseIdentifiers()

java.sql.DatabaseMetaData.storesMixedCaseIdentifiers()
Determine whether the database considers mixed case unquoted SQL identifiers as case insensitive and stores them in mixed case. @return true if unquoted SQL identifiers as stored inmixed case, false otherwise. @throws SQLException a database error occurred

    {
      DatabaseMetaData md = session.getSQLConnection().getConnection().getMetaData();


      // Don't change the case of the identifier if database allows mixed
      // case.
      if (md.storesMixedCaseIdentifiers())
      {
        return identifier;
      }
      // Fix the case according to what the database tells us.
      if (md.storesUpperCaseIdentifiers())

View Full Code Here

    {
      DatabaseMetaData md = session.getSQLConnection().getConnection().getMetaData();


      // Don't change the case of the identifier if database allows mixed
      // case.
      if (md.storesMixedCaseIdentifiers()) { return identifier; }
      // Fix the case according to what the database tells us.
      if (md.storesUpperCaseIdentifiers())
      {
        return identifier.toUpperCase();
      }

View Full Code Here

        }


        try {
            boolean needsUpperCase = false;
            try {
                needsUpperCase = dbData.storesLowerCaseIdentifiers() || dbData.storesMixedCaseIdentifiers();
            } catch (SQLException e) {
                String message = "Error getting identifier case information... Error was:" + e.toString();
                Debug.logError(message, module);
                if (messages != null) messages.add(message);
            }

View Full Code Here

            Map<String, Map<String, ColumnCheckInfo>> colInfo = FastMap.newInstance();
            try {
                String lookupSchemaName = getSchemaName(dbData);
                boolean needsUpperCase = false;
                try {
                    needsUpperCase = dbData.storesLowerCaseIdentifiers() || dbData.storesMixedCaseIdentifiers();
                } catch (SQLException e) {
                    String message = "Error getting identifier case information... Error was:" + e.toString();
                    Debug.logError(message, module);
                    if (messages != null) messages.add(message);
                }

View Full Code Here

        try {
            // ResultSet rsCols = dbData.getCrossReference(null, null, null, null, null, null);
            String lookupSchemaName = getSchemaName(dbData);
            boolean needsUpperCase = false;
            try {
                needsUpperCase = dbData.storesLowerCaseIdentifiers() || dbData.storesMixedCaseIdentifiers();
            } catch (SQLException e) {
                String message = "Error getting identifier case information... Error was:" + e.toString();
                Debug.logError(message, module);
                if (messages != null) messages.add(message);
            }

View Full Code Here

            return null;
        }


        needsUpperCase[0] = false;
        try {
            needsUpperCase[0] = dbData.storesLowerCaseIdentifiers() || dbData.storesMixedCaseIdentifiers();
        } catch (SQLException e) {
            String message = "Error getting identifier case information... Error was:" + e.toString();
            Debug.logError(message, module);
            if (messages != null) messages.add(message);
        }

View Full Code Here

    {
        DatabaseMetaData dmd = getDMD();
        
        assertFalse(dmd.storesLowerCaseIdentifiers());
        assertFalse(dmd.storesLowerCaseQuotedIdentifiers());
        assertFalse(dmd.storesMixedCaseIdentifiers());
        
        assertTrue(dmd.storesMixedCaseQuotedIdentifiers());
        assertTrue(dmd.storesUpperCaseIdentifiers());
        assertFalse(dmd.storesUpperCaseQuotedIdentifiers());
    }

View Full Code Here

      assertEquals(false, dbmd.storesUpperCaseIdentifiers());
      assertEquals(true, dbmd.storesUpperCaseQuotedIdentifiers());
    } else {
      assertEquals(false, dbmd.storesLowerCaseIdentifiers());
      assertEquals(false, dbmd.storesLowerCaseQuotedIdentifiers());
      assertEquals(true, dbmd.storesMixedCaseIdentifiers());
      assertEquals(true, dbmd.storesMixedCaseQuotedIdentifiers());
      assertEquals(false, dbmd.storesUpperCaseIdentifiers());
      assertEquals(true, dbmd.storesUpperCaseQuotedIdentifiers());
    }
  }

View Full Code Here

    DatabaseMetaData dbmd = this.conn.getMetaData();


    if (isServerRunningOnWindows()) {
      assertEquals(true, dbmd.storesLowerCaseIdentifiers());
      assertEquals(true, dbmd.storesLowerCaseQuotedIdentifiers());
      assertEquals(false, dbmd.storesMixedCaseIdentifiers());
      assertEquals(false, dbmd.storesMixedCaseQuotedIdentifiers());
      assertEquals(false, dbmd.storesUpperCaseIdentifiers());
      assertEquals(true, dbmd.storesUpperCaseQuotedIdentifiers());
    } else {
      assertEquals(false, dbmd.storesLowerCaseIdentifiers());

View Full Code Here

    {
        DatabaseMetaData dmd = getDMD();
        
        assertFalse(dmd.storesLowerCaseIdentifiers());
        assertFalse(dmd.storesLowerCaseQuotedIdentifiers());
        assertFalse(dmd.storesMixedCaseIdentifiers());
        
        assertTrue(dmd.storesMixedCaseQuotedIdentifiers());
        assertTrue(dmd.storesUpperCaseIdentifiers());
        assertFalse(dmd.storesUpperCaseQuotedIdentifiers());
    }

View Full Code Here

0 1 2 3 4 5 6 7

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.