"VENKATESH, SUMA (SBCSI)" <[EMAIL PROTECTED]> schrieb am 19.01.04 20:06:04:
Hi Suma, 1. Please post questions to the user list and not to individual developers. > > 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. Mhh, All Tutorials provide out of the box support only for the HSQLDB that ships with OJB. >From a short look at your stacktrace I see some Oracle exceptions. So you are not follwing exactly the steps described in the tutorial but try to run the app against Oracle, right? The actual problems seems to be clearly indicated by the stacktrace: The OJB default SequenceManager component relies on having a special table in your database. The app simply can not find this table in your DB. Please read the documentation regarding deployment on a specific database platform to setup this table: http://db.apache.org/ojb/platforms.html. Instead of using the default SeqMan you could also use an Oracle specific solution, that uses Oracle native sequence number instead: http://db.apache.org/ojb/howto-use-db-sequences.html Using JDO and PB together should be OK! cheers, Thomas > 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 > ______________________________________________________________________________ Erdbeben im Iran: Zehntausende Kinder brauchen Hilfe. UNICEF hilft den Kindern - helfen Sie mit! https://www.unicef.de/spe/spe_03.php --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
