Examples of org.springframework.jdbc.core.JdbcTemplate$RowCallbackHandlerResultSetExtractor

org.springframework.jdbc.core.JdbcTemplate
Adapter to enable use of a RowCallbackHandler inside a ResultSetExtractor.
Uses a regular ResultSet, so we have to be careful when using it: We don't use it for navigating since this could lead to unpredictable consequences.

    this.sql = sql;
  }


  public void setDataSource(DataSource dataSource) {
    if (null != dataSource) {
      jdbcTemplate = new JdbcTemplate(dataSource);
    } else {
      jdbcTemplate = null;
    }
  }

View Full Code Here

  private final int initCode = 0;
  
  protected JdbcTemplate jdbcTemplate = null;
  
  public DefaultUniqueTableApp(DataSource dataSource) {
    jdbcTemplate = new JdbcTemplate(dataSource);
    
    this.selectSQL = "SELECT code FROM WF_PRIMARYKEY WHERE name = ? ";
    this.updateSQL = "UPDATE WF_PRIMARYKEY SET code = code + ? WHERE name = ? ";
    this.insertSQL = "INSERT INTO WF_PRIMARYKEY (code, name) VALUES (?, ?)";
  }

View Full Code Here

import org.springframework.jdbc.core.JdbcTemplate;


@Ignore
public class TestUtil {
  public static void cleanData(ApplicationContext applicationContext) {
    JdbcTemplate jdbcTemplate = (JdbcTemplate)applicationContext.getBean(JdbcTemplate.class);
    jdbcTemplate.update("delete from WF_ACTIVITYINST");
    jdbcTemplate.update("delete from WF_PARTICIPANT");
    jdbcTemplate.update("delete from WF_PRIMARYKEY where name in ('processDefId', 'processInstId'," +
        "'activityInstId', 'workItemId', 'participantId', 'transCtrlId')");
    jdbcTemplate.update("delete from WF_PROCESSDEFINE");
    jdbcTemplate.update("delete from WF_PROCESSINST");
    jdbcTemplate.update("delete from WF_WORKITEM");
    jdbcTemplate.update("delete from WF_PROCESSDEFINE");
    jdbcTemplate.update("delete from WF_TRANSCTRL");
  }

View Full Code Here

   * 
   * @param dataSource
   *          the datasource to which the JdbcPreferenceStore is persisted.
   */
  public void setDataSource(DataSource dataSource) {
    jdbcTemplate = new JdbcTemplate(dataSource);
  }

View Full Code Here

