lcds/datamodeler inside oc4j container

[Former Community Member]

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?

[Former Community Member]

Is the JDBC jar in the Tomcat lib?

Steve

[kasmit44]

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 -->

[Former Community Member]

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

[Former Community Member]

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?

[kasmit44]

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

[Former Community Member]

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