Package java.sql

Examples of java.sql.DatabaseMetaData.supportsCatalogsInTableDefinitions()

664
665
666
667
668
669
670
671
672
673
674
      System.out.println("supportsCatalogsInDataManipulation(): " +
                 met.supportsCatalogsInDataManipulation());
      System.out.println("supportsCatalogsInProcedureCalls(): " +
                 met.supportsCatalogsInProcedureCalls());
      System.out.println("supportsCatalogsInTableDefinitions(): " +
                 met.supportsCatalogsInTableDefinitions());
      System.out.println("supportsCatalogsInIndexDefinitions(): " +
                 met.supportsCatalogsInIndexDefinitions());
      System.out.println("supportsCatalogsInPrivilegeDefinitions(): " +
                 met.supportsCatalogsInPrivilegeDefinitions());
      System.out.println("supportsPositionedDelete(): " +
View Full Code Here
779
780
781
782
783
784
785
786
787
788
789
    assertEquals("Hive", meta.getDatabaseProductName());
    assertEquals("1", meta.getDatabaseProductVersion());
    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());
View Full Code Here
413
414
415
416
417
418
419
420
421
422
423
      System.out.println("supportsCatalogsInDataManipulation(): " +
                 met.supportsCatalogsInDataManipulation());
      System.out.println("supportsCatalogsInProcedureCalls(): " +
                 met.supportsCatalogsInProcedureCalls());
      System.out.println("supportsCatalogsInTableDefinitions(): " +
                 met.supportsCatalogsInTableDefinitions());
      System.out.println("supportsCatalogsInIndexDefinitions(): " +
                 met.supportsCatalogsInIndexDefinitions());
      System.out.println("supportsCatalogsInPrivilegeDefinitions(): " +
                 met.supportsCatalogsInPrivilegeDefinitions());
      System.out.println("supportsPositionedDelete(): " +
View Full Code Here
337
338
339
340
341
342
343
344
345
346
347
       
        assertFalse(dmd.supportsCatalogsInDataManipulation());
        assertFalse(dmd.supportsCatalogsInIndexDefinitions());
        assertFalse(dmd.supportsCatalogsInPrivilegeDefinitions());
        assertFalse(dmd.supportsCatalogsInProcedureCalls());
        assertFalse(dmd.supportsCatalogsInTableDefinitions());
       
        assertTrue(dmd.supportsColumnAliasing());
       
        // Bug DERBY-462 should return false.
        assertTrue(dmd.supportsConvert());
View Full Code Here
1343
1344
1345
1346
1347
1348
1349
1350
1351
1352
1353
    assertEquals(System.getProperty("hive.version"), meta.getDatabaseProductVersion());
    assertTrue("verifying hive version pattern. got " + meta.getDatabaseProductVersion(),
        Pattern.matches("\\d+\\.\\d+\\.\\d+.*", meta.getDatabaseProductVersion()) );

    assertEquals(DatabaseMetaData.sqlStateSQL99, meta.getSQLStateType());
    assertFalse(meta.supportsCatalogsInTableDefinitions());
    assertFalse(meta.supportsSchemasInTableDefinitions());
    assertFalse(meta.supportsSchemasInDataManipulation());
    assertFalse(meta.supportsMultipleResultSets());
    assertFalse(meta.supportsStoredProcedures());
    assertTrue(meta.supportsAlterTableWithAddColumn());
View Full Code Here
849
850
851
852
853
854
855
856
857
858
859
    assertEquals("Hive", meta.getDatabaseProductName());
    assertEquals("1", meta.getDatabaseProductVersion());
    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());
View Full Code Here
223
224
225
226
227
228
229
230
231
232
233
        String tablePattern = escapePunctuation(originalTablePattern, isOracle);
        DatabaseMetaData databaseMetaData = getDatabaseMetaData(connection);
        boolean supportsCatalogsInTableDefinitions = true;
        try {
            supportsCatalogsInTableDefinitions =
                databaseMetaData.supportsCatalogsInTableDefinitions();
        }
        catch (SQLException sqlException) { /* ignore*/ }
        String catalogPattern = escapePunctuation(
            supportsCatalogsInTableDefinitions ? originalCatalogPattern : "", isOracle);
        // Make sure table(s) is/are available
View Full Code Here
396
397
398
399
400
401
402
403
404
405
406
       
        assertFalse(dmd.supportsCatalogsInDataManipulation());
        assertFalse(dmd.supportsCatalogsInIndexDefinitions());
        assertFalse(dmd.supportsCatalogsInPrivilegeDefinitions());
        assertFalse(dmd.supportsCatalogsInProcedureCalls());
        assertFalse(dmd.supportsCatalogsInTableDefinitions());
       
        assertTrue(dmd.supportsColumnAliasing());
       
        assertFalse(dmd.supportsConvert());
        // Simple check since convert is not supported.
View Full Code Here
281
282
283
284
285
286
287
288
289
290
291
       
        assertFalse(dmd.supportsCatalogsInDataManipulation());
        assertFalse(dmd.supportsCatalogsInIndexDefinitions());
        assertFalse(dmd.supportsCatalogsInPrivilegeDefinitions());
        assertFalse(dmd.supportsCatalogsInProcedureCalls());
        assertFalse(dmd.supportsCatalogsInTableDefinitions());
       
        assertTrue(dmd.supportsColumnAliasing());
       
        // Bug DERBY-462 should return false.
        assertTrue(dmd.supportsConvert());
View Full Code Here
1350
1351
1352
1353
1354
1355
1356
1357
1358
1359
1360
    assertEquals(System.getProperty("hive.version"), meta.getDatabaseProductVersion());
    assertTrue("verifying hive version pattern. got " + meta.getDatabaseProductVersion(),
        Pattern.matches("\\d+\\.\\d+\\.\\d+.*", meta.getDatabaseProductVersion()) );

    assertEquals(DatabaseMetaData.sqlStateSQL99, meta.getSQLStateType());
    assertFalse(meta.supportsCatalogsInTableDefinitions());
    assertTrue(meta.supportsSchemasInTableDefinitions());
    assertTrue(meta.supportsSchemasInDataManipulation());
    assertFalse(meta.supportsMultipleResultSets());
    assertFalse(meta.supportsStoredProcedures());
    assertTrue(meta.supportsAlterTableWithAddColumn());
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.