        super.resetRestTemplate();
    }


    @Test
    public void createWithApproval() {
        JdbcTemplate jdbcTemplate = new JdbcTemplate(testDataSource);


        UserTO userTO = getSampleTO("createWithApproval@syncope.apache.org");
        userTO.addResource("resource-testdb");


        // User with role 9 are defined in workflow as subject to approval
        MembershipTO membershipTO = new MembershipTO();
        membershipTO.setRoleId(9L);
        userTO.addMembership(membershipTO);


        // 1. create user with role 9 (and verify that no propagation occurred)
        userTO = restTemplate.postForObject(BASE_URL + "user/create", userTO, UserTO.class);
        assertNotNull(userTO);
        assertEquals(1, userTO.getMemberships().size());
        assertEquals(9, userTO.getMemberships().get(0).getRoleId());
        assertEquals("createApproval", userTO.getStatus());
        assertEquals(Collections.singleton("resource-testdb"), userTO.getResources());


        assertTrue(userTO.getPropagationTOs().isEmpty());


        Exception exception = null;
        try {
            jdbcTemplate.queryForInt("SELECT id FROM test WHERE id=?", userTO.getUsername());
        } catch (EmptyResultDataAccessException e) {
            exception = e;
        }
        assertNotNull(exception);


        // 2. request if there is any pending task for user just created
        WorkflowFormTO form = restTemplate.getForObject(BASE_URL + "user/workflow/form/{userId}", WorkflowFormTO.class,
                userTO.getId());
        assertNotNull(form);
        assertNotNull(form.getTaskId());
        assertNull(form.getOwner());


        // 4. claim task (from admin)
        form = restTemplate.getForObject(BASE_URL + "user/workflow/form/claim/{taskId}", WorkflowFormTO.class, form.
                getTaskId());
        assertNotNull(form);
        assertNotNull(form.getTaskId());
        assertNotNull(form.getOwner());


        // 5. approve user (and verify that propagation occurred)
        Map<String, WorkflowFormPropertyTO> props = form.getPropertyMap();
        props.get("approve").setValue(Boolean.TRUE.toString());
        form.setProperties(props.values());
        userTO = restTemplate.postForObject(BASE_URL + "user/workflow/form/submit", form, UserTO.class);
        assertNotNull(userTO);
        assertEquals("active", userTO.getStatus());
        assertEquals(Collections.singleton("resource-testdb"), userTO.getResources());


        exception = null;
        try {
            final String username = jdbcTemplate.queryForObject("SELECT id FROM test WHERE id=?", String.class, userTO.
                    getUsername());
            assertEquals(userTO.getUsername(), username);
        } catch (EmptyResultDataAccessException e) {
            exception = e;
        }

View Full Code Here

        userTO.addResource("resource-testdb");


        userTO = restTemplate.postForObject(BASE_URL + "user/create", userTO, UserTO.class);
        assertNotNull(userTO);


        JdbcTemplate jdbcTemplate = new JdbcTemplate(testDataSource);


        String username = jdbcTemplate.queryForObject("SELECT id FROM test WHERE id=?", String.class,
                userTO.getUsername());


        assertEquals(userTO.getUsername(), username);


        UserMod userMod = new UserMod();


        userMod.setId(userTO.getId());
        userMod.addResourceToBeRemoved("resource-testdb");


        userTO = restTemplate.postForObject(BASE_URL + "user/update", userMod, UserTO.class);


        assertTrue(userTO.getResources().isEmpty());


        jdbcTemplate.queryForObject("SELECT id FROM test WHERE id=?", String.class, userTO.getUsername());
    }

View Full Code Here


    public static final String CONTENT_XML = "content.xml";


    @Transactional
    public void load() {
        JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);


        boolean existingData;
        try {
            existingData = jdbcTemplate.queryForObject("SELECT COUNT(0) FROM " + SyncopeConf.class.getSimpleName(),
                    Integer.class) > 0;
        } catch (DataAccessException e) {
            LOG.error("Could not access to table " + SyncopeConf.class.getSimpleName(), e);
            existingData = true;
        }

