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.

REST - Representational State Transfer

Nice introduction article for REST By Rich Seeley

RESTLET is Lightweight REST framework for Java

Noelios Blog for Restlet project.

REST from Fielding Dissertation

Manohar Viswanathan posted nice demo application on his blog for Restful Webservices on Java,Spring with Tomcat.

Retroweaver supports most Java 1.5 features while running on Java 1.4. Open Source tool.

FreeMarker is a "template engine"; a generic tool to generate text output (anything from HTML to autogenerated source code) based on templates. It's a Java package, a class library for Java programmers. It's not an application for end-users in itself, but something that programmers can embed into their products.

Introduction to Spring 2 and JPA - IBM DeveloperWorks

Java™ server applications need not be difficult and tedious to create. Now in its second generation, the lightweight Spring framework adds a large suite of features that make it simple for even new server application developers to use. One key enhancement is Spring 2's integration with the Java Persistence API (JPA), a cornerstone of the Enterprise JavaBeans (EJB) 3.0 specification. In this tutorial, learn how to create server applications from scratch using the Spring 2 framework.

Read More

Working with Subselect in Hibernate

Working with many tables in the same PRESTO listing Problem Definition (This is taken from an internal framework that uses Hibernate extensively.) By default Presto works with single........
Read More

Oracle9i Archive Daily Features and Reqular expressions in Oracle database

Oracle9i daily feature from Archive, I found following nice features in Oracle9i.

Index Skip Scans
External Tables
MERGE Statement

You can read more Oracle 9i daily feature from this Archive.

Writing Better SQL Using Regular Expressions By Alice Rischert.

Oracle Releases Developer Preview of Oracle SOA Suite

Oracle has released a developer preview of its Oracle SOA suite available for download from OTN.

Oracle SOA Suite is a complete set of service infrastructure components for creating, deploying, and managing services.
It includes:

* Integrated Service Environment (ISE) to develop services - Based on JDeveloper, with new BPEL and ESB designers as well as visual XSLT mapping
* Oracle BPEL Process Manager to orchestrate services into business processes
* ESB to connect existing IT systems and business partners as a set of services
* Oracle Business Rules for dynamic decisions at runtime that can be managed by business users or business analysts
* Oracle Business Activity Monitoring to monitor services and disparate events and provide real-time visibility into the state of the enterprise, business processes, people, and systems.
* Oracle Web Services Manager to secure and manage authentication, authorization, and encryption policies on services that is separate from your service logic

Declared Unchecked Exception: The Best of Both Worlds

Hacking Architect posted this blog entry, which is very nice about Checked and Unchecked Exception in Java.

Since I started wearing the hat of a software architect, I started tutoring my teams on how to do this and that things in programming. One of first thing I taught my team is the difference between a checked exception and an unchecked exception, also known as RuntimeException. Read More.

Using Generics to Simplify Hibernate/Spring DAO's

Burt Beckwith in his blog, wrote an article in detail how to use Generics (Java 5.0 feature) with Hibernate and Spring. It is very nice article.

Building Custom Java Server Face UI Components

One of the key strengths of JavaServer Faces (JSF) is that not only does it provide substantial technology for easy, out of the box component based J2EE Web applications assembly, but it also is a very flexible API which allows for a wide breadth of customizations in numerous and innovative ways. This article, by Chris Schalk in TSS, introduces and explores the component developer's experience of building custom JSF user interface (UI) components.

MyFirstJSF application tutorial

I was looking for JSF tutorials to kickstart. Found couple of nice tutorials.

JSF KickStart (Create First simple JSF Application with Hello User) - best for starting for beginner.

Want to know more about JSF Navigation by Examples

JsfTutorial.net is another nice resource.

CoreServlet's Jsf Tutorial also good.

Free Text Editors for programmers

I am using Textpad as my default editor. It is very nice and simple.
Supports to compile Java files and other program files, provides we need to have compiler installed on our systems.

