Issue about configuring data source

[zonghuiliu]

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!

[workflowuser]

[zonghuiliu]

Above is what i have in configMgr.

[workflowuser]

your version of AEM

and are you logged in as admin?

[zonghuiliu]

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

[workflowuser]

http://localhost:4502/system/console/configMgr

make sure you are in this URL 

[zonghuiliu]

I'm sure the url is right.

[workflowuser]

make sure all your bundles are in active state

[zonghuiliu]

All bundles are in active mode.

[Pulkit_Jain_]

@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 · Accepted solution]

@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