Thursday, December 22, 2011

Design Patterns in java - part 2

Session Facade vs Business Delegate - both do the same function of hiding the implementation details from the caller object. But the main difference is Session Facade must be an EJB object and it will reside on the server side( you can put the transaction limitations on the session facade). On the other hand the Business Delegate can be anything that doesn't involve EJBs and transaction boundaries; eg, a business delegate that accepts input from the web layer(JSF/JSP beans ) and forwards it to Service.

Tuesday, December 6, 2011

Using Data source Explorer in Eclipse

All java developers would mostly be using some IDE based on Eclipse for their day to day coding activities. Nearly 50% of these developer would have to work with backend databases like Oracle or DB2 using tools like Oracle SQL Developer, TOAD(Tool for Oracle App Development), DB Visualizer or Squirrel. If you are into JEE development, you may have to get software installation requests or special admin rights from your company's network administration to install the additional softwares like SQl Developer or DB Visualizer. If you are looking for a shortcut or workaround for this scenario, this posting is for you. Another USP is the comfort to access the database tables directly from your Java IDE(Eclipse/RAD/WASD/JBoss App Dev Studio or any major IDE based on Eclipse).

All the latest releases of IDEs(mentioned previously) come with an option called Data Source Explorer which can be navigated via Window-> Show View -> Data Management -> Data source Explorer. If you are in Jave EE perspective you should be able to see it as a tab next to console or problems tab at the bottom of the Eclipse. You can connect to the database tables by creating a DB connection. You would have to select the appropriate DB and JDBC driver details from the dialog box and then enter the connection string details (authentication and sever IP/port details and service name)

P.S: If you are using Oracle RAC as the backend DB, then instead of selecting Oracle Thin Driver, just select "Other Driver" option and enter the connection string detail