cayenne-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Fernando Perez (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CAY-2441) No puedo insertar un texto AES-256 en Columna MySQL BLOB desde Cayenne
Date Fri, 15 Jun 2018 21:26:00 GMT
Fernando Perez created CAY-2441:
-----------------------------------

             Summary: No puedo insertar un texto AES-256 en Columna MySQL BLOB desde Cayenne
                 Key: CAY-2441
                 URL: https://issues.apache.org/jira/browse/CAY-2441
             Project: Cayenne
          Issue Type: Bug
          Components: Database integration
    Affects Versions: 4.0.RC1
         Environment: JSF2.0, Payara Server 4.1.2.174, JDK 7, MySQL5.6.38
            Reporter: Fernando Perez


Hola, al tratar de guardar una contraseña AES-256 en MySQL me manda el siguiente error:

INFORMACIÓN: *** error.
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the right syntax to use
near 'desc, password, target, type_idtype, user) VALUES ('', x'4F38726A5574395A6C4C384' at
line 1

Insesión:

INFORMACIÓN: INSERT INTO passwords.password (desc, password, target, type_idtype, user) VALUES
(?, ?, ?, ?, ?)
INFORMACIÓN: [bind: 1->desc:'', 2->*password:'O8rjUt9ZlL8Mybz7B8O/5w=='*, 3->target:'192.168.15.15',
4->type_idtype:1, 5->user:'nando']

Tabla en Base de Datos:

CREATE TABLE `password` (
 `idpassword` int(11) NOT NULL AUTO_INCREMENT,
 `user` varchar(45) COLLATE utf8_spanish_ci NOT NULL,
 `password` blob NOT NULL,
 `target` mediumtext COLLATE utf8_spanish_ci NOT NULL,
 `desc` mediumtext COLLATE utf8_spanish_ci,
 `type_idtype` int(11) NOT NULL,
 PRIMARY KEY (`idpassword`),
 KEY `fk_password_type1_idx` (`type_idtype`),
 CONSTRAINT `fk_password_type1` FOREIGN KEY (`type_idtype`) REFERENCES `type` (`idtype`) ON
DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

Usando *SQLTemplate* y Consola SQL guarda bien, pero no puedo obtener el ID del registro insertado
para usarlo con el elemento padre.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message