How to know whether a particular row exists in table

I have a Table USTCOLOR which has two colomns project_reference and Color_Codes.

How do i find a particular project reference exists in the table or not?

Are you using an ORM for this? If so, which one?

Yes...I am using Hibernate

I am using Oracle database

Well you can get it by its primary key or look it up via a query. See the Session interface and its various get and createQuery methods.

thanks for the information paul.....But i am completely new with the Hibernate...I really some code stuff...

Hi,

if you are new to Hibernate take look at Java Persistence with Hibernate - Chapter 2 for a deeper understanding. There search for createQuery.

Regards,
Darya