Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Type of INBOX_ID column in inbox table is too narrow #164

Open
yevhenii-nadtochii opened this issue Sep 14, 2022 · 1 comment
Open

Type of INBOX_ID column in inbox table is too narrow #164

yevhenii-nadtochii opened this issue Sep 14, 2022 · 1 comment
Assignees
Labels

Comments

@yevhenii-nadtochii
Copy link

JdbcInboxStorage fails to insert a new message to inbox due to a too narrow type of INBOX_ID column:

com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'INBOX_ID' at row 1.

The possible workaround can be specifying of a custom TypeMapping that effectively substitutes all VARCHAR(255) column types to VARCHAR(512):

TypeMapping typeMapping = TypeMappingBuilder.basicBuilder()
        .add(Type.STRING_255, "VARCHAR(512)")
        .build();
JdbcStorageFactory factory = JdbcStorageFactory.newBuilder()
        .setTypeMapping(typeMapping)
        .setDataSource(dataSource)
        .build();
@yevhenii-nadtochii yevhenii-nadtochii changed the title Type of INBOX_ID column in inbox table is too short Type of INBOX_ID column in inbox table is too narrow Sep 14, 2022
@armiol armiol self-assigned this Apr 13, 2023
@armiol armiol added this to v1.9 Apr 13, 2023
@armiol armiol moved this to In Progress in v1.9 Apr 13, 2023
@armiol
Copy link
Contributor

armiol commented Apr 19, 2023

Addressed in 1.x via #168.

@armiol armiol moved this from In Progress to Done in v1.9 Apr 19, 2023
@armiol armiol removed their assignment Apr 19, 2023
@armiol armiol added this to v2.0 Nov 10, 2023
@armiol armiol moved this to 🏗 In progress in v2.0 Nov 10, 2023
armiol added a commit that referenced this issue Dec 4, 2023
See #164, previously addressed for `1.x` branch.
@armiol armiol self-assigned this Apr 17, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
Status: 🏗 In progress
Status: Done
Development

No branches or pull requests

2 participants