Anorm, Postgres and Dates

hi!

Anorm Magic handles java.util.Date nicely but doesn't support
specifically java.sql.Date. However, the postgres driver can only
handle java.sql.Date

org.postgresql.util.PSQLException: Can't infer the SQL type to use
for an instance of java.util.Date. Use setObject() with an explicit
Types value to specify the type to use.
at
org.postgresql.jdbc2.AbstractJdbc2Statement.setObject(AbstractJdbc2Statement.java:
1801)
at
org.postgresql.jdbc3g.AbstractJdbc3gStatement.setObject(AbstractJdbc3gStatement.java:
37)
at
org.postgresql.jdbc4.AbstractJdbc4Statement.setObject(AbstractJdbc4Statement.java:
46)
at play.db.anorm.Sql$class.setAny(Anorm.scala:912)
at play.db.anorm.SimpleSql.setAny(Anorm.scala:829)

Can Anorm support java.sql.Date since most of drivers support this
type rather than java.util.Date? What would be the problem supporting
java.sql.Date?

Thanks!

The Anorm has a path that could use custom type, but it don''t release because play-scala 0.9.2 do not.

What play-scala version are you using?



--
www.sadekdrobi.com
ʎdoɹʇuǝ

Hi!

I'm using 0.9.1

using java.util.Date calls jdbc setObject method and pg driver doesn't
like this

You might want to use the java.sql.Timestamp class which the Postgres
driver supports.

It's also possible to add support for Timestamp to your companion
object by adding these methods:

import play.db.anorm._
import play.db.anorm.defaults._
import scala.reflect.Manifest

import java.sql.{Timestamp}


override def extendExtractor[C](f:(Manifest[C] =>
Option[ColumnTo[C]]), ma:Manifest[C]):Option[ColumnTo[C]] = (ma match
{
case m if m == Manifest.classType(classOf[Timestamp]) =>
Some(rowToTimestamp)
case _ => None
}).asInstanceOf[Option[ColumnTo[C]]]

def rowToTimestamp: Column[Timestamp] = {
Column[Timestamp](transformer = { (value, meta) =>
val MetaDataItem(qualified,nullable,clazz) = meta
value match {
case time:java.sql.Timestamp => Right(time)
case _ => Left(TypeDoesNotMatch("Cannot convert " + value + " to
Timestamp for column " + qualified))
}
})
}

The mechanism for this changed in the latest git release, though.

I'll try this, thanks Thomas.
I'll also try to adapt to java.sql.Date since I only want a date.

By the way, java.sql.Date is supported on master.

Oh great news thanks!