db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From salinaale <salina...@inwind.it>
Subject Oracle and query date
Date Wed, 16 Jul 2003 15:04:39 GMT
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.doSelectVillageRecords(BaseNocTempScadenzaPeer.java:403)
	at
com.sinapsi.comunicazioni.torque.BaseNocTempScadenzaPeer.doSelectVillageRecords(BaseNocTempScadenzaPeer.java:370)
	at
com.sinapsi.comunicazioni.torque.BaseNocTempScadenzaPeer.doSelect(BaseNocTempScadenzaPeer.java:339)
	at
com.sinapsi.comunicazioni.torque.NocTempScadenzaPeer.doSelectAll(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


Mime
View raw message