Package java.sql

Examples of java.sql.DatabaseMetaData.supportsResultSetType()

79
80
81
82
83
84
85
86
87
88
89
        databaseName = meta.getDatabaseProductName();
        databaseMajorVersion = getDatabaseMajorVersion(meta);
        log.info("RDBMS: " + databaseName + ", version: " + meta.getDatabaseProductVersion() );
        log.info("JDBC driver: " + meta.getDriverName() + ", version: " + meta.getDriverVersion() );
       
        metaSupportsScrollable = meta.supportsResultSetType(ResultSet.TYPE_SCROLL_INSENSITIVE);
        metaSupportsBatchUpdates = meta.supportsBatchUpdates();
        metaReportsDDLCausesTxnCommit = meta.dataDefinitionCausesTransactionCommit();
        metaReportsDDLInTxnSupported = !meta.dataDefinitionIgnoredInTransactions();
       
        if ( Environment.jvmSupportsGetGeneratedKeys() ) {
View Full Code Here
87
88
89
90
91
92
93
94
95
96
97
          databaseName = meta.getDatabaseProductName();
          databaseMajorVersion = getDatabaseMajorVersion(meta);
          log.info("RDBMS: " + databaseName + ", version: " + meta.getDatabaseProductVersion() );
          log.info("JDBC driver: " + meta.getDriverName() + ", version: " + meta.getDriverVersion() );

          metaSupportsScrollable = meta.supportsResultSetType(ResultSet.TYPE_SCROLL_INSENSITIVE);
          metaSupportsBatchUpdates = meta.supportsBatchUpdates();
          metaReportsDDLCausesTxnCommit = meta.dataDefinitionCausesTransactionCommit();
          metaReportsDDLInTxnSupported = !meta.dataDefinitionIgnoredInTransactions();

          if ( Environment.jvmSupportsGetGeneratedKeys() ) {
View Full Code Here
131
132
133
134
135
136
137
138
139
140
141
                  meta.getDriverMinorVersion()
            );
            LOG.debugf( "JDBC version : %s.%s", meta.getJDBCMajorVersion(), meta.getJDBCMinorVersion() );
          }

          metaSupportsScrollable = meta.supportsResultSetType( ResultSet.TYPE_SCROLL_INSENSITIVE );
          metaSupportsBatchUpdates = meta.supportsBatchUpdates();
          metaReportsDDLCausesTxnCommit = meta.dataDefinitionCausesTransactionCommit();
          metaReportsDDLInTxnSupported = !meta.dataDefinitionIgnoredInTransactions();
          metaSupportsGetGeneratedKeys = meta.supportsGetGeneratedKeys();
          extraKeywordsString = meta.getSQLKeywords();
View Full Code Here
94
95
96
97
98
99
100
101
102
103
104
        try {
            conn = DriverManager.getConnection(m_config.jdbcurl, m_config.jdbcuser, m_config.jdbcpassword);
            DatabaseMetaData dbmd = conn.getMetaData();
            int resultSetType = ResultSet.TYPE_FORWARD_ONLY;
            if (!dbmd.supportsResultSetType(resultSetType)) {
                resultSetType = ResultSet.TYPE_SCROLL_INSENSITIVE;
            }
            stmt = conn.prepareStatement(
                    "select * from " + m_config.jdbctable,
                    resultSetType,
View Full Code Here
139
140
141
142
143
144
145
146
147
148
149
            LOG.debugf( "JDBC version : %s.%s", meta.getJDBCMajorVersion(), meta.getJDBCMinorVersion() );
          }

          metaSupportsRefCursors = StandardRefCursorSupport.supportsRefCursors( meta );
          metaSupportsNamedParams = meta.supportsNamedParameters();
          metaSupportsScrollable = meta.supportsResultSetType( ResultSet.TYPE_SCROLL_INSENSITIVE );
          metaSupportsBatchUpdates = meta.supportsBatchUpdates();
          metaReportsDDLCausesTxnCommit = meta.dataDefinitionCausesTransactionCommit();
          metaReportsDDLInTxnSupported = !meta.dataDefinitionIgnoredInTransactions();
          metaSupportsGetGeneratedKeys = meta.supportsGetGeneratedKeys();
          extraKeywordsString = meta.getSQLKeywords();
View Full Code Here
127
128
129
130
131
132
133
134
135
136
137
                  meta.getDriverMinorVersion()
            );
            LOG.debugf( "JDBC version : %s.%s", meta.getJDBCMajorVersion(), meta.getJDBCMinorVersion() );
          }

          metaSupportsScrollable = meta.supportsResultSetType( ResultSet.TYPE_SCROLL_INSENSITIVE );
          metaSupportsBatchUpdates = meta.supportsBatchUpdates();
          metaReportsDDLCausesTxnCommit = meta.dataDefinitionCausesTransactionCommit();
          metaReportsDDLInTxnSupported = !meta.dataDefinitionIgnoredInTransactions();
          metaSupportsGetGeneratedKeys = meta.supportsGetGeneratedKeys();
          extraKeywordsString = meta.getSQLKeywords();
