cheers, Thomas
Jason Pyeron wrote:
I have been trying to fix my MySQL identity column issues, I turned off Mysql's auto increment, now using the High Low sequencer
but I get preparedCall not supported, why is OJB trying to prepare calls?
should it not be prepare statement?
my jars are compiled from cvs tip
-Jason Pyeron
...
<sequence-manager className="org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl"> <attribute attribute-name="grabSize" attribute-value="5"/> <attribute attribute-name="globalSequenceId" attribute-value="false"/> <attribute attribute-name="globalSequenceStart" attribute-value="10000"/> </sequence-manager>
...
<class-descriptor class="com.pyerotechnics.customer.mmserv.rejistore.tier1.dataobjects.AddressTypes" table="AddressTypes"> <field-descriptor name="id" column="id" jdbc-type="BIGINT" primarykey="true" autoincrement="true" /> <field-descriptor name="name" column="name" jdbc-type="VARCHAR" /> </class-descriptor>
...
AddressTypes at=new AddressTypes(); //AddressTypesCollection.java:38 at.setName("Work"); //AddressTypesCollection.java:39 broker.beginTransaction(); //AddressTypesCollection.java:40 broker.store(at); //AddressTypesCollection.java:41 broker.commitTransaction(); //AddressTypesCollection.java:42
...
[org.apache.ojb.broker.accesslayer.StatementsForClassImpl] ERROR: 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 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:2026)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java:1943)
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:129)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java:651)
at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPersistenceBroker.java:165)
at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPersistenceBroker.java:165)
at com.pyerotechnics.customer.mmserv.rejistore.tier1.AddressTypesCollection.refresh(AddressTypesCollection.java:41)
at com.pyerotechnics.customer.mmserv.rejistore.tier1.AddressTypesCollection.<init>(AddressTypesCollection.java:19)
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]