Issue about configuring data source | Community
Skip to main content
Z
zonghuiliu
New Participant
December 13, 2022
Solved

Issue about configuring data source

  • December 13, 2022
  • 3 replies
  • 2421 views

Hi Community!

 

I'm following this page(Deploying Adaptive Forms with Form Data Models to Production (or other environments) – Forms.life) and try to make a MYSQL connection.

But i can't find Apache Sling Connection Pooled DataSource in configMgr.

I've already installed mysql connector java bundle.

Is there something i still need to do in order to configure this Apache Sling Connection Pooled DataSource, for example add some dependencies in pom file?

 

Prefer some help.Thank you!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Mayank_Gandhi

@zonghuiliu 

 

sample file from the instance

 

:org.apache.felix.configadmin.revision:=L"1"
connectionProperties=""
datasource.name="test"
datasource.svc.prop.name="datasource.name"
datasource.svc.properties=[ \
"", \
]
defaultAutoCommit="Default"
defaultCatalog=""
defaultReadOnly="Default"
defaultTransactionIsolation="Default"
driverClassName=""
initSQL=""
initialSize=I"10"
jdbcInterceptors="StatementCache;SlowQueryReport(threshold\=10000);ConnectionState"
logValidationErrors=B"true"
maxActive=I"100"
maxAge=I"0"
maxIdle=I"100"
maxWait=I"30000"
minEvictableIdleTimeMillis=I"60000"
minIdle=I"10"
service.factoryPid="org.apache.sling.datasource.DataSourceFactory"
service.pid="org.apache.sling.datasource.DataSourceFactory.579dd9b2-8c32-428e-a0b5-5f416c66e571"
testOnBorrow=B"false"
testOnReturn=B"false"
testWhileIdle=B"false"
timeBetweenEvictionRunsMillis=I"5000"
url=""
username=""
validationInterval=I"30000"
validationQuery=""
validationQueryTimeout=I"-1"

 

 

path: crx-repository\launchpad\config\org\apache\sling\datasource\DataSourceFactory

3 replies

Mayank_Gandhi
Mayank_GandhiAccepted solution
Employee
December 13, 2022

@zonghuiliu 

 

sample file from the instance

 

:org.apache.felix.configadmin.revision:=L"1"
connectionProperties=""
datasource.name="test"
datasource.svc.prop.name="datasource.name"
datasource.svc.properties=[ \
"", \
]
defaultAutoCommit="Default"
defaultCatalog=""
defaultReadOnly="Default"
defaultTransactionIsolation="Default"
driverClassName=""
initSQL=""
initialSize=I"10"
jdbcInterceptors="StatementCache;SlowQueryReport(threshold\=10000);ConnectionState"
logValidationErrors=B"true"
maxActive=I"100"
maxAge=I"0"
maxIdle=I"100"
maxWait=I"30000"
minEvictableIdleTimeMillis=I"60000"
minIdle=I"10"
service.factoryPid="org.apache.sling.datasource.DataSourceFactory"
service.pid="org.apache.sling.datasource.DataSourceFactory.579dd9b2-8c32-428e-a0b5-5f416c66e571"
testOnBorrow=B"false"
testOnReturn=B"false"
testWhileIdle=B"false"
timeBetweenEvictionRunsMillis=I"5000"
url=""
username=""
validationInterval=I"30000"
validationQuery=""
validationQueryTimeout=I"-1"

 

 

path: crx-repository\launchpad\config\org\apache\sling\datasource\DataSourceFactory

    Pulkit_Jain_
    Pulkit_Jain_
    Employee
    December 13, 2022

    @zonghuiliu 

    Considering that the bundles are active, and you still don't see the config "Apache Sling Connection Pooled DataSource", I assume you're using a cloud SDK local set-up.

     

    Please be informed that you can store the data in external storage using FDM in case of a cloud SDK instance, as it's a little different from a typical AEM set-up.

    Multiple options exist with Forms as a cloud service: RESTful, SOAP-based web services, OData services (Version 4.0), and Microsoft Azure Blob Storage.

    Two new options are available: Microsoft Dynamics 365 and SalesForce.

     

    More information here - https://experienceleague.adobe.com/docs/experience-manager-cloud-service/content/forms/integrate/wor... 

    For detailed steps on creating data sources, refer to this help doc - https://experienceleague.adobe.com/docs/experience-manager-cloud-service/content/forms/integrate/use... 

      W
      workflowuser
      Employee
      December 13, 2022

       

        Z
        zonghuiliuAuthor
        New Participant
        December 13, 2022

        Above is what i have in configMgr.

          Terms & ConditionsAccessibility statement

          Loading footer...