db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thoralf Rickert" <thoralf.rick...@cadooz.de>
Subject AW: BigDecimal and MySQL decimal
Date Thu, 14 Dec 2006 12:55:47 GMT
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
View raw message