You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openjpa.apache.org by Fabien Charlet <fa...@gmail.com> on 2009/11/17 10:41:50 UTC

Bug with HsqlDB ?

Hello !

I have a weird problem.
I use an object Log, mapped with a table LOG in HsqlDB.

When I try to execute a "DELETE FROM Log" query, but I have an error
with the SQL code generated :

782  openjpa  TRACE  [main] openjpa.Query - Executing query: [DELETE
FROM Log l WHERE l.application = :application AND l.logDate < :aDate]
with parameters: {application=Isis, aDate=Tue Nov 17 10:12:26 CET
2009}
[KO] SimpleLogDAO.purgeLogs( Application@45d8241 Isis, Date@16a1227
Tue Nov 17 10:12:26 CET 2009 ) returned ReportingSQLException:
unexpected token: T0 {DELETE FROM LOG t0 WHERE (t0.APPLICATION_ID = ?
AND t0.LOG_DATE < ?)} [code=-5581, state=42581]
3782  openjpa  TRACE  [main] openjpa.jdbc.JDBC - <t 914454, conn
12437155> [0 ms] rollback
3782  openjpa  TRACE  [main] openjpa.jdbc.JDBC - <t 914454, conn
12437155> [0 ms] close

It seems that this HQL query generate "DELETE FROM LOG t0" but HsqlDB
doesn't suport a token after the table name in the delete statement.

Did I miss something ?

I use this mapping :

@Entity
@Table(name="LOG")
public class Log implements RestrictedObject, ICrudEntity {

  @Id
  @GeneratedValue(strategy=GenerationType.IDENTITY)
  private long id;

  @Column(name="VERSION")
  @Version
  private int version;

  @Column(name="USER")
  private String user;

  @OneToOne(fetch=FetchType.LAZY)
  @JoinColumn(name="APPLICATION_ID", referencedColumnName="ID")
  private Application application;

  @Column(name="APPLICATION_VERSION")
  private String applicationVersion;

  @Column(name="NETWORK_INFORMATION")
  private String networkInformation;

  @Column(name="MESSAGE")

  private String message;

  @Column(name="LOG_DATE")
  private Date logDate;

  @OneToOne(fetch=FetchType.LAZY)
  @JoinColumn(name="CATEGORY_ID", referencedColumnName="ID")
  private Category category;

  @Transient
  private List<File> datas = new ArrayList<File>();

....
}

And I create the table in HsqlDB with this query :

statement.executeUpdate("CREATE TABLE LOG ( ID BIGINT GENERATED BY
DEFAULT AS IDENTITY(START WITH 1) PRIMARY KEY, " +
        "VERSION INT," +
        "USER VARCHAR(20)," +
        "APPLICATION_ID BIGINT," +
        "APPLICATION_VERSION VARCHAR(20)," +
        "NETWORK_INFORMATION VARCHAR(40)," +
        "MESSAGE VARCHAR(1000)," +
        "LOG_DATE TIMESTAMP," +
        "CATEGORY_ID BIGINT)");

Thanks for your help !

Best regards

Fabien CHARLET

Re: Bug with HsqlDB ?

Posted by Michael Dick <mi...@gmail.com>.
Hi Fabien,

Sounds like a bug, could you open an issue at
http://issues.apache.org/jira/browse/OPENJPA ?

Thanks for finding it,
-mike

On Tue, Nov 17, 2009 at 3:41 AM, Fabien Charlet <fa...@gmail.com>wrote:

> Hello !
>
> I have a weird problem.
> I use an object Log, mapped with a table LOG in HsqlDB.
>
> When I try to execute a "DELETE FROM Log" query, but I have an error
> with the SQL code generated :
>
> 782  openjpa  TRACE  [main] openjpa.Query - Executing query: [DELETE
> FROM Log l WHERE l.application = :application AND l.logDate < :aDate]
> with parameters: {application=Isis, aDate=Tue Nov 17 10:12:26 CET
> 2009}
> [KO] SimpleLogDAO.purgeLogs( Application@45d8241 Isis, Date@16a1227
> Tue Nov 17 10:12:26 CET 2009 ) returned ReportingSQLException:
> unexpected token: T0 {DELETE FROM LOG t0 WHERE (t0.APPLICATION_ID = ?
> AND t0.LOG_DATE < ?)} [code=-5581, state=42581]
> 3782  openjpa  TRACE  [main] openjpa.jdbc.JDBC - <t 914454, conn
> 12437155> [0 ms] rollback
> 3782  openjpa  TRACE  [main] openjpa.jdbc.JDBC - <t 914454, conn
> 12437155> [0 ms] close
>
> It seems that this HQL query generate "DELETE FROM LOG t0" but HsqlDB
> doesn't suport a token after the table name in the delete statement.
>
> Did I miss something ?
>
> I use this mapping :
>
> @Entity
> @Table(name="LOG")
> public class Log implements RestrictedObject, ICrudEntity {
>
>  @Id
>  @GeneratedValue(strategy=GenerationType.IDENTITY)
>  private long id;
>
>  @Column(name="VERSION")
>  @Version
>  private int version;
>
>  @Column(name="USER")
>  private String user;
>
>  @OneToOne(fetch=FetchType.LAZY)
>  @JoinColumn(name="APPLICATION_ID", referencedColumnName="ID")
>  private Application application;
>
>  @Column(name="APPLICATION_VERSION")
>  private String applicationVersion;
>
>  @Column(name="NETWORK_INFORMATION")
>  private String networkInformation;
>
>  @Column(name="MESSAGE")
>
>  private String message;
>
>  @Column(name="LOG_DATE")
>  private Date logDate;
>
>  @OneToOne(fetch=FetchType.LAZY)
>  @JoinColumn(name="CATEGORY_ID", referencedColumnName="ID")
>  private Category category;
>
>  @Transient
>  private List<File> datas = new ArrayList<File>();
>
> ....
> }
>
> And I create the table in HsqlDB with this query :
>
> statement.executeUpdate("CREATE TABLE LOG ( ID BIGINT GENERATED BY
> DEFAULT AS IDENTITY(START WITH 1) PRIMARY KEY, " +
>        "VERSION INT," +
>        "USER VARCHAR(20)," +
>        "APPLICATION_ID BIGINT," +
>        "APPLICATION_VERSION VARCHAR(20)," +
>        "NETWORK_INFORMATION VARCHAR(40)," +
>        "MESSAGE VARCHAR(1000)," +
>        "LOG_DATE TIMESTAMP," +
>        "CATEGORY_ID BIGINT)");
>
> Thanks for your help !
>
> Best regards
>
> Fabien CHARLET
>