Package org.apache.commons.dbutils.handlers

Examples of org.apache.commons.dbutils.handlers.ArrayHandler

114
115
116
117
118
119
120
121
122
123
124
    {
        Connection con = null;
        try
        {
            con = getConnection();
            return (Object[])new QueryRunner().query(con, sql, new ArrayHandler());
        }
        finally
        {
            JdbcUtils.close(con);
        }
View Full Code Here
67
68
69
70
71
72
73
74
75
76
77
            public boolean isSatisfied()
            {
                try
                {
                    Object[] queryResult = (Object[]) qr.query(jdbcConnector.getConnection(),
                        "SELECT DATA FROM TEST WHERE TYPE = 1 AND ACK IS NULL", new ArrayHandler());
                    // Delivery was successful so row should be acknowledged (marked read).
                    return (queryResult == null);
                }
                catch (Exception e)
                {
View Full Code Here
96
97
98
99
100
101
102
103
104
105
106
            public boolean isSatisfied()
            {
                try
                {
                    Object[] queryResult = (Object[]) qr.query(jdbcConnector.getConnection(),
                        "SELECT DATA FROM TEST WHERE TYPE = 2 AND ACK IS NULL", new ArrayHandler());
                    // Delivery failed so row should not be acknowledged (marked read).
                    return (queryResult != null && queryResult.length == 1);
                }
                catch (Exception e)
                {
View Full Code Here
125
126
127
128
129
130
131
132
133
134
135
            public boolean isSatisfied()
            {
                try
                {
                    Object[] queryResult = (Object[]) qr.query(jdbcConnector.getConnection(),
                        "SELECT DATA FROM TEST WHERE TYPE = 3 AND ACK IS NULL", new ArrayHandler());
                    // Delivery failed so row should not be acknowledged (marked read).
                    return (queryResult != null && queryResult.length == 1);
                }
                catch (Exception e)
                {
View Full Code Here
154
155
156
157
158
159
160
161
162
163
164
            public boolean isSatisfied()
            {
                try
                {
                    Object[] queryResult = (Object[]) qr.query(jdbcConnector.getConnection(),
                        "SELECT DATA FROM TEST WHERE TYPE = 4 AND ACK IS NULL", new ArrayHandler());
                    // Exception occurs after the SEDA queue for an asynchronous request, so from the client's
                    // perspective, the message has been delivered successfully.
                    return (queryResult == null);
                }
                catch (Exception e)
View Full Code Here
42
43
44
45
46
47
48
49
50
51
52
            public boolean isSatisfied()
            {
                try
                {
                    Object[] queryResult = (Object[]) qr.query(jdbcConnector.getConnection(),
                        "SELECT DATA FROM TEST WHERE TYPE = 2 AND ACK IS NULL", new ArrayHandler());
                    // Exception occurs after the SEDA queue for an asynchronous request, so from the client's
                    // perspective, the message has been delivered successfully.
                    // Note that this behavior is different from services because the exception occurs before
                    // the SEDA queue for services.
                    return (queryResult == null);
View Full Code Here
75
76
77
78
79
80
81
82
83
84
85
            public boolean isSatisfied()
            {
                try
                {
                    Object[] queryResult = (Object[]) qr.query(jdbcConnector.getConnection(),
                        "SELECT DATA FROM TEST WHERE TYPE = 3 AND ACK IS NULL", new ArrayHandler());
                    // Exception occurs after the SEDA queue for an asynchronous request, so from the client's
                    // perspective, the message has been delivered successfully.
                    // Note that this behavior is different from services because the exception occurs before
                    // the SEDA queue for services.
                    return (queryResult == null);
View Full Code Here
42
43
44
45
46
47
48
49
50
51
52
            public boolean isSatisfied()
            {
                try
                {
                    Object[] queryResult = (Object[]) qr.query(jdbcConnector.getConnection(),
                        "SELECT DATA FROM TEST WHERE TYPE = 4 AND ACK IS NULL", new ArrayHandler());
                    // Although a component exception occurs after the SEDA queue, the use of transactions
                    // bypasses the SEDA queue, so message should get redelivered.
                    return (queryResult != null && queryResult.length == 1);
                }
                catch (Exception e)
View Full Code Here
36
37
38
39
40
41
42
43
    private ArrayHandler arrayHandler;

    public JdbcObjectStore()
    {
        this.arrayHandler = new ArrayHandler();
        this.maxEntries = -1;
    }
View Full Code Here
50
51
52
53
54
55
56
57
58
59
        MuleClient client = new MuleClient(muleContext);
        client.send("jdbc://writeTest?type=2", new DefaultMuleMessage(TEST_MESSAGE, muleContext));

        QueryRunner qr = jdbcConnector.getQueryRunner();
        Object[] obj2 =
            (Object[]) qr.query(jdbcConnector.getConnection(), "SELECT DATA FROM TEST WHERE TYPE = 2", new ArrayHandler());
        assertNotNull(obj2);
        assertEquals(1, obj2.length);
        assertEquals(TEST_MESSAGE, obj2[0]);
    }
View Full Code Here
TOP

Related Classes of org.apache.commons.dbutils.handlers.ArrayHandler

  • org.apache.commons.dbutils.AsyncQueryRunnerTest
  • org.apache.commons.dbutils.QueryRunnerTest
  • org.mule.test.integration.transport.jdbc.AbstractJdbcFunctionalTestCase
  • org.mule.transport.jdbc.functional.JdbcFunctionalTestCase
  • org.mule.transport.jdbc.reliability.InboundMessageLossFlowTestCase
  • org.mule.transport.jdbc.reliability.InboundMessageLossTestCase
  • org.mule.transport.jdbc.reliability.InboundMessageLossTransactionsTestCase
  • org.mule.transport.jdbc.store.JdbcObjectStore
    • 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.