ADF

Adf :1-1-association returning more than one row fix by overriding findOrCreateAssociationAccessorRS

 

So this was a strange issue, I face when writing a certain Junit test for a 1:1 association. I was creating a new row which partially fullfilled the 1:1 association condition, and when programmatically asking on this 1:1 assocaition about the other end, the newly created row was getting returned.

 

ADF DI - How to operate on a selected row in the table component within excel

ADF-DI Excel

 

ADF DI is ADF's desktop integration that enables a user to work with data in an excel sheet. It is not too feature rich and has its limitations, but it also does well, what it sets out to do. Basically batch creates, deletes and updates are really no problems for tables.

 

A case of oracle.jbo.TooManyObjectsException : Change createRowFromResultSet to createInstanceFromResultSet

TooManyObjectsException

So there are some documented cases of this exception happening and some remedies there-in, if you google this problem.

What if you think you don't fall into this category. So let me "describe" for you a scenario and if you fall into this category, this might save you some pain in troubleshooting this scenario. Again, this might not be the case for you and simple plain vanilla advice might be all you need. If the description some how matches your use case, you can try the solution I propose.

Part 3 : Output Debug SQL statements on a Managed Server on a Production Weblogic 10.3 Cluster

So if you have already read my debugging adventures on a production clone Weblogic server part 1 and part 2, this can be called the part 3 of that series.

Part 2 : Remote Debugging a Managed Server on Production Weblogic 10.3 Cluster via SSH tunnelling

So this is a follow up article to part 1 here. If you are reading this, I am assuming you were not able to connect your debugger to the port opened in part 1, same as me. Well don't despair. There is a solution. In my case apparently only common ports were opened on the system, as it was supposed to be built close to a production system. Or actually some network switch or a physical hardware must be blocking access to the port. For this part, I was not sure. And the IT person supporting me also probably also didn't know the cause.

Part 1 : Remote Debugging a Managed Server on Production Weblogic 10.3 Cluster

Database Time Interval Based View Criterias in ADF View Objects

So this is more of a cookbook recipe article to show you how you can create time based View Criterias using sql fragments for your ADF ViewObjects.

Important point to note up front. Your database and application server might be running in different time zones. So you need to place attention to this fact when designing your View Objects and View Criterias. For the purpose of this article, I am going to assume that the user is building queries that orient themselves around the database time.

Simulating an SQL IN clause with ADF ViewCriteria API

So again and again I find myself doing the use case of finding a bunch of rows given only a list of Ids. A possible SQL construct that fulfills this need is something like the IN clause which goes like "Where columnX IN  (id1, id2, id3, ... idn )". If you have been doing ADF you know there is no "IN" operator. Googling around might get you to a solution where people are manually just putting the "where IN clause" simply as a string. Of course if you do this, the onus of avoiding an sql injection attack but this method is on you.

Programmtically Creating a Shared AM Instance

ams

This one is a simple tip. If you don't want to add or declaratively deal with creating a shared AM instance and it's usuages in the different declarative file, you can quite simply programmatically create your shared AM. This few liners does the job of finding or creating a shared AM instance and than getting a VO for you. You can also adapt the code to get a session scoped shared AM.

 

Debugging Change Query Notification/Database Change Notification feature in ADF for Shared AM VO's (AutoRefresh Property)

Database change notification image

If you haven't worked on this area than the following information might be a little less known to you. I had to debug an issue in this area and I am summarizing the learnings about this feature here.

Pages

Subscribe to RSS - ADF