good day,
I've been able to deploy an lcds data modeled application into an oc4j container from a tomcat environment that works against an oracle db. After a lot of
errors and googling I got it to work by adding this to my WEB-INF/web.xml:
<resource-ref>
<res-ref-name>jdbc/myDataSource </res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
so fiber could make the connection to java:/comp/ env/jdbc/ myDataSource configured in my fml file.
Now from flashbuilder4 /data Model 1.0 I try to connect to the lcds/rds under oc4j and I get no datasources found message, what additional plumbing to I do to get this to work?
Views
Replies
Total Likes
Is the JDBC jar in the Tomcat lib?
Steve
Views
Replies
Total Likes
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 -->
<servlet>
<servlet-name>RDSDispatchServlet</servlet-name>
<display-name>RDSDispatchServlet</display-name>
<servlet-class>flex.rds.server.servlet.FrontEndServlet</servlet-class>
<init-param>
<param-name>useAppserverSecurity</param-name>
<param-value>false</param-value>
</init-param>
<load-on-startup>10</load-on-startup>
</servlet>
<servlet-mapping id="RDS_DISPATCH_MAPPING">
<servlet-name>RDSDispatchServlet</servlet-name>
<url-pattern>/CFIDE/main/ide.cfm</url-pattern>
</servlet-mapping>
<!-- End Add RDS servlets -->
Views
Replies
Total Likes
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.
chuckles
Views
Replies
Total Likes
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?
Views
Replies
Total Likes
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.
Ken
Views
Replies
Total Likes
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.
chuckles
Views
Replies
Total Likes