Hi
All,
Iam having some fun with JDO API. I tried to run tutorial5 . I have
followed evey step in it. I get the following chain of errors which hangs in
a loop.
Can somebody please help me resolve.I am analysing on using JDO in OJB along
with PB API for a large database application . Is it recommended ?
Thanks,
suma
The list of available products:
[JDO] DEBUG: OjbStoreConnector.begin: connectionReadyForRelease=false
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] ERROR: SQLException
during the execution of the query (for a
org.apache.ojb.broker.util.sequence.HighLowSequence): ORA-00942: table or
view does not exist
ORA-00942: table or view does not exist
java.sql.SQLException: ORA-00942: table or view does not exist
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:830)
at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2391)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
:2672)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedState
ment.java:589)
at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatem
ent.java:527)
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl
.java:305)
at
org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryObject.j
ava:113)
at
org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:202)
at
org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIterator
FactoryImpl.java:97)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Pers
istenceBrokerImpl.java:1601)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Persis
tenceBrokerImpl.java:1114)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByQuery(Persistenc
eBrokerImpl.java:1217)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(Dele
gatingPersistenceBroker.java:291)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(Dele
gatingPersistenceBroker.java:291)
at
org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.lookupStoreSe
quence(SequenceManagerHighLowImpl.java:262)
at
org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getSequence(S
equenceManagerHighLowImpl.java:233)
at
org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getUniqueLong
(SequenceManagerHighLowImpl.java:185)
at
org.apache.ojb.broker.util.sequence.AbstractSequenceManager.getUniqueValue(A
bstractSequenceManager.java:124)
at
org.apache.ojb.broker.util.BrokerHelper.getAutoIncrementValue(BrokerHelper.j
ava:312)
at
org.apache.ojb.broker.util.BrokerHelper.getValuesForObject(BrokerHelper.java
:357)
at
org.apache.ojb.broker.util.BrokerHelper.getKeyValues(BrokerHelper.java:212)
at org.apache.ojb.broker.Identity.init(Identity.java:173)
at org.apache.ojb.broker.Identity.<init>(Identity.java:127)
at
org.apache.ojb.jdori.sql.OjbStoreManager.copyKeyFieldsFromObjectId(OjbStoreM
anager.java:293)
at com.sun.jdori.common.state.StateManagerImpl.<init>(Unknown
Source)
at
com.sun.jdori.common.state.StateManagerFactory.newInstance(Unknown Source)
at com.sun.jdori.common.CacheManagerImpl.createNewSM(Unknown Source)
at com.sun.jdori.common.CacheManagerImpl.getStateManager(Unknown
Source)
at
com.sun.jdori.common.PersistenceManagerImpl.getStateManager(Unknown Source)
at
org.apache.ojb.jdori.sql.OjbExtent.provideStateManagers(OjbExtent.java:171)
at org.apache.ojb.jdori.sql.OjbExtent.<init>(OjbExtent.java:101)
at
org.apache.ojb.jdori.sql.OjbStoreManager.getExtent(OjbStoreManager.java:251)
at com.sun.jdori.common.PersistenceManagerImpl.getExtent(Unknown
Source)
at com.sun.jdori.common.query.QueryImpl.checkCandidates(Unknown
Source)
at com.sun.jdori.common.query.QueryImpl.execute(Unknown Source)
at
org.apache.ojb.tutorial5.UCListAllProducts.apply(UCListAllProducts.java:44)
at org.apache.ojb.tutorial5.Application.run(Application.java:100)
at org.apache.ojb.tutorial5.Application.main(Application.java:68)
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] ERROR: SQLException
during the execution of the query (for a
org.apache.ojb.broker.util.sequence.HighLowSequence): ORA-00942: table or
view does not exist
ORA-00942: table or view does not exist
java.sql.SQLException: ORA-00942: table or view does not exist
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:830)
at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2391)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
:2672)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedState
ment.java:589)
at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatem
ent.java:527)
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl
.java:305)
at
org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryObject.j
ava:113)
at
org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:202)
at
org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIterator
FactoryImpl.java:97)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Pers
istenceBrokerImpl.java:1601)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Persis
tenceBrokerImpl.java:1114)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByQuery(Persistenc
eBrokerImpl.java:1217)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(Dele
gatingPersistenceBroker.java:291)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(Dele
gatingPersistenceBroker.java:291)
at
org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.lookupStoreSe
quence(SequenceManagerHighLowImpl.java:262)
at
org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getSequence(S
equenceManagerHighLowImpl.java:233)
at
org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getUniqueLong
(SequenceManagerHighLowImpl.java:185)
at
org.apache.ojb.broker.util.sequence.AbstractSequenceManager.getUniqueValue(A
bstractSequenceManager.java:124)
at
org.apache.ojb.broker.util.BrokerHelper.getAutoIncrementValue(BrokerHelper.j
ava:312)
at
org.apache.ojb.broker.util.BrokerHelper.getValuesForObject(BrokerHelper.java
:357)
at
org.apache.ojb.broker.util.BrokerHelper.getKeyValues(BrokerHelper.java:212)
at org.apache.ojb.broker.Identity.init(Identity.java:173)
at org.apache.ojb.broker.Identity.<init>(Identity.java:127)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.removeFromCache(Persistence
BrokerImpl.java:1481)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.removeFromCache(Deleg
atingPersistenceBroker.java:181)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.removeFromCache(Deleg
atingPersistenceBroker.java:181)
at
org.apache.ojb.jdori.sql.OjbStoreManager.fetch(OjbStoreManager.java:221)
at com.sun.jdori.common.state.StateManagerImpl.fetch(Unknown Source)
at com.sun.jdori.common.state.StateManagerImpl.loadField(Unknown
Source)
at com.sun.jdori.common.state.StateManagerImpl.isLoaded(Unknown
Source)
at org.apache.ojb.tutorial5.Product.jdoGetid(Product.java:0)
at org.apache.ojb.tutorial5.Product.toString(Product.java:114)
at java.lang.String.valueOf(String.java:2466)
at java.lang.StringBuffer.append(StringBuffer.java:387)
at org.apache.ojb.broker.Identity.init(Identity.java:180)
at org.apache.ojb.broker.Identity.<init>(Identity.java:127)
at
org.apache.ojb.jdori.sql.OjbStoreManager.copyKeyFieldsFromObjectId(OjbStoreM
anager.java:293)
at com.sun.jdori.common.state.StateManagerImpl.<init>(Unknown
Source)
at
com.sun.jdori.common.state.StateManagerFactory.newInstance(Unknown Source)
at com.sun.jdori.common.CacheManagerImpl.createNewSM(Unknown Source)
at com.sun.jdori.common.CacheManagerImpl.getStateManager(Unknown
Source)
at
com.sun.jdori.common.PersistenceManagerImpl.getStateManager(Unknown Source)
at
org.apache.ojb.jdori.sql.OjbExtent.provideStateManagers(OjbExtent.java:171)
at org.apache.ojb.jdori.sql.OjbExtent.<init>(OjbExtent.java:101)
at
org.apache.ojb.jdori.sql.OjbStoreManager.getExtent(OjbStoreManager.java:251)
at com.sun.jdori.common.PersistenceManagerImpl.getExtent(Unknown
Source)
at com.sun.jdori.common.query.QueryImpl.checkCandidates(Unknown
Source)
at com.sun.jdori.common.query.QueryImpl.execute(Unknown Source)
at
org.apache.ojb.tutorial5.UCListAllProducts.apply(UCListAllProducts.java:44)
at org.apache.ojb.tutorial5.Application.run(Application.java:100)
at org.apache.ojb.tutorial5.Application.main(Application.java:68)
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] ERROR: SQLException
during the execution of the query (for a
org.apache.ojb.broker.util.sequence.HighLowSequence): ORA-00942: table or
view does not exist
ORA-00942: table or view does not exist
java.sql.SQLException: ORA-00942: table or view does not exist
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:830)
at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2391)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
:2672)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedState
ment.java:589)
at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatem
ent.java:527)
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl
.java:305)
at
org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryObject.j
ava:113)
at
org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:202)
at
org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIterator
FactoryImpl.java:97)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Pers
istenceBrokerImpl.java:1601)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Persis
tenceBrokerImpl.java:1114)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByQuery(Persistenc
eBrokerImpl.java:1217)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(Dele
gatingPersistenceBroker.java:291)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(Dele
gatingPersistenceBroker.java:291)
at
org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.lookupStoreSe
quence(SequenceManagerHighLowImpl.java:262)
at
org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getSequence(S
equenceManagerHighLowImpl.java:233)
at
org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getUniqueLong
(SequenceManagerHighLowImpl.java:185)
at
org.apache.ojb.broker.util.sequence.AbstractSequenceManager.getUniqueValue(A
bstractSequenceManager.java:124)
at
org.apache.ojb.broker.util.BrokerHelper.getAutoIncrementValue(BrokerHelper.j
ava:312)
at
org.apache.ojb.broker.util.BrokerHelper.getValuesForObject(BrokerHelper.java
:357)
at
org.apache.ojb.broker.util.BrokerHelper.getKeyValues(BrokerHelper.java:212)
at org.apache.ojb.broker.Identity.init(Identity.java:173)
at org.apache.ojb.broker.Identity.<init>(Identity.java:127)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.removeFromCache(Persistence
BrokerImpl.java:1481)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.removeFromCache(Deleg
atingPersistenceBroker.java:181)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.removeFromCache(Deleg
atingPersistenceBroker.java:181)
at
org.apache.ojb.jdori.sql.OjbStoreManager.fetch(OjbStoreManager.java:221)
at com.sun.jdori.common.state.StateManagerImpl.fetch(Unknown Source)
at com.sun.jdori.common.state.StateManagerImpl.loadField(Unknown
Source)
at com.sun.jdori.common.state.StateManagerImpl.isLoaded(Unknown
Source)
at org.apache.ojb.tutorial5.Product.jdoGetid(Product.java:0)
at org.apache.ojb.tutorial5.Product.toString(Product.java:114)
at java.lang.String.valueOf(String.java:2466)
at java.lang.StringBuffer.append(StringBuffer.java:387)
at org.apache.ojb.broker.Identity.init(Identity.java:180)
at org.apache.ojb.broker.Identity.<init>(Identity.java:127)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.removeFromCache(Persistence
BrokerImpl.java:1481)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.removeFromCache(Deleg
atingPersistenceBroker.java:181)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.removeFromCache(Deleg
atingPersistenceBroker.java:181)
at
org.apache.ojb.jdori.sql.OjbStoreManager.fetch(OjbStoreManager.java:221)
at com.sun.jdori.common.state.StateManagerImpl.fetch(Unknown Source)
at com.sun.jdori.common.state.StateManagerImpl.loadField(Unknown
Source)
at com.sun.jdori.common.state.StateManagerImpl.isLoaded(Unknown
Source)
at org.apache.ojb.tutorial5.Product.jdoGetid(Product.java:0)
at org.apache.ojb.tutorial5.Product.toString(Product.java:114)
at java.lang.String.valueOf(String.java:2466)
at java.lang.StringBuffer.append(StringBuffer.java:387)
at org.apache.ojb.broker.Identity.init(Identity.java:180)
at org.apache.ojb.broker.Identity.<init>(Identity.java:127)
at
org.apache.ojb.jdori.sql.OjbStoreManager.copyKeyFieldsFromObjectId(OjbStoreM
anager.java:293)
at com.sun.jdori.common.state.StateManagerImpl.<init>(Unknown
Source)
at
com.sun.jdori.common.state.StateManagerFactory.newInstance(Unknown Source)
at com.sun.jdori.common.CacheManagerImpl.createNewSM(Unknown Source)
at com.sun.jdori.common.CacheManagerImpl.getStateManager(Unknown
Source)
at
com.sun.jdori.common.PersistenceManagerImpl.getStateManager(Unknown Source)
at
org.apache.ojb.jdori.sql.OjbExtent.provideStateManagers(OjbExtent.java:171)
at org.apache.ojb.jdori.sql.OjbExtent.<init>(OjbExtent.java:101)
at
org.apache.ojb.jdori.sql.OjbStoreManager.getExtent(OjbStoreManager.java:251)
at com.sun.jdori.common.PersistenceManagerImpl.getExtent(Unknown
Source)
at com.sun.jdori.common.query.QueryImpl.checkCandidates(Unknown
Source)
at com.sun.jdori.common.query.QueryImpl.execute(Unknown Source)
at
org.apache.ojb.tutorial5.UCListAllProducts.apply(UCListAllProducts.java:44)
at org.apache.ojb.tutorial5.Application.run(Application.java:100)
at org.apache.ojb.tutorial5.Application.main(Application.java:68)
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] ERROR: SQLException
during the execution of the query (for a
org.apache.ojb.broker.util.sequence.HighLowSequence): ORA-00942: table or
view does not exist
ORA-00942: table or view does not exist
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
