Friday, June 29, 2012

My Pentaho experience

I was playing with pentaho over the weekend and must say I am impressed with what I have seen.

The report designer is now very functional. I am going to have to play with it a bit more to be understand what can be done fully but producing a report with parameters is really easy once you get a hang of the tool.
(I click on the query you want to modify and modify the sql instead of using the edit button)

I replaced the pentaho security implementation with my own implementation and was surprised to find out how easy the spring security implementation was (one thing I wrote my own GrantedAuthority implementation which was a bad idea the default one org.springframework.security.GrantedAuthorityImpl works well and includes an equals, hashcode and compareto which mine did not and didnt work and implementation) 

Monday, June 11, 2012

ADF: Testing iterator settings Pojo Data Controls

Jdev 11.1.1.5


I was doing some investigation into the inner workings and some of the more useful properties on the iterator bindings in the page definition xml files to to satisfy my curiosity.

So here are some findings I have to go into much more details than this but this should help someone.

I had a basic page with one iterator (driving a select one choice) two buttons one with an action one with an action listener and a child iterator driving a table.

I use any number of Refresh parameters on my page (always, deferred, ifNeeded) etc and the method bound was only called once on pressing any button or autoSubmit - all good.

I the set the CacheResults parameter to false this lead to my method being called a number of times and some weird but expected behaviour still good.

Now I changed to a methodIterator from a accessorIterator with one parameter and returned null from the data control. The method was now called a number of times with a null parameter not good. I changed the return null to return an empty list and everything started working as expected.

Need to still check immediate, partialSubmit, changeEventPolicy and a few other attributes but this answered some of my questions.

Eclipse maven problems m2e


Project configuration is not up-to-date with pom.xml
Right click project, select Maven, click Update Project configuration

Plugin execution not covered by lifecycle configuration
Click on the error nice red error (in the pom.xml Overview tab)
Select the permanently mark goal as ignore, click ok

Sorted

Derby, glassfish startup scripts


Startup script for my glassfish:
call asadmin start-database --dbhost 0.0.0.0 --dbport 1527
call asadmin start-domain domain1

Stop script for my glassfish

call asadmin stop-database
call asadmin stop-domain domain1

Derby current time in sql
CURRENT_TIMESTAMP