Examples of org.apache.derby.jdbc.ClientConnectionPoolDataSource

org.apache.derby.jdbc.ClientConnectionPoolDataSource
ClientConnectionPoolDataSource is a factory for PooledConnection objects. An object that implements this interface will typically be registered with a naming service that is based on the Java Naming and Directory Interface (JNDI). Use ClientConnectionPoolDataSource if your application runs under JDBC3.0 or JDBC2.0, that is, on the following Java Virtual Machines:
- JDBC 3.0 - Java 2 - JDK 1.4, J2SE 5.0
- JDBC 2.0 - Java 2 - JDK 1.2,1.3

        
        String retrieveMessageTextProperty = "retrieveMessageText";
        Connection conn;
        // with ConnectionPoolDataSource
        // ConnectionPoolDataSource - retrieveMessageTextProperty
        ClientConnectionPoolDataSource cpds = new ClientConnectionPoolDataSource();
        cpds.setDatabaseName(dbName);
        cpds.setConnectionAttributes(
                retrieveMessageTextProperty + "=false");
        conn = cpds.getConnection();
        assertMessageText(conn,"false");
        conn.close();
        cpds.setConnectionAttributes(
                retrieveMessageTextProperty + "=true");
        conn = cpds.getConnection();
        assertMessageText(conn,"true");
        cpds.setConnectionAttributes(null);
        conn.close();


        // now with XADataSource
        ClientXADataSource xads = new ClientXADataSource();
        //XADataSource - retrieveMessageTextProperty

