out of range error

[Sundar Murthi]

Hi..

i am using oracle 9i and hibernate. Using ant script i am executing the .hbm.xml file. it throws an error like this..

[schemaexport] ERROR - Unsuccessful: create table cga_price_component (ai_pricecomponent number(19,0) not null, am_amount number(19, 255), fl_target varchar2(255), fl_real varchar2(255), ch_value_threshold number(19, 255), ts_validity_start date, ts_validity_end date, am_minimal_amount number(19, 255), ai_condition number(19,0) not null, primary key (ai_pricecomponent))
[schemaexport] ERROR - ORA-01728: numeric scale specifier is out of range (-84 to 127)

i am exceuted this create table .... in oracle console i am getting the same error.

how can i change the numeric size level in hibernate?
ie 255 to less than 127.

help me plz
[ September 28, 2004: Message edited by: Sundar Murthi ]

[Sundar Murthi]

any way to change the size of the number through hibernate

urgent plz

[Paul Sturrock]

how can i change the numeric size level in hibernate

The restriction isn't Hibernate, its Oracle. Which version of Hibernate/Oracle are you using? And can you post how you are mapping the ai_pricecomponent property?

[Sundar Murthi]

Hi

i am using oracle9i and hibernate2

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping SYSTEM "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
 
    <class name="be.cora.thema2.model.contract.PriceComponent" table="cga_price_component">
 
        <id name="id" column="ai_pricecomponent" type="long">
            <generator class="sequence">
                <param name="sequence">s_price_component</param>
            </generator>
        </id>
 
        <property name="amount" column="am_amount"/>
        <property name="target" column="fl_target"/>
        <property name="real" column="fl_real"/>
        <property name="valueThreshold" column="ch_value_threshold"/>
        <property name="validityStartDate" column="ts_validity_start"/>
        <property name="validityEndDate" column="ts_validity_end"/>
        <property name="minimalAmount" column="am_minimal_amount"/>
 
        <many-to-one name="condition"
            column="ai_condition"
            class="be.cora.thema2.model.contract.Condition"
            not-null="true"
            cascade="none"
            outer-join="auto"/>
 
    </class>
 
</hibernate-mapping>

this is my pricecomponent.hbm.xml file

:roll: