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:54:54 GMT

The suggestions by Thoralf and Alvaro fixed the problem.  My issue  
with the NullPointerException was unrelated.

Thanks for the help.

-Jon



On Dec 14, 2006, at 8:35 AM, Jon August wrote:

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


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message