Sample 0 [from 754 instances]

Class1040.getConnection(){
        if (username == null && password == null) {
            log.log(Level.FINE, "connect to {0}", connectionUrl);
            conn = DriverManager.getConnection(connectionUrl);
        } else {
            log.log(Level.FINE, "connect to {0} with ''{1}''/''{2}''",
                    new Object[] { connectionUrl, username, password });
            conn = DriverManager.getConnection(connectionUrl, username, password);
        }
        return new DatabaseConnection(conn, schema);
}


Sample 1 [from 186 instances]

Class720.testDisallowDropOfColumnOnParentTable()#0{
        Connection conn = DriverManager.getConnection(getUrl());
        conn.createStatement().execute(ddl);
        conn.createStatement().execute(ddl);
            conn.createStatement().execute("ALTER TABLE tp DROP COLUMN v1");
}


Sample 2 [from 90 instances]

Class460.testArrayToStringFunctionWithNulls8(){
        Connection conn = DriverManager.getConnection(getUrl());
        initTables(conn);
        rs = conn.createStatement().executeQuery("SELECT ARRAY_TO_STRING(ARRAY[NULL, NULL, 'a', 'b', NULL, 'c', 'd', NULL, 'e', NULL, NULL], ', ') FROM regions WHERE region_name = 'SF Bay Area'");
        assertTrue(rs.next());
        assertEquals(expected, rs.getString(1));
        assertFalse(rs.next());
}


Sample 3 [from 83 instances]

Class1240.testTernarySubtractionExpression()#0{
        props.setProperty(PhoenixRuntime.CURRENT_SCN_ATTRIB, Long.toString(ts + 2)); // Execute at timestamp 2
        Connection conn = DriverManager.getConnection(PHOENIX_JDBC_URL, props);
            PreparedStatement statement = conn.prepareStatement(query);
            ResultSet rs = statement.executeQuery();
            assertTrue (rs.next());
            assertEquals(rs.getString(1), ROW7);
            assertTrue (rs.next());
            assertEquals(rs.getString(1), ROW9);
            assertFalse(rs.next());
            conn.close();
}


Sample 4 [from 41 instances]

Class240.createConnection(){
        if(null == _props) {
            if(_uname == null && _passwd == null) {
                return DriverManager.getConnection(_connectUri);
            }
            return DriverManager.getConnection(_connectUri,_uname,_passwd);
        }
        return DriverManager.getConnection(_connectUri,_props);
}


Sample 5 [from 27 instances]

Class730.dropTable()#1{
                Connection conn = DriverManager.getConnection("jdbc:default:connection");
                PreparedStatement ps = conn.prepareStatement("drop table t1");
                ps.execute();
                ps.close();
}


Sample 6 [from 27 instances]

Class1370.openConnection(boolean autocommit){
        Connection conn = DriverManager.getConnection("jdbc:h2:mem:example;DB_CLOSE_DELAY=-1");
        conn.setAutoCommit(autocommit);
}


Sample 7 [from 26 instances]

Class440.testInListParameterMetaData4(){
        Connection conn = DriverManager.getConnection(getUrl(), PropertiesUtil.deepCopy(TestUtil.TEST_PROPERTIES));
        PreparedStatement statement = conn.prepareStatement(query);
        ParameterMetaData pmd = statement.getParameterMetaData();
        assertEquals(3, pmd.getParameterCount());
        assertEquals(null, pmd.getParameterClassName(1));
        assertEquals(null, pmd.getParameterClassName(2));
        assertEquals(null, pmd.getParameterClassName(3));
}


Sample 8 [from 22 instances]

Class810.initTableValues()#2{
        Properties props = new Properties(TEST_PROPERTIES);
        Connection conn = DriverManager.getConnection(url, props);
        PreparedStatement stmt = conn.prepareStatement(
                "upsert into " + TABLE_NAME + " VALUES (?, ?)");
}


Sample 9 [from 20 instances]

