db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Fischer <fisc...@seitenbau.net>
Subject RE: Criteria.setIgnoreCase() and boolean fields?
Date Thu, 31 Mar 2005 10:48:25 GMT




Robert,

please omit also the port number:

http://issues.apache.org/scarab/issues/template/Confirm.vm/confirm/...

Can you please check your db.props file in the generator ? There it should
say
BOOLEANCHAR = char

so the column in the database should be a char column, and the upper()
should work.

Are you sure you have set

torque.database = postgresql

in your generator properties file ?

   Thomas


Robert Bowen <syg6@yahoo.com> schrieb am 31.03.2005 12:19:52:

> Hi Thomas,
>
> I am using Postgre 8.0.1 for Windoze, Torque 3.1.
>
> In my Torque schema I use data type BOOLEANCHAR, but
> the field in the database itself is boolean. I don't
> think there is a 'boolchar' option, or anything
> similar in Postgre. I guess that's why it's crashing.
> Ideally Torque would recognize that it is a boolean
> field and not try to perform an UPPER() on it.
>
> Incidentally, I registered for an account on scarab
> and got a message to confirm my subscription.
> Unfortunately the link sent in the confirm email is
> wrong:
>
> http://localhost:38080/scarab/issues/template/Confirm.vm/confirm/...
>
> localhost!?
>
> I tried putting issues.apache.org and www.apache.org
> instead of localhost but it doesn't work.
>
> Any idea?
>
> Tanky,
> Bob
>
>
> @seitenbau.net> wrote:
> >
> >
> >
> >
> > Robert,
> >
> > Which database and Torque version are you using ?
> > To my knowledge, booleanchar is usually implemented
> > as a char field in the
> > database (at least for oracle and Torque 3.1.1), so
> > upper should work
> > there.
> >
> > by the way, Scarab is the issue tracker for torqe:
> > http://issues.apache.org/scarab/issues
> > request a role as observer for Torque->Source and
> > then you are able to
> > create issues
> >
> >      Thomas
> >
> >
> >
> > Robert Bowen <syg6@yahoo.com> schrieb am 31.03.2005
> > 11:03:00:
> >
> > > I *am* using BOOLEANCHAR, and it still doesn't
> > work.
> > >
> > > I'll have to take a look at scarab, don't know
> > what it
> > > is!
> > >
> > > syg
> > >
> > > --- Thomas Fischer <fischer@seitenbau.net> wrote:
> > > >
> > > >
> > > >
> > > >
> > > > Sounds like a bug to me. Can you please enter
> > this
> > > > in scarab, including the
> > > > database and the torque version you use ?
> > > >
> > > > As a workaround, you can try to change your
> > > > datamodel such that you use the
> > > > data type booleanchar instead of boolean.
> > > >
> > > >    Thomas
> > > >
> > > > Robert Bowen <syg6@yahoo.com> schrieb am
> > 31.03.2005
> > > > 10:02:13:
> > > >
> > > > > Hello all. I have a class that sets a whole
> > bunch
> > > > of
> > > > > conditions for a search. Most of the fields I
> > > > search
> > > > > on are text so using Criteria.setIgnoreCase()
> > has
> > > > been
> > > > > working.
> > > > >
> > > > > I recently added another search criteria, on a
> > > > boolean
> > > > > field:
> > > > >
> > > > > criteria.add(NotificationPeer.IS_COMPLETE,
> > false);
> > > > >
> > > > > But since the setIgnoreCase() is set to true
> > for
> > > > the
> > > > > Criteria, Torque tries to do an UPPER() on a
> > > > boolean
> > > > > field!
> > > > >
> > > > > Can I avoid this somehow? Currently it crashes
> > in
> > > > a
> > > > > rather ugly way ...
> > > > >
> > > > > Thanks!
> > > > > syg
> > > > >
> > > > >
> > > > >
> > > > > __________________________________
> > > > > Do you Yahoo!?
> > > > > Make Yahoo! your home page
> > > > > http://www.yahoo.com/r/hs
> > > > >
> > > > >
> > > >
> > >
> >
> ---------------------------------------------------------------------
> > > > > 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
> > > >
> > > >
> > >
> > >
> > >
> > > __________________________________
> > > Do you Yahoo!?
> > > Yahoo! Small Business - Try our new resources
> > site!
> > > http://smallbusiness.yahoo.com/resources/
> > >
> > >
> >
> ---------------------------------------------------------------------
> > > 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
> >
> >
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Mail - Easier than ever with enhanced search. Learn more.
> http://info.mail.yahoo.com/mail_250
>
> ---------------------------------------------------------------------
> 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