EditPlus, which I found out from one of my collegue. It is very nice and have lot of features. It highlights many programming codes.

It also have built-in browser to test our html,css and javascript.

Restricting Access to your AJAX Services

Greg Murray 's blog talk about XmlHttpProxy client.

Services like the XmlHttpProxy for Java are designed to return JavaScript that is evaluated on the client. Unfortunately, if you are not careful with the design of your services, JSONP techniques could be used to hijack your services. Read More from Greg Murray's blog.

The XmlHttpProxy Client for Java

Greg Murray 's blog talk about XmlHttpProxy client.

One drawback of working with AJAX is that an AJAX-based client cannot make calls to URLs outside of its domain, which means that it cannot access services located on another server. Read More from Greg Murray's blog.

OpenSource Ajax for JSF

I was looking for OpenSource JSF framework to try in one of my home project.

Found that Ajax4jsf has nice features and it is OpenSource right now.

Java Mustang and Webservices sample code.

Danny Coward posted nice sample code to define WebServices on Java6(Mustang).

Check his weblog entry.

SCJP5 Resources and Tutorials

Are you preparing for SCJP5, check the following link for nice tutorials.

SCJP5 Tutorials by Exforsys

I become now regluar reader of Hoskinator blog. His blog has nice resource link for SCJP5.

Hoskinator SCJP5 Resources

SCJP 5 - Constructor revision sheet from Hoskinator blog.

Java Tutorials by Sun

Sun provides tutorials for JSE, JEE and Webservices.

Sun Tutorial Home Page

Java6 - Beta 2 features

Version 6 of the Java Platform, Standard Edition (Java SE), code-named Mustang, is currently in its second beta release – which is right on track for moving along to its Fall general release. So here are the top 10 things you need to know about Mustang, if you're still hovering hesitantly over that Beta 2 Download Page link.

Click - Another Web Tier Framework

Click is a simple J2EE web application framework for commercial Java developers.

Click is an open source project, licensed using the Apache license.

Click uses the event based programming model for processing Servlet requests and Velocity for rendering the response.

Click is JSP and MVC Free

Introduction to StAX

Processing XML documents has become a critical and integral part of most applications being developed today. Depending on different environments, there are various ways to process an XML document within a program.

Read more about StAX in this link.

Java - Thread Local

Use a thread local variable (where each thread has a separate value) when you want to carry a value along without explicitly passing it from method to method down the call stack, and when appropriate, remember to explicitly clear the value in a finally block to prevent memory leaks:

CrazyBob.org has detail article about this.

Mashup

Alexis Moussine-Pouchkine's Weblog,he explains how his Mashup implementation uses Java Persistence, NetBeans, and Java Studio Creator to query the, REST-based, GeoEncoding Web Service.

Part 1
Part 2

JUnit with Spring and database transaction

Manohar Viswanathan's blog explains how to do Better JUnit-ing for Spring, Junit with database transactions.

An Introduction to Java Persistence for Client-Side Developers

This link
gives nice introduction to Java Persistence for Cleint-Side Developers.

Pro EJB 3.0 Java Persistence API - Sample Chapter

The followig sample chapter posted in OTN. This gives nice introduction for EJB 3.0 JPA API programming using TopLink Essentials.

Java5 Free sample chapters to read

Once again from Hoskinator blog, here is the list of books for Java5.

Questions and Solutions using Generics, foreach and Enumerations


Generics Sample Chapter pdf


Hardcore Java - The Final Story
---This link will talk about final keyword of Java.

Thanks Hoskinator !!!!!

I am regular visitor Hoskinator blog....

What is TestDriven?

I was reading Hoskinator blog, found two blog entries in the following topics.

Test Driven Development and ObjectiveView magazine
Learning to love Junit and Test-driven development

I know about ObjectiveView online Free magazine.

Checking what is TestDriven? Some excerpt from TestDriven website.

