For a good idea about JDBC URL vs JDBC Datasource see: http://download.oracle.com/docs/cd/E14571_01/web.1111/b31974/bcservices.htm#ADFFD1501
Configuring JDBC Datasource
According to Oracle “A data source is a vendor-independent encapsulation of a database server connection”.
When deploying an Oracle ADF application with a bc4j (Business Configuration) to a stand-alone Weblogic instance, you need to make sure your data-source is configured in your application and defined in your weblogic server.
FYI: The “embedded” Weblogic Server (WLS) is the one that comes with JDeveloper i.e. the one that runs when you right click on a JSF page and click the play-button. The “Stand-alone” Weblogic Server is something that you installed. So if you did not download Weblogic you can follow these links: [download from here ] and [install doc is here].
Once you have the stand-alone weblogic server up and running and have a database instance to connect to, go to the weblogic admin console http://<server-host>:<server-port>/console and enter the admin login/password. The default is “weblogic” and the password you supplied during the install process.
In the Weblogic admin console look at the menu items on the left side of the screen and under “Domain Structure” menu goto the “Services” node, expand it and then goto the “JDBC” node and expand that. Click on the “Data Sources” child node of JDBC and you can see the configured data sources. For example: In the image below you are seeing the datasources for my soa1_server WLS managed server instance and it has quite a few datasources configured.
Configuring Weblogic Standalone server:
Steps to create a new data source are listed in the “Gallery” below … you need to go to through the Weblogic Wizard and enter your Database Url/Port.
Configuring the ADF Application:
Now you need to configure your ADF application to use this otherwise you may see errors like “password: null” etc. They are really vague messages but the stack trace tells the story – the Faces context tries to load the BC and the config cannot connect to a database because of missing or invalid connection properties.
Here are the steps for configuring your JDev Application … start with opening your Application Module XML (the Oracle editor for the XML opens up), select the “Configuration” tab and then set your datasource name there.