Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ADF Mobile Client : PageBinding Error

761579May 20 2010 — edited May 21 2010
Hi all,

I have created a sample ADF Mobile client application with 2 screens. Page1 has a link to Page2. And, Page2 has a URL Data Control for a webservice, which is giving me an XML. I have in place the corresponding XSD in my Model Project too. Now, after deploying the app on BlackBerry / Windows Mobile, I am getting the following error on clicking the Link in Page1.

Am I missing something here?

Please find the corresponding stack trace as below:

initializing default resource loader
adding jar rep
oracle.adfnmc.bindings.dbf.BindingContext.get: [oracle.adfnmc.bindings.dbf.BindingContext.get] BindingContext cannot contain a key for: URLDataControl1, only keys declared in application metadata (*.cpx) are allowed.
[oracle.adfnmc.bindings.dbf.BindingContext.get] Error retrieving BindingContainer: 'mobmgr_mobile_AlertsPageDef'
at oracle.adfnmc.bindings.dbf.BindingContext.get(Unknown Source)
at oracle.adfnmc.bindings.dbf.InitializeBindingContainerVisitor.getDataControl(Unknown Source)
at oracle.adfnmc.bindings.dbf.InitializeBindingContainerVisitor.visit(Unknown Source)
at oracle.adfnmc.bindings.dbf.InitializeBindingContainerVisitor.visit(Unknown Source)
at oracle.adfnmc.bindings.xmlmetadata.MethodAction.accept(Unknown Source)
at oracle.adfnmc.bindings.xmlmetadata.PageDefNode.accept(Unknown Source)
at oracle.adfnmc.util.parse.Visitor.visitEach(Unknown Source)
at oracle.adfnmc.bindings.xmlmetadata.PageDefVisitor.visit(Unknown Source)
at oracle.adfnmc.bindings.xmlmetadata.Bindings.accept(Unknown Source)
at oracle.adfnmc.bindings.xmlmetadata.PageDefNode.accept(Unknown Source)
at oracle.adfnmc.bindings.xmlmetadata.PageDefVisitor.visit(Unknown Source)
at oracle.adfnmc.bindings.dbf.InitializeBindingContainerVisitor.visit(Unknown Source)
at oracle.adfnmc.bindings.xmlmetadata.PageDefinition.accept(Unknown Source)
at oracle.adfnmc.bindings.xmlmetadata.PageDefNode.accept(Unknown Source)
at oracle.adfnmc.bindings.dbf.InitializeBindingContainerVisitor.populateBindingContainer(Unknown Source)
at oracle.adfnmc.bindings.dbf.BindingContainerImpl.initialize(Unknown Source)
at oracle.adfnmc.bindings.dbf.BindingContext.createAndInitBindingContainer(Unknown Source)
at oracle.adfnmc.bindings.dbf.BindingContext.get(Unknown Source)
at oracle.adfnmc.bindings.dbf.BindingContext.pageChanged(Unknown Source)
at oracle.adfnmc.app.UIModule.loadScreenId(Unknown Source)
at oracle.adfnmc.app.UIModule.showScreenId(Unknown Source)
at oracle.adfnmc.app.Navigation.execute(Unknown Source)
at oracle.adfnmc.component.ui.ExecuteActionHelper$NavigationRunner.run(Unknown Source)
at oracle.adfnmc.util.async.BackgroundWorker.doWork(Unknown Source)
at oracle.adfnmc.util.async.BackgroundWorker.doWork(Unknown Source)
at oracle.adfnmc.util.async.BackgroundWorker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

Comments

Frank Kulash
Hi,

Assuming the columns bb, cl and la are never NULL:
SELECT	customer_key
,	GREATEST ( bb
		 , cl
		 , la
		 )	AS spend
FROM	TABLE_X
;
Assuming the numbers can be NULL, is there a lower bound to their possible values (such as 0)?
If so, use NVL to map NULLs to an impossibly low value, e.g. NVL (bb, -1). You may want to use NULLIF to map that back to NULL in the event that all 3 columns are NULL.
If not, unpivot the 3 columns in to one column and use the aggregate MAX function.
Kodiak_Seattle
Cooool, let me try that out, thanks!
Kodiak_Seattle
Ok, this worked, I guess I need one more thing, I need an additional field that will tell me which column the Greatest Spend Came from, like BB, or CL, or LA ?

How would something like that be done ?
Frank Kulash
Answer
Hi,

Use a CASE expression.
Assuming the numbers are distinct and not NULL:
SELECT	customer_key
,	GREATEST ( bb
		 , cl
		 , la
		 )	AS spend
,	CASE
		WHEN  bb >= GREATEST (cl, la)	THEN  'BB'
		WHEN  cl >= la	     	  	THEN  'CL'
		      	    			ELSE  'LA'
	END		AS column_name
FROM	table_x
;
Marked as Answer by Kodiak_Seattle · Sep 27 2020
Kodiak_Seattle
Thank you for your time!
Aketi Jyuuzou
I like simple case expression :D
SELECT customer_key,GREATEST(bb,cl,la) AS spend
CASE GREATEST(bb,cl,la)
when bb then 'BB'
when cl then 'CL'
when la then 'LA' END AS column_name
FROM    table_x;
1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 18 2010
Added on May 20 2010
2 comments
760 views