cfml

Hey is there any way to get the underlying connection object from a data source name? For some failsafe checks I need to ensure that some JDBC settings are in place (specifically the `allowMultiQueries` setting passed in the connection string).

you could start with `getApplicationMetadata()` if that is no good then `getpagecontext().getConfig().getDatasource("dsourcename").getConnectionStringTranslated()`

Yeah cheers `getApplicationMetadata` isn't the object but it'll do. And cheers for the other option.

`getConfig` doesn't seem to be part of the standard PageContext spec, but is implemented in Lucee's `lucee.runtime.PageContext` class. On the <https://docs.lucee.org/reference/functions/getpagecontext.html> docs page there's a link to <https://javadoc.lucee.org/lucee/runtime/PageContext.html>, am I safe to assume that API is intended to be used in our applications, and accordingly is subject to the usual stability "guarantees" that the CFML parts of Lucee has (eg in <https://docs.lucee.org/>).

I guess the question is just clarifying that it's _not_ considered "internal implement detail" and subject to change at the whim of the Lucee dev team as their needs dictate?

It has existed since Railo, that is of course no guarantee for the future

there is Administrator.cfc <https://github.com/lucee/Lucee/blob/6.0/core/src/main/java/resource/component/org/lucee/cfml/Administrator.cfc> which is claimed to by a maintained wrapper for cfadmin it has a `getDatasource()` method

If that is like how `&lt;cfadmin&gt;` works, it's only good for getting stuff _actually set in the admin_. These DSNs are application-set.

The metadata approach is fine for my purposes.

we tend to avoid that as you need a password

Interestingly it seems that not _all_ of it requires a pwd. Which made me go "erm...?", but then I went "yeah not using this, don't care"

eg: `&lt;cfadmin action="getDebugData" returnvariable="debug_data"&gt;`... no pwd needed.

`getDatasource` _did_ need the pwd though.

this is a slightly more belt and braces version (excuse tags)
```&lt;cfset dataSource = getPageContext().getDatasource(datasourceName)&gt;
			&lt;cftry&gt;
				&lt;cfset details["Database"] = dataSource.getDatabase()&gt;
				&lt;cfcatch&gt;
					&lt;!--- if the datasource is defined in Application.cfc getDatabase() will error ---&gt;
					&lt;cfset details["Database"] = CreateObject("java", "lucee.runtime.services.DataSourceImpl").init(dataSource).getconnection().getCatalog()&gt;
				&lt;/cfcatch&gt;
			&lt;/cftry&gt;```