Slick报错：Exception in thread “main“ slick.SlickException: Read NULL value (null) for ResultSet column

一、问题描述

使用slick连接mysql数据库，查询数据，结果报错

Exception in thread "main" slick.SlickException: Read NULL value (null) for ResultSet column <computed>
	at slick.jdbc.SpecializedJdbcResultConverter$$anon$1.read(SpecializedJdbcResultConverters.scala:27)
	at slick.jdbc.SpecializedJdbcResultConverter$$anon$1.read(SpecializedJdbcResultConverters.scala:24)
	at slick.relational.ProductResultConverter.read(ResultConverter.scala:56)
	at slick.relational.ProductResultConverter.read(ResultConverter.scala:46)
	at slick.relational.TypeMappingResultConverter.read(ResultConverter.scala:136)
	at slick.driver.JdbcInvokerComponent$QueryInvokerImpl.extractValue(JdbcInvokerComponent.scala:37)
	at slick.jdbc.StatementInvoker$$anon$1.extractValue(StatementInvoker.scala:67)
	at slick.jdbc.PositionedResultIterator.fetchNext(PositionedResult.scala:176)
	at slick.util.ReadAheadIterator$class.slick$util$ReadAheadIterator$$update(ReadAheadIterator.scala:34)
	at slick.util.ReadAheadIterator$class.hasNext(ReadAheadIterator.scala:40)
	at slick.jdbc.PositionedResultIterator.hasNext(PositionedResult.scala:167)
	at scala.collection.Iterator$class.foreach(Iterator.scala:893)
	at slick.jdbc.PositionedResultIterator.foreach(PositionedResult.scala:167)
	at slick.jdbc.Invoker$class.foreach(Invoker.scala:49)
	at slick.jdbc.StatementInvoker.foreach(StatementInvoker.scala:16)
	at slick.jdbc.StreamingInvokerAction$class.run(StreamingInvokerAction.scala:22)
	at slick.driver.JdbcActionComponent$QueryActionExtensionMethodsImpl$$anon$1.run(JdbcActionComponent.scala:218)
	at slick.driver.JdbcActionComponent$QueryActionExtensionMethodsImpl$$anon$1.run(JdbcActionComponent.scala:218)
	at slick.backend.DatabaseComponent$DatabaseDef$$anon$2.liftedTree1$1(DatabaseComponent.scala:237)
	at slick.backend.DatabaseComponent$DatabaseDef$$anon$2.run(DatabaseComponent.scala:237)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)

二、问题原因

经查询，是因为映射表的某几列是可能为空值的，导致报错null

三、解决办法

将映射的对应字段，添加Option

def descs = column[String]("descs")

替换为

def descs = column[Option[String]]("descs")

四、参考

1.https://blog.csdn.net/Vector97/article/details/104727263/