I am having trouble setting a foreign key value to null. Parts of my torque schema file are below. table_2.parent_asset_id has a foreign key constraint defined on it & it must be either null or one of the table_1.asset_id column values.
<table name="table_1" idMethod="native"> <column name="asset_id" required="true" primaryKey="true" type="BIGINT" description="ASSET ID"/> </table> <table name="table_2" idMethod="none"> <column name="parent_asset_id" required="false" primaryKey="false" type="BIGINT" /> <!-- Some other columns defined here. --> <foreign-key foreignTable="table_1"> <reference local="parent_asset_id" foreign="asset_id"/> </foreign-key> </table> I want to be able to write code as follows: Table2Bean table2Bean = new Table2Bean(); table2Bean.setParentAssetId(null); However the setParentAssetId method in generated bean class takes has input parameter of type 'long'. So passing null does not work. The generated method in Table2Bean class looks like this: public void setParentAssetId(long v) { this.parentAssetId = v; setModified(true); } If the generated method was taking an object paramter (Long instead of long), it would work. Any idea how to make it work? Any help is appreciated. Shilpa __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]