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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
