Hello, i have a problem with a query like this

from doc in class model.Document
where doc.fecha = :fecha


and i set a query like this



Query q= session.getNamedQuery(.....
q.setDate("fecha",fecha)

Where fecha is 14/01/2004 and in the dataBase the column that map to this propties has the same value

The problem is that the query dosen't return any value, when it must return at least 100 rows

Can anyone help me please !!!!!!!!!!1

PD: sorry about my english

How did you map this? Have you mapped the property as type="date" and are you passing an java.util.Data to the query? Please show your mapping and your actual code.

Note that in class is deprecated and not maintained.
Prefer

this is my mapping

<class name="cl.sichile.documentos.model.Documento" table="DOC_DOC" >

<id name="id" column="id">
<generator class="native"/>
</id>


<!--
<id name="id" column="ID" unsaved-value="-1">
<generator class="native"/>

<generator class="sequence">
<param name="sequence">DOCUMENT_SEQUENCE</param>
</generator>
</id>
-->
<property name="numeroDocumento" column="DOC_NUM_DOC"/>
<property name="fecha" column="DOC_FEC_ING" type="date"/>
<property name="fechaControl" column="DOC_FECHA_CONTROL" type="date"/>

</class>

i try to set de type = date and didn't work

Another thing to try ??

What is the database field type? Are you actually passing a java.util.Date as query parameter?

the dataBase is SQLSERVER
the type of the field is dateTime
and i pass the parameter as java.util.Date

Don't forget the database will do an *exact* match on the date/time.
Unfortunately, the DB and Java dates do not have the same precision - up to the second only for the DB date...

Have a look at the API JavaDoc for java.sql.Date - there is warning saying you have to set the milliseconds to 0 on your java.util.Date...

the milliseconds in the parameter is setting to 0, but no in the data base,
i nid the minutes and seconds for other operation, but in the query i only need to compare by day month year

another chance ??

Did you set hour, min & sec to 0 as well in the date you give as argument to the query ?

i set min & sec to 0 as well in the date i give as argument
but in the data base the min & sec is not 0

Can anyone help me with this problem please !!!!!!