Re: Error with a hibernate query - Mailing list pgsql-jdbc

Do you have a hibernate mapping file ?

Dave

Vernon wrote:

>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/
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
>
>
>

--
Dave Cramer
http://www.postgresintl.com
519 939 0336
ICQ#14675561