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

            {
               throw new DeploymentException("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

View Full Code Here

            {
               throw new DeploymentException("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

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)) {
               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)) {
               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 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

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.