<class name="my.com.Report" table="IREPORT" where="STATUS=1">
public final class HSQLSchemaCreator implements InitializingBean {
/**
* schema name.
*/
private String schema;
/**
* data source.
*/
private DataSource dataSource;
// setters and getters
public String getSchema() {
return schema;
}
public void setSchema(String schema) {
this.schema = schema;
}
public DataSource getDataSource() {
return dataSource;
}
public void setDataSource(DataSource dataSource) {
this.dataSource = dataSource;
}
/**
* Create schema.
* @throws Exception any exception
*/
public void afterPropertiesSet() throws Exception {
JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
jdbcTemplate.execute("CREATE SCHEMA " + schema + " AUTHORIZATION DBA");
}
}
<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"
depends-on="hsqlSchemaCreator">
...
</bean>
<bean id="hsqlSchemaCreator" class="com.guident.skills.util.HSQLSchemaCreator">
<property name="dataSource" ref="dataSource" />
<property name="schema" value="MY_SCHEMA" />
</bean>
<hibernate-mapping>
<class>
...
</class>
<database-object>
<create>
[CREATE statement]
</create>
<drop>
[DROP statement]
</drop>
<dialect-scope name="org.hibernate.dialect.HSQLDialect" />
</database-object>
</hibernate-mapping>
/**
* Setup.
*/
@Before
public void setUp() {
// ...
}
<property name="birthday" type="date" formula="trunc(BIRTHDAY)"><column length="20" name="BIRTHDAY"/></property>
<spring:bind path="labelChanges.details">
<select id="detailFilter" name="${status.expression}" multiple="multiple" class="searchFilter">
<c:forEach var="item" items="${labelChangeMitigationDetails}">
<c:forEach items="${status.value}" var="currentItem">
<c:if test="${currentItem == item.value}">
<c:set var="selected" value="true"/>
</c:if>
</c:forEach>
<option value="${item.value}"
<c:if test="${selected}">selected="selected"</c:if>>
<c:out value="${item.key}" />
</option>
<c:remove var="selected"/>
</c:forEach>
</select>
</spring:bind>
<input type="hidden" name="_details" value="1"/>
<form:select id="statusFilter" cssClass="searchFilter"
path="statuses"
items="${labelChangeStatuses}"
itemValue="lcStatusRefSeq"
itemLabel="lcStatusName"
multiple="true" />
</td>
$("input:[name^='abc']")
$('input:checkbox.non-draft-status:checked')
$('td').find('.data4Sort')
Suppose you extends AbstractTransactionalJUnit4SpringContextTests but you have multiple datasource beans. When the context is loaded, Spring will complain that it could not setDatasource() for AbstractTransactionalJUnit4SpringContext because there is more than one bean with the type.
The solution is described here in Spring Docs.
If you are extending from a Spring-provided test base class that happens to use @Autowired on one of its setters methods, you might have multiple beans of the affected type defined in your application context: e.g. multiple DataSource beans. In such a case, you may override the setter and use the @Qualifier annotation to indicate a specific target bean as follows:
...
@Override @Autowired
public void setDataSource(@Qualifier("myDataSource") DataSource dataSource) {
super.setDataSource(dataSource);
}
...
Posts
All Comments
