0 Replies Latest reply on Apr 27, 2014 10:22 PM by Shraddha Prajapati

    ORM CFC Mapping

    Shraddha Prajapati Level 1

      Hi ,

          I want to map ORM CFC with 1-m and m-1, i have 3 table like:

       

      blogPost

             [blogpostid]

            ,[title]

            ,[summary]

            ,[body]

            ,[dateposted]

            ,[createdDateTime]

            ,[modifiedDateTime]

            ,[deleted]

       

      blogCategory

            [blogCategoryid]

            ,[name]

       

      BlogPostCategory

             [blogpostid]

            ,[blogCategoryid]

       

      blogPost ->BlogPostCategoryy  (1-m)

      blogCategory->BlogPostCategory (1-m)

      BlogPostCategory->blogPost , BlogPostCategory->blogCategory(m-1)

       

      Please tell me the step to craete it (By directly using this 3 tables)

       

      When i try to create it i got the error like i attach snapshot:

       

       

      Code could not be generated  

      struct
      DetailIf the component name is specified as a return type, it is possible that either a definition file for the component cannot be found or is not accessible.
      MessageThe value returned from the getTableInfo function is not of type ORMTable.
      StackTracecoldfusion.runtime.UDFMethod$InvalidReturnTypeException: The value returned from the getTableInfo function is not of type ORMTable. at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:433) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2659) at cfORMManager2ecfc1386102549$funcGETFKCOLUMN.runFunction(C:\ColdFusion10\cfusion\wwwroot\A dobe CFC Generator\handlers\framework\ORMManager.cfc:265) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:655) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:444) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:414) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2432) at cfgenerateORMSample2ecfm289018619.runPage(C:\ColdFusion10\cfusion\wwwroot\Adobe CFC Generator\handlers\generateORMSample.cfm:53) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:444) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2799) at cformCodeGenHandler2ecfm1858765394.runPage(C:\ColdFusion10\cfusion\wwwroot\Adobe CFC Generator\handlers\ormCodeGenHandler.cfm:25) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:444) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2799) at cfApplication2ecfc604785247$funcONREQUEST.runFunction(C:\ColdFusion10\cfusion\wwwroot\Ado be CFC Generator\handlers\Application.cfc:83) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:655) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:444) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:414) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:108) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:300) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:418) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:112) at coldfusion.filter.LicenseFilter.invoke(LicenseFilter.java:30) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:2 8) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:151) at coldfusion.CfmServlet.service(CfmServlet.java:204) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.j ava:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42 ) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.j ava:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:928) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:414) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987 ) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.jav a:539) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:300) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:722)
      Suppressed
      array [empty]
      TagContext
      array
      1
      struct
      COLUMN0
      IDCF_UDFMETHOD
      LINE265
      RAW_TRACEat cfORMManager2ecfc1386102549$funcGETFKCOLUMN.runFunction(C:\ColdFusion10\cfusion\wwwroot\A dobe CFC Generator\handlers\framework\ORMManager.cfc:265)
      TEMPLATEC:\ColdFusion10\cfusion\wwwroot\Adobe CFC Generator\handlers\framework\ORMManager.cfc
      TYPECFML
      2
      struct
      COLUMN0
      IDCF_TEMPLATEPROXY
      LINE53
      RAW_TRACEat cfgenerateORMSample2ecfm289018619.runPage(C:\ColdFusion10\cfusion\wwwroot\Adobe CFC Generator\handlers\generateORMSample.cfm:53)
      TEMPLATEC:\ColdFusion10\cfusion\wwwroot\Adobe CFC Generator\handlers\generateORMSample.cfm
      TYPECFML
      3
      struct
      COLUMN0
      IDCFINCLUDE
      LINE25
      RAW_TRACEat cformCodeGenHandler2ecfm1858765394.runPage(C:\ColdFusion10\cfusion\wwwroot\Adobe CFC Generator\handlers\ormCodeGenHandler.cfm:25)
      TEMPLATEC:\ColdFusion10\cfusion\wwwroot\Adobe CFC Generator\handlers\ormCodeGenHandler.cfm
      TYPECFML
      4
      struct
      COLUMN0
      IDCFINCLUDE
      LINE83
      RAW_TRACEat cfApplication2ecfc604785247$funcONREQUEST.runFunction(C:\ColdFusion10\cfusion\wwwroot\Ado be CFC Generator\handlers\Application.cfc:83)
      TEMPLATEC:\ColdFusion10\cfusion\wwwroot\Adobe CFC Generator\handlers\Application.cfc
      TYPECFML
      TypeORMTable
      functionNamegetTableInfo
      typeORMTable