[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
[eclipselink-users] Error inserting a BLOB data type in MySQL
|
Hi!
My application fail to insert a BLOB data type. I have researched and tested
several alternatives but always gives me the same error.
any suggestions?
Regards.
Daniel R. Criado
========
Platform
=======
- EclipseLink version: 1.1.1.v20090430-r4097 (using javax.persistent_1.99)
- Spring Framework 2.5.6
- MySQL 5.1.33-community
- MYSQL Connector
===========
Class Code:
===========
@Entity
public class Test8 implements Serializable {
@Id
@GeneratedValue(strategy=GenerationType.IDENTITY)
private int id;
private String name;
@Lob
private byte[] desc;
@Temporal(TemporalType.TIMESTAMP)
private Date date;
private static final long serialVersionUID = 1L;
public Test8() {
super();
}
public int getId() {
return this.id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return this.name;
}
public void setName(String name) {
this.name = name;
}
public byte[] getDesc() {
return this.desc;
}
public void setDesc(byte[] desc) {
this.desc = desc;
}
public Date getDate() {
return this.date;
}
public void setDate(Date date) {
this.date = date;
}
}
=======
Database Script
=======
CREATE TABLE EXISTS `test8` (
`id` INT NOT NULL AUTO_INCREMENT ,
`name` VARCHAR(45) NULL ,
`desc` LONGBLOB NULL ,
`date` DATETIME NULL ,
PRIMARY KEY (`id`) )
ENGINE = InnoDB;
==========
Error description
=========
[EL Warning]: 2009-05-25
20:06:26.281--UnitOfWork(189219)--Thread(Thread[main,5,main])--Exception
[EclipseLink-4002] (Eclipse Persistence Services - 1.1.1.v20090430-r4097):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception:
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, NAME, DATE) VALUES
(_binary'<html>\r\n<body>\r\n\r\nThe classes in this pa' at line 1
Error Code: 1064
Call: INSERT INTO TEST8 (DESC, NAME, DATE) VALUES (?, ?, ?)
bind => [[B@1dacccc, prueba, 2009-05-25 20:06:25.718]
Query: InsertObjectQuery(leandra.test1_8.Test8@12c8fa8)
class org.springframework.orm.jpa.JpaSystemException Exception
[EclipseLink-4002] (Eclipse Persistence Services - 1.1.1.v20090430-r4097):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception:
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, NAME, DATE) VALUES
(_binary'<html>\r\n<body>\r\n\r\nThe classes in this pa' at line 1
Error Code: 1064
Call: INSERT INTO TEST8 (DESC, NAME, DATE) VALUES (?, ?, ?)
bind => [[B@1dacccc, prueba, 2009-05-25 20:06:25.718]
Query: InsertObjectQuery(leandra.test1_8.Test8@12c8fa8); nested exception is
javax.persistence.PersistenceException: Exception [EclipseLink-4002]
(Eclipse Persistence Services - 1.1.1.v20090430-r4097):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception:
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, NAME, DATE) VALUES
(_binary'<html>\r\n<body>\r\n\r\nThe classes in this pa' at line 1
Error Code: 1064
Call: INSERT INTO TEST8 (DESC, NAME, DATE) VALUES (?, ?, ?)
bind => [[B@1dacccc, prueba, 2009-05-25 20:06:25.718]
Query: InsertObjectQuery(leandra.test1_8.Test8@12c8fa8)
--
View this message in context: http://www.nabble.com/Error-inserting-a-BLOB-data-type-in-MySQL-tp23711038p23711038.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.