The Incident Archive

Doing a quick set of performance tests to just confirm a few things I have experienced with ADF. (I will update this post with new info after each test). All tests done on an XE db Test 1) Read Only VO vs Updatable vs AM query vs SQL based VO - Scrollable 1000 batches of 1000 +- 300000 results Read only vo query results: 203,31,47,31,31,47 AM Query timing  31,31,15,15,31,31 SQL timing:78,15,16,0,15,16 VO timing:11653,11919,9812,9485,9781,9734 So definitely a case for not using updateable VO's everywhere. Test 2) Read Only VO vs Updatable vs SQL based VO - Range Paging 1000 batches of 1000 +- 300000 results Read only vo query results: 125,47,63,32 SQL timing: 62,32,32,31 VO timing:125, 94, 47, 32 Test 3) Read Only VO vs Updatable vs SQL based VO - Range Paging FIRST_ROWS 1000 batches of 1000 +- 300000 results Read only vo query results: 172,94,63,31 SQL timing: 78,62,15,15 VO timing:125, 78, 47, 47 NOTE: These are small localized tests to show some pe...

I am starting to play around with ADFs mobile stuff and forgot how to create the project. (Custom project then select the ADF Mobile Browser project feature). I have worked with trinidad before so the dev is not so tricky and drag and drop works so good times. Note to self follow this link if you forget: http://www.oracle.com/technetwork/developer-tools/jdev/ccset52-all-094777.html Also I am using the droid emulator that comes with the SDK for testing will get an iPhone one at a later stage.

Did a bit of refactoring and came accross a bit of a problem. One of the directories all the VO's displayed as blank with no details (jdev popup errors everywhere) ... problems. Solution Stop Jdev. Edit the Model.jpx file and add the directory missing manually to the file like such:    <Containee       Name="lov"       PackageName="za.co.company.adf.test.model.lov"       ObjectType="JboPackage">       <DesignTime>          <Attr Name="_VO" Value="true"/>       </DesignTime>    </Containee> Start Jdev

I had implemented autosuggest on an input text field and it was all working so I moved it into our template to make it available application wide. The component stopped working (bind problem first then it would not return the value I needed into the text box). Here are the fixes. The component is quick go button functionality with a suggest lookup to any menu link. Bind problems solution: I needed to lookup the template binding using the current bind did not have my VO:  BindingContext bctx = BindingContext.getCurrent();   DCBindingContainer bindings =        bctx.findBindingContainer(       "package_formTemplatePageDef"); Not returning the value solution: I had a uppercase conveter on my input text field - this was messing with my return value on the autosuggest. I removed it and it worked like magic. The working code (note the query is limited to 5 rows in the VO with a bind variable linked to rownum): J...

All I wanted out of life was to authenticate off Active Directory, have everyone with a valid user be able to read my svn repo and have a build user defined in a file for my Continuos integration (Non active directory user) and have a couple of AD users have read/write permissions sounds simple but maybe not so much. This is my config file (in /etc/httpd/conf.d): <AuthnProviderAlias ldap adf-ldap-alias> #ldap config make sure the DN config is correct and the server is right   AuthLDAPURL "ldap://adserver.co.za:3268/OU=User Accounts,DC=company,DC=co,DC=za?sAMAccountName?sub?(objectClass=*)" NONE   AuthLDAPBindDN "svnuser@company.co.za"   AuthLDAPBindPassword supersecret </AuthnProviderAlias> <AuthnProviderAlias file adf-file-alias> #setup this file using  htpasswd   AuthUserFile /etc/subversion/adf-auth-file </AuthnProviderAlias> <Location /adfrepo>   DAV svn   AuthType Basic   AuthName "ADF Subversi...

My way add a project (already created) using a tortoise: Repo browser add the folders to svn. Checkout newly created folder tolocal disk where project is. On explorer do a check for modifications add to your hearts content (remeber to uncheck unwanted dirs and add to ignore list). Check in.

JDeveloper 11.1.2.1 Found a nifty little setting in the adf-config.xml file Row Fetch Limit. This applies to all vo's in the application. Click on the Application resources menu tab and select the adf-config file under ADF META-INF. Click on the Business Components tab Ner the bottom there is a Row Fetch Limit checkbox. Why would I use this: This setting can be used for performance reasons to set a resultset limit across the entire application. This can prevent large meaningless user searches with million row results etc.