TDD is a lightweight programming methodology that emphasizes fast, incremental development and especially writing tests before writing code. Ideally these follow one another in cycles measured in minutes.

Functionality is added in very small chunks. Typically the first cycle will deal with utterly simple cases: you test what happens when you are out of stock, when the quantity ordered is zero, when the list is empty, when a string has no characters in it, when the user just hits [Enter]. Once you have these very simple tests working, you add more functionality, a bit at a time.

Need to learn more about this.............

Free Hibernate sample chapters

Blog by Hoskinator named A Funny Java Flavoured Look at the World have the list of links for Free Hibernate sample chapters.

Sematic Web

I was googling for details about codePointAt method of String class from Java. Saw a word SWOOP and it is a browser. Googled SWOOP and found that SWOOP is Hypermedia-based OWL Ontology Browser and Editor.

What is Ontology?
The branch of metaphysics that deals with the nature of being.

Further tried to find information about this browser, the new word pop-up. SEMATIC WEB.

What is Sematic Web?
The Semantic Web provides a common framework that allows data to be shared and reused across application, enterprise, and community boundaries. It is a collaborative effort led by W3C with participation from a large number of researchers and industrial partners. It is based on the Resource Description Framework (RDF).

Read further details about Sematic Web from W3C.

Also found a nice presentation about Introuction to Sematic Web using Google.

Want to know Sematic Web read this presentation.

SQL Developer Extensions and Eclipse

Recently, I read about SQL Developer extensions for Eclipse from Kris Rice's weblog.
I am giving the contents of his blog posting. I would like to post the contents, rather than giving link. The reason is the link may break and we may loss this information.

Thanks to Kris Rice.

Want to write an extension to SQL Developer but you only use Eclipse? There's a post on the forum about how to use Eclipse to write an extension to sql developer so I figured I'd put it here so it's not lost into the of the forum.

This is actually quite easy to setup. This can be checked by running the shell script with a -x, so bash -x sqldeveloper. This will show what is being executed

First make a run/debug configuration.


1. Main Tab
* Main Class: oracle.ideimpl.Main
* Check the Include libraries when searching for a main class checkbox

2. Arguments Tab
* The paths in the VM arguments should be adjusted to your specifics. Also if there is a space in the paths they will have to quoted like "C:\Document and Settings\sqldeveloper...."

* VM Arguments: -Dide.product=oracle.sqldeveloper -Dide.splash.screen=raptor-splash.gif -Xverify:none -Xmx512M -XX:MaxPermSize=128M -Dice.browser.forcegc=false -Dice.pilots.html4.tileOptThreshold=0 -DEDITOR_J2SE_VERSION=1.5 -DINSIGHT_OMIT_HIDDEN=true -Doracle.xdkjava.compatibility.version=9.0.4 -Dide.debug.controller.stack=false -Dceditor.java.parse.small=300 -Dceditor.java.parse.large=1500 -Dide.extension.cpmissing.nowarn=true -Dcompiler.vmargs=-mx512m -Djbo.debugoutput=silent -Djbo.showdebugwarningbanner=false -Dide.config_pathname=/home/klrice/sqldeveloper/jdev/bin/sqldeveloper.conf -Dide.startingcwd=/home/klrice/sqldeveloper/jdev/bin -Dide.user.dir=/tmp
* Working directory: choose Other . Then enter the path to /jdev/bin

3. Classpath Tab
* Add the following ( all paths are relative to )
* /ide/lib/ide.jar
* /ide/lib/javatools.jar
* /ide/lib/xmlparserv2.jar
* /ide/lib/help4.jar
* /ide/lib/share.jar
* /ide/lib/javax-ide.jar


Now the run configuration is setup and ready to use. You should now be able to run and debug an extension.

Posted by kris.rice at May 3, 2006 03:40 PM

What is mod_plsql?

