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]
