Package org.jboss.soa.esb.helpers.persist

Examples of org.jboss.soa.esb.helpers.persist.JdbcCleanConn

88
89
90
91
92
93
94
95
96
97
98
      _logger.info("@Starting HSQL database");
        try
        {
          Class.forName(mDbDriver);
            server = HsqldbUtil.startHsqldb(_dbFileName, "defaultReplyEprDB");
            _dbConn = new JdbcCleanConn
          (new SimpleDataSource(mDbDriver,mDbUrl,mDbUsername,mDbPassword));
            createMessageTable("foo");
            createMessageTable("foo_reply_table");
        }
        catch (Exception e)
View Full Code Here
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
        }
    } // ________________________________

    protected List<Map<String, Object>> pollForCandidates() {
        List<Map<String, Object>> oResults = new ArrayList<Map<String, Object>>();
        final JdbcCleanConn oConn = getDbConn();
       
        ResultSet RS = null;
       
        try {
            RS = oConn.execQueryWait(_PSscan, 1);
            ResultSetMetaData meta = RS.getMetaData();
            while (RS.next()) {
                Map<String, Object> row = new HashMap<String, Object>();
                for (int iCurr = 1; iCurr <= meta.getColumnCount(); iCurr++) {
                    String sCol = meta.getColumnName(iCurr);
                    if (!_inProcessField.equalsIgnoreCase(sCol)) {
                        final int type = meta.getColumnType(iCurr) ;
                        if (type == Types.BLOB) {
                            final Blob blob = RS.getBlob(iCurr) ;
                            row.put(sCol, ((blob != null) ? StreamUtils.readStreamString(blob.getBinaryStream(), "UTF-8") : null));
                        } else if (type == Types.CLOB) {
                            final Clob clob = RS.getClob(iCurr) ;
                            row.put(sCol, ((clob != null) ? StreamUtils.readReader(clob.getCharacterStream()) : null));
                        } else {
                            row.put(sCol, RS.getObject(iCurr));
                        }
                    }
                }

                oResults.add(row);
            }
        }
        catch (Exception e) {
            _logger.debug("Some triggers might not have been returned", e);
        }
        finally {
            try {
          if (RS != null)
              RS.close();
         
                oConn.rollback();
            } catch (final SQLException sqle) {
              refreshDatasource();
            }
        }
        if (_logger.isDebugEnabled()) {
View Full Code Here
561
562
563
564
565
566
567
568
569
570
571
           * Create JdbcCleanConn even if oDS is null because that will
           * manage the error handling for us by throwing SQLExceptions
           * at the appropriate time.
           */
         
          _dbConn = new JdbcCleanConn(oDS, transacted);
        }
     
        if ((null != _dbConn) && (_dbConn.getStatements().size() == 0)) {
          try {
        prepareStatements();       
View Full Code Here
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
        } else {
            content = obj.toString();
        }
       
    m_oCols.setProperty(m_sDataCol, content);
    JdbcCleanConn oConn = null;
    PreparedStatement ps = null;
    try
    {
      oConn = createJdbcCleanConnection();
      ps = oConn.prepareStatement(getInsertStmt());
      oConn.execUpdWait(ps, 3); // TODO the executeUpdate routine doesn't check return code, which could mask a problem https://jira.jboss.org/jira/browse/SOA-642                 
      // TODO the executeUpdate routine doesn't check return code, which could mask a problem https://jira.jboss.org/jira/browse/SOA-642
      oConn.commit();
    }
    catch( SQLException e)
    {
      final String errorMsg = "SqlException while trying to notify table. Insert statement : " + getInsertStmt();
      log.error( errorMsg , e );
      throw new NotificationException( errorMsg, e);
    }
    finally
    {
      if ( ps != null )
      {
        try
        {
          ps.close();
        }
        catch (SQLException e)
        {
          log.error( "SqlException while trying to close prepared statement PS", e );
        }
      }
      if (null != oConn)
      {
        oConn.release();
      }
    }
  } // __________________________________
View Full Code Here
199
200
201
202
203
204
205
  /*
   * extracted this method to simplify testing. DanielB
   */
  protected JdbcCleanConn createJdbcCleanConnection()
  {
    return new JdbcCleanConn(new SimpleDataSource(m_sDriver, m_sURL, m_sUser, m_sPwd));
  }
View Full Code Here
142
143
144
145
146
147
148
149
150
151
152
   
    gateway = new SqlTableGatewayListener(tree);
   
    try
    {
      JdbcCleanConn conn = gateway.getDbConn();
      gateway.prepareStatements();
    }
    catch (RuntimeException ex)
    {
      log.error(ex);
View Full Code Here
140
141
142
143
144
145
146
147
148
149
150
   
    gateway = new SqlTableGatewayListener(tree);
   
    try
    {
      JdbcCleanConn conn = gateway.getDbConn();
      gateway.prepareStatements();
    }
    catch (RuntimeException ex)
    {
      log.error(ex);
View Full Code Here
TOP

Related Classes of org.jboss.soa.esb.helpers.persist.JdbcCleanConn

  • org.jboss.soa.esb.addressing.eprs.tests.DefaultJdbcReplyToEprUnitTest
  • org.jboss.soa.esb.listeners.gateway.SqlTableGatewayListener
  • org.jboss.soa.esb.listeners.gateway.SqlTableGatewayListenerOptionalUnitTest
  • org.jboss.soa.esb.listeners.gateway.SqlTableGatewayListenerUnitTest
  • org.jboss.soa.esb.notification.NotifySqlTable
  • java.sql.PreparedStatement
  • java.sql.SQLException
    • 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.