Announcement Announcement Module
Collapse
No announcement yet.
ROO + composite primary keys in data on demand Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • #16
    If you get the latest Roo code from Git, I just committed code today that will now support composite keys in DoD (data on demand) and intregration tests - no web UI functionality yet though.

    Comment


    • #17
      Hi Alan,

      I am new to this...no idea how to get latest code from git.....

      can u pls help me in this??

      Thanks,
      Pavan

      Comment


      • #18
        Check the sticky links on this forum

        Comment


        • #19
          Hi,

          I got the location for code "http://git.springsource.org/roo/roo". But when i tried to clone, it is asking Publick key....since i am using windows environment i dont have any public key...

          Thanks,
          Pavan

          Comment


          • #20
            Hi Alan,

            Atlast i downloaded "org.springframework.roo.addon.dod-1.1.3.BUILD-20110320.082216-18.jar" and org.springframework.roo.addon.entity-1.1.3.BUILD-20110320.082136-18.jar files from "http://s3browse.springsource.com" and place it under "spring-roo-1.1.2.RELEASE\bundle".

            But still i am getting "missing right parathesis error".

            Thanks,
            Pavan

            Comment


            • #21
              Hi Alan,

              Any update on this??

              Thanks,
              Pavan

              Comment


              • #22
                Hi all!

                I also I have the same error

                Code:
                ERROR org.hibernate.util.JDBCExceptionReporter - ORA-00907: missing right parenthesis
                and I have primary key composite of three columns

                I need help please!

                is very important!!

                Comment


                • #23
                  You will have go explain your problem more. What version of Roo, what error are you seeing, is it with tests or web app? Can you please attach your dbre.xml file here ?
                  Alan

                  Comment


                  • #24
                    Hi Alan

                    I'm using roo 1.1.5
                    Oracle database

                    the error is with web app

                    dbre.xml

                    Code:
                    <?xml version="1.0" encoding="UTF-8" standalone="no"?>
                    <!--WARNING: DO NOT EDIT THIS FILE. THIS FILE IS MANAGED BY SPRING ROO.-->
                    <database name="XXXX">
                        <option key="testAutomatically" value="false"/>
                        <option key="includeNonPortableAttributes" value="false"/>
                        <table name="MXXX">
                            <column name="XXXXHOST" primaryKey="false" required="true" scale="0" size="2" type="3,NUMBER"/>
                            <column name="XXXSEQ" primaryKey="false" required="true" scale="-127" size="0" type="3,NUMBER"/>
                            <column name="XXXDATE" primaryKey="false" required="false" scale="0" size="7" type="93,DATE"/>
                            <column name="XXXONEDA" primaryKey="false" required="false" scale="0" size="2" type="3,NUMBER"/>
                            <column name="XXXXALFA" primaryKey="true" required="true" scale="0" size="3" type="12,VARCHAR2"/>
                            <column name="XXXPAIS" primaryKey="false" required="false" scale="0" size="2" type="12,VARCHAR2"/>
                            <column name="XXXNEDA" primaryKey="false" required="false" scale="0" size="40" type="12,VARCHAR2"/>
                            <column name="XXXINICIO" primaryKey="true" required="true" scale="0" size="7" type="93,DATE"/>
                            <column name="XXXXTERMINO" primaryKey="true" required="true" scale="0" size="7" type="93,DATE"/>
                            <column name="XXXXEU" primaryKey="false" required="false" scale="5" size="11" type="3,NUMBER"/>
                            <column name="XXXGEB" primaryKey="false" required="false" scale="5" size="11" type="3,NUMBER"/>
                            <column name="XXXUSD" primaryKey="false" required="false" scale="5" size="11" type="3,NUMBER"/>
                            <column name="XXGBP" primaryKey="false" required="false" scale="0" size="1" type="12,VARCHAR2"/>
                            <column name="XXXSD" primaryKey="false" required="false" scale="0" size="1" type="12,VARCHAR2"/>
                            <column name="XXXXREGISTRO" primaryKey="false" required="false" scale="0" size="2" type="3,NUMBER"/>
                            <column name="XXXEGISTRO" primaryKey="false" required="false" scale="0" size="30" type="12,VARCHAR2"/>
                            <column name="XXXXGISTRO" primaryKey="false" required="false" scale="0" size="7" type="93,DATE"/>
                            <unique name="PKXXX">
                                <unique-column name="XXXXALFA"/>
                                <unique-column name="XXXINICIO"/>
                                <unique-column name="XXXXTERMINO"/>
                            </unique>
                            <index name="MNDI_AK_01">
                                <index-column name="XXXONEDA"/>
                                <index-column name="XXXINICIO"/>
                                <index-column name="XXXXTERMINO"/>
                            </index>
                        </table>
                    </database>
                    thanks for you response

                    Karina.

                    Comment


                    • #25
                      I can't reproduce your issue, however data on demand was not honouring length consraints in composite primary columns when constructing the primary key. For this bug, I raised and resolved https://jira.springsource.org/browse/ROO-2726.

                      Comment


                      • #26
                        there is another option for this error?

                        Comment

                        Working...
                        X