From: | Vernon <vwu725(at)yahoo(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Error with a hibernate query |
Date: | 2005-04-15 00:16:06 |
Message-ID: | 20050415001606.11426.qmail@web40502.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
The Java code:
public class User {
private Long id;
private String username;
private String password;
//...
}
The DB table:
create table USERS (
id SERIAL UNIQUE primary key,
username VARCHAR(80) NOT NULL,
password VARCHAR(80) NOT NULL,
...
);
The Hibernate query:
getHibernateTemplate().findByNamedParam("select u from
User as u where u.username=:username and
u.password=:password", new String[] { "username",
"password" }
From the stack, the following error seems to be on the
JDBC driver side. Any suggestions of solving this
problem?
org.springframework.jdbc.BadSqlGrammarException: Bad
SQL grammar [] in task 'Hibernate operation'; nested
exception is java.sql.SQLException: ERROR: operator
does not exist: character varying = bytea
java.sql.SQLException: ERROR: operator does not exist:
character varying = bytea
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1365)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1160)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:172)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:387)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:328)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:238)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
at
net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:88)
at
net.sf.hibernate.loader.Loader.getResultSet(Loader.java:875)
at
net.sf.hibernate.loader.Loader.doQuery(Loader.java:269)
at
net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)
at
net.sf.hibernate.loader.Loader.doList(Loader.java:1033)
at
net.sf.hibernate.loader.Loader.list(Loader.java:1024)
at
net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854)
at
net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1553)
at
net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:39)
at
__________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2005-04-15 00:33:45 | Re: Error with a hibernate query |
Previous Message | Alan Stange | 2005-04-14 23:53:36 | Re: process large tables |