Hi Sergio, my first thought was that you have problems how to include dates in your query but as you stated now it seams you managed that. Having a second look on your code I found that you will have the problem that your query returns the wrong records. This relates to the way you map the dates to your database with string and the pattern 'dd/MM/yyyy'. With the pattern you use a date '01/12/2004' comes before '13/01/2004' which is obviously not what you want. I suggest you to change your mapping to 'yyyy/MM/dd'. This is also easy to read but has the advantage that you'll be able to sort your records with that field and your query will return the results you expect.
Ralf Sergio Collantes schrieb: > 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] > ------------------------------------------------- -- Syscon Ingenieurbüro für Meß- und Datentechnik GmbH Ralf Joachim Raiffeisenstraße 11 D-72127 Kusterdingen Germany Tel. +49 7071 3690 52 Mobil: +49 173 9630135 Fax +49 7071 3690 98 Email: [EMAIL PROTECTED] Web: www.syscon-world.de ------------------------------------------------- If you wish to unsubscribe from this list, please send an empty message to the following address: [EMAIL PROTECTED] -------------------------------------------------
