I am querying a record in a table and two rows are found. If I have any null values in any fields then the rows for all fields become null.

For example,
row 1
col a = aba
col b = cbc
col c = dfd
col d = fff

row 2
col a = ba
col b = bc
col c = fd
col d = ff

Then the object is created correctly with the data as:
Objects 1 and two are as follow:
aba, cbc, dfd, fff
ba, bc, fd, ff

In this case though:

row 1
col a = aba
col b = cbc
col c = null
col d = fff

row 2
col a = ba
col b = bc
col c = fd
col d = ff

Then the object is created correctly with the data as:
Objects 1 and two are as follow:
null, null, null, null
ba, bc, fd, ff

Any ideas why?
Thanks,
Joe Russo

After looking further into the log files it indicates that two rows are found, but only one row is hydrated.

09 Nov 2007 10:09:42 [5_623=WebEcommerceSetup] DEBUG -done processing result set (2 rows)
09 Nov 2007 10:09:42 [5_623=WebEcommerceSetup] DEBUG -about to close ResultSet (open ResultSets: 1, globally: 1)
09 Nov 2007 10:09:42 [5_623=WebEcommerceSetup] DEBUG -about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
09 Nov 2007 10:09:42 [5_623=WebEcommerceSetup] DEBUG -closing statement
09 Nov 2007 10:09:42 [5_623=WebEcommerceSetup] DEBUG -total objects hydrated: 1

I found the problem. This was related to mapping the table correctly. I had it originally within the composite id element. Once I move it out of the composite id then restarted it worked fine.