Hi, currently I am using OJB 1.0rc4 for the object-relational mapping with MS Access an the Jdbc-Odbc-Bridge from SUN. I know that there are some issues with this "database" but nonetheless I have to make OJB working with it. So far everything worked quite well and I couldn't find any of those discussed issues. I even could use the data-type LONGVARCHAR for long text fields.
But now I get an error where I did not expect any problems: I want to delete a relation (n:m) from the database. So I use the following code to delete the relation between a person and a department: PersistenceBroker pb = PersistenceBrokerFactory.defaultPersistenceBroker(); pb.beginTransaction(); Person p= Person.getObjectById(pb, 84); Department del = Department.getObjectById(pb, 12); p.removeDepartment(del); pb.store(tino); pb.commitTransaction(); When trying to commit the transaction I get the following error: java.sql.SQLException: SQL Exception : [Microsoft][ODBC Microsoft Access Driver]Optionales Feature wurde nicht implementiert. [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] ERROR: SQLException during the execution of the Update SQL query (for a kos.om.Person): SQL Exception : [Microsoft][ODBC Microsoft Access Driver]Optionales Feature wurde nicht implementiert. SQL Exception : [Microsoft][ODBC Microsoft Access Driver]Optionales Feature wurde nicht implementiert. at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setObject(JdbcOdbcPreparedStatement. java:1437) at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setObject(JdbcOdbcPreparedStatement. java:1072) at org.apache.ojb.broker.platforms.PlatformDefaultImpl.setObjectForStatement(Un known Source) at org.apache.ojb.broker.platforms.PlatformMsAccessImpl.setObjectForStatement(U nknown Source) at org.apache.ojb.broker.accesslayer.StatementManager.bindValues(Unknown Source) at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeUpdateSQL(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.deleteMtoNImplementor(Unkno wn Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeCollections(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source) at DeleteTest.listA(DeleteTest.java:56) at TestBase.runTests(TestBase.java:28) at TestBase.main(TestBase.java:46) So do you have any ideas how to delete those relations from the database? With regards --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
