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.

 

ORA-24247 ACL error in Oracle 12c

So the debugger was not connecting to debug a PLSQL procedure one day. I knew I had debugged this on Oracle 11g, so it had to work as well on 12c. But the debugger was not connecting and complaining something like below:

 Connecting to the database MYDB_12c.
Executing PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUE
Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP('X.X.X.X', '57908')
ORA-24247: network access denied by access control list (ACL)
ORA-06512: at "SYS.DBMS_DEBUG_JDWP", line 68
ORA-06512: at line 1
Process exited.
Disconnecting from the database MYDB_12c.

 

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.

Deactivating Statistics, Counter and Leaflets Modules

Leaflet Module

So with Boost running, it made no sense really to have the Counter module, since it was always a snapshot view of the counter at some point in time when the page was first generated by boost. Similarly the leaflet module does not make sense. I have a feeling with Boost it is also not doing its job. Hence time to slim down my drupal install. This means I really also don't need the statistics module. Google analytics and Apache logs should be good enough for all purposes. Then the webalizer running already on the logs makes for good enough reports.

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

Importing Sample Maven projects in Eclipse for the book OReilly's Enterprise JavaBeans 3.1

So while reading this book, I though I might as well get the source code and look and run it in an IDE instead of just glance at it in the book. So turned my attention to section V, examples and proceeded to the anonymous git cloning instruction and building as below :

Oracle SQL : Matching Prefix and Suffix string but only accepting whats in between

regex replace

A while ago I wrote an article about regex lookahead and lookbehind here. I needed the same thing now in SQL, specifically Oracle flavor. Turns out that Oracle supports the POSIX BRE syntax and POSIX ERE syntax plus PERL influenced extensions, but no look ahead look behind equivalent regex syntax.

So the problem we have to solve is the same. I have a String that is ";" seperated key value pairs that might look like below:

Pages

Subscribe to Ahsan's Corner RSS