Hi, I had this kind of problem (working fine but exception on insert) 1 or 2 month ago with MS SQL. I simply remove P6Spy and update OJB (RC2=>RC3), it solve my problem ... I'm not sure P6Spy was the problem but probably. You can try to remove it ... ----- Original Message ----- From: Thomas Dudziak To: [EMAIL PROTECTED] Sent: Friday, September 19, 2003 1:50 PM Subject: Error with MySQL: Callable statements not supported
I just updated my CVS version and after the necessary changes (e.g. using the new ojbcore_schema.xml, repository.dtd) I get the mentioned exception (see below for the stacktrace) when using it with MySQL. My specs are: MySQL 4.0.1 on Windows XP (local db) MySQL Connector/J 3.0.8 stable (wrapped by P6Spy) Any idea how to handle this ? The stacktrace: [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] ERROR: PersistenceBrokerException during the execution of the insert: Could not build statement ask for: Callable statments not supported. Could not build statement ask for: Callable statments not supported. java.sql.SQLException: Callable statments not supported. at com.mysql.jdbc.Connection.prepareCall(Connection.java:1201) at com.mysql.jdbc.Connection.prepareCall(Connection.java:1221) at com.p6spy.engine.spy.P6Connection.prepareCall(P6Connection.java:179) at org.apache.ojb.broker.accesslayer.StatementsForClassImpl.prepareStatement(StatementsForClassImpl.java:306) at org.apache.ojb.broker.accesslayer.StatementsForClassImpl.getInsertStmt(StatementsForClassImpl.java:184) at org.apache.ojb.broker.accesslayer.StatementManager.getInsertStatement(StatementManager.java:691) at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAccessImpl.java:224) at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(PersistenceBrokerImpl.java:2038) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java:1948) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java:661) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPersistenceBroker.java:165) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPersistenceBroker.java:165) at org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getSequence(SequenceManagerHighLowImpl.java:289) at org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getUniqueLong(SequenceManagerHighLowImpl.java:191) at org.apache.ojb.broker.util.sequence.AbstractSequenceManager.getUniqueValue(AbstractSequenceManager.java:125) at org.apache.ojb.broker.util.BrokerHelper.getAutoIncrementValue(BrokerHelper.java:303) at org.apache.ojb.broker.util.BrokerHelper.getValuesForObject(BrokerHelper.java:349) at org.apache.ojb.broker.util.BrokerHelper.getKeyValues(BrokerHelper.java:215) at org.apache.ojb.broker.Identity.init(Identity.java:165) at org.apache.ojb.broker.Identity.<init>(Identity.java:124) at org.apache.ojb.odmg.locking.InMemoryLockMapImpl.getWriter(InMemoryLockMapImpl.java:111) at org.apache.ojb.odmg.locking.AbstractLockStrategy.getWriter(AbstractLockStrategy.java:141) at org.apache.ojb.odmg.locking.ReadUncommittedStrategy.writeLock(ReadUncommittedStrategy.java:145) at org.apache.ojb.odmg.locking.LockManagerDefaultImpl.writeLock(LockManagerDefaultImpl.java:121) at org.apache.ojb.odmg.TransactionImpl.lock(TransactionImpl.java:276) Tom --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.519 / Virus Database: 317 - Release Date: 18/09/2003
