You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by TINO SCH�LLHORN <ts...@tiscali.de> on 2003/11/25 19:34:54 UTC
Optional Feature not implemented
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: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org