db-ojb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Mahler <thm...@web.de>
Subject Re: Invalid SQL call statements generated
Date Mon, 06 Oct 2003 06:03:06 GMT
There seems to be a minor problem in StatementForClassImpl. We are 
working on it.

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: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org


Mime
View raw message