2 Replies Latest reply on Jun 19, 2010 10:00 PM by $Nith$

    Flex Directly To JdbcService

    The Flex Viking Level 1

      I need to have a Flex form communicate with the LC database.  I see 4 ways to make this happen.

       

      1. Have Flex use a RemoteObject call to a custom written process that actually invokes a JDBC operation
      2. Have Flex use a RemoteObject call to a custom written process that uses the ExecuteScript activity to invoke the JDBC operation
      3. Have Flex use a RemoteObject call to a custom Java service component that invokes the JDBC operation
      4. Have Flex use a RemoteObject call to the JDBCService component directly

       

      I have done 1, 2 & 3 and while those are fine in most cases, at some points, I find myself wanted to use (4).  Has anyone done (4)?  In theory, it shouldn't be that hard, the problem I have is that in looking at the component.xml file, it looks like it is calling special classes, such as

       

      • com.adobe.idp.dsc.jdbc.bean.SqlStatementInfoBean
      • com.adobe.idp.dsc.jdbc.bean.XmlDocumentInfoBean

       

      which I would need to pass as part of the parameters in the Flex RemoteObject call.  Has one anyone done this?  Where would I find these classes and how would I create them within the Flex environment so that they could be used by the JdbcService?