View Full Code Here
457
458
459
460
461
462
463
464
465
466
467
        assertTrue(dmd.supportsResultSetHoldability(
                ResultSet.CLOSE_CURSORS_AT_COMMIT));
        assertTrue(dmd.supportsResultSetHoldability(
                ResultSet.HOLD_CURSORS_OVER_COMMIT));
       
        assertTrue(dmd.supportsResultSetType(
                ResultSet.TYPE_FORWARD_ONLY));
        assertTrue(dmd.supportsResultSetType(
                ResultSet.TYPE_SCROLL_INSENSITIVE));
        assertFalse(dmd.supportsResultSetType(
                ResultSet.TYPE_SCROLL_SENSITIVE));
View Full Code Here
459
460
461
462
463
464
465
466
467
468
469
        assertTrue(dmd.supportsResultSetHoldability(
                ResultSet.HOLD_CURSORS_OVER_COMMIT));
       
        assertTrue(dmd.supportsResultSetType(
                ResultSet.TYPE_FORWARD_ONLY));
        assertTrue(dmd.supportsResultSetType(
                ResultSet.TYPE_SCROLL_INSENSITIVE));
        assertFalse(dmd.supportsResultSetType(
                ResultSet.TYPE_SCROLL_SENSITIVE));
       
        assertTrue(dmd.supportsSavepoints());
View Full Code Here
461
462
463
464
465
466
467
468
469
470
471
       
        assertTrue(dmd.supportsResultSetType(
                ResultSet.TYPE_FORWARD_ONLY));
        assertTrue(dmd.supportsResultSetType(
                ResultSet.TYPE_SCROLL_INSENSITIVE));
        assertFalse(dmd.supportsResultSetType(
                ResultSet.TYPE_SCROLL_SENSITIVE));
       
        assertTrue(dmd.supportsSavepoints());
        assertTrue(dmd.supportsSchemasInDataManipulation());
        assertTrue(dmd.supportsSchemasInIndexDefinitions());
View Full Code Here
118
119
120
121
122
123
124
125
126
127
128
          log.info( "JDBC driver: " + meta.getDriverName() + ", version: " + meta.getDriverVersion() );

          dialect = DialectFactory.buildDialect( props, conn );
          jdbcSupport = JdbcSupportLoader.loadJdbcSupport( conn );

          metaSupportsScrollable = meta.supportsResultSetType( ResultSet.TYPE_SCROLL_INSENSITIVE );
          metaSupportsBatchUpdates = meta.supportsBatchUpdates();
          metaReportsDDLCausesTxnCommit = meta.dataDefinitionCausesTransactionCommit();
          metaReportsDDLInTxnSupported = !meta.dataDefinitionIgnoredInTransactions();
          metaSupportsGetGeneratedKeys = meta.supportsGetGeneratedKeys();
        }
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.