Examples with Driver org.postgresql.Driver used on opensource projects

Example 1 with Driver

use of org.postgresql.Driver in project teiid by teiid.

the class TestEmbeddedServer method testRemoteODBCTrasport.

@Test
public void testRemoteODBCTrasport() throws Exception {
    SocketConfiguration s = new SocketConfiguration();
    InetSocketAddress addr = new InetSocketAddress(0);
    s.setBindAddress(addr.getHostName());
    s.setPortNumber(addr.getPort());
    s.setProtocol(WireProtocol.pg);
    EmbeddedConfiguration config = new EmbeddedConfiguration();
    config.addTransport(s);
    es.start(config);
    es.deployVDB(new ByteArrayInputStream("<vdb name=\"test\" version=\"1\"><model name=\"test\" type=\"VIRTUAL\"><metadata type=\"DDL\"><![CDATA[CREATE VIEW helloworld as SELECT 'HELLO WORLD';]]> </metadata></model></vdb>".getBytes()));
    Connection conn = null;
    try {
        Driver d = new Driver();
        Properties p = new Properties();
        p.setProperty("user", "testuser");
        p.setProperty("password", "testpassword");
        conn = d.connect("jdbc:postgresql://" + addr.getHostName() + ":" + es.transports.get(0).getPort() + "/test", p);
        ResultSet rs = conn.createStatement().executeQuery("select * from helloworld");
        rs.next();
        assertEquals("HELLO WORLD", rs.getString(1));
    } finally {
        if (conn != null) {
            conn.close();
        }
    }
}

Example 2 with Driver

use of org.postgresql.Driver in project teiid by teiid.

the class IntegrationTestDeployment method testODBCConnectionFailure.

@Test
public void testODBCConnectionFailure() throws Exception {
    admin.deploy("bqt.vdb", new FileInputStream(UnitTestUtil.getTestDataFile("bqt.vdb")));
    Driver d = new Driver();
    Properties p = new Properties();
    p.setProperty("user", "user");
    p.setProperty("password", "notpassword");
    try {
        d.connect("jdbc:postgresql://127.0.0.1:35432/bqt", p);
        fail("failed due to bad credentials");
    } catch (SQLException e) {
    }
}

Example 3 with Driver

use of org.postgresql.Driver in project teiid by teiid.

the class IntegrationTestDeployment method testODBCConnectionSuccess.

@Test
public void testODBCConnectionSuccess() throws Exception {
    admin.deploy("bqt.vdb", new FileInputStream(UnitTestUtil.getTestDataFile("bqt.vdb")));
    Driver d = new Driver();
    Properties p = new Properties();
    p.setProperty("user", "user");
    p.setProperty("password", "user");
    Connection c = d.connect("jdbc:postgresql://127.0.0.1:35432/bqt", p);
    c.close();
}

Example 4 with Driver

use of org.postgresql.Driver in project teiid by teiid.

the class TestODBCSSL method testNonSSL.

@Test(expected = SQLException.class)
public void testNonSSL() throws Exception {
    odbcServer.start(Mode.DISABLED);
    Driver d = new Driver();
    Properties p = new Properties();
    p.setProperty("user", "testuser");
    p.setProperty("password", "testpassword");
    p.setProperty("ssl", "true");
    p.setProperty("sslfactory", "org.postgresql.ssl.NonValidatingFactory");
    d.connect("jdbc:postgresql://" + odbcServer.addr.getHostName() + ":" + odbcServer.odbcTransport.getPort() + "/parts", p);
}

Example 5 with Driver

use of org.postgresql.Driver in project teiid by teiid.

the class TestODBCSocketTransport method connect.

private void connect(String database) throws SQLException {
    Driver d = new Driver();
    Properties p = new Properties();
    p.setProperty("user", "testuser");
    p.setProperty("password", "testpassword");
    conn = d.connect("jdbc:postgresql://" + odbcServer.addr.getHostName() + ":" + odbcServer.odbcTransport.getPort() + "/" + database, p);
}