[ojb-users] Database Error

[Srividya V. <p_s...@ya...>]

  Hi ,
I am having a problem to run the OJB application on SQLMPDatabase. I am getting the open cursor error! ie., it is unable to excute two SQL statements! That first statement is running fine and for the second statement I am getting the following erro message -- "Cannot set a value in a statement with  an open cursor"   Other JDBC applications on the  same Database are working fine! How can I fix this problem.I am including the printStackTrace with some additional debugging statements added by me!
I appreciate any help!
Thanks
Srividya
 
 
BOOT] INFO: OJB.properties: 
file:/usr/tandem/objectpersistence/OJB.properties
[DEFAULT] INFO: OJB Descriptor Repository: 
file:/usr/tandem/objectpersistence/repository.xml
[BOOT] INFO: loading XML took 1041 msecs
[DEFAULT] INFO: ...Finished parsing
[ojb.broker.singlevm.PersistenceBrokerImpl] DEBUG: store com.co.atre.engine.container.ATRDataContainer@105248f5
[ojb.broker.singlevm.PersistenceBrokerImpl] DEBUG: getObjectByIdentity ojb.broker.util.sequence.HighLowSequence{com.co.atre.engine.container.ATRDataContainer,m_intPnrID}
[ojb.broker.accesslayer.SqlGenerator] DEBUG: SQL: SELECT A0.CLASSNAME,A0.FIELDNAME,A0.MAX_KEY,A0.GRAB_SIZE FROM =OJB_HL_SEQ A0 WHERE (A0.CLASSNAME = ?) AND (A0.FIELDNAME = ?)
[ojb.broker.accesslayer.StatementsForClass] DEBUG: prepareStatement: 
SELECT A0.CLASSNAME,A0.FIELDNAME,A0.MAX_KEY,A0.GRAB_SIZE FROM =OJB_HL_SEQ A0 WHERE 
(A0.CLASSNAME = ?) AND (A0.FIELDNAME = ?)
[ojb.broker.accesslayer.JdbcAccess] DEBUG: before bind select....
[ojb.broker.accesslayer.JdbcAccess] DEBUG: After bind select....
[ojb.broker.accesslayer.JdbcAccess] DEBUG: After EXCUTING QUERYD***************
[ojb.broker.singlevm.PersistenceBrokerImpl] DEBUG: store 
ojb.broker.util.sequence.HighLowSequence@687248f0
[ojb.broker.accesslayer.JdbcAccess] DEBUG: before bind select....
[DEFAULT] ERROR: bindSelect failed for: ojb.broker.util.sequence.HighLowSequence
{com.co.atre.engine.container.ATRDataContainer,m_intPnrID}, PK: 0, value: 
com.co.atre.engine.container.ATRDataContainer
[ojb.broker.accesslayer.JdbcAccess] ERROR: SQLException during the 
execution of materializeObject: SQLMP: Cannot set a value in a statement with  an 
open cursor

SQLMP: Cannot set a value in a statement with  an open cursor
java.sql.SQLException: SQLMP: Cannot set a value in a statement with  
an open cursor at com.tandem.sqlmp.SQLMPPreparedStatement.setObject(SQLMPPreparedStatem
ent.java, Compiled Code)
        at com.tandem.sqlmp.SQLMPPreparedStatement.setObject(SQLMPPreparedStatem
ent.java, Compiled Code)
        at ojb.broker.accesslayer.StatementManager.bindSelect(Unknown 
Source)
        at ojb.broker.accesslayer.JdbcAccess.materializeObject(Unknown 
Source)
        at ojb.broker.singlevm.PersistenceBrokerImpl.store(Unknown 
Source)
        at ojb.broker.util.sequence.SequenceManagerHighLowImpl.getUniqueId(Unkno
wn Source)
        at ojb.broker.util.sequence.SequenceManagerDefaultImpl.getUniqueLong(Unk
nown Source)
        at ojb.broker.singlevm.PersistenceBrokerImpl.getUniqueLong(Unknown 
Source)
        at ojb.broker.metadata.ClassDescriptor.getAutoIncrementValue(Unknown 
Source)
        at ojb.broker.metadata.ClassDescriptor.getKeyValues(Unknown 
Source)
        at ojb.broker.Identity.<init>(Unknown Source)
        at ojb.broker.singlevm.PersistenceBrokerImpl.store(Unknown 
Source)
        at objectpersistence.ATRObjectPersistor.writeATREObject(Unknown 
Source)
        at TandemTester.main(TandemTester.java, Compiled Code)
[DEFAULT] ERROR: OJB ERROR: Dont know how to autoincrement field class 
com.co.atre.engine.container.ATRDataContainer.m_intPnrID
java.lang.RuntimeException: OJB ERROR: Dont know how to autoincrement 
field class com.co.atre.engine.container.ATRDataContainer.m_intPnrID
        at ojb.broker.metadata.ClassDescriptor.getAutoIncrementValue(Unknown 
Source)
        at ojb.broker.metadata.ClassDescriptor.getKeyValues(Unknown 
Source)
        at ojb.broker.Identity.<init>(Unknown Source)
        at ojb.broker.singlevm.PersistenceBrokerImpl.store(Unknown 
Source)
        at objectpersistence.ATRObjectPersistor.writeATREObject(Unknown 
Source)
      at ojb.broker.metadata.ClassDescriptor.getAutoIncrementValue(Unknown 
Sou
rce)
        at ojb.broker.metadata.ClassDescriptor.getKeyValues(Unknown 
Source)
        at ojb.broker.Identity.<init>(Unknown Source)
        at ojb.broker.singlevm.PersistenceBrokerImpl.store(Unknown 
Source)
        at objectpersistence.ATRObjectPersistor.writeATREObject(Unknown 
Source)
        at TandemTester.main(TandemTester.java, Compiled Code)
[DEFAULT] ERROR: null
ojb.broker.PersistenceBrokerException
        at ojb.broker.metadata.ClassDescriptor.getKeyValues(Unknown 
Source)
        at ojb.broker.Identity.<init>(Unknown Source)
        at ojb.broker.singlevm.PersistenceBrokerImpl.store(Unknown 
Source)
        at objectpersistence.ATRObjectPersistor.writeATREObject(Unknown 
Source)
        at TandemTester.main(TandemTester.java, Compiled Code)
null
ojb.broker.metadata.ClassNotPersistenceCapableException
        at ojb.broker.singlevm.PersistenceBrokerImpl.store(Unknown 
Source)
        at objectpersistence.ATRObjectPersistor.writeATREObject(Unknown 
Source)
        at TandemTester.main(TandemTester.java, Compiled Code)




---------------------------------
Do You Yahoo!?
Sign-up for Video Highlights of 2002 FIFA World Cup