For the record, the "proper" way to do this since Torque
3.2 is to use the size and scale attributes. (Though the
older size=(size,scale) is still supported).
One thing that can cause the SAX parsing exception is if
the DTD specified in the DOCTYPE of your schema isn't set to
use the same DTD as the version you're generating with. E.g.:
<!DOCTYPE database SYSTEM
"http://db.apache.org/torque/dtd/database_3_2.dtd";>
This will let you use any new XML attributes.
> -----Original Message-----
> From: Jon August [mailto:[EMAIL PROTECTED]
> Sent: Thursday, December 14, 2006 8:55 AM
> To: Apache Torque Users List
> Cc: Thoralf Rickert
> Subject: Re: AW: BigDecimal and MySQL decimal
>
>
> 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:[EMAIL PROTECTED]
> >>> 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
> >>>> For additional commands, e-mail: [EMAIL PROTECTED]
> >>>>
> >>>>
> >>>>
> >>>>
> >>>> ---------------------------------
> >>>> Want to start your own business? Learn how on Yahoo! Small
> >>>> Business.
> >>>
> >>>
> >>>
> --------------------------------------------------------------------
> >>> -
> >>> To unsubscribe, e-mail: [EMAIL PROTECTED]
> >>> For additional commands, e-mail: [EMAIL PROTECTED]
> >>>
> >>>
> >>
> >>
> >>
> >>
> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: [EMAIL PROTECTED]
> >> For additional commands, e-mail: [EMAIL PROTECTED]
> >>
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
Duke CE Privacy Statement
Please be advised that this e-mail and any files transmitted with it are
confidential communication or may otherwise be privileged or confidential and
are intended solely for the individual or entity to whom they are addressed.
If you are not the intended recipient you may not rely on the contents of this
email or any attachments, and we ask that you please not read, copy or
retransmit this communication, but reply to the sender and destroy the email,
its contents, and all copies thereof immediately. Any unauthorized
dissemination, distribution or copying of this communication is strictly
prohibited.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
