Thank you much for the help!
--- "Gentry, Michael (Contractor)" <michael_gentr..anniemae.com> wrote:
> I try to always work on objects (CayenneDataObjects) returned from a
> SelectQuery. Then when it comes time to update, I do something like:
>
> // customer is a CayenneDataObject from a previous SelectQuery
> customer.setDateOfBirth(dob);
> ctxt.commitChanges();
>
> There are some Cayenne tutorials for both JSP/Struts and Tapestry you
> can look at on the web site. I'm guessing you are using the former
> since with Tapestry you don't have to go and get values out of the
> request cycle. Those might be helpful, though.
>
> /dev/mrg
>
>
> -----Original Message-----
> From: Alan Baltazar [mailto:acatalan..ahoo.com]
> Sent: Wednesday, April 05, 2006 6:57 PM
> To: cayenne-use..ncubator.apache.org
> Subject: RE: UpdateQuery not updating
>
>
> How would you implement your way for updating tables?
>
> --- "Gentry, Michael (Contractor)" <michael_gentr..anniemae.com> wrote:
>
> > I've never used UpdateQuery before, but try:
> >
> > UpdateQuery updated =
> > new UpdateQuery(Customer.class,
> > template.expWithParameters(params));
> >
> > Also, I don't think you need the commitChanges() at the end ... That
> > would be more useful if you were working with actual
> CayenneDataObjects,
> > which you aren't. Also, I think your object graph might get
> out-of-sync
> > this way, which could lead to more problems.
> >
> > /dev/mrg
> >
> >
> > -----Original Message-----
> > From: Alan Baltazar [mailto:acatalan..ahoo.com]
> > Sent: Wednesday, April 05, 2006 5:13 PM
> > To: cayenne-use..ncubator.apache.org
> > Subject: UpdateQuery not updating
> >
> >
> > Hello,
> >
> > I'm trying to update a field in a table using the UpdateQuery. The
> > following code
> > doesn't update my data.
> >
> > Date dob = null;
> > DateFormat df = DateFormat.getDateInstance();
> > DataContext ctxt =
> > BasicServletConfiguration.getDefaultContext(request.getSession());
> >
> > String customerName = request.getParameter("customerName");
> > String dateOfBirth = request.getParameter("dateOfBirth");
> >
> > Expression template = Expression.fromString("customerName =
> > $customerName");
> > Map params = new HashMap();
> > params.put("customerName", customerName);
> >
> > UpdateQuery updated = new UpdateQuery(Customer.class,template);
> >
> > try {
> > dob = df.parse(dateOfBirth);
> > }
> > catch(ParseException e) {
> > System.out.println("Unable to parse ");
> > }
> >
> > updated.addUpdAttribute("DATE_OF_BIRTH",dob);
> > ctxt.performNonSelectingQuery(updated);
> > ctxt.commitChanges();
> >
> > return mapping.findForward("success");
> > }
> >
> > this is the mysql table,
> > CREATE TABLE `CUSTOMER` (
> > `CUSTOMER_ID` int(10) unsigned NOT NULL ,
> > `CUSTOMER_NAME` varchar(20) NOT NULL default '',
> > `DATE_OF_BIRTH` date NOT NULL default '0000-00-00',
> > PRIMARY KEY (`CUSTOMER_ID`)
> > ) TYPE=InnoDB;
> >
> > here's the data object,
> > public class _Customer extends
> org.objectstyle.cayenne.CayenneDataObject
> > {
> >
> > public static final String CUSTOMER_NAME_PROPERTY =
> "customerName";
> > public static final String DATE_OF_BIRTH_PROPERTY = "dateOfBirth";
> > public static final String PRODUCT_ARRAY_PROPERTY =
> "productArray";
> >
> > public static final String CUSTOMER_ID_PK_COLUMN = "CUSTOMER_ID";
> >
> > public void setCustomerName(String customerName) {
> > writeProperty("customerName", customerName);
> > }
> > public String getCustomerName() {
> > return (String)readProperty("customerName");
> > }
> >
> >
> > public void setDateOfBirth(java.util.Date dateOfBirth) {
> > writeProperty("dateOfBirth", dateOfBirth);
> > }
> > public java.util.Date getDateOfBirth() {
> > return (java.util.Date)readProperty("dateOfBirth");
> > }
> >
> >
> > public void addToProductArray(dao.Product obj) {
> > addToManyTarget("productArray", obj, true);
> > }
> > public void removeFromProductArray(dao.Product obj) {
> > removeToManyTarget("productArray", obj, true);
> > }
> > public List getProductArray() {
> > return (List)readProperty("productArray");
> > }
> >
> >
> > }
> >
> >
> > if there's any other shorter way to do this with UpdateQuery, I'm
> > listening
> >
> > thanks for any help,
> > alan
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam? Yahoo! Mail has the best spam protection around
> > http://mail.yahoo.com
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
This archive was generated by hypermail 2.0.0 : Thu Apr 06 2006 - 11:04:50 EDT