slick.SlickException: Invalid default value None for non-nullable column FOO.BEGIN_DATE of type java.sql.Timestamp, meta data: MColumn(MQName(FOO),BEGIN_DATE,93,TIMESTAMP(0),Some(7),Some(0),10,Some(false),None,Some(NULL ),7,3,Some(false),None,None,Some(false))

GitHub | OUeasley | 8 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Invalid default value None for non-nullable column. (Oracle)

    GitHub | 8 months ago | OUeasley
    slick.SlickException: Invalid default value None for non-nullable column FOO.BEGIN_DATE of type java.sql.Timestamp, meta data: MColumn(MQName(FOO),BEGIN_DATE,93,TIMESTAMP(0),Some(7),Some(0),10,Some(false),None,Some(NULL ),7,3,Some(false),None,None,Some(false))

    Root Cause Analysis

    1. slick.SlickException

      Invalid default value None for non-nullable column FOO.BEGIN_DATE of type java.sql.Timestamp, meta data: MColumn(MQName(FOO),BEGIN_DATE,93,TIMESTAMP(0),Some(7),Some(0),10,Some(false),None,Some(NULL ),7,3,Some(false),None,None,Some(false))

      at slick.jdbc.JdbcModelBuilder$ColumnBuilder$$anonfun$defaultColumnOption$3$$anonfun$apply$18$$anonfun$apply$19.apply()
    2. slick.jdbc
      JdbcModelBuilder$ColumnBuilder$$anonfun$defaultColumnOption$3$$anonfun$apply$18$$anonfun$apply$19.apply
      1. slick.jdbc.JdbcModelBuilder$ColumnBuilder$$anonfun$defaultColumnOption$3$$anonfun$apply$18$$anonfun$apply$19.apply(JdbcModelBuilder.scala:257)
      2. slick.jdbc.JdbcModelBuilder$ColumnBuilder$$anonfun$defaultColumnOption$3$$anonfun$apply$18$$anonfun$apply$19.apply(JdbcModelBuilder.scala:257)
      2 frames
    3. Scala
      Option.getOrElse
      1. scala.Option.getOrElse(Option.scala:121)
      1 frame
    4. slick.jdbc
      JdbcModelBuilder$ColumnBuilder$$anonfun$defaultColumnOption$3$$anonfun$apply$18.apply
      1. slick.jdbc.JdbcModelBuilder$ColumnBuilder$$anonfun$defaultColumnOption$3$$anonfun$apply$18.apply(JdbcModelBuilder.scala:257)
      2. slick.jdbc.JdbcModelBuilder$ColumnBuilder$$anonfun$defaultColumnOption$3$$anonfun$apply$18.apply(JdbcModelBuilder.scala:254)
      2 frames
    5. Scala
      Option.map
      1. scala.Option.map(Option.scala:146)
      1 frame
    6. slick.jdbc
      JdbcModelBuilder$ColumnBuilder$$anonfun$defaultColumnOption$3.apply
      1. slick.jdbc.JdbcModelBuilder$ColumnBuilder$$anonfun$defaultColumnOption$3.apply(JdbcModelBuilder.scala:254)
      2. slick.jdbc.JdbcModelBuilder$ColumnBuilder$$anonfun$defaultColumnOption$3.apply(JdbcModelBuilder.scala:254)
      2 frames
    7. Scala
      Option.getOrElse
      1. scala.Option.getOrElse(Option.scala:121)
      1 frame
    8. slick.jdbc
      JdbcModelBuilder$TableBuilder$$anonfun$columns$1.apply
      1. slick.jdbc.JdbcModelBuilder$ColumnBuilder.defaultColumnOption(JdbcModelBuilder.scala:253)
      2. slick.jdbc.JdbcModelBuilder$ColumnBuilder.convenientDefault(JdbcModelBuilder.scala:263)
      3. slick.jdbc.JdbcModelBuilder$ColumnBuilder.model(JdbcModelBuilder.scala:281)
      4. slick.jdbc.JdbcModelBuilder$TableBuilder$$anonfun$columns$1.apply(JdbcModelBuilder.scala:163)
      5. slick.jdbc.JdbcModelBuilder$TableBuilder$$anonfun$columns$1.apply(JdbcModelBuilder.scala:163)
      5 frames
    9. Scala
      AbstractTraversable.map
      1. scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)
      2. scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)
      3. scala.collection.Iterator$class.foreach(Iterator.scala:893)
      4. scala.collection.AbstractIterator.foreach(Iterator.scala:1336)
      5. scala.collection.IterableLike$class.foreach(IterableLike.scala:72)
      6. scala.collection.AbstractIterable.foreach(Iterable.scala:54)
      7. scala.collection.TraversableLike$class.map(TraversableLike.scala:234)
      8. scala.collection.AbstractTraversable.map(Traversable.scala:104)
      8 frames
    10. slick.jdbc
      JdbcModelBuilder$$anonfun$buildModel$3$$anonfun$apply$17.apply
      1. slick.jdbc.JdbcModelBuilder$TableBuilder.columns$lzycompute(JdbcModelBuilder.scala:163)
      2. slick.jdbc.JdbcModelBuilder$TableBuilder.columns(JdbcModelBuilder.scala:163)
      3. slick.jdbc.JdbcModelBuilder$TableBuilder.buildModel(JdbcModelBuilder.scala:161)
      4. slick.jdbc.JdbcModelBuilder$$anonfun$buildModel$3$$anonfun$apply$17.apply(JdbcModelBuilder.scala:96)
      5. slick.jdbc.JdbcModelBuilder$$anonfun$buildModel$3$$anonfun$apply$17.apply(JdbcModelBuilder.scala:96)
      5 frames
    11. Scala
      List.map
      1. scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)
      2. scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)
      3. scala.collection.immutable.List.foreach(List.scala:381)
      4. scala.collection.TraversableLike$class.map(TraversableLike.scala:234)
      5. scala.collection.immutable.List.map(List.scala:285)
      5 frames
    12. slick.jdbc
      JdbcModelBuilder$$anonfun$buildModel$3.apply
      1. slick.jdbc.JdbcModelBuilder$$anonfun$buildModel$3.apply(JdbcModelBuilder.scala:96)
      2. slick.jdbc.JdbcModelBuilder$$anonfun$buildModel$3.apply(JdbcModelBuilder.scala:93)
      2 frames
    13. slick.dbio
      DBIOAction$$anonfun$map$1.apply
      1. slick.dbio.DBIOAction$$anonfun$map$1.apply(DBIOAction.scala:44)
      2. slick.dbio.DBIOAction$$anonfun$map$1.apply(DBIOAction.scala:44)
      2 frames
    14. slick.basic
      BasicBackend$DatabaseDef$$anonfun$runInContext$1.apply
      1. slick.basic.BasicBackend$DatabaseDef$$anonfun$runInContext$1.apply(BasicBackend.scala:149)
      2. slick.basic.BasicBackend$DatabaseDef$$anonfun$runInContext$1.apply(BasicBackend.scala:149)
      2 frames
    15. Scala
      ForkJoinWorkerThread.run
      1. scala.concurrent.Future$$anonfun$flatMap$1.apply(Future.scala:253)
      2. scala.concurrent.Future$$anonfun$flatMap$1.apply(Future.scala:251)
      3. scala.concurrent.impl.CallbackRunnable.run(Promise.scala:32)
      4. scala.concurrent.impl.ExecutionContextImpl$AdaptedForkJoinTask.exec(ExecutionContextImpl.scala:121)
      5. scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260)
      6. scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.pollAndExecAll(ForkJoinPool.java:1253)
      7. scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1346)
      8. scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979)
      9. scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107)
      9 frames