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

            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

      System.out.println("supportsMixedCaseQuotedIdentifiers(): " +
                 met.supportsMixedCaseQuotedIdentifiers());
      System.out.println("storesUpperCaseQuotedIdentifiers(): " +
                 met.storesUpperCaseQuotedIdentifiers());
      System.out.println("storesLowerCaseQuotedIdentifiers(): " +
                 met.storesLowerCaseQuotedIdentifiers());
      System.out.println("storesMixedCaseQuotedIdentifiers(): " +
                 met.storesMixedCaseQuotedIdentifiers());
      System.out.println("getIdentifierQuoteString(): " +
                 met.getIdentifierQuoteString());
      System.out.println("getNumericFunctions(): " +

View Full Code Here

/*      */         {
/* 1049 */           throw new DeploymentException("Mismatched quote in table name: " + tableName);
/*      */         }
/* 1051 */         int quoteLength = quote.length();
/* 1052 */         tableName = tableName.substring(quoteLength, tableName.length() - quoteLength);
/* 1053 */         if (dmd.storesLowerCaseQuotedIdentifiers())
/* 1054 */           tableName = tableName.toLowerCase();
/* 1055 */         else if (dmd.storesUpperCaseQuotedIdentifiers()) {
/* 1056 */           tableName = tableName.toUpperCase();
/*      */         }
/*      */

View Full Code Here

/*      */         {
/* 1113 */           throw new DeploymentException("Mismatched quote in table name: " + tableName);
/*      */         }
/* 1115 */         int quoteLength = quote.length();
/* 1116 */         tableName = tableName.substring(quoteLength, tableName.length() - quoteLength);
/* 1117 */         if (dmd.storesLowerCaseQuotedIdentifiers())
/* 1118 */           tableName = tableName.toLowerCase();
/* 1119 */         else if (dmd.storesUpperCaseQuotedIdentifiers()) {
/* 1120 */           tableName = tableName.toUpperCase();
/*      */         }
/*      */

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

  public void testBug11575() throws Exception {
    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 {

View Full Code Here

      assertEquals(false, dbmd.storesMixedCaseQuotedIdentifiers());
      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

  public void testBug11575() throws Exception {
    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 {

View Full Code Here

      assertEquals(false, dbmd.storesMixedCaseQuotedIdentifiers());
      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

                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

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.