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@1c297a3[
     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(Unknown Source)
        at 
org.apache.ojb.broker.singlevm.DelegatingPersistenceBroker.beginTransaction(Unknown 
Source)
        at 
org.apache.ojb.broker.util.sequence.SequenceGenerator.getNextSequence(Unknown Source)
        at 
org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getUniqueId(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(ActionServlet.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.invokeNext(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.invokeNext(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.invokeNext(Unknown
 Source)
        at org.apache.catalina.valves.ErrorDispatcherValve.invoke(Unknown Source)
        at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown
 Source)
        at org.apache.catalina.valves.ErrorReportValve.invoke(Unknown Source)
        at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown
 Source)
        at org.apache.catalina.valves.AccessLogValve.invoke(Unknown Source)
        at 
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.invokeNext(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

Reply via email to