A Primer on Spring's Data Access Object (DAO) Framework

A Primer on Spring's Data Access Object (DAO) Framework by Dhrubojyoti Kayal -- This article introduces the Spring Data Access Object (DAO) framework. After examining the architectural needs for DAO, it describes the DAO pattern in general and how Spring simplifies the implementation.

Source: Dev2Dev

Java - Sorting Algorithms

The animations on this URL illustrate a number of different sequential and parallel sorting algorithms. The relative execution times of the animations give a very rough idea of the relative speeds of the algorithms. Each algorithm is finished when its colored lines disappear.

To see animation, you need Java Runtime Enviroment.

How Oracle Hash Join works?

Hash Join is one of join used by Oracle server when we joine multiple table. Following link will give you a demo on Flash. This demo explains how Hash Join works in Oracle.
This demo was created by TomKyte from Oracle. I got this link from AskTom.

http://tinyurl.com/l2qsh

Alternatively, if you want "offline viewing" of this, you can download a .exe
file (about 1.8mb) that lets you play this whenever you want:

http://tinyurl.com/nyjro

Nagios

Nagios is a host and service monitor designed to inform you of network problems before your clients, end-users or managers do. It has been designed to run under the Linux operating system, but works fine under most *NIX variants as well. The monitoring daemon runs intermittent checks on hosts and services you specify using external "plugins" which return status information to Nagios. When problems are encountered, the daemon can send notifications out to administrative contacts in a variety of different ways (email, instant message, SMS, etc.). Current status information, historical logs, and reports can all be accessed via a web browser.

Nagios is licensed under the terms of the GNU General Public License Version 2 as published by the Free Software Foundation. This gives you legal permission to copy, distribute and/or modify Nagios under certain conditions. Read the 'LICENSE' file in the Nagios distribution or read the online version of the license for more details. Nagios is provided AS IS with NO WARRANTY OF ANY KIND, INCLUDING THE WARRANTY OF DESIGN, MERCHANTABILITY, AND FITNESS FOR A PARTICULAR PURPOSE.

VPN Solution - Hamachi , OpenVPN

Hamachi is a great program that enables you to easily set up an encrypted private network between remote computers over the open internet. It's a simple elegant solution without much fuss. It does have some limitations, but it's definitely an easy and secure way to access your shared folders, enable remote network gaming, and control your machines via Remote Desktop or VNC type programs.

Nice tutorial, how to setup Hamachi is available here.

OpenVPN is a full-featured SSL VPN which implements OSI layer 2 or 3 secure network extension using the industry standard SSL/TLS protocol, supports flexible client authentication methods based on certificates, smart cards, and/or username/password credentials, and allows user or group-specific access control policies using firewall rules applied to the VPN virtual interface. OpenVPN is not a web application proxy and does not operate through a web browser.

Oracle Tip - SQL Order by clause with CASE

How to use CASE in ORDER BY clause of SELECT statement in Oracle SQL.
Order By clause allow you display data in ASCENDING or DESCENDING.

Using Order By clause we can able to arrange data in ASCENDING or DESCENDING based on columns. If it is VARCHAR2 column for ASCENDIGN and DESCENDING data will be sorted by Alphabetical. What if we want to sort CUSTOM Sort, not Alphabetically ascending or descending.

For example, take the following SQL. We can display CITY column either in Alphabetically ASC or DESC.

SQL with ORDER BY CITY ASC:
===========================

select city from (
select
'San Francisco' a from dual
union all
Select 'Boston' a from dual
union all
Select 'Charlotte' a from dual
union all
Select 'Phoenix' a from dual
union all
Select 'Houston' a from dual
union all
Select 'Washington DC' a from dual)
order by city ASC

Now let us see how we can do Custom Sorting using CASE clause in ORDER BY Clause.
We want to get list of city in the follwoing order, then we will use the following SQL.

CITY
=====
Charlotte
Boston
Phoenix
Washington DC
Houston
San Francisco


SQL with CUSTOM Sorting.
========================

select city from (
select
'San Francisco' a from dual
union all
Select 'Boston' a from dual
union all
Select 'Charlotte' a from dual
union all
Select 'Phoenix' a from dual
union all
Select 'Houston' a from dual
union all
Select 'Washington DC' a from dual)
order by CASE a when 'Charlotte' then 1
when 'Boston' then 2
when 'Phoenix' then 3
when 'Washington DC' then 4
when 'Houston' then 5
end;


