[CONJ-448] QueryException: Incorrect arguments to mysqld_stmt_execute on inserting an "emptyString"-Lob with JPA - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 1.5.8, 1.5.9
Fix Version/s: 2.0.0-RC, 1.6.0
Component/s: Other
Labels:
None
Environment:
Hibernate 5.2.8

Description

JPA-Mapping:
@Entity
public class someEntity

{ ... @Lob private String property = ""; ... }

Since version 1.5.8 persisting a new instance of 'someEntity' fails with following exception:
javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute statement
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:147)
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:155)
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:162)
at org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:780)
at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:758)
at picture.infrastructure.rest.Request.persistEntity(Request.java:63)
Caused by: org.mariadb.jdbc.internal.util.dao.QueryException: Incorrect arguments to mysqld_stmt_execute
Query is: insert into SomeEntity (..., property, ...) values (...), parameters [...,<Buffer:''>, ...]
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1144)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1076)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1031)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executePreparedQuery(AbstractQueryProtocol.java:617)
at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeInternal(MariaDbServerPreparedStatement.java:401)
... 73 more

If the property contains a filled string, the entity will be persisted successfully.
Using an earlier Connector-version (e.g. 1.5.7) does not cause the exception.

Attachments

Activity

Ascending order - Click to sort in descending order

Stefan created issue - 2017-03-23 12:57

Stefan made changes - 2017-03-23 12:59

Field	Original Value	New Value
Description	@Entity public class someEntity{ ... @Lob private String property = ""; ... } Since version 1.5.8 persisting a new instance of 'someEntity' fails with following exception: Caused by: org.mariadb.jdbc.internal.util.dao.QueryException: Incorrect arguments to mysqld_stmt_execute Query is: insert into SomeEntity (..., property, ...) values (...), parameters [...,<Buffer:''>, ...] at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1144) at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1076) at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1031) at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executePreparedQuery(AbstractQueryProtocol.java:617) at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeInternal(MariaDbServerPreparedStatement.java:401) ... 73 more If the property contains a filled string, the object will be persisted successfully. Using an earlier Connector-version (e.g. 1.5.7) does not cause the exception.	JPA-Mapping: @Entity public class someEntity{ ... @Lob private String property = ""; ... } Since version 1.5.8 persisting a new instance of 'someEntity' fails with following exception: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute statement at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:147) at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:155) at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:162) at org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:780) at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:758) at picture.infrastructure.rest.Request.persistEntity(Request.java:63) Caused by: org.mariadb.jdbc.internal.util.dao.QueryException: Incorrect arguments to mysqld_stmt_execute Query is: insert into SomeEntity (..., property, ...) values (...), parameters [...,<Buffer:''>, ...] at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1144) at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1076) at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1031) at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executePreparedQuery(AbstractQueryProtocol.java:617) at org.mariadb.jdbc.MariaDbServerPreparedStatement.executeInternal(MariaDbServerPreparedStatement.java:401) ... 73 more If the property contains a filled string, the entity will be persisted successfully. Using an earlier Connector-version (e.g. 1.5.7) does not cause the exception.

Diego Dupin made changes - 2017-04-03 07:44

Status

Open [ 1 ]

In Progress [ 3 ]

Diego Dupin made changes - 2017-04-03 08:13

Fix Version/s

1.5.10 [ 22523 ]

Diego Dupin made changes - 2017-04-03 09:00

Component/s		Other [ 12201 ]
Resolution		Fixed [ 1 ]
Status	In Progress [ 3 ]	Closed [ 6 ]

Diego Dupin made changes - 2017-05-10 19:05

Fix Version/s		1.6.0 [ 22529 ]
Fix Version/s		2.0.0-RC [ 22119 ]
Fix Version/s	1.5.10 [ 22523 ]

Sergei Golubchik made changes - 2021-12-06 21:27

Workflow

MariaDB v3 [ 80098 ]

MariaDB v4 [ 134965 ]

People

Assignee:: Diego Dupin

Reporter:: Stefan

Votes:: 1 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2017-03-23 12:57

Updated:: 2017-05-10 19:05

Resolved:: 2017-04-03 09:00

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Connector/J