Hi Fedor,
In this case since the row already exists I would expect that if I do not
define a value for the field, turbine will only modify the fields that I
want.(but maybe is supposed to have a different behavior??) In this case
when I'm doing an update (as opposed to an insert) I think the default
values should not be used.
andres
Fedor Karpelevitch wrote:
> you need to specify a default value for that field AFAICT.
>
> fedor.
>
> > -----Original Message-----
> > From: Andres Portillo [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, August 13, 2001 10:02 AM
> > To: Turbine-user
> > Subject: Torque wants to update all the fields in a table.
> >
> >
> > Hi All,
> >
> > I'm having a problem with Turbin 2.1 with an Oracle DB. I have a
> > table with 5 fields all marked as required. I'm able to do insert and
> > delete in the table using the Peer functions doInsert and
> > doDelete, but
> > the problem is when I try to do an update of just a few fields.
> >
> > I got an exception saying that I can not do the update because one
> > of the fields is NULL. This is the exception:
> >
> > Stack Trace follows:
> > java.lang.reflect.InvocationTargetException: java.sql.SQLException:
> > ORA-01407: cannot update ("TEST"."COURSE"."COURSE_CREATION_DATE")
> >
> > I think Turbine is trying to update all the fields of the row, but
> > since I only set values for some of them the DB is
> > complaining about it.
> > Does somebody knows a fix/workaround for this problem??
> >
> > andres
> >
> > PS, BTW I tried to set the "services.LoggingService.sql.level=DEBUG"
> > parameter but it doesn't seem to work.. :(
> >
> > --
> > =============================================
> > Andres G. Portillo D.
> > Software Engineer
> > Veratech (www.veratech.com.mx)
> > =============================================
> >
> >
> >
> > ---------------------------------------------------------------------
> > 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]
--
=============================================
Andres G. Portillo D.
Software Engineer
Veratech (www.veratech.com.mx)
=============================================
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
