3 Replies Latest reply on Jan 12, 2010 11:29 AM by jamesjmp

    Views and seam-gen usage

    vijay172.bvijaykr.gmail.com

      HI,


      1st time user of the posts.I have googled for this and cannot seem to find an answer.
      I am trying to reverse engineer a complex Oracle view and seam-gen doesn't generate any entities.
      I am trying to sell usage of Seam within my company and any help is appreciated. My apologies if this has been answered but I cannot seem to find the answer. I have
      googled and looked at "SEam In Action"

      seam-gen.reveng.xml:

      table-filter match-name="SIC_CLAIMANT_VW" match-schema="SICWCC" exclude="false"/>            
      table name="SIC_CLAIMANT_VW" class="com.standard.wcc.model.SicClaimantType"....

      Huge oracle View spread out across multiple schemas and tables:

      FROM code_trunc_mvw cis_tac,test1.personname pn,cdcountrytp country,locationgroup hr_em_lg,test1.contractcompval std_ccv


      Any links or any articles explaining how to do this would be very helpful for a novice user.

      TIA,
      VIjay

        • 1. Re: Views and seam-gen usage

          Hi and welcome to Seam,
          Have you succeeded in generate entities from standard tables (not views)? I mean to check if your configuration is ok.
          As it´s your first time I advise you to have a look at chapter 2 of the reference documentation: Getting started with Seam, using
          seam-gen. It would be very useful.
          You may find that documentation available in pdf and html in your downloaded distro in this path:


          ..\jboss-seam-2.X.Y.GA\doc\reference\en-US\



          Hope it helps!

          • 2. Re: Views and seam-gen usage
            vijay172.bvijaykr.gmail.com

            Hi Jaime,
            Thanks for your reply and the link.Yes,I have created at least 5 different projects with seam-gen but they all point to simple tables.This is a complex view with multiple tables in multiple schemas.


            Vijay

            • 3. Re: Views and seam-gen usage

              Hi, I have generated views sometimes with eclipse and seam-gen without problem. Howewer I only have one schema in that projects. I´m afraid the problem is that seam-gen is not able to work with complex views from multiple schemas and that you´ll have to code it without the help of seam-gen.