Override autoincrement PK sequence for BO

Berkoff, Alexis (Alex) (Contractor, eDataTech)

unread,

Nov 14, 2020, 7:10:26 PM11/14/20

to kc.techni...@kuali.org

Hello KC tech gurus -

Had a question about overriding the sequence used on one of my Business Objects - EPS_PROPOSAL.

<class-descriptor class="org.kuali.kra.proposaldevelopment.bo.DevelopmentProposal" table="EPS_PROPOSAL">
<field-descriptor name="proposalNumber" column="PROPOSAL_NUMBER" jdbc-type="VARCHAR" primarykey="true" sequence-name="SEQ_PROPOSAL_NUMBER_KRA" autoincrement="true" />
...
</class-descriptor>

Question:
Per the Apache documentation Sequence Manager documentation located here -
http://db.apache.org/ojb/api/org/apache/ojb/broker/util/sequence/SequenceManagerNextValImpl.html

It seems that I can override this method, but not sure I quite follow how I can apply it specifically for that particular BO.
Has anyone done this by chance and can provide some guidance on how they did it?

The use case that demands this:

We have a PROPOSAL_TYPE called "Revision" that references an original PROPOSAL_NUMBER. So if someone creates a proposal of type "Revision" - on the initial save event - we don't want to use the next sequence number that ORACLE is managing, instead, we want to use the original proposal's PROPOSAL_NUMBER and append a decimal to the end of it that represents the current revision for that proposal.

e.g.
given SEQ_PROPOSAL_NUMBER_KRA.NEXTVAL = 2488
given PROPOSAL_NUMBER 2345 is currently on REVISION = 0 (it has not been revised yet)

user creates "Revision" proposal and links to PROPOSAL_NUMBER = 2345
new proposal is created and the PROPOSAL_NUMBER should NOT be 2488, but rather 2345.01

Where .01 = 1st revision (e.g. if 2345 is revised again the resultant PROPOSAL_NUMBER would be 2345.02, etc.)

Thanks!
Hope everyone is safe and well.

Alex

Ken Geis

unread,

Nov 16, 2020, 2:37:56 AM11/16/20

to Berkoff, Alexis (Alex) (Contractor, eDataTech), kc.techni...@kuali.org

Hi Alex.

I haven't done this, but this would be my approach:

Edit the repository.xml and remove the auto-increment attribute. (My build process applies customizations similar to this.)
Subclass the proposal's document object; override prepareForSave() to generate the ID

use SequenceAccessorService.getNextAvailableSequenceNumber(..) to replicate current auto-increment

Change the document XML to refer to your subclass and ingest the XML

I hope this helps.

Ken

--
To unsubscribe from this group and stop receiving emails from it, send an email to kc.technical.co...@kuali.org.

--

Ken Geis (he/him/his)

Acting Director, IT
Research Administration and Compliance
University of California, Berkeley
LinkedIn | rac.berkeley.edu | berkeley.edu

Berkoff, Alexis (Alex) (Contractor, eDataTech)

unread,

Nov 17, 2020, 6:19:18 PM11/17/20

to Ken Geis, kc.techni...@kuali.org

Hi Ken –

You got me past the first bump. My DevelopmentPropsal BO is deciding on how to assign the PK. THANKS!

The issue that I’m running into now is of course related … and it is being caused by something in OJB.

One another thing to note here – is that our custom PK (that doesn’t use the sequence generator) will only be created when someone “Copies” a PDD.

The initial save during that copy process works.

But the subsequent save is where things go sideways (when things like ProposalPerson, Abstract, Budget, etc. are attached to that BO).

Here is the output:

org.apache.ojb.broker.PersistenceBrokerException: org.apache.ojb.broker.PersistenceBrokerException: java.lang.NumberFormatException: For input string: "2352.01"

at org.apache.ojb.broker.core.proxy.CollectionProxyDefaultImpl.loadData(Unknown Source)

at org.apache.ojb.broker.core.proxy.ListProxyDefaultImpl.loadData(Unknown Source)

at org.apache.ojb.broker.core.proxy.CollectionProxyDefaultImpl.getData(Unknown Source)

at org.apache.ojb.broker.core.proxy.ListProxyDefaultImpl.getListData(Unknown Source)

at org.apache.ojb.broker.core.proxy.ListProxyDefaultImpl.get(Unknown Source)

