Sorry, I didn't include that information.
Obviusly, what I try to do is to filter the results,
getting only those within certain Dates. When I execute
the query it return all the rows in the DB, even the ones that
are not supposed to be included. When I use the equal
operator, the resultset returns 0 results, no matter if the
Date exist in the database or not. No exceptions, and no other
extrage behavior.
Thanks for all.
On Mon, 22 Aug 2005 14:38:23 +0200, Werner Guttmann
<[EMAIL PROTECTED]> wrote:
Hi Sergio,
how does the problem actually manifest itself ? It is that the query
does not return anything ? Or do you get any exceptions ?
Werner
-----Ursprüngliche Nachricht-----
Von: Sergio Collantes [mailto:[EMAIL PROTECTED]
Gesendet: Montag, 22. August 2005 14:26
An: [email protected]
Betreff: Re: [castor-user] [JDO] Using OQL with Date
Hello, Ralf.
Thanks for your quick answer, but it does not solve
the problem. I have to say that is my fault, I explined
the problem in a wrong way. What I actually do is what
you suggested, bind the java.util.Date to the query (when
I posted that simple example, I forgot to do so, but in my
real app it is just what I do). Anyway, is does not work either.
Thank again, Ralf.
On Mon, 22 Aug 2005 13:53:15 +0200, Ralf Joachim
<[EMAIL PROTECTED]> wrote:
Hi Sergio,
you should be able to execute such a query with:
OQLQuery query = db.getOQLQuery(
"select a from MyClass a where a.mydate > $1");
query.bind(expirationDate);
QueryResults results = query.execute();
Regards
Ralf
Sergio Collantes schrieb:
Hi all:
I've been having trouble when trying to
build an OQL query using java.util.Date types.
Suppose we have a simple class "MyClass" with
a java.util.Date filed named "myDate".
The query goes like this:
select a from MyClass a where a.mydate > expirationDate
Let's suppose that the object expirationDate is declared
in this way:
Calendar calendar = Calendar.getInstance();
calendar.set (...) // Whe set the expiration date
java.util.Date expirationDate = calendar.getTime();
The field myDate is a varchar in the database, and the
mapping is correct (i.e. the data is converted to Date
correctly in the JDO, i have tried it and it works).
The mapping is declared as follows:
<field name="mydate" type="date">
<sql name="mydate" type="char[dd/MM/yyyy]"/>
</field>
I assume in doing the wrong query, ¿can anybody tell
me what do I have to do?
-------------------------------------------------
If you wish to unsubscribe from this list, please send an empty message
to the following address:
[EMAIL PROTECTED]
-------------------------------------------------
-------------------------------------------------
If you wish to unsubscribe from this list, please
send an empty message to the following address:
[EMAIL PROTECTED]
-------------------------------------------------
-------------------------------------------------
If you wish to unsubscribe from this list, please
send an empty message to the following address:
[EMAIL PROTECTED]
-------------------------------------------------
-------------------------------------------------
If you wish to unsubscribe from this list, please
send an empty message to the following address:
[EMAIL PROTECTED]
-------------------------------------------------
-------------------------------------------------
If you wish to unsubscribe from this list, please
send an empty message to the following address:
[EMAIL PROTECTED]
-------------------------------------------------
