Weird Error in Access with Memo-Fields

[Tino Schöllhorn <t....@tiscali.de>]

Hi,

I am using OJB and Access at the moment. So far everything worked fine, 
and I can also store memofields to the database. Now I integrated my 
classes in a web-application and there I get a really strange behaviour, 
when I save my data to the database:

A) When I start Tomcat (5.0) and edit an entry and save it everything 
works fine. The data is written correctly to the database.

B) When I try to edit again another or the same entry I get the typical 
error when the repository_user.xml file is not correctly set up: but all 
my necessary fiels are set to LONGVARCHAR. The error message is 
something like that:

org.apache.ojb.broker.PersistenceBrokerSQLException: [Microsoft][ODBC 
Microsoft Access Driver]Die Zeichenfolgedaten wurden rechts 
abgeschnitten. (null)
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeUpdate(JdbcAccessImpl.java: 
479)
org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(PersistenceBrokerImpl.java: 
1996)
org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java: 
1889)
org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java: 
665)
org.apache.ojb.broker.core.PersistenceBrokerImpl.storeCollectionObject(PersistenceBrokerImpl.java: 
855)
org.apache.ojb.broker.core.PersistenceBrokerImpl.storeCollections(PersistenceBrokerImpl.java: 
814)
org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(PersistenceBrokerImpl.java: 
2007)
org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java: 
1889)
org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java: 
665)
org.apache.ojb.broker.core.PersistenceBrokerImpl.storeCollectionObject(PersistenceBrokerImpl.java: 
855)
org.apache.ojb.broker.core.PersistenceBrokerImpl.storeCollections(PersistenceBrokerImpl.java: 
814)
org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(PersistenceBrokerImpl.java: 
2007)
org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java: 
1889)
org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java: 
665)
org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPersistenceBroker.java: 
160)
org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPersistenceBroker.java: 
160)
kos.wnetz.wwnavi.WWEntity.save(WWEntity.java: 285)
sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethodAccessorImpl.java: 
no source available)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java: 
39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java: 
25)


What I tried next was to view the behaviour of the PlatformMsAccessImpl 
class: What I noticed there that the second time the data was about to 
be store ther was no output of this class (I coded some low level 
debugging messages).

Does anyone know if this is an error of OJB or what am I doing wrong?

tino



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