mod_plsql is an oracle module for Apache.It is essentially an apache module that provides direct access to stored procuders via HTTP requests.

Roland Bouman in his blog gives nice introduction to mod_plsql and how to enable this feature in OracleXE(free oracle database).

Laurent Schneider in his blog gives simple example for mod_plsql.

Remote Debugging with SQL Developer

Oracle free tool SQL Developer got nice feature. Sue Harper from Oracle in her blog gave very detail tutorial, how to do remote debugging with stored proecedures,funtion and packages using SQL Developer.

You need SQL Developer and Oracle XE.
To download click the links:
SQL Developer
OracleXE

Making the Most of Oracle SQL Developer Reports - OTN

Oracle SQL Developer (formerly Project Raptor) is Oracle’s new multiplatform graphical user interface (GUI) for developers and DBAs. Like Oracle Database 10g Express Edition (XE) and Oracle JDeveloper, Oracle SQL Developer can be downloaded completely free. Oracle SQL Developer runs on the Windows, Macintosh, and Linux platforms.

Make the best use of the reporting capabilities in Oracle's free database development tool
by
Lewis R. Cunningham

Websphere Tutorials and Articles

This devx.com link have compiled all nice links for Websphere tutorials and articles.

Want to program in IBM Rational Applicaton Developer V6, refer this Redbook.

Spring 2.0 AOP - Spruce Up Your Domain Model

Debasish Ghosh on his blog talks about Spring 2.0 AOP - Spruce Up Your Domain Model

Websphere Portal resources

Guides:
Portlet Development Guide: Second Edition

Portlet Development Best Practices and Coding Guidelines


Articles

Developing and Deploying a Struts Application as a WebSphere Portal V5 Portlet

Applying the State Pattern to WebSphere Portal V5 Portlets: Part 1

Applying the State Pattern to WebSphere Portal V5 Portlets: Part 2

Simflet - simple MVC framework for JSR-168 portlet

Simflet is a simple MVC framework for JSR-168 portlet.

Simflet is an open source simple framework for portlet development. The reason it's been written? Because there is no proper MVC model in the Portlet API. As a result, portlet development is like servlet development: complex applications aren't easy, because of the infrastructure issues.

It has following features and more.

Struts like MVC model

Simple, easy to use

No additional configuration is required

Portlet development with Simflet framework can be deploy in any JSR-168 compliant portal

Easy file upload handling

Light - OpenSource Portal framework

Light is an AJAX- and Java-driven portal framework. One of its unique features is that it can be turned on when users need to access their personalized portal and turned off when users want to do regular business processes.

List of OpenSource Portal frameworks available here.

How to put file per server in Weblogic Cluster

Let say you want to put file(either property or standard) per server on WebLogic Cluster.

In simple term, you want to write file to each server, when WebLogic server runs on cluster.

You can get thesse information in your code:
T3Services.getT3Services().config().getProperty("weblogic.system.home");
T3Services.getT3Services().config().getProperty("weblogic.system.name");
T3Services.getT3Services().config().getProperty("weblogic.cluster.name");
T3Services.getT3Services().config().getProperty("weblogic.home");

Now using above details we can write file as below.

T3Services.getT3Services().config().getProperty("weblogic.system.home") +
File.seperator +
T3Services.getT3Services().config().getProperty("weblogic.cluster.name") +
File.seperator +
T3Services.getT3Services().config().getProperty("weblogic.system.name") +
"mysoftware.properties";

Google Map Taglibs

I just found out about the GoogleMaps JSP Taglibrary. It can be as easy as this, but also allows a lot of other usages.

<googlemaps:map id="map" width="250" height="300" version="2" type="STREET" zoom="12">

<googlemaps:key domain="localhost" key="xxxx"/>

<googlemaps:point id="point1" address="74 Connors Lane" city="Elkton" state="MD" zipcode="21921" country="US"/>

<googlemaps:marker id="marker1" point="point1"/>

