You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
With a table defined as :
CREATE TABLE question ( a? int(11) NOT NULL AUTO_INCREMENT, b? char(80) DEFAULT NULL, PRIMARY KEY (a?));
Inserting data with a prepared statement ( INSERT INTO question ( a? , b? ) VALUES ( ? , ?) ) would fail with :
org.drizzle.jdbc.internal.common.QueryException: You need to set exactly 4 parameters on the prepared statement
at org.drizzle.jdbc.internal.common.query.DrizzleParameterizedQuery.length(DrizzleParameterizedQuery.java:88)
at org.drizzle.jdbc.internal.common.packet.commands.StreamedQueryPacket.send(StreamedQueryPacket.java:67)
at org.drizzle.jdbc.internal.mysql.MySQLProtocol.executeQuery(MySQLProtocol.java:439)
at org.drizzle.jdbc.DrizzlePreparedStatement.executeUpdate(DrizzlePreparedStatement.java:126)
This is due to the fact that the parameterized query does not handle '`', but only single and double quote
The text was updated successfully, but these errors were encountered:
StephG38
pushed a commit
to gilius38/DrizzleJDBC
that referenced
this issue
Apr 13, 2018
With a table defined as :
CREATE TABLE
question
(a?
int(11) NOT NULL AUTO_INCREMENT,b?
char(80) DEFAULT NULL, PRIMARY KEY (a?
));Inserting data with a prepared statement ( INSERT INTO
question
(a?
,b?
) VALUES ( ? , ?) ) would fail with :org.drizzle.jdbc.internal.common.QueryException: You need to set exactly 4 parameters on the prepared statement
at org.drizzle.jdbc.internal.common.query.DrizzleParameterizedQuery.length(DrizzleParameterizedQuery.java:88)
at org.drizzle.jdbc.internal.common.packet.commands.StreamedQueryPacket.send(StreamedQueryPacket.java:67)
at org.drizzle.jdbc.internal.mysql.MySQLProtocol.executeQuery(MySQLProtocol.java:439)
at org.drizzle.jdbc.DrizzlePreparedStatement.executeUpdate(DrizzlePreparedStatement.java:126)
This is due to the fact that the parameterized query does not handle '`', but only single and double quote
The text was updated successfully, but these errors were encountered: