Is the JDBC jar in the Tomcat lib?
You need to uncomment the RDS section in the web.xml file of your webapp. It is commented out initially for security reasons - RDS should not be enabled in a production environment. Also you probably want to set useAppserverSecurity to false as below.
<!-- Add RDS servlets -->
<!-- End Add RDS servlets -->
I had already uncommented that entry while in my development
environment running under tomcat. I deployed to oc4j by creating a
war file from my development environment.
there is no tomcat container, I'm using oc4j as the container. should I have an jdbc.jar under the WEB-INF/lib for lcds?
Oracle Appserver is not a supported platform. So, I have no experience with it. Does your model deploy to the server? If not, you will need to configure and deploy the RDS servlets similar to what is done with tomcat.
If your application is running and connecting to Oracle dbms, it would seem you JDBC driver is setup properly. I have had better luck connecting to Oracle from lcds using the ojdbc14 driver versus the newer ones. You could try it. Are you using the driver that worked for you in Tomcat? If not try it.
I can get the model to deploy to the server and bring the application
up under oc4j which will move to web logic in the future, we will be
doing our development under tomcat
so RDS won't be critical. I was wondering if I overlooked something
in configuring oc4j.