[prev in list] [next in list] [prev in thread] [next in thread] 

List:       ojb-user
Subject:    Re: ojb + ms-sql server: error re-reading row data
From:       Jakob Braeuchi <jbraeuchi () gmx ! ch>
Date:       2004-10-22 17:21:59
Message-ID: 417941B7.8060606 () gmx ! ch
[Download RAW message or body]

hi phil,

forgot to post the revision of the patch.
it's RowReaderDefaultImpl revision 1.31

jakob

Jakob Braeuchi schrieb:

> hi phil,
> 
> imo the problem is caused by an optimization. first only the columns of 
> the pk are read, and then in a second step all columns of the rows are 
> read.
> afaik there's a patch available.
> 
> jakob
> 
> WHIRLYCOTT schrieb:
> 
>> I just upgraded to OJB 1.0.01 today.  I was using rc7 previously and 
>> didn't have the following problem.
>>
>> Quick description of my environment:  I have a class called 'Folder' 
>> that corresponds to a db table called 'folder'.  I have a class called 
>> 'Letter' that corresponds to a table called 'letter'.  A folder can 
>> have more than one letter in it, so my Folder class has a Collection 
>> attribute called 'letters'.  I have a join table called folder_letters 
>> with the mappings.  It's a fairly straightforward setup.
>>
>> However, when I try to get a List of the Folders in my db, I'm getting 
>> this error:
>>
>> Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver 
>> for JDBC]ResultSet can not re-read row data for column 1.
>>
>> I can go into more detail if required, but I'm wondering if somone has 
>> seen this before.  One thing that I did notice is that when I set the 
>> auto-retrieve attribute of the Folder in my repository.xml file to 
>> 'false', the error doesn't occur (and Folder.letters is, of course, 
>> empty).
>>
>>  From inside the Folder class-descriptor:
>>
>> <collection-descriptor name="letters"
>> collection-class="org.apache.ojb.broker.util.collections.ManageableArrayList" 
>> element-class-ref="com.asdf.Letter"
>> auto-update="false"
>> auto-retrieve="true"
>> indirection-table="folder_letters">
>>
>>     <fk-pointing-to-this-class column="folderId"/>
>>     <fk-pointing-to-element-class column="letterId"/>
>>
>> </collection-descriptor>
>>
>> Thoughts?
>>
>> phil.
>>
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
> 
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

[prev in list] [next in list] [prev in thread] [next in thread]