Like I said, I feel that this is a critical feature and have submitted bug reports explaining the problem and the fix - so far I haven't seen any interest in fixing it... But then again, I'm running 3.0 - so someone, in some later version, may have already fixed it; but it's doubtful.
-- Voytek Jarnot Quidquid latine dictum sit, altum viditur. > -----Original Message----- > From: salinaale [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 17, 2003 4:41 AM > To: torque-user > Subject: RE: Oracle and query date > > > Great!!!!!! > Now all is running!!!! Do you now if in new version 3.1 this > bug will be fixed? > Thanks! > > > Yes, my code matches yours (minus the println). > > > > Are you still getting the null pointer exception? If so, > did you see my text > > about the torque.properties file? That's what fixed my > null pointer - I > > then got other errors regarding the date format... > > > > -- > > Voytek Jarnot > > Quidquid latine dictum sit, altum viditur. > > > > > > > > > -----Original Message----- > > > From: salinaale [mailto:[EMAIL PROTECTED] > > > Sent: Wednesday, July 16, 2003 11:09 AM > > > To: torque-user > > > Subject: RE: Oracle and query date > > > > > > > > > Tx! > > > I've re compiled the torque project inserting this code but > > > it seams is not > > > used... where i'm wrong??? > > > > > > private static final String DATE_FORMAT = "dd-MM-yyyy HH:mm:ss"; > > > public String getDateString(Date date) { > > > > > > System.out.println("I'm here!!"); > > > return "TO_DATE('" + new > > > SimpleDateFormat(DATE_FORMAT).format(date) + "', > > > 'DD-MM-YYYY HH24:MI:SS')"; > > > } > > > > > > When i run the application i don't see any "I' m > here!!!!" string.... > > > You talk about a method getDateString(String) ... but that i > > > introduced is > > > getDateString(Date date)... is it correct??? > > > > > > Thanks for your patience! > > > > > > > > > > I had the same problem (and fixed it) back in february. > > > I've submitted TWO > > > > bug reports (along with code that solves the problem), > > > which seem to have > > > > been ignored... > > > > > > > > Here's my message about the fix from february: > > > > > > > > [QUOTING MYSELF] > > > > Well, I'm going to answer myself in the hopes that this > > > helps someone else, > > > > my null pointer exception was solved by adding > > > > torque.database.default.adapter=oracle to my > torque.properties file. > > > > > > > > That brought to light a whole new suite of problems with > > > using Dates in > > > > Criteria with Oracle. After wading through the source for > > > a while, I've > > > > fixed the problem by adding the following to > > > > org.apache.torque.adapter.DBOracle.java: > > > > > > > > private static final String DATE_FORMAT = "dd-MM-yyyy HH:mm:ss"; > > > > public String getDateString(Date date) { > > > > return "TO_DATE('" + new > > > SimpleDateFormat(DATE_FORMAT).format(date) + "', > > > > 'DD-MM-YYYY HH24:MI:SS')"; > > > > } > > > > > > > > Essentially, since DBOracle didn't override > > > getDateString(String), the one > > > > from DB was being used - which is completely useless as far > > > as Oracle is > > > > concerned. Actually it's beyond buggy, because it doesn't > > > take into account > > > > the fact that Timestamp objects cannot represent dates > > > before 01-Jan-1970. > > > > [/QUOTING MYSELF] > > > > > > > > -- > > > > Voytek Jarnot > > > > Quidquid latine dictum sit, altum viditur. > > > > > > > > > > > > > -----Original Message----- > > > > > From: salinaale [mailto:[EMAIL PROTECTED] > > > > > Sent: Wednesday, July 16, 2003 10:05 AM > > > > > To: torque-user > > > > > Subject: Oracle and query date > > > > > > > > > > > > > > > Hi, > > > > > i've a big problem: > > > > > i 'm using torque 3.0.2 and the db is oracle 8.1.7.0.0. In > > > > > many of my table > > > > > there are columns of DATE type, but it seems to me that > > > > > torque is not able to > > > > > catch this field!!!! > > > > > When i try to called a doSelect using a criteria like this: > > > > > > > > > > crit.add(peer.DATESTART, date,Criteria.EQUAL); > > > > > > > > > > date is an object of java.util.Date > > > > > > > > > > I've tried also to use : > > > > > crit.addDate(....) > > > > > > > > > > but i get always this error: > > > > > > > > > > java.lang.NullPointerException > > > > > at > > > > > > org.apache.torque.util.SqlExpression.build(SqlExpression.java:278) > > > > > at > > > > > > > > > org.apache.torque.util.Criteria$Criterion.appendTo(Criteria.java:3410) > > > > > at > > > > > > > > > org.apache.torque.util.Criteria$Criterion.toString(Criteria.java:3550) > > > > > at > > > > > > org.apache.torque.util.BasePeer.createQuery(BasePeer.java:1124) > > > > > at > > > > > > > > > org.apache.torque.util.BasePeer.createQueryString(BasePeer.java:927) > > > > > at > org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1360) > > > > > at > > > > > com.sinapsi.comunicazioni.torque.BaseNocTempScadenzaPeer.doSel > > > > > ectVillageRecords(BaseNocTempScadenzaPeer.java:403) > > > > > at > > > > > com.sinapsi.comunicazioni.torque.BaseNocTempScadenzaPeer.doSel > > > > > ectVillageRecords(BaseNocTempScadenzaPeer.java:370) > > > > > at > > > > > com.sinapsi.comunicazioni.torque.BaseNocTempScadenzaPeer.doSel > > > > > ect(BaseNocTempScadenzaPeer.java:339) > > > > > at > > > > > com.sinapsi.comunicazioni.torque.NocTempScadenzaPeer.doSelectA > > > > > ll(NocTempScadenzaPeer.java:38) > > > > > ...... > > > > > ...... > > > > > > > > > > > > > > > Any idea???? If i can't use this feature torque is not > > > usefull for me. > > > > > Thanks! > > > > > > > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > > > For additional commands, e-mail: > [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