View Full Code Here

    public void testClientDSConnectionAttributes() throws SQLException {
        if (usingEmbedded())
            return;


        // now with ConnectionPoolDataSource
        ClientConnectionPoolDataSource cpds = 
            new ClientConnectionPoolDataSource();
        // ConnectionPoolDataSource - EMPTY
        dsConnectionRequests(new String[]  
            {"08001","08001","08001","08001",
             "08001","08001","08001","08001","08001"}, 
            (ConnectionPoolDataSource)cpds);


        // ConnectionPoolDataSource 
        // - connectionAttributes=databaseName=<valid dbname>
        cpds.setConnectionAttributes("databaseName=" + dbName);
        dsConnectionRequests(new String[]  
            {"08001","08001","08001","08001",
             "08001","08001","08001","08001","08001"},
            (ConnectionPoolDataSource)cpds);
        cpds.setConnectionAttributes(null);


        // Test that database name specified in connection attributes is 
        // not used
        // ConnectionPoolDataSource - databaseName=wombat and 
        // connectionAttributes=databaseName=kangaroo
        cpds.setConnectionAttributes("databaseName=kangaroo");
        cpds.setDatabaseName(dbName);
        dsConnectionRequests(new String[]  
            {"OK","08001","OK","OK","08001","08001","OK","OK","OK"},
            (ConnectionPoolDataSource)cpds);
        cpds.setConnectionAttributes(null);
        cpds.setDatabaseName(null);


        // now with XADataSource
        ClientXADataSource xads = new ClientXADataSource();
        // XADataSource - EMPTY
        dsConnectionRequests(new String[]

View Full Code Here


    /**
     * Verify that handling of the {@code maxStatements} property is working.
     */
    public void testMaxStatementsProperty() {
        ClientConnectionPoolDataSource cDs =
                new ClientConnectionPoolDataSource();
        // Check the default value.
        assertEquals("Unexpected default value", 0, cDs.getMaxStatements());
        cDs.setMaxStatements(25);
        // Verify that the new value has been set.
        assertEquals("New value not set", 25, cDs.getMaxStatements());
        // Try a negative value
        try {
            cDs.setMaxStatements(-99);
            fail("Negative values should not be allowed: " +
                    cDs.getMaxStatements());
        } catch (IllegalArgumentException iae) {
            // As expected, continue the test.
        }
        // Try setting it to zero to disable statement pooling.
        cDs.setMaxStatements(0);
        assertEquals("New value not set", 0, cDs.getMaxStatements());
    }

View Full Code Here

     *
     * @throws SQLException if database operations fail
     */
    public void testGetConnectionNoStatementPooling()
            throws SQLException {
        ClientConnectionPoolDataSource cDs = (ClientConnectionPoolDataSource)
                J2EEDataSource.getConnectionPoolDataSource();
        // Make sure statement pooling is disabled.
        cDs.setMaxStatements(0);
        assertEquals(0, cDs.getMaxStatements());
        verifyConnection(cDs);
    }

View Full Code Here

     *
     * @throws SQLException if database operations fail
     */
    public void testGetConnectionWithStatementPooling()
            throws SQLException {
        ClientConnectionPoolDataSource cDs = (ClientConnectionPoolDataSource)
                J2EEDataSource.getConnectionPoolDataSource();
        // Enable statement pooling.
        cDs.setMaxStatements(27);
        assertTrue(cDs.getMaxStatements() > 0);
        verifyConnection(cDs);
    }

View Full Code Here

    public void testClientDSConnectionAttributes() throws SQLException {
        if (usingEmbedded())
            return;


        // now with ConnectionPoolDataSource
        ClientConnectionPoolDataSource cpds = 
            new ClientConnectionPoolDataSource();
        cpds.setPortNumber(TestConfiguration.getCurrent().getPort());
        
        // ConnectionPoolDataSource - EMPTY
        dsConnectionRequests(new String[]  
            {"08001","08001","08001","08001",
             "08001","08001","08001","08001","08001"}, 
            (ConnectionPoolDataSource)cpds);


        // ConnectionPoolDataSource 
        // - connectionAttributes=databaseName=<valid dbname>
        cpds.setConnectionAttributes("databaseName=" + dbName);
        dsConnectionRequests(new String[]  
            {"08001","08001","08001","08001",
             "08001","08001","08001","08001","08001"},
            (ConnectionPoolDataSource)cpds);
        cpds.setConnectionAttributes(null);


        // Test that database name specified in connection attributes is 
        // not used
        // ConnectionPoolDataSource - databaseName=wombat and 
        // connectionAttributes=databaseName=kangaroo
        cpds.setConnectionAttributes("databaseName=kangaroo");
        cpds.setDatabaseName(dbName);
        dsConnectionRequests(new String[]  
            {"OK","08001","OK","OK","08001","08001","OK","OK","OK"},
            (ConnectionPoolDataSource)cpds);
        cpds.setConnectionAttributes(null);
        cpds.setDatabaseName(null);


        // now with XADataSource
        ClientXADataSource xads = new ClientXADataSource();
        
        xads.setPortNumber(TestConfiguration.getCurrent().getPort());

View Full Code Here

    public void testClientMessageTextConnectionAttribute() throws SQLException
    {
        String retrieveMessageTextProperty = "retrieveMessageText";
        // with ConnectionPoolDataSource
        // ConnectionPoolDataSource - retrieveMessageTextProperty
        ClientConnectionPoolDataSource cpds = new ClientConnectionPoolDataSource();
        cpds.setPortNumber(TestConfiguration.getCurrent().getPort());
        
        cpds.setDatabaseName(dbName);
        cpds.setConnectionAttributes(
                retrieveMessageTextProperty + "=false");
        PooledConnection cpConn = cpds.getPooledConnection();
        assertMessageText(cpConn.getConnection(), "false");
        cpConn.close();
        cpds.setConnectionAttributes(
                retrieveMessageTextProperty + "=true");
        cpConn = cpds.getPooledConnection();
        assertMessageText(cpConn.getConnection(), "true");
        cpds.setConnectionAttributes(null);
        cpConn.close();


        // now with XADataSource
        ClientXADataSource xads = new ClientXADataSource();
        //XADataSource - retrieveMessageTextProperty

View Full Code Here

    public void testClientDSConnectionAttributes() throws SQLException {
        if (usingEmbedded())
            return;


        // now with ConnectionPoolDataSource
        ClientConnectionPoolDataSource cpds = 
            new ClientConnectionPoolDataSource();
        // ConnectionPoolDataSource - EMPTY
        dsConnectionRequests(new String[]  
            {"08001","08001","08001","08001",
             "08001","08001","08001","08001","08001"}, 
            (ConnectionPoolDataSource)cpds);


        // ConnectionPoolDataSource 
        // - connectionAttributes=databaseName=<valid dbname>
        cpds.setConnectionAttributes("databaseName=" + dbName);
        dsConnectionRequests(new String[]  
            {"08001","08001","08001","08001",
             "08001","08001","08001","08001","08001"},
            (ConnectionPoolDataSource)cpds);
        cpds.setConnectionAttributes(null);


        // Test that database name specified in connection attributes is 
        // not used
        // ConnectionPoolDataSource - databaseName=wombat and 
        // connectionAttributes=databaseName=kangaroo
        cpds.setConnectionAttributes("databaseName=kangaroo");
        cpds.setDatabaseName(dbName);
        dsConnectionRequests(new String[]  
            {"OK","08001","OK","OK","08001","08001","OK","OK","OK"},
            (ConnectionPoolDataSource)cpds);
        cpds.setConnectionAttributes(null);
        cpds.setDatabaseName(null);


        // now with XADataSource
        ClientXADataSource xads = new ClientXADataSource();
        // XADataSource - EMPTY
        dsConnectionRequests(new String[]

View Full Code Here

        
        String retrieveMessageTextProperty = "retrieveMessageText";
        Connection conn;
        // with ConnectionPoolDataSource
        // ConnectionPoolDataSource - retrieveMessageTextProperty
        ClientConnectionPoolDataSource cpds = new ClientConnectionPoolDataSource();
        cpds.setDatabaseName(dbName);
        cpds.setConnectionAttributes(
                retrieveMessageTextProperty + "=false");
        conn = cpds.getConnection();
        assertMessageText(conn,"false");
        conn.close();
        cpds.setConnectionAttributes(
                retrieveMessageTextProperty + "=true");
        conn = cpds.getConnection();
        assertMessageText(conn,"true");
        cpds.setConnectionAttributes(null);
        conn.close();


        // now with XADataSource
        ClientXADataSource xads = new ClientXADataSource();
        //XADataSource - retrieveMessageTextProperty

View Full Code Here

    public void testClientDSConnectionAttributes() throws SQLException {
        if (usingEmbedded())
            return;


        // now with ConnectionPoolDataSource
        ClientConnectionPoolDataSource cpds = 
            new ClientConnectionPoolDataSource();
        cpds.setPortNumber(TestConfiguration.getCurrent().getPort());
        
        // ConnectionPoolDataSource - EMPTY
        dsConnectionRequests(new String[]  
            {"08001","08001","08001","08001",
             "08001","08001","08001","08001","08001"}, 
            (ConnectionPoolDataSource)cpds);


        // ConnectionPoolDataSource 
        // - connectionAttributes=databaseName=<valid dbname>
        cpds.setConnectionAttributes("databaseName=" + dbName);
        dsConnectionRequests(new String[]  
            {"08001","08001","08001","08001",
             "08001","08001","08001","08001","08001"},
            (ConnectionPoolDataSource)cpds);
        cpds.setConnectionAttributes(null);


        // Test that database name specified in connection attributes is 
        // not used
        // ConnectionPoolDataSource - databaseName=wombat and 
        // connectionAttributes=databaseName=kangaroo
        cpds.setConnectionAttributes("databaseName=kangaroo");
        cpds.setDatabaseName(dbName);
        dsConnectionRequests(new String[]  
            {"OK","08001","OK","OK","08001","08001","OK","OK","OK"},
            (ConnectionPoolDataSource)cpds);
        cpds.setConnectionAttributes(null);
        cpds.setDatabaseName(null);


        // now with XADataSource
        ClientXADataSource xads = new ClientXADataSource();
        
        xads.setPortNumber(TestConfiguration.getCurrent().getPort());

View Full Code Here

0 1 2 3

TOP

Related Classes of org.apache.derby.jdbc.ClientConnectionPoolDataSource

org.apache.derby.client.am.LogWriter

org.apache.derby.client.ClientDataSourceFactory

org.apache.derby.client.ClientPooledConnection

org.apache.derbyTesting.functionTests.tests.jdbc4.DataSourceTest

org.apache.derbyTesting.functionTests.tests.jdbcapi.checkDataSource

org.apache.derbyTesting.functionTests.tests.jdbcapi.ClientConnectionPoolDataSourceTest

org.apache.derbyTesting.functionTests.tests.jdbcapi.DataSourceTest

org.apache.derbyTesting.functionTests.tests.jdbcapi.J2EEDataSourceTest

org.talend.esb.datasource.derby.ShutdownDBActivator

javax.sql.PooledConnection

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.