11:19 a.m.
Incorrect SQL syntax for EJB query involving Entity with composite Key
----------------------------------------------------------------------
Key: HHH-3797
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3797
Project: Hibernate Core
Issue Type: Bug
Components: query-hql
Environment: Hibernate JPA (hibernate3.jar), Sql Server 2003
Reporter: Diego Palumbo
Hello.
I have some trouble with queries on Entities with composite key as follow:
select count(o) from Logqueryt as o
the key is LogquerytPK.java (see the follwing definition).
Now i'm not able to see the SQL generated but when i try to excute my project i
receive an SQLGrammarException (see follow report)
I also red this issue (http://opensource.atlassian.com/projects/hibernate/browse/HHH-2266)
where was considered the same problem but I didn't hunderstand if this could be
considered a bug or if I have to use a different syntax for this kind of queries.
If it is a bug, was it fixed?
------------------LogquerytPK--------------------------------------------------
package entities;
import java.io.Serializable;
import javax.persistence.Basic;
import javax.persistence.Column;
import javax.persistence.Embeddable;
/**
*
* @author d.palumbo
*/
@Embeddable
public class LogquerytPK implements Serializable {
@Basic(optional = false)
@Column(name = "ID")
private int id;
@Basic(optional = false)
@Column(name = "ANNO")
private short anno;
public LogquerytPK() {
}
public LogquerytPK(int id, short anno) {
this.id = id;
this.anno = anno;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public short getAnno() {
return anno;
}
public void setAnno(short anno) {
this.anno = anno;
}
@Override
public int hashCode() {
int hash = 0;
hash += (int) id;
hash += (int) anno;
return hash;
}
@Override
public boolean equals(Object object) {
// TODO: Warning - this method won't work in the case the id fields are not
set
if (!(object instanceof LogquerytPK)) {
return false;
}
LogquerytPK other = (LogquerytPK) object;
if (this.id != other.id) {
return false;
}
if (this.anno != other.anno) {
return false;
}
return true;
}
@Override
public String toString() {
return "entities.LogquerytPK[id=" + id + ", anno=" + anno +
"]";
}
}
-------------------------------Exception-------------------------------------
4-mar-2009 10.12.20 org.hibernate.util.JDBCExceptionReporter logWarnings
AVVERTENZA: SQL Warning: 170, SQLState: 37000
4-mar-2009 10.12.20 org.hibernate.util.JDBCExceptionReporter logWarnings
AVVERTENZA: Preparing the statement failed: Line 1: Incorrect syntax near ','.
4-mar-2009 10.12.20 org.hibernate.util.JDBCExceptionReporter logExceptions
AVVERTENZA: SQL Error: 170, SQLState: 37000
4-mar-2009 10.12.20 org.hibernate.util.JDBCExceptionReporter logExceptions
GRAVE: Line 1: Incorrect syntax near ','.
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could
not execute query
at
org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:637)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:74)
at persistence.QueryTester.main(QueryTester.java:30)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2223)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:65)
... 1 more
Caused by: java.sql.SQLException: Line 1: Incorrect syntax near ','.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
at
net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
at
net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:777)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
at org.hibernate.loader.Loader.doQuery(Loader.java:674)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2220)
... 9 more
---------------------------------------------------------------------------
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira