Why is OJB inserting null on one field?

[C F <ta...@yahoo.com>]

Hello,

I'm about 90% sure this problem started happening after I upgraded some stuff (OJB, PostgreSQL and JDBC driver).  What's happening is that for some reason, on inserting, OJB seems to be inserting everything correctly except for my 'status_id' field and I have no idea why.  Below, I have a code sample, the SQL statement that is being received by the database and repository defs.  Notice that in the insert statement, the status_id field is null despite being explicitly set by newImport.setStatus_id("Q")...

   Import newImport = new Import();
   newImport.setUser_id(user.getId());
   newImport.setFile_size(new BigDecimal(file.getFileSize()));
   newImport.setIn_file(file.getFileName());
   newImport.setOut_file(outFile.getName());
   newImport.setStatus_id("Q");
     try
  {
   tx = odmg.newTransaction();
   tx.begin();
   tx.lock(layerImport, tx.WRITE);
   tx.commit();
  }


..... the resulting SQL statement is....

INSERT INTO imports (file_format,file_size,id,in_file,out_file,request_date,status_id,user_id) VALUES ( null, 3100237, 21, 'Exports.zip', '0001_60784.zip', null, null, 1 )


....Object Defs....

<class-descriptor class="Import" table="imports">
<field-descriptor id="1" name="file_format" column="file_format" jdbc-type="VARCHAR"></field-descriptor>
<field-descriptor id="2" name="file_size" column="file_size" jdbc-type="NUMERIC"></field-descriptor>
<field-descriptor id="3" name="id" column="id" jdbc-type="INTEGER" primarykey="true" autoincrement="true"></field-descriptor>
<field-descriptor id="4" name="in_file" column="in_file" jdbc-type="VARCHAR"></field-descriptor>
<field-descriptor id="5" name="out_file" column="out_file" jdbc-type="VARCHAR"></field-descriptor>
<field-descriptor id="6" name="request_date" column="request_date" jdbc-type="TIMESTAMP"></field-descriptor>
<field-descriptor id="7" name="status_id" column="status_id" jdbc-type="VARCHAR"></field-descriptor>
<field-descriptor id="8" name="user_id" column="user_id" jdbc-type="INTEGER"></field-descriptor>
<reference-descriptor name="lu_process_status" class-ref="Lu_process_status" auto-retrieve="true" auto-update="false" auto-delete="false">
<foreignkey field-id-ref="7" />
</reference-descriptor>
</class-descriptor>


<class-descriptor class="Lu_process_status" table="lu_process_status">
<field-descriptor id="1" name="id" column="id" jdbc-type="VARCHAR" primarykey="true"></field-descriptor>
<field-descriptor id="2" name="name" column="name" jdbc-type="VARCHAR"></field-descriptor>
<collection-descriptor name="exports" element-class-ref="Export" auto-retrieve="true" auto-update="false" auto-delete="false">
<inverse-foreignkey field-id-ref="9" />
</collection-descriptor>
<collection-descriptor name="imports" element-class-ref="Import" auto-retrieve="true" auto-update="false" auto-delete="false">
<inverse-foreignkey field-id-ref="7" />
</collection-descriptor>
</class-descriptor>

-----------------------------------------------------------------------------------------

There's nothing wrong with my 'Import' bean.  After setting the Status_id, I can System.out.println(newImport.getStatus_id()) just fine.

I'm using OJB from CVS a few days ago (0.9.9+) and PostgreSQL 7.3.2 with their JDBC 7.3 driver.

Any ideas??

Thanks!


 

 



---------------------------------
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, and more