Torque wants to update all the fields in a table.

[Andres Portillo <an...@veratech.com.mx>]

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: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org

Re: Torque wants to update all the fields in a table.

[Daniel Rall <dl...@finemaltcoding.com>]

Andres Portillo <an...@veratech.com.mx> writes:

> PS, BTW I tried to set the "services.LoggingService.sql.level=DEBUG"
> parameter but it doesn't seem to work.. :(

It works fine for SELECTs, but Village generates the SQL for INSERTs,
and is not currently logged.  Also, you must be sure that you actually
have the sql facility active.


---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org