@Test public void testQueryWithMissingMapParams() { MappingSqlQuery<Integer> query = new MappingSqlQuery<Integer>() { @Override protected Integer mapRow(ResultSet rs, int rownum) throws SQLException { return rs.getInt(1); } }; query.setDataSource(dataSource); query.setSql(SELECT_ID_WHERE); query.declareParameter(new SqlParameter(COLUMN_NAMES[0], COLUMN_TYPES[0])); query.declareParameter(new SqlParameter(COLUMN_NAMES[1], COLUMN_TYPES[1])); query.compile(); thrown.expect(InvalidDataAccessApiUsageException.class); query.executeByNamedParam(Collections.singletonMap(COLUMN_NAMES[0], "value")); }
@Test public void testQueryWithoutEnoughParams() { MappingSqlQuery<Integer> query = new MappingSqlQuery<Integer>() { @Override protected Integer mapRow(ResultSet rs, int rownum) throws SQLException { return rs.getInt(1); } }; query.setDataSource(dataSource); query.setSql(SELECT_ID_WHERE); query.declareParameter(new SqlParameter(COLUMN_NAMES[0], COLUMN_TYPES[0])); query.declareParameter(new SqlParameter(COLUMN_NAMES[1], COLUMN_TYPES[1])); query.compile(); thrown.expect(InvalidDataAccessApiUsageException.class); query.execute(); }
public UserQuery(DataSource ds, String sql) { super(ds, sql); if (sql.equals(USER_QUERY_BY_ID)) { super.declareParameter(new SqlParameter("user id", Types.VARCHAR)); } else if (sql.equals(USER_QUERY_BY_NAME)) { super.declareParameter(new SqlParameter("user name", Types.VARCHAR)); } compile(); }
IncrementerValueQuery(DataSource ds) { super(ds, "SELECT SEQ_VL FROM UP_SEQ WHERE SEQ_NM=?"); super.declareParameter(new SqlParameter(Types.VARCHAR)); compile(); }
"SELECT * FROM plugin_configuration WHERE tenantId = ? AND assocTypeId = ? AND pluginId = ? AND " + "pluginVersion = ? AND name = ?", pluginRegistry); readConfiguration.declareParameter(new SqlParameter("tenantId", Types.INTEGER)); readConfiguration.declareParameter(new SqlParameter("assocTypeId", Types.INTEGER)); readConfiguration.declareParameter(new SqlParameter("pluginId", Types.VARCHAR)); readConfiguration.declareParameter(new SqlParameter("pluginVersion", Types.VARCHAR)); readConfiguration.declareParameter(new SqlParameter("name", Types.VARCHAR)); readConfiguration.compile(); "SELECT * FROM plugin_configuration WHERE tenantId = ? AND assocTypeId = ? AND pluginId = ? AND " + "pluginVersion = ?", pluginRegistry); readConfigurations.declareParameter(new SqlParameter("tenantId", Types.INTEGER)); readConfigurations.declareParameter(new SqlParameter("assocTypeId", Types.INTEGER)); readConfigurations.declareParameter(new SqlParameter("pluginId", Types.VARCHAR)); readConfigurations.declareParameter(new SqlParameter("pluginVersion", Types.VARCHAR)); readConfigurations.compile(); "SELECT * FROM plugin_configuration WHERE tenantId = ? AND assocTypeId = ? AND active = b'1'", pluginRegistry); readActiveConfiguration.declareParameter(new SqlParameter("tenantId", Types.INTEGER)); readActiveConfiguration.declareParameter(new SqlParameter("assocTypeId", Types.INTEGER)); readActiveConfiguration.compile();
QUERY_GET_ITEMIDS.declareParameter(new SqlParameter("tenantId1", Types.INTEGER)); QUERY_GET_ITEMIDS.declareParameter(new SqlParameter("item1TypeId", Types.INTEGER)); QUERY_GET_ITEMIDS.declareParameter(new SqlParameter("tenantId2", Types.INTEGER)); QUERY_GET_ITEMIDS.declareParameter(new SqlParameter("item2TypeId", Types.INTEGER)); QUERY_GET_ITEMIDS.compile();