My method looks like this:
<cffunction name="getConnection" output="false">
<cfset var admin = createObject("component",
"bluedragon.adminapi.Administrator") />
<cfset var adminDS = "" />
<cfset var ds = "" />
<cfset var loginResult = false />
<cfset var connection = "" />
<cfset loginResult = admin.login("password") />
<cfif loginResult>
<cfset session.auth = {
loggedIn = true,
password = "password"
} />
</cfif>
<cfset adminDS = createObject("component", "bluedragon.adminapi.Datasource")
/>
<cfset ds = adminDS.getDatasources(application.dsn) />
<cftry>
<cfset createObject("java", "java.lang.Class").forName(ds.driverName) />
<cfset connection = createObject("java",
"java.sql.DriverManager").getConnection(ds.hoststring, ds.username,
ds.password) />
<cfcatch>
<cfdump var="#ds#" />
<cfdump var="#cfcatch#" />
<cfabort />
</cfcatch>
</cftry>
<cfset admin.logout() />
<cfreturn connection />
</cffunction>
--
official tag/function reference: http://openbd.org/manual/
mailing list - http://groups.google.com/group/openbd?hl=en