</googlemaps:map>


Great stuff!

Spring PropertyPlaceholderConfigurer

I found two blog entries for Spring PropertyPlaceholderConfigurer class. It is very informative.

Spring PropertyPlaceholderConfigurer by techno.blog("Dion")

Externalizing Configuration with Spring by Stefan Kleineikenscheidt

Sending E-Mail with Spring

This TheServerSide artcile by Matt Raible gives small tutorial, how to send email using Spring and Velocity.

what is singleton?

A singleton class is one in which instantiation is restricted to ensure that only one instance is created for the current Java Virtual Machine. Singletons usually have a private default constructor, to prevent direct instantiation, and a static method to obtain a "new" reference to the single instance. On its first call, the static instance method creates the object using a private constructor and stores a static reference to it for all subsequent calls.

This is useful when exactly one object is needed to coordinate actions across the system. Sometimes it is generalized to systems that operate more efficiently when only one or a few objects exist.

Singleton Example:
//For Single Thread safe
public class Singleton {
// Private constructor suppresses generation of a (public) default constructor
private Singleton() {}
private static class SingletonHolder {
private static Singleton instance = new Singleton();
}
public static Singleton getInstance() {
return SingletonHolder.instance;
}
}

// Correct multithreaded version for J2SE 1.4 and earlier
public class Singleton {
private Helper helper = null;
public synchronized Helper getHelper() {
if (helper == null)
helper = new Helper();
return helper;
}
// other functions and members...
}

What happens to singletons when two JVMs are running?

A: There is only one instance of a true singleton in a single virtual machine. If two virtual machines are running, two separate and independent instances of a singleton exist. If the singleton in question is governing access to the same system resource, there may be conflicts between the two systems, which is why the singleton design pattern is not ideal in this scenario.

For more details on J2EE Patterns by Sun

How SpringFrameWork works?

SpringFramework works on the principle of Inversion Control.

What is Inversion Control?
Inversion Control, also known as IOC, is an important object-oriented programming principle that can be used to reduce coupling inherent in computer programs.

Read more about Inversion Control from Wikipedia.

A simple demo of Inversion of Control (using Spring framework)available.

XSLT Processing with Java

This article from Onjava, explains using Java how XSLT works and has working sample aso.

Spring Framework MVC application step-by-step and Resources

To learn Spring MVC, please visit series of articles which define step by step instruction to create Spring MVC.

The link will take to Part1. Follow the Part2, Part3 and Part4 also.

Visit SpringHub for more resources on Spring.

Developer.com has very nice article for How To Develop J2EE Applications Using Hibernate Annotations and Spring MVC

WebServices - IBM Education Assistant

IBM Education Assistant provides nice tutorial about WebServices and Webservices with IBM® WebSphere® Application Server, V6.0 and V6.0.1

Recommended Eclipse reading list

IBM developer works journal posted Recommended reading list for Eclipse.

This list is compiled from a variety of sources and is intended for anyone who wishes to find centralized reading material about Eclipse. One of the biggest challenges new Eclipse users face is where to find the right information for a task. This article provides a small step in solving that problem.

Enabling Data Exchange in Ajax Applications - OTN Article

Learn how to transfer data between Ajax clients and Java servers with XML and JavaScript Object Notation. This article by Andrei Cioroianu. Article available in OTN.

Cayenne

This article presents Cayenne - a fast, scalable and easy-to-learn open source Object Relational Mapping (ORM) framework. Cayenne is a rare kind of a Java open source project. It is not just an "edit your own XML" runtime library, but an integrated suite that includes modeling and deployment tools. This article shows how to quickly create an ORM application with Cayenne and discusses its core features and design principles. For detailed information on Cayenne visit http://objectstyle.org/cayenne/.

Other Object Relational Mapping frameworks are
Hibernate
IBATES by Apache
DALI by Eclipse

Ajax Tutorials

