Hibernate Community • View topic - Bind type problem for named queries

View unanswered posts | View active topics

Board index » Projects » Search, Validator, Shards

All times are UTC - 5 hours [ DST ]

Bind type problem for named queries

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

UTDrew

Post subject: Bind type problem for named queries

Posted: Fri Oct 06, 2006 3:54 pm

Newbie

Joined: Wed May 03, 2006 5:09 pm
Posts: 17

Hibernate version:
3.2.0 cr 4

Full stack trace of any exception that occurs:

Name and version of the database you are using:

Oracle 10g r2

The generated SQL (show_sql=true):

2006-10-06 12:50:25,767 DEBUG [org.hibernate.SQL]
select
quser0_.qUserId as qUserId73_,
quser0_.businessId as businessId73_,
quser0_.username as username73_,
quser0_.firstName as firstName73_,
quser0_.lastName as lastName73_,
quser0_.internal as internal73_,
quser0_.userAccountStatusId as userAcc15_73_,
quser0_.forcePasswordChange as forcePas7_73_,
quser0_.emailAddress as emailAdd8_73_,
quser0_.passwordChangeDate as password9_73_,
quser0_.accountExpirationDate as account10_73_,
quser0_.failedLoginAttempts as failedL11_73_,
quser0_.impersonatable as imperso12_73_,
quser0_.statusChangeDate as statusC13_73_,
quser0_.template as template73_
from
QUser quser0_
where
quser0_.qUserId like ?

Debug level Hibernate log excerpt:

Hi,

I'm having a problem where I'm trying to do a query like this:

Code:

SELECT * FROM TestTable WHERE testId like '1%'

My EJBQL/HQL looks like this:

Code:

SELECT tt FROM TestTable tt WHERE tt.testId LIKE :testId

If I try to set the parameter :testId to "1%" I get a TypeMismatchException telling me that I can't set the parameter to be a String, that it has to be an Integer.

Is there somehow to tell hibernate to ignore doing any type checking on the value or some other way I could do this sort of query? There are a number of situations where I would like to be able to do a like query on a non-string field.

BTW, I can execute the following query just fine if I don't use a parameter for the '1%':

Code:

SELECT tt FROM TestTable tt WHERE tt.testId LIKE '1%'

Entity Definition:

Code:

@Entity
@NamedQuery(name="test",query="SELECT tt FROM TestTable tt WHERE tt.testId LIKE :testId")
public class TestTable implements Serializable {

  @Id
  private int testId;

  public int getTestId() {
    return testId;
  }
  public void setTestId(int id) {
    this.testId = id;
  }

}

Top

Page 1 of 1

[ 1 post ]

Board index » Projects » Search, Validator, Shards

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum