Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Adobe Summit 2023 [19th to 23rd March, Las Vegas and Virtual] | Complete AEM Session & Lab list
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

10 Replies

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