Problem solved. Question marks shouldn´t be inside apostrophes 'SELECT * FROM chaves_de_encriptacao WHERE numero_funcional = ?' and not: 'SELECT * FROM chaves_de_encriptacao WHERE numero_funcional = ''?''' 2017-09-18 20:11 GMT-03:00 Casimiro de Almeida Barreto < casimiro.barreto@gmail.com>:
By the way, the following script fails with the same Exception (mysql_stmt_send_long_data):
| db str sttmt |
db := GADriver connectToConnectionString: 'mysql://localhost:3306/leaincertezas?user=learoot&password=welcomeLEA'.
str := 'INSERT INTO chaves_de_encriptacao (numero_funcional, chave_privada, chave_publica) VALUES (''?'', ''?'', ''?'')'.
sttmt := db prepare: str. sttmt at: 1 bind: '10'. sttmt at: 2 bind: '0BC0DE0FG32A128AB2EF01'. sttmt at: 3 bind: 'BEC0D01279F92123FAB2E0'.
sttmt execute.
db close.
But the script:
| db str sttmt |
db := GADriver connectToConnectionString: 'mysql://localhost:3306/leaincertezas?user=learoot&password=welcomeLEA'.
str := 'INSERT INTO chaves_de_encriptacao (numero_funcional, chave_privada, chave_publica) VALUES (''10'', ''0BC0DE0FG32A128AB2EF01'', ''0BC0DE0FG32A128AB2EF01'')'.
db execute: str.
db close.
Results:
MariaDB [leaincertezas]> SELECT * FROM chaves_de_encriptacao; +------------------+------------------------+------------------------+ | numero_funcional | chave_privada | chave_publica | +------------------+------------------------+------------------------+ | 10 | 0BC0DE0FG32A128AB2EF01 | 0BC0DE0FG32A128AB2EF01 | +------------------+------------------------+------------------------+ 1 row in set (0.00 sec)
-- The information contained in this message is confidential and intended to the recipients specified in the headers. If you received this message by error, notify the sender immediately. The unauthorized use, disclosure, copy or alteration of this message are strictly forbidden and subjected to civil and criminal sanctions.