Please note that in CASE clause, I never mentioned about 'San Francisco' city. But the SQL will bring 'San Francisco' as last city in the record set.

This may be required sometimes, we want to display in DropDown List box in frontend applications.

Oracle - Jonathan Lewis blog

Jonathan Lewis started blogging since last week. I need to track his blog every day.

Nice blog for Oracle tips

Sample build.xml for Tomcat & JBoss

I have spend lot of time to figure out sample build.xml sample files to deploy Struts Application as WebApplication to Tomcat server. Finally I found out from Developer Apple website.

Here is link for Tomcat Struts build.xml as WAR file.

Another link for build.xml to deploy Struts application to JBoss server as EAR file.

Using Oracle's recycle bin - Oracle 10G feature

In OraFaq, Using Oracle's recycle bin was posted by Natalka Roshak. This article gives very nice examples to demonstrate this feature in simple manner.

Natalka Roshak scripts and tips can be found in her online DBA toolkit at http://toolkit.rdbms-insight.com/.

what is VTD-XML

Simplify XML processing with VTD-XML
A new option that overcomes the problems of DOM and SAX

Cut, paste, split, and assemble XML documents with VTD-XML
VTD-XML eliminates the performance overhead associated with updating XML

Neat Java initializer trick by Andres Almiray

Andres Almiray's blog have Neat Java initializer trick to Initialize and Define Java List,Map and Set.

Introduction to Oracle Instant Portal

Check the nice demo about Oracle Instant Portal.

Stripes, Spring and Hibernate Tutorial

Roel Vanderpaal posted nice tutorial in hib blog, which implements Stripes, Spring and Hibernate. Source code also avaialble.

Useful links to read

I was check web and collected couple of links, which I am interested to read. Once I collected realised that I have run for work. Compiled and posted into blog as link.
That way, I can read it later.

Changing the order of columns in a JSF Table Component -in the client, at run-time, by the end user by Lucas Jellema

Testing Knowledge of Database Performance - Is this a good Execution Plan? by Lucas Jellema

On Oracle OTN Shay Shmeltzer has written an article that explains how to use the Spring framework within JDeveloper and how to best setup JDeveloper for Spring 2.0. Interface21 has announced that the final release of Spring 2.0 is planned onSeptember 26th, 2006.

http://www.oracle.com/technology/products/jdev/howtos/1013/SpringwithJDev/in

Sun's Developer Network has posted "U.S. Daylight Saving Time Changes in 2007," detailing the changes in the start and end dates of daylight savings. This affects the JVM because it compensates for DST in various countries and older JVMs' information about DST is incorrect. Read More from TSS.


How to Create a secure login page with Java by Ramesh Nagappan


Hibernate 3.1 used with Tomcat 5.5.x By Bill Treuman and Igor Dayen


Oracle JHeadstart 10g for ADF

Orablogs


DevX: Comparison of EJB 3.0 and Spring, Part II

Spring Interface21 Blogs

Introduction to Spring 2.0 and JPA

Introduction to Spring 2 and JPA, a developerWorks tutorial by Sing Li, shows's how to create web-based server applications from scratch using Spring 2.0. The persistence technology used is JPA.

Spring 2.0, Struts in Oracle JDeveloper tutorial

Getting Started With Spring 2.0 in Oracle JDeveloper is a well illustrated OTN article by Shay Shmeltzer which shows how to set up JDeveloper to use the Spring framework, and then highlight some of the functionality in JDeveloper that can make your development experience with Spring more productive.

Basic Spring Interaction with WebLogic Portal 8.1

Basic Spring Interaction with WebLogic Portal by Mark Meyer and Don Davis -- This tutorial uses a demonstration application to show how BEA WebLogic Portal 8.1 and the Spring framework can be used together to give developers powerful techniques for delivering flexible applications.

Migrating to Spring 2.01

Matt Raible posted nice blog entry about Migrating to Spring 2.01

Nice OracleApps Links

I was looking for nice links and Blog for Oracle Applications, then compile here.

OracleAppsBlog
Oracle Workflow Frequently Asked Questions (FAQ)
Oracle AppCasts - Podcasts on Oracle Application

What is JCom?

JCom is a bridge library between Java and Com to enable COM object access from Java classes. Example: Creating an Excel worksheet, or using Visual Basic COM application from a Java application.

It is a opensoure tool.