David - Awesome. Thanks. I'm trying to pass the datasource name as a parameter from dialog thus, not putting it in the code. But, this explains why my stuff wasn't working also. The documentation doesn't mention the config directory part. All good. Thanks for replying.

Ok, I figured it out. Making an sling:OsgiConfig node in CRX manually does not work as the instructions imply. Go to ConfigMgrSearch for jdbcpoolAdd new configuration.  The datasource.name is waaay at the bottom - I missed that.Save it and it works.

Don't know how my answer was accepted because I didn't accept ithttps://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/datasourcepool-in-workflowprocess/qaq-p/409972 I'll give some more detail because I have RTFM as was answered (and accepted mysteriously). This is my code for inj...

I am trying to dynamically connect to a datasource.  I'm using the AEM archetype. public class mystuff implements WorkflowProcess {private static final Logger log = LoggerFactory.getLogger(mystuff.class);@referenceprivate DataSourcePool dsp;@Overridepublic void execute(WorkItem workItem, WorkflowSes...

I am creating a custom dialog for a workflow component. I am using the variablePropertyComponent which has a"type" property which I can set to "java.lang.Long" and the drop down will filter all Long process variables.However, I would like to NOT filter any variables by type. I have tried these thing...

Figured it out. @reference(target = "(&(objectclass=javax.sql.DataSource)(datasource.name=MYDB))")private DataSource ds;

 I have tried dependency injection but, it cannot find my "Apache Sling Connection Pooled DataSource"@referenceprivate DataSourcePool dsp; DataSource ds = (DataSource) dsp.getDataSource("MYDB"); I am using SlingSafeMethodsServlet. Any help would be appreciated. 

I figured this out . . . the code was working as expected.  I went into configmgr and whitelisted all components and it worked.  The code, right or wrong, is working.  Now I need to figure out a service account and not use the whitelisting.

I actually got it working with very similar code. It was a permissions thing. I figured out how to whitelist my component but, ultimately I need to set up a service account becasue loginAdministrative() is deprecated. I need to find some easy instructions for a service account.

I have a custom workflow component that needs to look up a User in the AEM User repository. Code is pretty simple:resourceResolver = getResourceResolver(workflowSession);UserManager userManager = resourceResolver.adaptTo(UserManager.class);Iterator<Authorizable> userIterator = userManager.findAuthor...