Why is JOOQ restricted to Integer values and not Longs?

Question

I am new with JOOQ and it seems a little strange why it has many of my columns type-safed as Integers while they could easily need to be Longs in the near future.

Even count(*) results must be casted into Integers!

Is there a setting to have Long as default or any way to set Long globally in current project? (wherever this may apply)

If this is not possible.. Is there a reason to have it as Integer?'

this is a sample of some code in Scala:

def loggedInUserOwnsAccount(userId: Long) = {
selectCount().
  from(LOGGED_IN, EMAIL_ACCOUNT).
  where(LOGGED_IN.USER_ID.equal(EMAIL_ACCOUNT.PASS_ID)).
  and(LOGGED_IN.USER_ID.equal(userId.toInt)).asInstanceOf[ResultQuery[Record]]
}

Please note that the important part is that I need to convert Long to Int with this code userId.toInt, otherwise it will not compile

Answer 1

In your database, LOGGED_IN.USER_ID is probably of the SQL type INT which has its best equivalence in a Java Integer or a Scala Int. If you wanted to operate on a Long, you should change your database column's type to BIGINT.

There's no way around this "limitation", which is a good thing in my opinion. For instance, you cannot insert a Long into an INT database column. With jOOQ, the Java / Scala compilers will prevent that from happening accidentally.

Workaround using implicit conversion

There is a workaround in Scala for this kind of problem. You can, of course try to apply implicit conversion by extending the existing jOOQ-scala tools.

trait SNumberField[T <: Number] extends SAnyField[T] {
  // [...]
  def equal(value : Number)        : Condition;
  def equal(value : Field[Number]) : Condition;
}

abstract class NumberFieldBase[T <: Number](override val underlying: Field[T])
    extends AnyFieldBase[T] (underlying)
    with SNumberField[T] {

  // [...]
  def equal(value : Number)
    = underlying.equal(underlying.getDataType().convert(value));
  def equal(value : Field[_ <: Number]) 
    = underlying.equal(value.coerce(underlying.getDataType());
}