db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jarnot Voytek Contr AU HQ/SC <Voytek.Jar...@MAXWELL.AF.MIL>
Subject RE: Oracle and query date
Date Wed, 16 Jul 2003 16:45:38 GMT
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:salinaale@inwind.it]
> 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:salinaale@inwind.it]
> > > 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: torque-user-unsubscribe@db.apache.org
> > > For additional commands, e-mail: torque-user-help@db.apache.org
> > > 
> > 
> > 
> ---------------------------------------------------------------------
> > To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> > For additional commands, e-mail: torque-user-help@db.apache.org
> > 
> > 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message