db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jon August <...@internection.com>
Subject Re: AW: BigDecimal and MySQL decimal
Date Thu, 14 Dec 2006 13:35:40 GMT
Thanks - that fixed the "maven torque"...

Now when I do the save from my object, I get an error that I wasn't  
getting when the scale wasn't set:

java.lang.NullPointerException
	java.math.BigDecimal.<init>(BigDecimal.java:181)







On Dec 14, 2006, at 7:55 AM, Thoralf Rickert wrote:

> Try size="7,2" instead of size=".." scale=".."
>
>
>
>> -----Ursprüngliche Nachricht-----
>> Von: Jon August [mailto:jon@internection.com]
>> Gesendet: Donnerstag, 14. Dezember 2006 13:52
>> An: Apache Torque Users List
>> Betreff: Re: BigDecimal and MySQL decimal
>>
>>
>> Hey Alvaro,
>>
>> Thanks for the suggestion.  I tried this:
>>
>>      <column name="price"                scale="2" size="7"
>> type="DECIMAL" />
>>
>> but I get this error when I run "maven torque":
>>
>> org.apache.torque.engine.EngineException: org.xml.sax.SAXException:
>> Error while parsing wp-schema.xml at line 13 column 77 : Attribute
>> "scale" must be declared for element type "column".
>>
>>
>> Is my syntax incorrect?
>>
>> -Jon
>>
>>
>>
>>
>>
>> On Dec 14, 2006, at 7:24 AM, Alvaro Coronel wrote:
>>
>>> I have had no trouble using it just as you do. Maybe you haven't
>>> set the scale yet.
>>>
>>> This is an excerpt of my schema.xml file:
>>>
>>> <column name="moncotiza"
>>>              required="true"
>>>              scale="2"
>>>              size="7"
>>>              type="DECIMAL" />
>>>
>>> What I usually do is to define the schema.xml file and from it
>>> obtain the .sql file via ant to create the database.
>>>
>>> Good luck,
>>> Álvaro.
>>>
>>> Jon August <jon@internection.com> wrote: Hey,
>>>
>>> I'm using decimal (in the schema) to store a dollar amount
>> in my MySQL
>>> database.  I get the value from a web page and convert it to a
>>> BigDecimal before storing it.  For some reason, the decimal portion
>>> gets truncated and $10.32 gets stored as 10.  Should I be using
>>> something other than BigDecimal or is there something else wrong?
>>>
>>> Sorry if this is not a torque question.
>>>
>>> -Jon
>>>
>>>
>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>>> For additional commands, e-mail: torque-user-help@db.apache.org
>>>
>>>
>>>
>>>
>>> ---------------------------------
>>> Want to start your own business? Learn how on Yahoo! Small Business.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>> For additional commands, e-mail: torque-user-help@db.apache.org
>>
>>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message