Addressing the “invalid column index” SQLException is easy. One solution is to change the “def” on lines 18-21 to an explicit “String” type.