List of storesLowerCaseIdentifiers() Examples

Examples of storesLowerCaseIdentifiers()

java.sql.DatabaseMetaData.storesLowerCaseIdentifiers()
Determine whether the database treats SQL identifiers that are in mixed case (and unquoted) as case insensitive. If true then the database stores them in lower case. @return true if unquoted SQL identifiers are stored inlower case, false otherwise. @throws SQLException a database error occurred

Examples of java.sql.DatabaseMetaData.storesLowerCaseIdentifiers()

         conn = pool.reserve();
         DatabaseMetaData meta = conn.getMetaData();
         
         this.maxProcLength = meta.getMaxProcedureNameLength();
         
         if (meta.storesLowerCaseIdentifiers())
            this.caseSense = CASE_LOWER;
         else if (meta.storesUpperCaseIdentifiers())
            this.caseSense = CASE_UPPER;
         else if (meta.storesMixedCaseIdentifiers())
            this.caseSense = CASE_MIXED;

View Full Code Here

Examples of java.sql.DatabaseMetaData.storesLowerCaseIdentifiers()

     */
    public void testIdentifierStorage() throws SQLException
    {
        DatabaseMetaData dmd = getDMD();
        
        assertFalse(dmd.storesLowerCaseIdentifiers());
        assertFalse(dmd.storesLowerCaseQuotedIdentifiers());
        assertFalse(dmd.storesMixedCaseIdentifiers());
        
        assertTrue(dmd.storesMixedCaseQuotedIdentifiers());
        assertTrue(dmd.storesUpperCaseIdentifiers());

View Full Code Here

Examples of java.sql.DatabaseMetaData.storesLowerCaseIdentifiers()

    t = jj_consume_token(IDENTIFIER);
        haveConnection();
        DatabaseMetaData dbmd = theConnection.getMetaData();


        String identifier = t.image;
        if (dbmd.storesLowerCaseIdentifiers())
            identifier = identifier.toLowerCase(Locale.ENGLISH);
        else if (dbmd.storesUpperCaseIdentifiers())
            identifier = identifier.toUpperCase(Locale.ENGLISH);


        {if (true) return identifier;}

View Full Code Here

Examples of java.sql.DatabaseMetaData.storesLowerCaseIdentifiers()

     * @throws Exception if an error occurs
     */
    protected void checkSchema() throws Exception {
        DatabaseMetaData metaData = con.getMetaData();
        String tableName = schemaObjectPrefix + "NODE";
        if (metaData.storesLowerCaseIdentifiers()) {
            tableName = tableName.toLowerCase();
        } else if (metaData.storesUpperCaseIdentifiers()) {
            tableName = tableName.toUpperCase();
        }

View Full Code Here

Examples of java.sql.DatabaseMetaData.storesLowerCaseIdentifiers()

        }


        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

Examples of java.sql.DatabaseMetaData.storesLowerCaseIdentifiers()

            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

Examples of java.sql.DatabaseMetaData.storesLowerCaseIdentifiers()

        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

Examples of java.sql.DatabaseMetaData.storesLowerCaseIdentifiers()

            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

Examples of java.sql.DatabaseMetaData.storesLowerCaseIdentifiers()

    //tolerate null names for proper usage in filters
    if (objectName == null) {
      return null;
    }
    DatabaseMetaData metaData = getDatabaseMetaData();
    if (metaData.storesLowerCaseIdentifiers()) {
      return objectName.toLowerCase();
    }else if (metaData.storesUpperCaseIdentifiers()) {
      return objectName.toUpperCase();
    }

View Full Code Here

Examples of java.sql.DatabaseMetaData.storesLowerCaseIdentifiers()

               tableName = toUpperCase(tableName);
            }
         }
         else
         {
            if (dmd.storesLowerCaseIdentifiers())
            {
               tableName = toLowerCase(tableName);
            }
            else if (dmd.storesUpperCaseIdentifiers())
            {

View Full Code Here

0 1 2 3 4 5

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.