@Override public int getDatabaseMajorVersion() throws SQLException { return metaData.getDatabaseMajorVersion(); }
protected boolean canUpsert(Handle handle) throws SQLException { if (canUpsert == null) { DatabaseMetaData metaData = handle.getConnection().getMetaData(); canUpsert = metaData.getDatabaseMajorVersion() > 9 || (metaData.getDatabaseMajorVersion() == 9 && metaData.getDatabaseMinorVersion() >= 5); } return canUpsert; }
public Object doInConnection(Connection c) throws SQLException, DataAccessException { DatabaseMetaData meta = c.getMetaData(); databaseName = meta.getDatabaseProductName(); databaseMajorVersion = meta.getDatabaseMajorVersion(); databaseMinorVersion = meta.getDatabaseMinorVersion(); return null; } });
private boolean isMySQLAtLeast56() throws SQLException { java.sql.DatabaseMetaData meta = connection.getMetaData(); int major = meta.getDatabaseMajorVersion(); int minor = meta.getDatabaseMinorVersion(); return ((major == 5 && minor >= 6) || major > 5); }
private static void validateServerVersion(Statement statement) throws SQLException { DatabaseMetaData metaData = statement.getConnection().getMetaData(); int majorVersion = metaData.getDatabaseMajorVersion(); int minorVersion = metaData.getDatabaseMinorVersion(); if (majorVersion < 9 || (majorVersion == 9 && minorVersion < 4)) { throw new SQLException("Cannot connect to a version of Postgres lower than 9.4"); } }
@Override public int getDatabaseMajorVersion() { try { return interpretVersion( databaseMetaData.getDatabaseMajorVersion() ); } catch (SQLException e) { throw BasicSQLExceptionConverter.INSTANCE.convert( e ); } }
public static MysqlVersion capture(Connection c) throws SQLException { DatabaseMetaData meta = c.getMetaData(); return new MysqlVersion(meta.getDatabaseMajorVersion(), meta.getDatabaseMinorVersion()); } }
static Database getDatabaseForConnection(Connection connection) throws SQLException { final DatabaseMetaData metaData = connection.getMetaData(); final String databaseName = metaData.getDatabaseProductName(); final String url = metaData.getURL(); for (final Database database : Database.values()) { if (database.isRecognized(databaseName, url)) { if (database == MYSQL && metaData.getDatabaseMajorVersion() <= 4) { // si mysql et version 4 alors c'est MYSQL4 et non MYSQL return MYSQL4; } return database; } } throw new IllegalArgumentException( I18N.getFormattedString("type_base_de_donnees_inconnu", databaseName)); } }
/** * Returns the current position in the server tx log. * * @return a long value, never negative * @throws SQLException if anything unexpected fails. */ public long currentXLogLocation() throws SQLException { AtomicLong result = new AtomicLong(0); int majorVersion = connection().getMetaData().getDatabaseMajorVersion(); query(majorVersion >= 10 ? "select * from pg_current_wal_lsn()" : "select * from pg_current_xlog_location()", rs -> { if (!rs.next()) { throw new IllegalStateException("there should always be a valid xlog position"); } result.compareAndSet(0, LogSequenceNumber.valueOf(rs.getString(1)).asLong()); }); return result.get(); }
@Test public void testGetDatabaseProductVersion() throws Exception { try (Connection connection = createConnection()) { DatabaseMetaData metaData = connection.getMetaData(); assertEquals(metaData.getDatabaseProductName(), "Presto"); assertEquals(metaData.getDatabaseProductVersion(), "testversion"); assertEquals(metaData.getDatabaseMajorVersion(), 0); assertEquals(metaData.getDatabaseMinorVersion(), 0); } }
private DatabaseMetaData newMetadata(int dbMajorVersion, int dbMinorVersion) throws SQLException { DatabaseMetaData metadata = mock(DatabaseMetaData.class, Mockito.RETURNS_DEEP_STUBS); when(metadata.getDatabaseMajorVersion()).thenReturn(dbMajorVersion); when(metadata.getDatabaseMinorVersion()).thenReturn(dbMinorVersion); return metadata; } }
private DatabaseMetaData newMetadata(int dbMajorVersion, int dbMinorVersion) throws SQLException { DatabaseMetaData metadata = mock(DatabaseMetaData.class, Mockito.RETURNS_DEEP_STUBS); when(metadata.getDatabaseMajorVersion()).thenReturn(dbMajorVersion); when(metadata.getDatabaseMinorVersion()).thenReturn(dbMinorVersion); return metadata; } }
private DatabaseMetaData newMetadata(int dbMajorVersion, int dbMinorVersion) throws SQLException { DatabaseMetaData metadata = mock(DatabaseMetaData.class, Mockito.RETURNS_DEEP_STUBS); when(metadata.getDatabaseMajorVersion()).thenReturn(dbMajorVersion); when(metadata.getDatabaseMinorVersion()).thenReturn(dbMinorVersion); return metadata; }
private DatabaseMetaData newMetadata(int dbMajorVersion, int dbMinorVersion, String driverVersion) throws SQLException { DatabaseMetaData metadata = mock(DatabaseMetaData.class, Mockito.RETURNS_DEEP_STUBS); when(metadata.getDatabaseMajorVersion()).thenReturn(dbMajorVersion); when(metadata.getDatabaseMinorVersion()).thenReturn(dbMinorVersion); when(metadata.getDriverVersion()).thenReturn(driverVersion); return metadata; } }
private static Connection createMockConnection(final String dbProductName, final int dbMajorVersion, final int dbMinorVersion) throws SQLException { final Connection connection = Mockito.mock(Connection.class); final DatabaseMetaData databaseMetaData = Mockito.mock(DatabaseMetaData.class); Mockito.when(databaseMetaData.getDatabaseProductName()).thenReturn(dbProductName); Mockito.when(databaseMetaData.getDatabaseMajorVersion()).thenReturn(dbMajorVersion); Mockito.when(databaseMetaData.getDatabaseMinorVersion()).thenReturn(dbMajorVersion); Mockito.when(connection.getMetaData()).thenReturn(databaseMetaData); return connection; }
Version checkDbVersion(DatabaseMetaData metaData, Version minSupported) throws SQLException { int major = metaData.getDatabaseMajorVersion(); int minor = metaData.getDatabaseMinorVersion(); Version version = Version.create(major, minor, 0); if (version.compareTo(minSupported) < 0) { throw MessageException.of(String.format( "Unsupported %s version: %s. Minimal supported version is %s.", getId(), version, minSupported)); } return version; } }
if (isMysql()) { DatabaseMetaData databaseMetaData = connection.getMetaData(); int majorVersion = databaseMetaData.getDatabaseMajorVersion(); int minorVersion = databaseMetaData.getDatabaseMinorVersion(); log.info("Found MySQL: majorVersion=" + majorVersion + " minorVersion=" + minorVersion);
dbMajorVersion = databaseMetaData.getDatabaseMajorVersion(); final int dbMinorVersion = databaseMetaData.getDatabaseMinorVersion(); version = dbMajorVersion + "." + dbMinorVersion;
/** * @throws Exception If failed. */ @Test public void testVersions() throws Exception { try (Connection conn = DriverManager.getConnection(BASE_URL)) { assertEquals("Apache Ignite", conn.getMetaData().getDatabaseProductName()); assertEquals(JdbcDatabaseMetadata.DRIVER_NAME, conn.getMetaData().getDriverName()); assertEquals(IgniteVersionUtils.VER.toString(), conn.getMetaData().getDatabaseProductVersion()); assertEquals(IgniteVersionUtils.VER.toString(), conn.getMetaData().getDriverVersion()); assertEquals(IgniteVersionUtils.VER.major(), conn.getMetaData().getDatabaseMajorVersion()); assertEquals(IgniteVersionUtils.VER.major(), conn.getMetaData().getDriverMajorVersion()); assertEquals(IgniteVersionUtils.VER.minor(), conn.getMetaData().getDatabaseMinorVersion()); assertEquals(IgniteVersionUtils.VER.minor(), conn.getMetaData().getDriverMinorVersion()); assertEquals(4, conn.getMetaData().getJDBCMajorVersion()); assertEquals(1, conn.getMetaData().getJDBCMinorVersion()); } }
driverMajorVersion = databaseMetaData.getDriverMajorVersion(); driverMinorVersion = databaseMetaData.getDriverMinorVersion(); databaseMajorVersion = databaseMetaData.getDatabaseMajorVersion(); databaseMinorVersion = databaseMetaData.getDatabaseMinorVersion(); jdbcMajorVersion = databaseMetaData.getJDBCMajorVersion();