ROO + composite primary keys in data on demand

[pavan4uus]

Hi Alan,

Any update on this??

Thanks,
Pavan

[Karina]

Hi all!

I also I have the same error

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!!

[Alan Stewart]

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

[Karina]

Hi Alan

I'm using roo 1.1.5
Oracle database

the error is with web app

dbre.xml

<?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.

[Alan Stewart]

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.

[Karina]

there is another option for this error?