Examples of java.sql.DatabaseMetaData.storesLowerCaseQuotedIdentifiers()

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

    public void testIdentifierStorage() throws SQLException
    {
        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

            if (!tableName.endsWith(quote)) {
               throw new IllegalStateException("Mismatched quote in table name: " + tableName);
            }
            int quoteLength = quote.length();
            tableName = tableName.substring(quoteLength, tableName.length() - quoteLength);
            if (dmd.storesLowerCaseQuotedIdentifiers()) {
               tableName = toLowerCase(tableName);
            } else if (dmd.storesUpperCaseQuotedIdentifiers()) {
               tableName = toUpperCase(tableName);
            }
         } else {

View Full Code Here

            {
               throw new IllegalStateException("Mismatched quote in table name: " + tableName);
            }
            int quoteLength = quote.length();
            tableName = tableName.substring(quoteLength, tableName.length() - quoteLength);
            if (dmd.storesLowerCaseQuotedIdentifiers())
            {
               tableName = toLowerCase(tableName);
            }
            else if (dmd.storesUpperCaseQuotedIdentifiers())
            {

View Full Code Here

                if (tableName.endsWith(quote) == false) {
                    throw MESSAGES.mismatchedQuoteTableName(tableName);
                }
                int quoteLength = quote.length();
                tableName = tableName.substring(quoteLength, tableName.length() - quoteLength);
                if (dmd.storesLowerCaseQuotedIdentifiers())
                    tableName = tableName.toLowerCase();
                else if (dmd.storesUpperCaseQuotedIdentifiers())
                    tableName = tableName.toUpperCase();
            } else {
                if (dmd.storesLowerCaseIdentifiers())

View Full Code Here

                if (tableName.endsWith(quote) == false) {
                    throw MESSAGES.mismatchedQuoteTableName(tableName);
                }
                int quoteLength = quote.length();
                tableName = tableName.substring(quoteLength, tableName.length() - quoteLength);
                if (dmd.storesLowerCaseQuotedIdentifiers())
                    tableName = tableName.toLowerCase();
                else if (dmd.storesUpperCaseQuotedIdentifiers())
                    tableName = tableName.toUpperCase();
            } else {
                if (dmd.storesLowerCaseIdentifiers())

View Full Code Here

    public void testIdentifierStorage() throws SQLException
    {
        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

    public void testIdentifierStorage() throws SQLException
    {
        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

            {
               throw new IllegalStateException("Mismatched quote in table name: " + tableName);
            }
            int quoteLength = quote.length();
            tableName = tableName.substring(quoteLength, tableName.length() - quoteLength);
            if (dmd.storesLowerCaseQuotedIdentifiers())
            {
               tableName = toLowerCase(tableName);
            }
            else if (dmd.storesUpperCaseQuotedIdentifiers())
            {

View Full Code Here

                if (tableName.endsWith(quote) == false) {
                    throw new RuntimeException("Mismatched quote in table name: " + tableName);
                }
                int quoteLength = quote.length();
                tableName = tableName.substring(quoteLength, tableName.length() - quoteLength);
                if (dmd.storesLowerCaseQuotedIdentifiers())
                    tableName = tableName.toLowerCase();
                else if (dmd.storesUpperCaseQuotedIdentifiers())
                    tableName = tableName.toUpperCase();
            } else {
                if (dmd.storesLowerCaseIdentifiers())

View Full Code Here

                if (tableName.endsWith(quote) == false) {
                    throw new RuntimeException("Mismatched quote in table name: " + tableName);
                }
                int quoteLength = quote.length();
                tableName = tableName.substring(quoteLength, tableName.length() - quoteLength);
                if (dmd.storesLowerCaseQuotedIdentifiers())
                    tableName = tableName.toLowerCase();
                else if (dmd.storesUpperCaseQuotedIdentifiers())
                    tableName = tableName.toUpperCase();
            } else {
                if (dmd.storesLowerCaseIdentifiers())

View Full Code Here

0 1 2 3 4 5 6

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.