View Full Code Here


    @Test
    public void createWithApproval() {
        Assume.assumeTrue(ActivitiDetector.isActivitiEnabledForUsers());


        JdbcTemplate jdbcTemplate = new JdbcTemplate(testDataSource);


        UserTO userTO = getUniqueSampleTO("createWithApproval@syncope.apache.org");
        userTO.addResource(RESOURCE_NAME_TESTDB);


        // User with role 9 are defined in workflow as subject to approval
        MembershipTO membershipTO = new MembershipTO();
        membershipTO.setRoleId(9L);
        userTO.addMembership(membershipTO);


        // 1. create user with role 9 (and verify that no propagation occurred)
        userTO = createUser(userTO);
        assertNotNull(userTO);
        assertEquals(1, userTO.getMemberships().size());
        assertEquals(9, userTO.getMemberships().get(0).getRoleId());
        assertEquals("createApproval", userTO.getStatus());
        assertEquals(Collections.singleton(RESOURCE_NAME_TESTDB), userTO.getResources());


        assertTrue(userTO.getPropagationStatusTOs().isEmpty());


        Exception exception = null;
        try {
            jdbcTemplate.queryForObject("SELECT id FROM test WHERE id=?",
                    new String[]{userTO.getUsername()}, Integer.class);
        } catch (EmptyResultDataAccessException e) {
            exception = e;
        }
        assertNotNull(exception);


        // 2. request if there is any pending form for user just created
        List<WorkflowFormTO> forms = userWorkflowService.getForms();
        assertNotNull(forms);
        assertEquals(1, forms.size());


        WorkflowFormTO form = userWorkflowService.getFormForUser(userTO.getId());
        assertNotNull(form);
        assertNotNull(form.getTaskId());
        assertNull(form.getOwner());


        // 4. claim task (from admin)
        form = userWorkflowService.claimForm(form.getTaskId());
        assertNotNull(form);
        assertNotNull(form.getTaskId());
        assertNotNull(form.getOwner());


        // 5. approve user (and verify that propagation occurred)
        Map<String, WorkflowFormPropertyTO> props = form.getPropertyMap();
        props.get("approve").setValue(Boolean.TRUE.toString());
        form.setProperties(props.values());
        userTO = userWorkflowService.submitForm(form);
        assertNotNull(userTO);
        assertEquals("active", userTO.getStatus());
        assertEquals(Collections.singleton(RESOURCE_NAME_TESTDB), userTO.getResources());


        exception = null;
        try {
            final String username = jdbcTemplate.queryForObject("SELECT id FROM test WHERE id=?", String.class,
                    userTO.getUsername());
            assertEquals(userTO.getUsername(), username);
        } catch (EmptyResultDataAccessException e) {
            exception = e;
        }

View Full Code Here


        userTO = createUser(userTO);
        assertNotNull(userTO);
        assertEquals(1, userTO.getResources().size());


        JdbcTemplate jdbcTemplate = new JdbcTemplate(testDataSource);


        String username = jdbcTemplate.queryForObject("SELECT id FROM test WHERE id=?", String.class,
                userTO.getUsername());


        assertEquals(userTO.getUsername(), username);


        UserMod userMod = new UserMod();


        userMod.setId(userTO.getId());
        userMod.addResourceToBeRemoved(RESOURCE_NAME_TESTDB);


        userTO = userService.update(userMod.getId(), userMod);


        assertTrue(userTO.getResources().isEmpty());


        jdbcTemplate.queryForObject("SELECT id FROM test WHERE id=?", String.class, userTO.getUsername());
    }

View Full Code Here

        actual = userService.read(actual.getId());
        assertEquals("virattrcache", actual.getVirtualAttributeMap().get("virtualdata").getValues().get(0));


        Exception exception = null;
        try {
            final JdbcTemplate jdbcTemplate = new JdbcTemplate(testDataSource);


            String value = jdbcTemplate.queryForObject(
                    "SELECT USERNAME FROM testsync WHERE ID=?", String.class, actual.getId());
            assertEquals("virattrcache", value);


            jdbcTemplate.update("UPDATE testsync set USERNAME='virattrcache2' WHERE ID=?", userTO.getId());


            value = jdbcTemplate.queryForObject(
                    "SELECT USERNAME FROM testsync WHERE ID=?", String.class, userTO.getId());
            assertEquals("virattrcache2", value);


        } catch (EmptyResultDataAccessException e) {
            exception = e;

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.springframework.jdbc.core.JdbcTemplate$RowCallbackHandlerResultSetExtractor

ch.inftec.ju.db.DbSpecificHandlerDefault

ch.inftec.ju.db.DbSpecificHandlerMySql

ch.inftec.ju.db.DbSpecificHandlerOracle

ch.inftec.ju.db.JuConnUtils

com.alibaba.otter.node.etl.common.db.DbDialectTest

com.alibaba.otter.node.etl.load.loader.db.DbLoadAction$DbLoadWorker

com.bank.repository.internal.JdbcAccountRepository

com.bank.service.TransferServiceTests

com.github.hakko.musiccabinet.dao.jdbc.JdbcDatabaseAdministrationDao

com.github.hakko.musiccabinet.dao.util.PostgreSQLUtil

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.