I have oracle 12c working with coldfusion 11 enterprise edition on 64bit oracle linux 6.5, using the built-in oracle driver provided by CF11.
However, 12c uses a container/pluggable architecture. If I create a user in the container database (CDB), I can configure the datasource GUI in CF11 to log into the db account, but I can't configure CF11 to log into the container database. What does the connection string look like, and does it use the Oracle driver that comes with CF11 ent edition? I've tried a few ways, but I can't get it to connect. I have an oracle service name in listener.ora, I CAN log into the pluggable account from the shell i.e. sqlplus user@pdb. So that works. Is it even possible to log into the account within the PDB with the default ORACLE driver in CF11 datasource GUI? Or, ...must one set up the database as a "container-only" (no plug-in db's) to allow CF11 access? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-server/message.cfm/messageid:7023 Subscription: http://www.houseoffusion.com/groups/cf-server/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-server/unsubscribe.cfm
