Hi!
I am running a program from debugger in my IDE (SunOne) which reads data from a file and stores in RDBMS using ODMG. It worked fine for 700 entities but now on the next entity that needs to be persisted in the database I get the following exception trace. First time I got this was after 700 successful ones but now I am getting the error at the first attempt for the same dataset. I am certain that there is nothing in the data itself that can cause this. Am I crossing some upper limit here, like number of brokers etc.? Since this is 701st entry and the input file still has the previous 700 entities, the program first queries the RDBMS (using ODMG) to find out if an entity has already been persisted and if so skips it. Each entity has sub-entities and thus every entity involves several tables. It can be seen in the error trace below that failure occurs for sub-entity MYDATA.
Any advice shall be greatly appreciated.
Thanks for your time and help.
Ashish
Exception trace:->
[org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl] ERROR: Can't lookup new HighLowSequence for field myDataId using sequence name SEQ_ARC_DAT_MYDATA
Borrow broker from pool failed, using PBKey org.apache.ojb.broker.PBKey: jcdAlias=default, user=thedba, password=*****
org.apache.ojb.broker.PBFactoryException: Borrow broker from pool failed, using PBKey org.apache.ojb.broker.PBKey: jcdAlias=default, user=thedba, password=*****
at org.apache.ojb.broker.core.PersistenceBrokerFactoryDefaultImpl.createPersistenceBroker(PersistenceBrokerFactoryDefaultImpl.java:117)
at org.apache.ojb.broker.PersistenceBrokerFactory.createPersistenceBroker(PersistenceBrokerFactory.java:86)
at org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getSequence(SequenceManagerHighLowImpl.java:190)
at org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getUniqueLong(SequenceManagerHighLowImpl.java:145)
at org.apache.ojb.broker.util.sequence.AbstractSequenceManager.getUniqueValue(AbstractSequenceManager.java:128)
at org.apache.ojb.broker.util.BrokerHelper.getAutoIncrementValue(BrokerHelper.java:302)
at org.apache.ojb.broker.util.BrokerHelper.getValuesForObject(BrokerHelper.java:347)
at org.apache.ojb.broker.util.BrokerHelper.getKeyValues(BrokerHelper.java:173)
at org.apache.ojb.broker.Identity.init(Identity.java:118)
at org.apache.ojb.broker.Identity.<init>(Identity.java:82)
at org.apache.ojb.odmg.locking.InMemoryLockMapImpl.getWriter(InMemoryLockMapImpl.java:64)
at org.apache.ojb.odmg.locking.AbstractLockStrategy.getWriter(AbstractLockStrategy.java:59)
at org.apache.ojb.odmg.locking.ReadUncommittedStrategy.writeLock(ReadUncommittedStrategy.java:100)
at org.apache.ojb.odmg.locking.LockManagerDefaultImpl.writeLock(LockManagerDefaultImpl.java:76)
at org.apache.ojb.odmg.TransactionImpl.lock(TransactionImpl.java:234)
at org.apache.ojb.odmg.TransactionImpl.tryLock(TransactionImpl.java:529)
:
:
[My code here that calls above method]
Caused by: java.util.NoSuchElementException
at org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:803)
at org.apache.ojb.broker.core.PersistenceBrokerFactoryDefaultImpl.createPersistenceBroker(PersistenceBrokerFactoryDefaultImpl.java:99)
... 21 more
org.apache.ojb.broker.metadata.ClassNotPersistenceCapableException: Can not init Identity for given object [EMAIL PROTECTED]
at org.apache.ojb.broker.Identity.init(Identity.java:125)
at org.apache.ojb.broker.Identity.<init>(Identity.java:82)
at org.apache.ojb.odmg.locking.InMemoryLockMapImpl.getWriter(InMemoryLockMapImpl.java:64)
at org.apache.ojb.odmg.locking.AbstractLockStrategy.getWriter(AbstractLockStrategy.java:59)
at org.apache.ojb.odmg.locking.ReadUncommittedStrategy.writeLock(ReadUncommittedStrategy.java:100)
at org.apache.ojb.odmg.locking.LockManagerDefaultImpl.writeLock(LockManagerDefaultImpl.java:76)
at org.apache.ojb.odmg.TransactionImpl.lock(TransactionImpl.java:234)
at org.apache.ojb.odmg.TransactionImpl.tryLock(TransactionImpl.java:529)
:
:
[My code here that calls above method]
Caused by: org.apache.ojb.broker.PersistenceBrokerException: Could not get key value
at org.apache.ojb.broker.util.BrokerHelper.getAutoIncrementValue(BrokerHelper.java:315)
at org.apache.ojb.broker.util.BrokerHelper.getValuesForObject(BrokerHelper.java:347)
at org.apache.ojb.broker.util.BrokerHelper.getKeyValues(BrokerHelper.java:173)
at org.apache.ojb.broker.Identity.init(Identity.java:118)
... 13 more
Caused by: org.apache.ojb.broker.util.sequence.SequenceManagerException: Can't build new sequence
at org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getSequence(SequenceManagerHighLowImpl.java:205)
at org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getUniqueLong(SequenceManagerHighLowImpl.java:145)
at org.apache.ojb.broker.util.sequence.AbstractSequenceManager.getUniqueValue(AbstractSequenceManager.java:128)
at org.apache.ojb.broker.util.BrokerHelper.getAutoIncrementValue(BrokerHelper.java:302)
... 16 more
Caused by: org.apache.ojb.broker.PBFactoryException: Borrow broker from pool failed, using PBKey org.apache.ojb.broker.PBKey: jcdAlias=default, user=thedba, password=*****
at org.apache.ojb.broker.core.PersistenceBrokerFactoryDefaultImpl.createPersistenceBroker(PersistenceBrokerFactoryDefaultImpl.java:117)
at org.apache.ojb.broker.PersistenceBrokerFactory.createPersistenceBroker(PersistenceBrokerFactory.java:86)
at org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getSequence(SequenceManagerHighLowImpl.java:190)
... 19 more
Caused by: java.util.NoSuchElementException
at org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:803)
at org.apache.ojb.broker.core.PersistenceBrokerFactoryDefaultImpl.createPersistenceBroker(PersistenceBrokerFactoryDefaultImpl.java:99)
... 21 more
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
