Expand my Community achievements bar.

Enhance your AEM Assets & Boost Your Development: [AEM Gems | June 19, 2024] Improving the Developer Experience with New APIs and Events
SOLVED

Issue about configuring data source

Avatar

Level 3

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!

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

@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

View solution in original post

10 Replies

Avatar

Employee Advisor

your version of AEM

and are you logged in as admin?

Avatar

Employee Advisor

@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... 

Avatar

Correct answer by
Employee Advisor

@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