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.