topic Re: Connect External Databse in Alfresco Forum

Connect External Databse

sp2 — Wed, 15 Aug 2018 11:10:14 GMT

I am trying to connect external database from alfresco to get constraint like below way.<bean id="DataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName" value="${jdbcDriver}" /> <property name="url" value="${jdbcUr

Re: Connect External Databse

afaust — Wed, 15 Aug 2018 11:33:32 GMT

How did you register that constraint with the model? Did you use the class name as the type of the constraint in the data model? Then that is the cause for the problem - when you use the class name as the type, the class is instantiated using the default constructor without any parameters passed into it. So instead of using your defined bean, it uses an unitialized instance where of course the field for your DAO is null. You need to use a registered constraint to reference your Spring bean.

Re: Connect External Databse

sp2 — Wed, 15 Aug 2018 11:51:01 GMT

Like this way,

Re: Connect External Databse

sp2 — Wed, 15 Aug 2018 11:51:51 GMT

How to use registered constraint ? Can you Give me some idea?

Re: Connect External Databse

afaust — Wed, 15 Aug 2018 12:34:17 GMT

See the Alfresco code for smart folders:

Re: Connect External Databse

sp2 — Wed, 15 Aug 2018 13:30:36 GMT

Hi,

I have defined constraint as per above link but it is giving me error.

Bean :

Constraint :

<constraint name="mbs:batchTypeAspectList"
type="REGISTERED">
<parameter name="registeredName">
<value>batchType</value>
</parameter>
</constraint>

Error :

There is no constraint registered by name 'batchType'.

Re: Connect External Databse

sp2 — Wed, 15 Aug 2018 13:32:11 GMT

I am using SDK2 for customization.

Re: Connect External Databse

afaust — Wed, 15 Aug 2018 15:36:32 GMT

Please read again what I have linked. The constraint been needs to be registered with the constraint registry, which are set as properties on the bean. The bean class (which I did not link but would have been easy to find) extends from AbstractConstraint which contains all the logic and properties for registration.

Re: Connect External Databse

sp2 — Wed, 15 Aug 2018 15:58:25 GMT

Still Error.

<bean id="batchType" class="com.mbs.constraints.BatchTypeConstraints" init-method="initialize">
<property name="shortName">
<value>batchType</value>
</property>
<property name="registry">
<ref bean="cm:constraintRegistry" />
</property>
<property name="sorted" value="true" />
<property name="documentDAOImpl" ref="documentDAOImpl" />
</bean>

Re: Connect External Databse

sp2 — Thu, 16 Aug 2018 05:17:11 GMT

Can you guide me how can i implement?

Re: Connect External Databse

afaust — Thu, 16 Aug 2018 07:54:05 GMT

Make sure your Spring file is actually loaded / processed. When building a module it should be in alfresco/module/<moduleId>/module-context.xml file (or a file imported there). If you are just doing customisation without really building a proper module (you SHOULD consider building a module), then it can be any alfresco/extension/<xyz>-context.xml file

Re: Connect External Databse

sp2 — Fri, 17 Aug 2018 02:59:21 GMT

Thanks Axel Faust‌ for help.

I have solved this way.

Constraints:

<constraint name="mbs:batchTypeAspectList" type="REGISTERED">
<parameter name="registeredName">
<value>batchType</value>
</parameter>
</constraint>

Bean:

<bean id="batchType"
class="com.mbs.constraints.BatchTypeConstraints"
init-method="initialize">
<property name="shortName">
<value>batchType</value>
</property>
<property name="sorted" value="true" />
<property name="registry">
<ref bean="cm:constraintRegistry" />
</property>
</bean>

Class:

public class BatchTypeConstraints extends ListOfValuesConstraint implements Serializable{
/**
*
*/
private static final long serialVersionUID = -2561245100862732935L;
@Autowired
DocumentDAOImpl documentDaoImpl;

public BatchTypeConstraints() {
super();
}

@Override
public List<String> getRawAllowedValues() {
List<String> result = new ArrayList<>();
List<MetaDataModel> providers = documentDaoImpl.getAllBatchByWorkFlowType();
for (MetaDataModel data : providers) {
result.add(data.getName());
}
super.setAllowedValues(result);
return result;
}

@Override
public List<String> getAllowedValues() {
return super.getAllowedValues();
}

@Override
protected void evaluateSingleValue(Object value) {
super.setAllowedValues(getAllowedValues());
}

}