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

Issue about configuring data source

  • December 13, 2022
  • 3 replies
  • 2428 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

W
Adobe Employee
workflowuserAdobe Employee
Adobe Employee
December 13, 2022

 

    W
    Adobe Employee
    workflowuserAdobe Employee
    Adobe Employee
    December 13, 2022

    your version of AEM

    and are you logged in as admin?

      Z
      zonghuiliuAuthor
      Level 2
      December 13, 2022

      Version is AEM 6.5 and i'm logging as admin.

        Pulkit_Jain_
        Adobe Employee
        Pulkit_Jain_Adobe Employee
        Adobe 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... 

          Mayank_Gandhi
          Adobe Employee
          Mayank_GandhiAdobe EmployeeAccepted solution
          Adobe 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

            Terms & ConditionsAccessibility statement

            Loading footer...