Package org.springframework.jdbc.core

Examples of org.springframework.jdbc.core.PreparedStatementCreatorFactory$PreparedStatementCreatorImpl

8
9
10
11
12
13
14
   * @param sql
   * @param types
   * @return
   */
  public static PreparedStatementCreatorFactory newStmtCreatorFactory(String sql, int... types) {
    return new PreparedStatementCreatorFactory(sql, types);
  }
View Full Code Here
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
  public Node create(Node newObject) {
    KeyHolder generatedKey = new GeneratedKeyHolder();
    JdbcTemplate j = getJdbcTemplate();
   
    PreparedStatementCreatorFactory creatorFactory =
      new PreparedStatementCreatorFactory(insertSql(),getTypes());
    creatorFactory.setReturnGeneratedKeys(true);
   
    int rows = j.update(creatorFactory.newPreparedStatementCreator(getParameters(newObject)), generatedKey);
    if (rows != 1)
      throw new HiveRuntimeException("Unable to create Resource: "
          + getParameters(newObject));
    if (generatedKey.getKeyList().size() == 0)
      throw new HiveRuntimeException("Unable to retrieve generated primary key");
View Full Code Here
80
81
82
83
84
85
86
87
88
89
90
91
92
    Lists.copyInto(getParameters(node), params);
    Lists.copyInto(getTypes(), types);
    params[params.length-1] = node.getId();
    types[types.length-1] = Types.INTEGER;
   
    PreparedStatementCreatorFactory creatorFactory = new PreparedStatementCreatorFactory(updateSql(),types);
   
    int rows = j.update(creatorFactory.newPreparedStatementCreator(params));
    if (rows != 1)
      throw new HiveRuntimeException("Unable to update node with id: " + node.getId());
   
    return node;
  }
View Full Code Here
93
94
95
96
97
98
99
100
101
102
103
104
105
106
 
  public Node delete(Node node) {
    Object[] parameters = new Object[] { node.getId()};
   
    JdbcTemplate j = getJdbcTemplate();
    PreparedStatementCreatorFactory creatorFactory = new PreparedStatementCreatorFactory(
        "DELETE from node_metadata where id=?",
        new int[] { Types.INTEGER });
    int rows = j.update(creatorFactory
        .newPreparedStatementCreator(parameters));
    if (rows != 1)
      throw new HiveRuntimeException("Unable to delete node for id: " + node.getId());
    return node;
  }
View Full Code Here
69
70
71
72
73
74
75
76
77
78
79
80
81
    return (Integer) directory.newTransaction().execute(new TransactionCallback() {
      public Object doInTransaction(TransactionStatus arg0) {
        Integer rowsAffected = 0;
        for (SecondaryIndex secondaryIndex : resource.getSecondaryIndexes()) {
          PreparedStatementCreatorFactory deleteIndexFactory =
            Statements.newStmtCreatorFactory(sql.deleteAllSecondaryIndexKeysForResourceId(secondaryIndex), resource.getColumnType());
          rowsAffected += getJdbcTemplate().update(deleteIndexFactory.newPreparedStatementCreator(parameters));
        }
        return rowsAffected;
      }
    });
  }
View Full Code Here
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
    //While it is possible to write a record to multiple locations within the Hive, the default implementation
    //inserts a single copy.
    hive.directory().insertPrimaryIndexKey(spork.getType());
    //Next we insert the record into the assigned data node
    Collection<SimpleJdbcDaoSupport> sporkDaos = hive.connection().daoSupport().get(spork.getType(), AccessType.ReadWrite);
    PreparedStatementCreatorFactory stmtFactory =
      new PreparedStatementCreatorFactory(productInsertSql, new int[]{Types.INTEGER, Types.VARCHAR, Types.VARCHAR});
    Object[] parameters = new Object[]{spork.getId(), spork.getName(), spork.getType()};
    for (JdbcDaoSupport dao : sporkDaos)
      dao.getJdbcTemplate().update(stmtFactory.newPreparedStatementCreator(parameters));

    //Update the resource id so that the hive can locate it
    hive.directory().insertResourceId(resourceName, spork.getId(), spork.getType());
    //Finally we update the SecondaryIndex
    hive.directory().insertSecondaryIndexKey(resourceName, "name", spork.getName(), spork.getId());
View Full Code Here
261
262
263
264
265
266
267
268
269
270
271
272
273
274
     
      ParsedSql parsedSql1 = this.getParsedSql(sql).getDelegate();
      String sqlToUse1 = NamedParameterUtils.substituteNamedParameters(parsedSql1, paramSource);
      Object[] params = NamedParameterUtils.buildValueArray(parsedSql1, paramSource, null);
      List<SqlParameter> declaredParameters = NamedParameterUtils.buildSqlParameterList(parsedSql1, paramSource);
      PreparedStatementCreatorFactory pscf = new PreparedStatementCreatorFactory(sqlToUse1, declaredParameters);
      pscf.setResultSetType( ResultSet.TYPE_FORWARD_ONLY );
      pscf.setUpdatableResults(false);
      PreparedStatementCreator preparedStatementCreator = pscf.newPreparedStatementCreator(params);
     
      //con.prepareStatement(theSql, ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
     
      preparedStatement = preparedStatementCreator.createPreparedStatement(con);
      this.rs = preparedStatement.executeQuery();
View Full Code Here
TOP

Related Classes of org.springframework.jdbc.core.PreparedStatementCreatorFactory$PreparedStatementCreatorImpl

  • com.alexkasko.springjdbc.parallel.CancellableStatementCreator
  • com.danidemi.jlubricant.springbatch.NamedJdbcCursorItemReader
  • com.pv.mf.db.mock.entity.DefaultEntityHandler
  • com.springsource.greenhouse.events.load.JdbcEventLoaderRepository
  • org.hivedb.ExampleHiveTest
  • org.hivedb.meta.directory.BatchIndexWriter
  • org.hivedb.meta.persistence.NodeDao
  • org.hivedb.meta.persistence.PartitionDimensionDao
  • org.hivedb.meta.persistence.ResourceDao
  • org.hivedb.meta.persistence.SecondaryIndexDao
    • 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.