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 Paula de Matos <pm...@ebi.ac.uk> on 2003/06/04 15:41:17 UTC
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:org.apache.ojb.broker.cache.ObjectCacheEmptyImpl@dc6a9d[
CACHE STATISTICS
Count of temporarily cached objects=0
]
36107 DEBUG [Thread-4] sequence.SequenceManagerFactory - create new sequence
manager for broker org.apache.ojb.broker.core.PersistenceBrokerImpl@dba9f9
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:
org.postgresql.jdbc3.Jdbc3Connection@ccc621
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
org.apache.ojb.broker.query.Criteria@3f5a2f)
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
org.apache.ojb.broker.query.Criteria@3f5a2f
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(AbstractJdbc1Connection
.java:505)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.j
ava:320)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.j
ava:48)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statem
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(Unknown
Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Unkn
own Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Unknow
n Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow
n Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow
n Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow
n Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(Unknow
n Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByQuery(Unknown
Source)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(Unkn
own Source)
at
org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getSequence(U
nknown Source)
at
org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getUniqueLong
(Unknown Source)
at
org.apache.ojb.broker.util.sequence.AbstractSequenceManager.getUniqueId(Unkn
own Source)
at
org.apache.ojb.broker.util.sequence.AbstractSequenceManager.getUniqueValue(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(Application
FilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:260)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:191)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase
.java:493)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180
)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:170)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172
)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
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.invok
eNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
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:432)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
ction(Http11Protocol.java:386)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534)
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
org.postgresql.jdbc3.Jdbc3Connection@ccc621
36185 DEBUG [Thread-4] core.PersistenceBrokerImpl - PB.close was called:
org.apache.ojb.broker.core.PersistenceBrokerImpl@dba9f9
36216 INFO [Thread-4] accesslayer.ConnectionManagerImpl - Rollback was
called, do rollback on current connection
org.postgresql.jdbc3.Jdbc3Connection@f52460
Re: Storing objects creates exception: no such attribute a0.version
Posted by Armin Waibel <ar...@code-au-lait.de>.
Please have a look in the release notes.
OJB_HL_SEQ table has changed.
regards,
Armin
----- Original Message -----
From: "Paula de Matos" <pm...@ebi.ac.uk>
To: "OJB Users List" <oj...@db.apache.org>
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:org.apache.ojb.broker.cache.ObjectCacheEmptyImpl@dc6a9d[
> CACHE STATISTICS
> Count of temporarily cached objects=0
> ]
> 36107 DEBUG [Thread-4] sequence.SequenceManagerFactory - create new
sequence
> manager for broker
org.apache.ojb.broker.core.PersistenceBrokerImpl@dba9f9
> 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:
> org.postgresql.jdbc3.Jdbc3Connection@ccc621
> 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
> org.apache.ojb.broker.query.Criteria@3f5a2f)
> 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
> org.apache.ojb.broker.query.Criteria@3f5a2f
> 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
> org.postgresql.jdbc3.Jdbc3Connection@ccc621
> 36185 DEBUG [Thread-4] core.PersistenceBrokerImpl - PB.close was
called:
> org.apache.ojb.broker.core.PersistenceBrokerImpl@dba9f9
> 36216 INFO [Thread-4] accesslayer.ConnectionManagerImpl - Rollback
was
> called, do rollback on current connection
> org.postgresql.jdbc3.Jdbc3Connection@f52460
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
>
>
>