I connect and run queries against Oracle DB using Hibernate. I have the following piece of code:
I receive the following error:
Does anybody know what am I doing wrong? Any help is greatly appreciated.
Joined: Nov 01, 2011
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:
Thought it might help somebody.
subject: java.lang.IllegalArgumentException: Parameter UserName does not exist