Robin Moffatt 3/11/2021

Kafka Connect - SQLSyntaxErrorException: BLOB/TEXT column … used in key specification without a key length

Read Original

This technical article details a specific error encountered when using the Kafka Connect JDBC Sink connector with MySQL: 'SQLSyntaxErrorException: BLOB/TEXT column used in key specification without a key length'. It explains the cause, which involves auto-creating tables with a TEXT column as a primary key, and discusses the connector's type mapping and MySQL's constraints on primary keys.

Kafka Connect - SQLSyntaxErrorException: BLOB/TEXT column … used in key specification without a key length

Comments

No comments yet

Be the first to share your thoughts!

Browser Extension

Get instant access to AllDevBlogs from your browser

Top of the Week

1
The Beautiful Web
Jens Oliver Meiert 2 votes
2
Container queries are rad AF!
Chris Ferdinandi 2 votes
3
Quoting Thariq Shihipar
Simon Willison 2 votes
4
Wagon’s algorithm in Python
John D. Cook 1 votes
6
Top picks — 2026 January
Paweł Grzybek 1 votes
7
In Praise of –dry-run
Henrik Warne 1 votes
9
Vibe coding your first iOS app
William Denniss 1 votes