Package org.apache.derby.jdbc

Examples of org.apache.derby.jdbc.ClientConnectionPoolDataSourceInterface

2713
2714
2715
2716
2717
2718
2719
2720
2721
2722
2723
2724
2725
2726
2727
2728
2729
2730
2731
2732
2733
2734
2735
2736
2737
2738
2739
2740
2741
2742
2743
2744
2745
2746
2747
2748
2749
2750
2751
2752
2753
2754
2755
2756
2757
2758
2759
2760
2761
2762
            IllegalAccessException, InstantiationException {
        if (usingEmbedded())
            return;

        // now with ConnectionPoolDataSource
        ClientConnectionPoolDataSourceInterface cpds;

        if (JDBC.vmSupportsJNDI()) {
            cpds = (ClientConnectionPoolDataSourceInterface)Class.forName(
               "org.apache.derby.jdbc.ClientConnectionPoolDataSource").
                    newInstance();
        } else {
            cpds = (ClientConnectionPoolDataSourceInterface)Class.forName(
               "org.apache.derby.jdbc.BasicClientConnectionPoolDataSource40").
                    newInstance();
        }

        cpds.setPortNumber(TestConfiguration.getCurrent().getPort());
       
        // ConnectionPoolDataSource - EMPTY
        dsCPConnectionRequests(new String[]
            {"08001","08001","08001","08001",
             "08001","08001","08001","08001","08001"},
            cpds);

        // ConnectionPoolDataSource
        // - connectionAttributes=databaseName=<valid dbname>
        cpds.setConnectionAttributes("databaseName=" + dbName);
        dsCPConnectionRequests(new String[]
            {"08001","08001","08001","08001",
             "08001","08001","08001","08001","08001"},
            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);
        dsCPConnectionRequests(new String[]
            {"OK","08001","OK","OK","08001","08001","OK","OK","OK"},
            cpds);
        cpds.setConnectionAttributes(null);
        cpds.setDatabaseName(null);

        // now with XADataSource
        ClientXADataSourceInterface xads;
       
        if (JDBC.vmSupportsJNDI()) {
View Full Code Here
3048
3049
3050
3051
3052
3053
3054
3055
3056
3057
3058
3059
3060
3061
3062
3063
3064
3065
3066
3067
3068
3069
3070
3071
3072
3073
3074
3075
3076
3077
3078
3079
3080
3081
3082
            InstantiationException
    {
        String retrieveMessageTextProperty = "retrieveMessageText";
        // with ConnectionPoolDataSource
        // ConnectionPoolDataSource - retrieveMessageTextProperty
        ClientConnectionPoolDataSourceInterface cpds;

        if (JDBC.vmSupportsJNDI()) {
            cpds = (ClientConnectionPoolDataSourceInterface)Class.forName(
               "org.apache.derby.jdbc.ClientConnectionPoolDataSource").
                    newInstance();
        } else {
            cpds = (ClientConnectionPoolDataSourceInterface)Class.forName(
               "org.apache.derby.jdbc.BasicClientConnectionPoolDataSource40").
                    newInstance();
        }

        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
        ClientXADataSourceInterface xads;
        if (JDBC.vmSupportsJNDI()) {
View Full Code Here
2728
2729
2730
2731
2732
2733
2734
2735
2736
2737
2738
2739
2740
2741
2742
2743
2744
2745
2746
2747
2748
2749
2750
2751
2752
2753
2754
2755
2756
2757
2758
2759
2760
2761
2762
2763
2764
2765
2766
2767
2768
2769
2770
2771
2772
2773
2774
2775
2776
2777
            IllegalAccessException, InstantiationException {
        if (usingEmbedded())
            return;

        // now with ConnectionPoolDataSource
        ClientConnectionPoolDataSourceInterface cpds;

        if (JDBC.vmSupportsJNDI()) {
            cpds = (ClientConnectionPoolDataSourceInterface)Class.forName(
               "org.apache.derby.jdbc.ClientConnectionPoolDataSource").
                    newInstance();
        } else {
            cpds = (ClientConnectionPoolDataSourceInterface)Class.forName(
               "org.apache.derby.jdbc.BasicClientConnectionPoolDataSource40").
                    newInstance();
        }

        cpds.setPortNumber(TestConfiguration.getCurrent().getPort());
       
        // ConnectionPoolDataSource - EMPTY
        dsCPConnectionRequests(new String[]
            {"08001","08001","08001","08001",
             "08001","08001","08001","08001","08001"},
            cpds);

        // ConnectionPoolDataSource
        // - connectionAttributes=databaseName=<valid dbname>
        cpds.setConnectionAttributes("databaseName=" + dbName);
        dsCPConnectionRequests(new String[]
            {"08001","08001","08001","08001",
             "08001","08001","08001","08001","08001"},
            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);
        dsCPConnectionRequests(new String[]
            {"OK","08001","OK","OK","08001","08001","OK","OK","OK"},
            cpds);
        cpds.setConnectionAttributes(null);
        cpds.setDatabaseName(null);

        // now with XADataSource
        ClientXADataSourceInterface xads;
       
        if (JDBC.vmSupportsJNDI()) {
View Full Code Here
3066
3067
3068
3069
3070
3071
3072
3073
3074
3075
3076
3077
3078
3079
3080
3081
3082
3083
3084
3085
3086
3087
3088
3089
3090
3091
3092
3093
3094
3095
3096
3097
3098
3099
3100
            InstantiationException
    {
        String retrieveMessageTextProperty = "retrieveMessageText";
        // with ConnectionPoolDataSource
        // ConnectionPoolDataSource - retrieveMessageTextProperty
        ClientConnectionPoolDataSourceInterface cpds;

        if (JDBC.vmSupportsJNDI()) {
            cpds = (ClientConnectionPoolDataSourceInterface)Class.forName(
               "org.apache.derby.jdbc.ClientConnectionPoolDataSource").
                    newInstance();
        } else {
            cpds = (ClientConnectionPoolDataSourceInterface)Class.forName(
               "org.apache.derby.jdbc.BasicClientConnectionPoolDataSource40").
                    newInstance();
        }

        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
        ClientXADataSourceInterface xads;
        if (JDBC.vmSupportsJNDI()) {
View Full Code Here
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
    /**
     * Verify that handling of the {@code maxStatements} property is working.
     */
    public void testMaxStatementsProperty() throws Exception {
        ClientConnectionPoolDataSourceInterface cDs;

        if (JDBC.vmSupportsJNDI()) {
            cDs = (ClientConnectionPoolDataSourceInterface)Class.forName(
                "org.apache.derby.jdbc.ClientConnectionPoolDataSource")
                    .newInstance();
        } else {
            cDs = (ClientConnectionPoolDataSourceInterface)Class.forName(
                "org.apache.derby.jdbc.BasicClientConnectionPoolDataSource40")
                    .newInstance();
        }
        // 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
86
87
88
89
90
91
92
93
94
95
96
97
98
     *
     * @throws SQLException if database operations fail
     */
    public void testGetConnectionNoStatementPooling()
            throws SQLException {
        ClientConnectionPoolDataSourceInterface cDs =
            (ClientConnectionPoolDataSourceInterface)J2EEDataSource.
                getConnectionPoolDataSource();
        // Make sure statement pooling is disabled.
        cDs.setMaxStatements(0);
        assertEquals(0, cDs.getMaxStatements());
        verifyConnection(cDs);
    }
View Full Code Here
103
104
105
106
107
108
109
110
111
112
113
114
115
     *
     * @throws SQLException if database operations fail
     */
    public void testGetConnectionWithStatementPooling()
            throws SQLException {
        ClientConnectionPoolDataSourceInterface cDs =
            (ClientConnectionPoolDataSourceInterface)J2EEDataSource.
                getConnectionPoolDataSource();
        // Enable statement pooling.
        cDs.setMaxStatements(27);
        assertTrue(cDs.getMaxStatements() > 0);
        verifyConnection(cDs);
    }
View Full Code Here
TOP

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

  • org.apache.derbyTesting.functionTests.tests.jdbcapi.ClientConnectionPoolDataSourceTest
  • org.apache.derbyTesting.functionTests.tests.jdbcapi.J2EEDataSourceTest
    • Copyright © 2018 www.massapicom. 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.