Class1100.insertRow(int p1,String p2)#0{
    Connection conn = DriverManager.getConnection("jdbc:default:connection");
    PreparedStatement ps = conn.prepareStatement("insert into t1 values (?, ?)");
    ps.setInt(1, p1);
    ps.setString(2, p2);
    ps.executeUpdate();
    ps.close();
}


Sample 10 [from 17 instances]

Class140.testVanityDriverArgsInUrl()#0{
        DriverManager.getConnection(
            "jdbc:splunk:"
            + "url='" + SPLUNK_URL + "'"
            + ";user='" + SPLUNK_USER + "'"
            + ";password='" + SPLUNK_PASSWORD + "'");
    connection.close();
}


Sample 11 [from 13 instances]

Class10.createConnection(Properties p)#0{
        Properties props = new java.util.Properties();
        props.put("password", pass);
        return DriverManager.getConnection(url, props);
}


Sample 12 [from 12 instances]

Class190.helpTestToNumberFilter(String toNumberClause,BigDecimal expectedDecimal)#1{
        PhoenixConnection pconn = DriverManager.getConnection(getUrl(), TEST_PROPERTIES).unwrap(PhoenixConnection.class);
        PhoenixPreparedStatement pstmt = new PhoenixPreparedStatement(pconn, query);
        QueryPlan plan = pstmt.optimizeQuery();
        Scan scan = plan.getContext().getScan();
        Filter filter = scan.getFilter();
}


Sample 13 [from 10 instances]

Class490.testHavingAggregation()#1{
        Properties props = new Properties(TEST_PROPERTIES);
        Connection conn = DriverManager.getConnection(url, props);
}


Sample 14 [from 10 instances]

Class1130.testScanCaching_Default()#1{
        PhoenixConnection pconn = DriverManager.getConnection(getUrl(), PropertiesUtil.deepCopy(TEST_PROPERTIES)).unwrap(PhoenixConnection.class);
        PhoenixPreparedStatement pstmt = newPreparedStatement(pconn, query);
        QueryPlan plan = pstmt.optimizeQuery();
        Scan scan = plan.getContext().getScan();
}


Sample 15 [from 7 instances]

Class1150.openDBCon()#0{
            if (con == null || con.isClosed()) {
                con = DriverManager.getConnection("jdbc:sqlite:" + dbPath.toString());
            }
}


Sample 16 [from 6 instances]

Class480.testTypeMismatchBoundLimit()#1{
        PhoenixConnection pconn = DriverManager.getConnection(getUrl(), TEST_PROPERTIES).unwrap(PhoenixConnection.class);
        ColumnResolver resolver = FromCompiler.getResolver(statement, pconn);
        StatementContext context = new StatementContext(new PhoenixStatement(pconn), resolver, binds, scan);
            LimitCompiler.compile(context, statement);
}


Sample 17 [from 6 instances]

Class780.getConnection(String db){
        Properties prop = new Properties();
        prop.setProperty("password", "");
        return DriverManager.getConnection(url, prop);
}


Sample 18 [from 6 instances]

Class930.getConnection()#0{
        if ( _jdbcUser == null && _jdbcPassword == null ) {
            return DriverManager.getConnection(_jdbcUrl);
        } else {
            String password = _jdbcPassword;
                        
            if (PropertyValueEncryptionUtils.isEncryptedValue(password)) {
                password = decryptPassword(password);
            }
            
            return DriverManager.getConnection(_jdbcUrl, _jdbcUser, password);
        }
}


Sample 19 [from 5 instances]

Class280.initDateTableValues(String tenantId,byte[][] splits,long ts,Date startDate,double dateIncrement)#0{
        Properties props = new Properties(TEST_PROPERTIES);
        Connection conn = DriverManager.getConnection(url, props);
            assertNoRows(conn);
            initDateTableValues(conn, tenantId, startDate, dateIncrement);
            conn.commit();
            conn.close();
}