Here is list of links for Ajax simple to Complex Tutorials

A List Apart is pleased to present the following excerpt from Chapter 27 of Web Design in a Nutshell (O’Reilly Media, Inc., third edition, February 21, 2006). —Ed.

60 More AJAX Tutorials

Apache Tuscany M1 released

TheServerSide.com reports Apache Tuscany M1 was released. It provides a Java implementation of the Service Component Architecture (SCA) and Service Data Objects (SDO) specifications, and a Data Access Service (DAS) supporting SDO.

Implementing Google AJAX Search

Read this blog to implement Google AJAX search on your site, blog. This blog has step by step instructions.

SCJP 5 - Collections / Generics Resources

I found this very good link to a Generics and Collections tutorial for people studying for their SCJP Java 5 exam. I think Generics and collections can be quite difficult due to the number of tricky facts you have to learn.

SOA Best Practices: The BPEL Cookbook - Oracle OTN

From this article, Learn advanced BPEL concepts and best practices for development, deployment, and administration from the architects implementing them in real-world applications.

Service-Oriented Architecture (SOA) is creating a lot of buzz across the IT industry. Propelled by standards-based technologies like XML, Web Services, and SOAP, SOA is quickly moving from pilot projects to mainstream applications critical to business operations.

Hibernate Articles, Materials and Tutorials

Want to read articles, materials, tutorials and demo applications, please refer following links

Hibernate External articles & tutorials

Demo Applications

Basic Spring Web services with XFire and JSR 181

I was reading a blog of Basic Spring Web services with XFire and JSR 181

There is a reference to JSR 181 (Web Services Metadata for Java Platform) and XFire in above blog.

Look here for an introduction to JSR 181 and where it fits in to the world of Web services.

What is XFire?

Codehaus XFire is a next-generation java SOAP framework. Codehaus XFire makes service oriented development approachable through its easy to use API and support for standards. It is also highly performant since it is built on a low memory StAX based model.

Yet to read completly all the links.

Best 27 Eclipse Tutorials by IBM

The Intelligentedu.com blog has thrown up a great compilation post linking to the top 27 Eclipse-based tutorials from IBM. For anyone wanting to get started with the Eclipse platform, here is a great place to start or at least bookmark!

These tutorials cover every thing from developing RCP applications, to web services, to using TPTP, to developing Eclipse plugins.

Spring 2.0 - Preview

Found out couple blog entries for Spring 2.0 preview.

Spring Components - XML configuration on steroids

Spring 2.0: Hiding Services Behind Custom XML Schema (Part I)

Spring 2.0: Hiding Services Behind Custom XML Schema (Part II)

Spring 2.0 - XML Configuration on more steroids

Read article about Inversion of Control Containers and the Dependency Injection pattern

Nice introduction to The Spring Framework by Benoy Jose.

SysInternals - Freeware

The Sysinternals web site provides you with advanced utilities, technical information, and source code related to Windows internals that you won't find anywhere else. Mark Russinovich and Bryce Cogswell alone write and update everything in this website. This website got nice freeware tools for File&Disk, Security,Networking, Process&Thread and System Information.

SOAPUI - Desktop tool for WebServices

SOAPUI is a desktop application for inspecting, invoking and testing (functional and load) of web services over HTTP. It is mainly aimed at developers/testers providing and/or consuming web services (java, .net, etc). Functional and Load-Testing can be done both interactively in soapui or within a automated build/integration process using the soapui command-line tools. soapui currently requires java 1.5 and is licensed under the LGPL license.

An Introduction to SIP

An Introduction to SIP, Part 2: SIP Servlets by Emmanuel Proulx -- Java is an excellent platform for SIP development. This is especially true for server-side aspects of SIP development. In this article, Emmanuel Proulx describes the SIP Servlet API technology and provides an annotated example of its use.

Dev2Dev - Managed File Transfer Capabilities in the WebLogic Platform

