Re: Torque save() method doesnt work for 1 object type..but works for others

[Thomas Fischer <tf...@apache.org>]

If Torque does not throw an exception, this means that jdbc thinks the 
changes are committed into the database. Do you do anything from the 
changes being committed (like passing a db connection to the save method 
and having set autocommit to false etc.). Or do you have any triggers in 
the database which might reset the row to its old value ?

If yo do not trust what Torque does, you can use P6spy to log the jdbc 
commands. See the wiki n how to set it up.

       Thomas


On Mon, 26 Jun 2006, bobbysojitra wrote:

>
> Hi Guys
>
> I have a torque schema with a few objects. myObject.save() works for all
> objects (i.e. writes values to the database when adding or updating) except
> 1 object.
>
> Here is the part of the schema (see below) for the object which doesnt save.
>
> I dont get an error message or anything. It seems as if it has all worked
> fine, but when I check the database, the object's values are as before.. any
> ideas? Thanks in advance.
>
> <table javaName="Step" name="steps">
>                <idMethodParameter value="id" />
>                <column javaName="id" name="id" primaryKey="true"
> required="true" type="INTEGER" autoIncrement="true"/>
>                <column javaName="taskId" name="taskId" required="true"
> type="INTEGER" default="0"/>
>                <column javaName="stepId" name="stepId" required="true"
> type="INTEGER" default="0"/>
>                <column javaName="stepName" name="stepName" required="false"
> default="" type="VARCHAR" size="255"/>
>                <column javaName="stepDescription" name="stepDescription"
> required="false" default="" type="LONGVARCHAR"/>
>                <column javaName="completed" name="completed"
> required="true" type="INTEGER" default="0" />
>                <column javaName="percentComplete" name="percentComplete"
> required="false" type="INTEGER" default="0"/>
>                <column javaName="weight" name="weight" required="false"
> type="INTEGER" default="0"/>
>                <column javaName="status" name="status" required="false"
> type="INTEGER" default="0"/>
>                <column javaName="updatedOn" name="updatedOn"
> required="true" type="BIGINT"/>
>        </table>
> --
> View this message in context: http://www.nabble.com/Torque-save%28%29-method-doesnt-work-for-1-object-type..but-works-for-others-t1849364.html#a5048260
> Sent from the Apache DB - Torque Users forum at Nabble.com.
>
>
> ---------------------------------------------------------------------
> 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