mule - How to configure Database with custom Datasource in MUlesoft

Question

I have a requirement that to configure the database connector using my custom-defined Datasource(Spring based). When configuring my data-source to DB Connector with my custom bean, I am getting an error that cannot set javax.sql.Datasource to org.mule.extension.db.internal.domain.data source.DataSourceConnetionSettings.dataSourceRef. When I didn't configure my DB connector and referred to the data source using java invoke, able to get the Datasource object. How can I pass this Datasource this my database connector in runtime?

Referred to the below but didn't help.

https://help.mulesoft.com/s/article/Spring-based-datasources

Can someone help me with the last point in the below knowledgebase?

https://help.mulesoft.com/s/article/How-to-configure-connector-with-dynamic-parameters

<db:config name="Database_Config">

<db:data-source-connection dataSourceRef="myDbConnetor" />

</db:config>

My beans.xml as like below:

<beans xmlns="http://www.springframework.org/schema/beans"
  xmlns:context="http://www.springframework.org/schema/context"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xmlns:jdbc="http://www.springframework.org/schema/jdbc"
  xsi:schemaLocation="http://www.springframework.org/schema/beans
   http://www.springframework.org/schema/beans/spring-beans-4.1.xsd
   http://www.springframework.org/schema/jdbc
   http://www.springframework.org/schema/jdbc/spring-jdbc-4.1.xsd
   http://www.springframework.org/schema/context
   http://www.springframework.org/schema/context/spring-context-4.1.xsd">

<context:annotation-config />
<context:component-scan base-package="com.test.datasource.*" />
<bean id="myDbConnetor" class="com.test.datasource.MyCustomDataSource"/>
</beans>

question from:https://stackoverflow.com/questions/65890097/how-to-configure-database-with-custom-datasource-in-mulesoft

Answer 1

Waitting for answers