at org.kuali.kra.proposaldevelopment.bo.DevelopmentProposal.evaluateMoveOptions(DevelopmentProposal.java:547)

at org.kuali.kra.proposaldevelopment.bo.DevelopmentProposal.getProposalPersons(DevelopmentProposal.java:541)

at org.kuali.kra.proposaldevelopment.bo.DevelopmentProposal.buildListOfDeletionAwareLists(DevelopmentProposal.java:1263)

at org.kuali.kra.proposaldevelopment.document.ProposalDevelopmentDocument.buildListOfDeletionAwareLists(ProposalDevelopmentDocument.java:483)

at org.kuali.rice.krad.service.util.OjbCollectionHelper.processCollections(OjbCollectionHelper.java:56)

at org.kuali.rice.krad.dao.impl.DocumentDaoOjb.save(DocumentDaoOjb.java:64)

at org.kuali.rice.krad.dao.proxy.DocumentDaoProxy.save(DocumentDaoProxy.java:98)

Notice that there’s something breaking about how OJB retrieves the list of ProposalPerson objects.

This is of course tied to the configuration of that class associated to the DevelopmentProposal. Here’s the snippet from that config:

What I don’t understand is that the ProposalPerson POJO defines proposalNumber as a String, YET org.apache.ojb.broker as you can see in the stacktrace is trying to CAST it into an INTEGER? *shoulder shrug*

The proposalNumber attribute for ProposalPerson has not been altered from the default config (this is directly from our overlay DD file – ProposalPerson.xml):

I went into our version of rice to see what genericSystemId validation is defined there. It has the “AnyCharacterValidationPattern” so it would seem that our decimal formatted String should be fine?!

Any thoughts or ideas or anyone else in the community?

Thanks!

From: Ken Geis <kg...@berkeley.edu>
Sent: Sunday, November 15, 2020 11:38 PM
To: Berkoff, Alexis (Alex) (Contractor, eDataTech) <ambe...@nps.edu>
Cc: kc.techni...@kuali.org
Subject: Re: [kuali] Override autoincrement PK sequence for BO

NPS WARNING: *external sender* verify before acting.

Ken Geis

unread,

Nov 17, 2020, 6:49:24 PM11/17/20

to Berkoff, Alexis (Alex) (Contractor, eDataTech), kc.techni...@kuali.org

Looking at the OJB code, it appears that the PersistenceBrokerException is a rethrow. Do you have a "caused by" trace below it in the logs?

Ken

Berkoff, Alexis (Alex) (Contractor, eDataTech)

unread,

Nov 17, 2020, 7:59:13 PM11/17/20

to Ken Geis, kc.techni...@kuali.org

@Ken Geis - Wish granted! 😊

I’m giving you everything starting with the “Copy” process being kicked off with me clicking on the “Copy Proposal” button.

2020-11-17 16:51:26,143 [http-nio-8080-exec-8] u:amberkof/d: INFO org.kuali.rice.kns.web.struts.action.KualiRequestProcessor - Started processing request: '/kc-dev/proposalDevelopmentActions.do' w/ query string: 'null'

2020-11-17 16:51:26,358 [http-nio-8080-exec-8] u:amberkof/d: INFO org.kuali.kra.proposaldevelopment.service.impl.ProposalCopyServiceImpl - STARTING PROPOSAL COPY

2020-11-17 16:51:26,512 [http-nio-8080-exec-8] u:amberkof/d: INFO org.kuali.kra.proposaldevelopment.service.impl.ProposalCopyServiceImpl - EXECUTING IN createNewProposal

2020-11-17 16:51:26,539 [http-nio-8080-exec-8] u:amberkof/d: INFO org.kuali.rice.krad.document.DocumentBase - invoking rules engine on document 19806

proccessValidateSponsor

returning: true

2020-11-17 16:51:26,599 [http-nio-8080-exec-8] u:amberkof/d: INFO org.kuali.rice.krad.service.impl.DocumentServiceImpl - storing document 19806

2020-11-17 16:51:27,193 [http-nio-8080-exec-8] u:amberkof/d: INFO org.apache.ojb.broker.metadata.MetadataManager - No 'default-connection' attribute set in jdbc-connection-descriptors, thus it's currently not possible to use 'defaultPersistenceBroker()' convenience method to lookup PersistenceBroker instances. But it's possible to enable this at runtime using 'setDefaultKey' method.

