[castor-dev] OQL update error

[Sundaram Ramasamy]

Hi,

I have written some test program, add, select, remove and update.

Only update is not working for me. I am sending my source, can you help to
find the error.

Attaching table schema, mapping xml file, account object and Test program.
Database is postgresql.

Thanks
-SR

a.sql

<!DOCTYPE databases PUBLIC "-//EXOLAB/Castor Mapping DTD Version 1.0//EN"
                           "http://castor.exolab.org/mapping.dtd";>
<mapping>

<!--  Mapping for Account  -->
  <class name="myapp.Account"  identity="acctno">
    <description>Computer definition, extends generic product</description>
    <map-to table="account" xml="account" />
    <field name="acctno" type="integer">
      <sql name="acctno" type="integer" />
       <xml  node="element" />
    </field>
    <field name="name" type="string">
      <sql name="name" type="varchar"/>
      <xml  node="element" />
    </field>
	<field name="amt" type="double">
      <sql name="amt" type="double"/>
      <xml  node="element" />
    </field>
  </class>

</mapping>

Test.java

Account.java