Hi Gerardo,
between 0.9.8 and 0.9.9 many changes were made.
Now field descriptor id was no longer used, see examples in
repository files (in particular reference-descriptor, use
foreignkey field-ref).
Do you really update all configuration files (OJB.properties,
repository_internal.xml, ...)?
If this doesn't help, try to use another SequenceManager
for testing e.g. SequenceManagerInMemoryImpl (this
implementation does not store any data to database)
and post the stack trace again.
regards,
Armin
----- Original Message -----
From: "Gerardo Arroyo" <[EMAIL PROTECTED]>
To: "OJB Users List" <[EMAIL PROTECTED]>
Sent: Monday, February 17, 2003 6:30 PM
Subject: Problem with HighLowSequence under 0.9.9 and 0.9.8
> Hi,
>
> I am having some problems with OJB 0.9.8 and 0.9.9.
>
> The problems is a
> [org.apache.ojb.broker.util.sequence.SequenceGenerator] ERROR: Can not
get next org.apache.ojb.broker.util.sequence.HighLowSequence for next
scope of keys
> null
>
> everytime that I attempt to insert a new record on a table, I am using
SybaseASE 11.9.2 under Linux. The extract of the repository user is:
>
> <class-descriptor
> class="com.unify.webcenter.data.teamsData"
> table="teams"
> >
> <field-descriptor id="1"
> name="authorized"
> column="authorized"
> jdbc-type="CHAR"
> />
> <field-descriptor id="2"
> name="members"
> column="members"
> jdbc-type="INTEGER"
> />
> <field-descriptor id="3"
> name="projects"
> column="projects"
> jdbc-type="INTEGER"
> />
> <field-descriptor id="4"
> name="published"
> column="published"
> jdbc-type="CHAR"
> />
> <field-descriptor id="5"
> name="id"
> column="id"
> jdbc-type="INTEGER"
> primarykey="true"
> autoincrement="true"
> />
> <reference-descriptor name="parentMember"
> class-ref="com.unify.webcenter.data.membersData"
> refresh="true">
> <foreignkey field-id-ref = "2"/>
> </reference-descriptor>
> </class-descriptor>
>
>
> And the stack trace is below. Any idea or suggestion???
>
> Thanks in advance!
>
>
> [org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl] INFO:
Create new connection
pool:org.apache.ojb.broker.metadata.JdbcConnectionDescriptor@1014e21[
> jcd-alias=default
> default-connection=true
> dbms=SybaseASE
> jdbc-level=1.0
> driver=com.sybase.jdbc2.jdbc.SybDriver
> protocol=jdbc
> sub-protocol=sybase
> db-alias=Tds:10.1.1.137:5000/unifycenter
> user=sa
> password=*****
> eager-release=false
> ConnectionPoolDescriptor={whenExhaustedAction=0, maxIdle=-1,
maxActive=21, maxWait=5000, removeAbandoned=false,
numTestsPerEvictionRun=10, testWhileIdle=false,
minEvictableIdleTimeMillis=600000, testOnReturn=false,
logAbandoned=false, removeAbandonedTimeout=300,
timeBetweenEvictionRunsMillis=-1, testOnBorrow=true}
> batchMode=false
>
sequenceDescriptor=org.apache.ojb.broker.metadata.SequenceDescriptor@1c2
97a3[
> sequenceManagerClass=class
org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl
> Properties={grabSize=5}
> ]
> ]
> [org.apache.ojb.broker.util.sequence.SequenceGenerator] ERROR: Can not
get next org.apache.ojb.broker.util.sequence.HighLowSequence for next
scope of keys
> null
> org.apache.ojb.broker.TransactionInProgressException
> at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.beginTransaction(Un
known Source)
> at
org.apache.ojb.broker.singlevm.DelegatingPersistenceBroker.beginTransact
ion(Unknown Source)
> at
org.apache.ojb.broker.util.sequence.SequenceGenerator.getNextSequence(Un
known Source)
> at
org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getUnique
Id(Unknown Source)
> at
org.apache.ojb.broker.util.BrokerHelper.getAutoIncrementValue(Unknown
Source)
> at
org.apache.ojb.broker.util.BrokerHelper.getKeyValues(Unknown Source)
> at org.apache.ojb.broker.Identity.init(Unknown Source)
> at org.apache.ojb.broker.Identity.<init>(Unknown Source)
> at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.store(Unknown
Source)
> at
org.apache.ojb.broker.singlevm.DelegatingPersistenceBroker.store(Unknown
Source)
> at
com.unify.webcenter.broker.MainBroker.add(MainBroker.java:37)
> at
com.unify.webcenter.action.teamsAction.perform(teamsAction.java:156)
> at
org.apache.struts.action.ActionServlet.processActionPerform(ActionServle
t.java:1720)
> at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1519)
> at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:505)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java)
> at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown
Source)
> at
org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source)
> at
org.apache.catalina.core.StandardWrapperValve.invoke(Unknown Source)
> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(Unknown Source)
> at org.apache.catalina.core.StandardPipeline.invoke(Unknown
Source)
> at org.apache.catalina.core.ContainerBase.invoke(Unknown
Source)
> at
org.apache.catalina.core.StandardContextValve.invoke(Unknown Source)
> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(Unknown Source)
> at org.apache.catalina.core.StandardPipeline.invoke(Unknown
Source)
> at org.apache.catalina.core.ContainerBase.invoke(Unknown
Source)
> at org.apache.catalina.core.StandardContext.invoke(Unknown
Source)
> at org.apache.catalina.core.StandardHostValve.invoke(Unknown
Source)
> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(Unknown Source)
> at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(Unknown Source)
> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(Unknown Source)
> at org.apache.catalina.valves.ErrorReportValve.invoke(Unknown
Source)
> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(Unknown Source)
> at org.apache.catalina.valves.AccessLogValve.invoke(Unknown
Source)
> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(Unknown Source)
> at org.apache.catalina.core.StandardPipeline.invoke(Unknown
Source)
> at org.apache.catalina.core.ContainerBase.invoke(Unknown
Source)
> at org.apache.catalina.core.StandardEngineValve.invoke(Unknown
Source)
> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(Unknown Source)
> at org.apache.catalina.core.StandardPipeline.invoke(Unknown
Source)
> at org.apache.catalina.core.ContainerBase.invoke(Unknown
Source)
> at
org.apache.catalina.connector.http.HttpProcessor.process(Unknown Source)
> at
org.apache.catalina.connector.http.HttpProcessor.run(Unknown Source)
> at java.lang.Thread.run(Thread.java:536)
> [org.apache.ojb.broker.accesslayer.ConnectionManagerImpl] INFO:
Rollback was called, do rollback on current connection
com.sybase.jdbc2.jdbc.SybConnection@1f195fc
>
>
>
> Ing. Gerardo Arroyo Arce
> Flecha Roja Technologies
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]