Managed File Transfer Capabilities in the WebLogic Platform by Senthil Kumar Krishnan and Ambarish Nagarajan, Hari Prakash -- Recent regulations are calling for every process to be documented and auditable, including those business processes that incorporate or leverage FTP. This article describes how to build industry-strength file transfer capabilities using WebLogic Workshop and WebLogic Integration 8.1.

Dev2Dev - Java Portlet Tools: Converting Java Web Applications into Adaptive Portlets

Java Portlet Tools: Converting Java Web Applications into Adaptive Portlets by Andrew Lorek -- The AquaLogic User Interaction Java Portlet Tools rewrites HTML so plain Web applications can be used unmodified within a portal. In this article Andrew Lorek introduces the tools and provides examples of configuration and use.

Building an Ajax Memory Tree - from OTN

The following article by Scott Spendolini in OTN gives step by step instruction to Learn how to create an Ajax-based memory tree in Oracle Application Express(formely known as Oracle HTML DB).

What is Reverse Ajax?

Jonathan Downes has written an article called "What is Reverse Ajax?," addressing the definition of this 'new technique' - which is actually a set of older techniques combined under a single name, much like Ajax itself is.

Google releases AJAX development toolkit

At JavaOne2006, Google announced the official release of the Google Web Toolkit (GWT), a Java-based platform for the development of AJAX web applications that work in all mainstream web browsers. Designed to simplify AJAX development, GWT generates consistent, browser-neutral Javascript from simple Java source code.
Nice article about this tool.

Other OpenSource JavaScript Toolkit for Ajax are DOJO, Direct Web Remoting(DWR) and Blackbase

Oracle - SQL Developer

Oracle SQL Developer
Oracle SQL Developer is a new, free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks.

SQL Developer can connect to any Oracle Database version 9.2.0.1 and later and runs on Windows, Linux and Mac OSX.

SQL Developer is free.

Declarative Caching Services for Spring

Declarative Caching Services for Spring by Alex Ruiz -- Caching is an essential practice that improves the performance of enterprise applications. In this article, Alex Ruiz demonstrates a declarative caching framework for Spring 2.0, which supports pluggable cache implementations

JavaOne 2006 - Day1

I am attending JavaOne 2006 at Mascon Center, San Frascisco,CA. Today is my first day. This conference will end on May,20,2006. This is my first conference. It is very nice experience. I came here on Saturday night and register myself on Monday,15, May,2006.

Day1, Tuesday morning at 8.30 the session started with general sessions by Java CEO and other leading technical people.
Sun is planning to release Java to OpenSource. The question was asked like this. Wheather Sun plans to release Java to OpenSource and it was answered that it is not WHEATHER, but HOW. That shows Java is going to be available to OpenSource. Still they need to work out the existing licence and compatability issues. Thanks Java.

General sessions insisted everyone to join JCP.org and Java.net. Motorola CEO predicts mobile applications will be taking the ride in coming 10 years using Java. Linux Unbuntu and Java are availble in desktop in China and South Africa.

Motorola device won Duke's best Music device award.

Marc Fleury, CEO of JBoss was not willing to talk about JBoss and Redhat merge, but he informs that they are not decided about the name. Either name can be REDBOSS or JHAT!!!

Some of the annouements on Day1

Java EE 5.0 is available to production.

JMS goes to OpenSource.

Project Tango was renamed WSIT and that goes to OpenSource.

BPEL engine moved into OPENESB.

All OpenSource products will be named under Open Java EE.

After the general sessions, attended EJB 3.0 session. It is very nice and gave nice details about EJB feature.

Second session was Essential Lessons for Distributed Caching. It was from Tagosol CEO. It is very nice and in detail.

Third session was Concurrent collection utilities in Java SE 5.0.

Fourth session, TestNG which is alternate to JUnit

