SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-16-2008, 12:14 AM
| ||||
| ||||
 SQLMAP IBATIS insert values from web forms to a money type column Hello, I am using SQLMAP ibatis to do DB insertion for a webapplication. In my sqlmap.xml file, I was trying to insert values into a table with one col (type is Money), but in java, I could not find Money type. Does someone knows about ibatis how to make values got from the web form to be inserted into money type column through IBATIS ? Thanks a lot! ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly      |
|
04-16-2008, 12:14 AM
| |||
| |||
| Re: SQLMAP IBATIS insert values from web forms to a money type Hi, I think you should use BigDecimal ... /David Emi Lu wrote: > Hello, > > I am using SQLMAP ibatis to do DB insertion for a webapplication. > > In my sqlmap.xml file, I was trying to insert values into a table with > one col (type is Money), but in java, I could not find Money type. > > Does someone knows about ibatis how to make values got from the web > form to be inserted into money type column through IBATIS ? > > Thanks a lot! > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > > > ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match |
|
04-16-2008, 12:14 AM
| ||||
| ||||
| Re: SQLMAP IBATIS insert values from web forms to a money > > I think you should use BigDecimal ... > > I tried java.math.BigDeciaml. It does not work for me, I still get the exceptions: column "salary_amount" is of type money but expression is of type numeric > > Emi Lu wrote: >> Hello, >> >> I am using SQLMAP ibatis to do DB insertion for a webapplication. >> >> In my sqlmap.xml file, I was trying to insert values into a table >> with one col (type is Money), but in java, I could not find Money type. >> >> Does someone knows about ibatis how to make values got from the web >> form to be inserted into money type column through IBATIS ? >> >> Thanks a lot! >> >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 1: if posting/reading through Usenet, please send an appropriate >> subscribe-nomail command to majordomo@postgresql.org so that your >> message can get through to the mailing list cleanly >> >> >> > > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match |
Linear Mode
