Package java.sql

Examples of java.sql.DatabaseMetaData.supportsMultipleResultSets()

96
97
98
99
100
101
102
103
104
105
106
    // This should always be false for postgresql (at least for 7.x)
    assertTrue(!dbmd.isReadOnly());

    // we support multiple resultsets via multiple statements in one execute()
    // now
    assertTrue(dbmd.supportsMultipleResultSets());

    // yes, as multiple backends can have transactions open
    assertTrue(dbmd.supportsMultipleTransactions());

    assertTrue(dbmd.supportsMinimumSQLGrammar());
View Full Code Here
363
364
365
366
367
368
369
370
371
372
373
      System.out.println("supportsGroupByBeyondSelect(): " +
                 met.supportsGroupByBeyondSelect());
      System.out.println("supportsLikeEscapeClause(): " +
                 met.supportsLikeEscapeClause());
      System.out.println("supportsMultipleResultSets(): " +
                 met.supportsMultipleResultSets());
      System.out.println("supportsMultipleTransactions(): " +
                 met.supportsMultipleTransactions());
      System.out.println("supportsNonNullableColumns(): " +
                 met.supportsNonNullableColumns());
      System.out.println("supportsMinimumSQLGrammar(): " +
View Full Code Here
378
379
380
381
382
383
384
385
386
387
388
       
        assertFalse(dmd.supportsMixedCaseIdentifiers());
        assertTrue(dmd.supportsMixedCaseQuotedIdentifiers());
       
        assertTrue(dmd.supportsMultipleOpenResults());
        assertTrue(dmd.supportsMultipleResultSets());
        assertTrue(dmd.supportsMultipleTransactions());
       
        assertFalse(dmd.supportsNamedParameters());
        assertTrue(dmd.supportsNonNullableColumns());
       
View Full Code Here
1346
1347
1348
1349
1350
1351
1352
1353
1354
1355
1356
    assertEquals(DatabaseMetaData.sqlStateSQL99, meta.getSQLStateType());
    assertFalse(meta.supportsCatalogsInTableDefinitions());
    assertFalse(meta.supportsSchemasInTableDefinitions());
    assertFalse(meta.supportsSchemasInDataManipulation());
    assertFalse(meta.supportsMultipleResultSets());
    assertFalse(meta.supportsStoredProcedures());
    assertTrue(meta.supportsAlterTableWithAddColumn());

    //-1 indicates malformed version.
    assertTrue(meta.getDatabaseMajorVersion() > -1);
View Full Code Here
852
853
854
855
856
857
858
859
860
861
862
    assertEquals(DatabaseMetaData.sqlStateSQL99, meta.getSQLStateType());
    assertNull(meta.getProcedures(null, null, null));
    assertFalse(meta.supportsCatalogsInTableDefinitions());
    assertFalse(meta.supportsSchemasInTableDefinitions());
    assertFalse(meta.supportsSchemasInDataManipulation());
    assertFalse(meta.supportsMultipleResultSets());
    assertFalse(meta.supportsStoredProcedures());
    assertTrue(meta.supportsAlterTableWithAddColumn());
  }

  public void testResultSetMetaData() throws SQLException {
View Full Code Here
436
437
438
439
440
441
442
443
444
445
446
       
        assertFalse(dmd.supportsMixedCaseIdentifiers());
        assertTrue(dmd.supportsMixedCaseQuotedIdentifiers());
       
        assertTrue(dmd.supportsMultipleOpenResults());
        assertTrue(dmd.supportsMultipleResultSets());
        assertTrue(dmd.supportsMultipleTransactions());
       
        assertFalse(dmd.supportsNamedParameters());
        assertTrue(dmd.supportsNonNullableColumns());
       
View Full Code Here
322
323
324
325
326
327
328
329
330
331
332
       
        assertFalse(dmd.supportsMixedCaseIdentifiers());
        assertTrue(dmd.supportsMixedCaseQuotedIdentifiers());
       
        assertTrue(dmd.supportsMultipleOpenResults());
        assertTrue(dmd.supportsMultipleResultSets());
        assertTrue(dmd.supportsMultipleTransactions());
       
        assertFalse(dmd.supportsNamedParameters());
        assertTrue(dmd.supportsNonNullableColumns());
       
View Full Code Here
1353
1354
1355
1356
1357
1358
1359
1360
1361
1362
1363
    assertEquals(DatabaseMetaData.sqlStateSQL99, meta.getSQLStateType());
    assertFalse(meta.supportsCatalogsInTableDefinitions());
    assertTrue(meta.supportsSchemasInTableDefinitions());
    assertTrue(meta.supportsSchemasInDataManipulation());
    assertFalse(meta.supportsMultipleResultSets());
    assertFalse(meta.supportsStoredProcedures());
    assertTrue(meta.supportsAlterTableWithAddColumn());

    //-1 indicates malformed version.
    assertTrue(meta.getDatabaseMajorVersion() > -1);
View Full Code Here
415
416
417
418
419
420
421
422
423
424
425
       
        assertFalse(dmd.supportsMixedCaseIdentifiers());
        assertTrue(dmd.supportsMixedCaseQuotedIdentifiers());
       
        assertTrue(dmd.supportsMultipleOpenResults());
        assertTrue(dmd.supportsMultipleResultSets());
        assertTrue(dmd.supportsMultipleTransactions());
       
        assertFalse(dmd.supportsNamedParameters());
        assertTrue(dmd.supportsNonNullableColumns());
       
View Full Code Here
363
364
365
366
367
368
369
370
371
372
373
      System.out.println("supportsGroupByBeyondSelect(): " +
                 met.supportsGroupByBeyondSelect());
      System.out.println("supportsLikeEscapeClause(): " +
                 met.supportsLikeEscapeClause());
      System.out.println("supportsMultipleResultSets(): " +
                 met.supportsMultipleResultSets());
      System.out.println("supportsMultipleTransactions(): " +
                 met.supportsMultipleTransactions());
      System.out.println("supportsNonNullableColumns(): " +
                 met.supportsNonNullableColumns());
      System.out.println("supportsMinimumSQLGrammar(): " +
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.