Fifth session is Portlet 2.0 with JSR 286. With JSR 286, it looks like we will have event for portlets and render parameter for portlet.

I left at 6.30pm to my hotel.

Article: Why Spring JDBC?

Vikram Veeravelu has written an article discussing the use of Spring JDBC over direct use of the JDBC API. It's published on java.net and is a good introduction for anyone interested in trying the Spring JDBC library.

Live Clipboard – Ajax direction ?

Do you want copy one web page to another web site. Microsoft is coming with new feature called Live Clipboard. More

Spring Web Flow 1.0

Spring Web Flow 1.0 was released. Read More

Spring Framework 1.2.8 was released. More

WebLogic Portal 9.2

In Josh Lannin's Blog, he talks about Making your Portal development leaner and more agile with WebLogic Portal 9.2

Two toolkits bring Ajax to Eclipse

Get ready for the new Open Ajax Initiative, dedicated to building an open platform in which developers can collaborate. Two existing run-time tools, Dojo and Zimbra, are supported in Eclipse's Ajax Toolkit Framework (ATF) and can help you prepare. More >>

Dali - Eclipse ORM

Eclipse coming with new Tool for ORM. They code named this project as Dali.

The goal of the Dali EJB Object-Relational Mapping project is to build extensible frameworks and exemplary tools for the definition and editing of Object-Relational (O/R) mappings for EJB 3.0 Entities. EJB 3.0 O/R mapping support will focus on minimizing the complexity of mapping by providing creation and automated initial mapping wizards, and programming assistance such as dynamic problem identification.

In his blog, Arthur Ryman the Web Tools Project co-lead discusses Dali and other new WTP-related Eclipse projects. Sept 2005

Spring Components - XML configuration on steroids

The single most important feature in Spring 2.0 (IMO) is a new XML
configuration convenience feature. I believe this is going to
revolutionize the way people develop for Spring and bootstrap a modest
component market too. This is a lot more than a convenience features
- it’s a fledgling component model too.

Read More

Spring applications for IBM WebSphere Application

Develop a J2EE™ application for IBM® WebSphere® Application Server using the Spring Framework and IBM Rational® Application Developer. In this first of three articles, learn about Spring, the Spring bean factory, and AOP, and about how to integrate Spring and Struts applications.

Read More

LdapTemplate: LDAP Programming in Java Made Simple

The Java Naming and Directory Interface (JNDI) is for LDAP programming what Java Database Connectivity (JDBC) is for SQL programming. There are several similarities between JDBC and JNDI/LDAP (Java LDAP). Despite being two completely different APIs with different pros and cons, they share a number of less flattering characteristics:

* They require extensive plumbing code, even to perform the simplest of tasks.
* All resources need to be correctly closed, no matter what happens.
* Exception handling is difficult.

The above points often lead to massive code duplication in common usages of the APIs. As we all know, code duplication is one of the worst code smells. All in all, it boils down to this: JDBC and LDAP programming in Java are both incredibly dull and repetitive.

Read More

IBM Easy Website Builder

IBM Easy Website Builder

An Eclipse-based tool that enables non-technical business users to build dynamic Web sites without assistance from technical developers.

Free tool is available to download.

This tool uses Apache Derby database, Eclipse and TomCat to build your website.

It has got nice Wizard to build your website.

Read More

Oracle fires a shot across Red Hat’s bows

FT.com reports following report.
For long-time watchers of Larry Ellison, the revelation that Oracle is looking at launching its own version of the Linux open source operating system has aroused a suspicion: is the software industry’s most acquisitive CEO stalking his next target?

Ajax Programming in WebLogic Portal 8.1

Ajax Programming in BEA WebLogic Portal 8.1, Part 2 by John Margaglione -- In the final part of the series examining low-level Ajax programming in BEA WebLogic Portal 8.1, John Margaglione provides several example portlets together with commentary explaining the pitfalls awaiting the unsuspecting Ajax programmer.