I got this very strange error message. This application works fine in another box. I copy and paste the query and run against the database, and it works just fine.

select user0_.USER_ID as USER1_3_, user0_.USERNAME as USERNAME3_, user0_.PASSWORD as PASSWORD3_ from SOMEDB.USERS user0_ where upper(user0_.USERNAME)='SOMEUSER'

What could be the problem here?

The hibernate query is:

hibernateTemplate.find(
" from User u where upper(u.username)=?",
username.toUpperCase());

Hibernate version:
3.1.3

Full stack trace of any exception that occurs:
2008-02-02 10:05:11,239 WARN [httpSSLWorkerThread-8080-0] (JDBCExceptionReporter.java:71) - SQL Error: 0, SQLState: 07001
2008-02-02 10:05:11,240 ERROR [httpSSLWorkerThread-8080-0] (JDBCExceptionReporter.java:72) - No value specified for parameter 2

Name and version of the database you are using:
mysql Ver 14.12 Distrib 5.0.45, for suse-linux-gnu (i686) using readline 5.2

The generated SQL (show_sql=true):
select user0_.USER_ID as USER1_3_, user0_.USERNAME as USERNAME3_, user0_.PASSWORD as PASSWORD3_ from SOMEDB.USERS user0_ where upper(user0_.USERNAME)=?

As the title said.