6 Replies Latest reply on Apr 6, 2010 2:36 PM by ecchuckles

    lcds/datamodeler inside oc4j container

    ecchuckles

      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?

        • 1. Re: lcds/datamodeler inside oc4j container
          Steve L Walker Level 5

          Is the JDBC jar in the Tomcat lib?

           

          Steve

          • 2. Re: lcds/datamodeler inside oc4j container
            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 -->

            • 3. Re: lcds/datamodeler inside oc4j container
              ecchuckles Level 1

              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

              • 4. Re: lcds/datamodeler inside oc4j container
                ecchuckles Level 1

                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?

                • 5. Re: lcds/datamodeler inside oc4j container
                  kasmit44 Level 2

                  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

                  • 6. Re: lcds/datamodeler inside oc4j container
                    ecchuckles Level 1

                    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