2020-11-17 16:51:27,217 [http-nio-8080-exec-8] u:amberkof/d: INFO org.apache.ojb.broker.metadata.MetadataManager - No 'default-connection' attribute set in jdbc-connection-descriptors, thus it's currently not possible to use 'defaultPersistenceBroker()' convenience method to lookup PersistenceBroker instances. But it's possible to enable this at runtime using 'setDefaultKey' method.

2020-11-17 16:51:27,358 [http-nio-8080-exec-8] u:amberkof/d:19806 INFO org.apache.ojb.broker.cache.CacheDistributor -

<====

Setup new object cache instance on CONNECTION LEVEL for

PersistenceBroker: org.apache.ojb.broker.core.PersistenceBrokerImpl@252a8a67

descriptorBasedCache: false

Connection jcdAlias: rice.ksb.messageDataSource

Calling class: class org.kuali.rice.ksb.messaging.PersistedMessageBOObjectCache: org.apache.ojb.broker.metadata.ObjectCacheDescriptor@acda94a[ObjectCache=class org.apache.ojb.broker.cache.ObjectCachePerBrokerImpl,Properties={}]

====>

2020-11-17 16:51:27,358 [http-nio-8080-exec-8] u:amberkof/d:19806 INFO org.apache.ojb.broker.cache.CacheDistributor - Specified cache class org.apache.ojb.broker.cache.ObjectCachePerBrokerImpl does not implement interface org.apache.ojb.broker.cache.ObjectCacheInternal and will be wrapped by a helper class

2020-11-17 16:51:27,476 [http-nio-8080-exec-8] u:amberkof/d:19806 INFO org.kuali.rice.kew.util.PerformanceLogger - Time: 78ms, Time to activate action request with id 30108

2020-11-17 16:51:27,530 [http-nio-8080-exec-8] u:amberkof/d:19806 INFO org.kuali.rice.kew.util.PerformanceLogger - Time: 132ms, Time to activate 1 action requests.

2020-11-17 16:51:27,553 [http-nio-8080-exec-8] u:amberkof/d:19806 INFO org.kuali.rice.krad.service.impl.PostProcessorServiceImpl - started handling route status change from I to S for document 19806

2020-11-17 16:51:27,562 [http-nio-8080-exec-8] u:amberkof/d:19806 INFO org.kuali.kra.proposaldevelopment.document.ProposalDevelopmentDocument - Route status change for document 19806 - proposal number 2352.01 is moving from I to S

2020-11-17 16:51:27,562 [http-nio-8080-exec-8] u:amberkof/d:19806 INFO org.kuali.rice.krad.service.impl.PostProcessorServiceImpl - finished handling route status change from I to S for document 19806

2020-11-17 16:51:27,897 [http-nio-8080-exec-8] u:amberkof/d:19806 INFO org.kuali.rice.krad.document.DocumentBase - invoking rules engine on document 19806

proccessValidateSponsor

returning: true

2020-11-17 16:51:27,952 [http-nio-8080-exec-8] u:amberkof/d:19806 INFO org.kuali.rice.krad.service.impl.DocumentServiceImpl - storing document 19806

2020-11-17 16:51:28,293 [http-nio-8080-exec-8] u:amberkof/d:19806 INFO org.apache.ojb.broker.metadata.MetadataManager - No 'default-connection' attribute set in jdbc-connection-descriptors, thus it's currently not possible to use 'defaultPersistenceBroker()' convenience method to lookup PersistenceBroker instances. But it's possible to enable this at runtime using 'setDefaultKey' method.

2020-11-17 16:51:28,421 [http-nio-8080-exec-8] u:amberkof/d:19806 INFO org.kuali.rice.krad.document.DocumentBase - invoking rules engine on document 19806

proccessValidateSponsor

returning: true

2020-11-17 16:51:28,465 [http-nio-8080-exec-8] u:amberkof/d:19806 INFO org.kuali.rice.krad.service.impl.DocumentServiceImpl - storing document 19806

2020-11-17 16:51:28,506 [http-nio-8080-exec-8] u:amberkof/d:19806 FATAL org.kuali.rice.core.framework.persistence.jta.KualiTransactionInterceptor - Exception caught by Transaction Interceptor, this will cause a rollback at the end of the transaction.