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.

Replacing line feeds with HTML breaks using JSTL

E-Surfer's blog posted nice Tech tip for replacing line feeds with HTML breaks using JSTL.

Java 5 StringValuedEnumUserType in Hibernate

Following entry in Hibernate will explain how,Hibernate 3 Parameterized type for mapping a Java 5 Enum with string values.

This allows you to avoid the need to define a concrete UserType instance for every enum that you have. Just create a new typedef for each one, giving it a unique type name. Then reference this type name in the property tag.

Side-by-Side Comparison of Spring and EJB 3.0

DEVX posted a Make the Right Decision with Our Side-by-Side Comparison of Spring and EJB 3.0
Are you trying to choose between Spring and EJB 3.0? If you are you know what a hard decision it can be. Explore the similarities and differences between two of the most popular Java technologies today and learn key distinctions in making a technological decision between the two.

by Rod Coffin

Where Are Your Log4j Log Files?

An Army of Solipsists blog talks about Location for Log4j properties file in the project.