AW: BigDecimal and MySQL decimal
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=pricescale=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]
Re: AW: BigDecimal and MySQL decimal
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=pricescale=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]
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=pricescale=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]
RE: AW: BigDecimal and MySQL decimal
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=pricescale=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]
Re: AW: BigDecimal and MySQL decimal
You're right. I had 3.1 in the DOCTYPE. The separate attribute method is working for me. On Dec 14, 2006, at 9:18 AM, Greg Monroe wrote: 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=pricescale=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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]