Please have a look in the release notes. OJB_HL_SEQ table has changed. regards, Armin
----- Original Message ----- From: "Paula de Matos" <[EMAIL PROTECTED]> To: "OJB Users List" <[EMAIL PROTECTED]> Sent: Wednesday, June 04, 2003 3:41 PM Subject: Storing objects creates exception: no such attribute a0.version > Hi, > > I am currently upgrading from ver 0.9.8 to ver 1.0 rc3. I used to be able to > store objects > with no problems but am now having problems with getting the identifiers > generated from org.apache.ojb.broker.util.sequence.HighLowSequence. It keeps > on giving me an > ERROR: No such attribute a0.version when I try to store. > > I used this org.apache.ojb.broker.util.sequence.SequenceManagerHiLoImpl > class with no problems at all in version 0.9.8. > Now the only thing that works is > org.apache.ojb.broker.util.sequence.SequenceManagerInMemoryImpl. > > My question is why and what is the difference between these two sequence > managers. > > > Cheers > Paula > > The operation I perform is as follows: > > try { > // Set author > Author author = new Author(); > author.setAuthor(name); > author.setEmailAddress(emailAddress); > > // Add comment to vector > Vector commentVector = author.getCommentVector(); > commentVector.addElement(comment); > author.setCommentVector(commentVector); > > ObjectModificationDefaultImpl objectMod = new > ObjectModificationDefaultImpl(true, false); > > broker.beginTransaction(); > broker.store(author, objectMod); > broker.commitTransaction(); > > } catch (Exception e) { > e.printStackTrace(); > broker.abortTransaction(); > return false; > } > > The repostitory_database.xml extract is: > > <sequence-manager > className="org.apache.ojb.broker.util.sequence.SequenceManagerHiLoImpl"> > <attribute attribute-name="grabSize" attribute-value="20"/> > <attribute attribute-name="autoNaming" attribute-value="true"/> > <attribute attribute-name="globalSequenceId" > attribute-value="false"/> > <attribute attribute-name="globalSequenceStart" > attribute-value="10000"/> > </sequence-manager> > > > The stack trace and logfile I get is as follows with > org.apache.ojb.broker.util.sequence.SequenceManagerHiLoImpl: > > 36107 DEBUG [Thread-4] accesslayer.ConnectionManagerImpl - Try to change > autoCommit state to 'false' > 36107 DEBUG [Thread-4] cache.ObjectCacheFactory - Object cache created, > using cache:[EMAIL PROTECTED] > CACHE STATISTICS > Count of temporarily cached objects=0 > ] > 36107 DEBUG [Thread-4] sequence.SequenceManagerFactory - create new sequence > manager for broker [EMAIL PROTECTED] > 36107 DEBUG [Thread-4] sequence.SequenceManagerFactory - > Jdbc-Connection-Descriptor 'postgres' use sequence manager: class > org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl > 36123 DEBUG [Thread-4] accesslayer.ConnectionFactoryPooledImpl - makeObject > called > 36138 DEBUG [Thread-4] accesslayer.ConnectionManagerImpl - Request new > connection from ConnectionFactory: > [EMAIL PROTECTED] > 36138 DEBUG [Thread-4] accesslayer.ConnectionManagerImpl - Try to change > autoCommit state to 'false' > 36154 DEBUG [Thread-4] core.PersistenceBrokerImpl - getCollectionByQuery > (class org.apache.ojb.broker.util.collections.RemovalAwareCollection, class > org.apache.ojb.broker.util.sequence.HighLowSequence, Query from class > org.apache.ojb.broker.util.sequence.HighLowSequence where > [EMAIL PROTECTED]) > 36154 DEBUG [Thread-4] core.PersistenceBrokerImpl - Creating RsIterator for > class [org.apache.ojb.broker.util.sequence.HighLowSequence] > 36154 DEBUG [Thread-4] accesslayer.JdbcAccessImpl - executeQuery : Query > from class org.apache.ojb.broker.util.sequence.HighLowSequence where > [EMAIL PROTECTED] > 36154 DEBUG [Thread-4] sql.SqlGeneratorDefaultImpl - SQL:SELECT > A0.VERSION,A0.GRAB_SIZE,A0.MAX_KEY,A0.FIELDNAME,A0.TABLENAME FROM OJB_HL_SEQ > A0 WHERE (A0.TABLENAME LIKE ? ) AND A0.FIELDNAME LIKE ? > 36169 ERROR [Thread-4] accesslayer.JdbcAccessImpl - SQLException during the > execution of the query (for a > org.apache.ojb.broker.util.sequence.HighLowSequence): ERROR: No such > attribute a0.version > > java.sql.SQLException: ERROR: No such attribute a0.version > > at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131) > at > org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connec tion > .java:505) > at > org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Stateme nt.j > ava:320) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme nt.j > ava:48) > at > org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1St atem > ent.java:153) > at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown > Source) > at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown Source) > at > org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknow n > Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery( Unkn > own Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Un know > n Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Un know > n Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Un know > n Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Un know > n Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Un know > n Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByQuery(Unknow n > Source) > at > org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery( Unkn > own Source) > at > org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getSequen ce(U > nknown Source) > at > org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getUnique Long > (Unknown Source) > at > org.apache.ojb.broker.util.sequence.AbstractSequenceManager.getUniqueId( Unkn > own Source) > at > org.apache.ojb.broker.util.sequence.AbstractSequenceManager.getUniqueVal ue(U > nknown Source) > at org.apache.ojb.broker.util.BrokerHelper.getAutoIncrementValue(Unknown > Source) > at org.apache.ojb.broker.util.BrokerHelper.getValuesForObject(Unknown > Source) > at org.apache.ojb.broker.util.BrokerHelper.getKeyValues(Unknown Source) > at org.apache.ojb.broker.Identity.init(Unknown Source) > at org.apache.ojb.broker.Identity.<init>(Unknown Source) > at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) > at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown > Source) > at uk.ac.ebi.compounds.dbAccess.ojb.OjbCommentor.OjbSetComments(Unknown > Source) > at uk.ac.ebi.compounds.servlets.CommentServlet.service(Unknown Source) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica tion > FilterChain.java:247) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt erCh > ain.java:193) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv e.ja > va:260) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nvok > eNext(StandardPipeline.java:643) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4 80) > at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv e.ja > va:191) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nvok > eNext(StandardPipeline.java:643) > at > org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authenticator Base > .java:493) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nvok > eNext(StandardPipeline.java:641) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4 80) > at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > at > org.apache.catalina.core.StandardContext.invoke(StandardContext.java:241 5) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java :180 > ) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nvok > eNext(StandardPipeline.java:643) > at > org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherVa lve. > java:170) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nvok > eNext(StandardPipeline.java:641) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java :172 > ) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nvok > eNext(StandardPipeline.java:641) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4 80) > at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve. java > :174) > at > org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i nvok > eNext(StandardPipeline.java:643) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4 80) > at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) > at > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:43 2) > at > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC onne > ction(Http11Protocol.java:386) > at > org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:53 4) > at > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool .jav > a:530) > at java.lang.Thread.run(Thread.java:536) > 36185 INFO [Thread-4] accesslayer.ConnectionManagerImpl - Rollback was > called, do rollback on current connection > [EMAIL PROTECTED] > 36185 DEBUG [Thread-4] core.PersistenceBrokerImpl - PB.close was called: > [EMAIL PROTECTED] > 36216 INFO [Thread-4] accesslayer.ConnectionManagerImpl - Rollback was > called, do rollback on current connection > [EMAIL PROTECTED] > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]