Is the multiline codec supposed to work with the JDBC input plugin?

Yes, it ignores the codec. The only reason it enables the codec option is that logstash requires it. Every input and output has to have a codec option. Using it is optional.

This is another example of this, with a workaround.