Category Archives: Dong Shin

Dong Shin 10.21.2014

deployed new FA – fixed PM Actuals, broken Appropriation Years in the Financial Data Editor…
fixed Appropriation Years in Financial Data Editor
fixed PM Actuals % sorting
generated database documents – Google Drive/Builds/project_portfolio_enh_doc/

deployed the new Post Processing queries for updating 3rd year obligations/outlays
3rd year for RDT&E not showing in the Financial Data Editor, but was shown previously…
downloading and setting up Eclipse Luna, Keplar is out of date already.

fixed Drag and Drop not scrolling thru as Flex doesn’t support auto scrolling – had to add autoScroll method on dragOverHandler
query folders can now be published/unbublished

few issues on-site
- folders in Query Builder keeps adding itself when drop happend – fixed
- datagrid filtering with columns not working – fixed
- Lenny wants to get all related contracts data in separate rows….

finally got Spring Security example to work!
- configure Tomcat DataSource JNDI! – server.xml and context.xml
- modifying to work with project_portfolio_enh database….
adding session control
- http://blog.trifork.com/2014/02/28/session-timeout-and-concurrent-session-control-with-spring-security-and-spring-mvc/
Lenny reported some problems – both fixed!!
- RA doesn’t show FY15 data…. RA show currently due data only, may have to fix by showing future years
- add PO Reference to the new query builder

looks like Spring JDBC template can simplify lots of codes –
- http://www.journaldev.com/2593/spring-jdbc-and-jdbctemplate-crud-with-datasource-example-tutorial
Spring Security
- http://www.journaldev.com/2715/spring-security-in-servlet-web-application-using-dao-jdbc-in-memory-authentication
- http://javahash.com/spring-security-hello-world-example/
- http://www.journaldev.com/2736/spring-mvc-security-example-using-in-memory-userdetailsservice-and-jdbc-authentication
- trying to get SpringMVCSecurity example working….
working on integrating Spring JDBC to UserService
- had to set the dataSource property for controller, not service like the example!!!!!
- mixing version number don’t play well., ie. spring 4.0.0 with spring-jdbc 4.0.2 generates weird exceptions…
many examples I have found use Maven – manually download artifacts – http://search.maven.org

working on getting POST to work with Java/Spring
- http://www.journaldev.com/2552/spring-restful-web-service-example-with-json-jackson-and-client-program
- got it to work in TaskManagerApp
  - @RequestMapping(value = “/tasks/create”, method = RequestMethod.POST, headers = {“Content-type=application/json”})
    public @ResponseBody Task createTask(@RequestBody Task task) { }
useful Chrome plugin – Postman – REST Client
- https://chrome.google.com/webstore/detail/postman-rest-client/fdmmgilgnpjigdojojpjoooidkmcomcm?hl=en
- very simple to use!!! tested POST service in TaskManagerApp
looking at Spring Security User Session Management

got SpringServiceJsonSample to generate JSON objects with a nested list, one to many relationship
Generating Java POJOs for project_portfolio_enh database
- http://www.javacodegeeks.com/2013/10/step-by-step-auto-code-generation-for-pojo-domain-java-classes-and-hbm-using-eclipse-hibernate-plugin.html

reworked Save Query to be simpler
- removed queries datagrid
- modified the form
more AngularJS!

managed to blow up the flex workspace again! almost lost all recent code changes.
working on Query Mgmt
- drop cannot be received on closed parent item and empty parent doesn’t open up on click! manually open up the empty folders…
- ALTER TABLE `qb_queries` CHANGE `query` `query` TEXT NULL DEFAULT NULL;
- got drag and drop to work
- got save / delete to work
- done!

went over the queries with Lenny
working on Query Mgmt…
- separated Query DG to a component – QueryMgmtPanel
- added folder_name to qb_queries table