[ojb-users] WG: AW: AW: [Fwd: Thank you]

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

=20

-----Urspr=FCngliche Nachricht-----
Von: Srividya Vullanki [mailto:p_s...@ya...]
Gesendet: Donnerstag, 13. Juni 2002 17:38
An: Mahler Thomas
Betreff: Re: AW: AW: [Fwd: Thank you]

Hi Thomas,=20

 The OJB tool worked great on Win2K using MySQL as the database. But, =
when
we tried to implement on Tandem box using NonStop SQL as the Database, =
we
had a couple of problems. We are not sure what the problem is though.=20

Probably you could help us out, so that we could succefully implement =
on
Tandem.=20

Below, Is the attached error message. If you could explain to us what =
SQL
statements are passed to JDBC, it could help us to track down whether =
its a
problem with the JDBC driver on Tandem.=20

Once again Thnaks a bunch.=20

FYI, We added a some print statements for debugging purposes.=20

Sri=20

/usr/tandem/objectpersistence>java TandemTester
Persisting an ATRDataContainer Object
[BOOT] INFO: OJB.properties:
file:/usr/tandem/objectpersistence/OJB.properties
[DEFAULT] INFO: OJB Descriptor Repository:
file:/usr/tandem/objectpersistence/re
pository.xml
[BOOT] INFO: loading XML took 1080 msecs
[DEFAULT] INFO: ...Finished parsing
Created an instance of ATREStaticData
Got the Static Data
[ojb.broker.singlevm.PersistenceBrokerImpl] DEBUG: store
com.co.atre.engine.cont
ainer.ATRDataContainer@90132bee =
<mailto:ainer.ATRDataContainer@90132bee>=20
[ojb.broker.singlevm.PersistenceBrokerImpl] DEBUG: getObjectByIdentity
ojb.broke
r.util.sequence.HighLowSequence{com.co.atre.engine.container.ATRDataCont=
aine
r,m_
intPnrID}
[ojb.broker.accesslayer.SqlGenerator] DEBUG: SQL: SELECT
A0.CLASSNAME,A0.FIELDNA
ME,A0.MAX_KEY,A0.GRAB_SIZE FROM =3DOJB_HL_SEQ A0 WHERE (A0.CLASSNAME =
=3D ?) AND
(A0.
FIELDNAME =3D ?)
[ojb.broker.accesslayer! .StatementsForClass] DEBUG: prepareStatement:
SELECT A0.C
LASSNAME,A0.FIELDNAME,A0.MAX_KEY,A0.GRAB_SIZE FROM =3DOJB_HL_SEQ A0 =
WHERE
(A0.CLAS
SNAME =3D ?) AND (A0.FIELDNAME =3D ?)
[ojb.broker.accesslayer.JdbcAccess] DEBUG: before bind select....
Number of primary Keys...2
First Value is    com.co.atre.engine.container.ATRDataContainer
Value is not null.. and setting the object with values
Arg 1 01
arg 2 com.co.atre.engine.container.ATRDataContainer
arg 3 12
First Value is    m_intPnrID
Value is not null.. and setting the object with values
Arg 1 11
arg 2 m_intPnrID
arg 3 12
[ojb.broker.accesslayer.JdbcAccess] DEBUG: After bind select....
[ojb.broker.accesslayer.JdbcAccess] DEBUG: After EXCUTING
QUERYD***************=20

[ojb.broker.singlevm.PersistenceBrokerImpl] DEBUG: store
ojb.broker.util.sequenc
e.HighLowSequence@e9e32beb <mailto:e.HighLowSequence@e9e32beb>=20
[ojb.broker.accesslayer.JdbcAccess] DEBUG: before bind select....
Number of primary Keys...2
First Value is    com.co.atre.engine.container.ATRDataContainer
Value is not null.. and setting the object with values
Arg 1 01
arg 2 com.co.atre.engine.container.ATRDataContainer
arg 3 12
[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 cu
rsor
        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(Unkn
own Sourc
e)

    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
Sourc
e)
        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 object! =
persistence.ATRObjectPersistor.writeATREObject(Unknown
Source)
        at TandemTester.main(TandemTester.java, Compiled Code)
[DEFAULT] ERROR: OJB ERROR: Dont know how to autoincrement field class
com.co.at
re.engine.container.ATRDataContainer.m_intPnrID
java.lang.RuntimeException: OJB ERROR: Dont know how to autoincrement =
field
clas
s com.co.atre.engine.container.ATRDataContainer.m_intPnrID
        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.write! =
ATREObject(Unknown
Source)
      &nbs p; 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)
[ojb.broker.singlevm.PersistenceBrokerImpl] ERROR: Error in Transaction
abort: S
QLMP: Cannot rollback in auto commit mode
null
ojb.broker.metadata.ClassNotPersistenceCapableException
        at ojb.broker.singlevm.PersistenceBrokerImpl.store(Unknown =
Source)
 &nb! sp;      at
objectpersistence.ATRObjectPersistor.writeATREObject(Unknown Source)
        at TandemTester.main(TandemTester.java, Compiled Code)
Writing into the database!!!!                                       =20

  _____ =20

Do You Yahoo!?
Sign-up
<http://rd.yahoo.com/welcome/*http://fifaworldcup.yahoo.com/fc/en/spl> =
for
Video Highlights of 2002 FIFA World Cup