PostgreSQL numeric type and anorm parser with Play! scala 2.3

Question

I want to use the numeric type of Postgresql 9.3 but my parser :

private val Account403Parser: RowParser[Account403] = {
  get[Long]("id") ~
  get[Float]("amount") map {
  case id ~ amount =>
    Account403.apply(id, amount)
}

doesn't work since anorm can't convert from java.math.BigDecimal to Float.

Here is the error that I get :

[RuntimeException: TypeDoesNotMatch(Cannot convert 9.5: class java.math.BigDecimal to Float for column ColumnName(account403.amount,Some(amount)))]

How can I change my parser to make it convert from the java.math.BigDecimal type to the Float type?

More numeric conversions are available in master.

cchantep
– cchantep

2014-11-29 01:34:23 +00:00
Commented Nov 29, 2014 at 1:34 — cchantep
– cchantep, Commented Nov 29, 2014 at 1:34

Erwin Brandstetter · Accepted Answer · 2014-11-09 04:00:02Z

1

According to the type-compatibility matrix in the documentation you should use

BigDecimal, Double or Long to assign a BigDecimal.

Or you could cast to real (4-byte floating point number) on the Postgres side: amount::real, thereby losing some precision. Not sure about the syntax in scala.

answered Nov 9, 2014 at 4:00

Erwin Brandstetter

668k159 gold badges1.2k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PostgreSQL numeric type and anorm parser with Play! scala 2.3

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related