java.lang.IllegalArgumentException: Parameter UserName does not exist

[R Naijat]

Hi everybody,
I connect and run queries against Oracle DB using Hibernate. I have the following piece of code:

String query = "SELECT Id, Date FROM tableName WHERE UserName=:username AND UserId=:userId";
																		  
List<Object[]> result = sessionFactory.getCurrentSession().createSQLQuery(query).setString("UserName", username).setInteger("UserId", userId).list();

I receive the following error:

java.lang.IllegalArgumentException: Parameter UserName does not exist as a named parameter in [SELECT Id, Date FROM tableName WHERE UserName=:username AND UserId=:userId]

Does anybody know what am I doing wrong? Any help is greatly appreciated.

[R Naijat]

In the query, UserName and UserId refer to the columns in the db which actually are not case sensitive; however, :username and :userId are parameters that we need to set values for, so setString("username", username), the first item is case sensitive and should match what we have in :username, and setInteger("userId", userId): the first parameter should match what we have in :userId.

So the following works with no error:

String query = "SELECT Id, Date FROM tableName WHERE UserName=:username AND UserId=:userId";
				  
List<Object[]> result = sessionFactory.getCurrentSession().createSQLQuery(query).setString("username", username).setInteger("userId", userId).list();

Thought it might help somebody.