SpringSource/spring-social — Issue #24: JdbcUsersConnectionRepository.sql isn't compatible with MySQL
Author: danwashusen
Created: 2011-11-29 20:22:45+00:00
State: open

Running JdbcUsersConnectionRepository.sql on MySQL 5.1 gives the following error:
[ERROR in query 1] Specified key was too long; max key length is 1000 bytes

The culprit being: primary key (userId, providerId, providerUserId)

Reducing the size of the userId, providerId and/or providerUserId columns resolves the issue...