Nice Oracle Analytic Article

Today, I found the following article by Jonathan Lewis was very nice and
interesting. The article is about Analytic functions, and is one that
Jonathan first published in the UKOUG journal earlier on last year.
This article published in Select (the journal of the IOUG) has won the
"SELECT Editors' Choice" award.There's going to be a presentation of
awards at Collaborate '07, which starts this week.

http://www.jlcomp.demon.co.uk/analytics.html

Single Sign On between WebLogic Server 9.2 and IIS

Single Sign On between WebLogic Server 9.2 and IIS using SAML by Alex Rykov -- Single sign on (SSO) is becoming increasingly important in enterprise environments. This tutorial by Alex Rykov describes a simple SAML SSO scenario between Microsoft Internet Information Services Server (IIS) and BEA WebLogic Server 9

Oracle 9i - How to add missing partitions

Assume, We need to insert missing partition as new partition with Oracle Range Partition.

Here is the simple example for that.

create table karth_test (a date,data char(10))
partition by range(a)
( partition p1 values less than (to_date('2007-01-01','YYYY-MM-DD')),
partition p2 values less than (to_date('2007-02-01','YYYY-MM-DD')),
partition p4 values less than (to_date('2007-04-01','YYYY-MM-DD'))
)

select partition_name pname, high_value from user_tab_partitions
where table_name ='KARTH_TEST' order by partition_name

alter table KARTH_TEST add partition p3 values less than (TO_DATE('2007-03-01','YYYY-MM-DD'))

-- Above statement raises ORA-14074: partition bound must collate higher than that of the last partition.

-- We can execute following statement to overcome above error

Alter table KARTH_TEST split partition p4 at (TO_DATE('2007-03-01','YYYY-MM-DD'))
into (partition p3, partition p4)

Drop table KARTH_TEST

Exploring the WebLogic Integration 8.1 RDBMS Event Generator

Nice DEV2DEV article. It is well explained in simple terms.

Exploring the WebLogic Integeration 8.1 RDBMS Event Generator
by Mahadevan Krishnan. Learn about an approach to integerating databases with enterprise applications through the use of WebLogic Integeration Event Generators.

Introduction to OpenTerracotta - From InfoQ

Orion Letizi posted nice article in www.infoq.com
Java applications are easiest to write and test when they run in a single JVM. However, the requirements to make applications scalable and highly available have forced Java applications to run on more than one JVM. In this article, we introduce OpenTerracotta, an enterprise-class, open-source JVM-level clustering solution. Read more

Web2.0, REST & Weblogic Workshop - Vinny Carpenter's blog

Found nice link at Vinny's blog about REST, Web 2.0 and BEA Workshop.

Dynamic DataSource Routing - Spring 2.0.1

Spring 2.0.1 introduced an AbstractRoutingDataSource. I believe that it deserves attention, since (based on frequent questions from clients) I have a hunch that there are quite a few 'home-grown' solutions to this problem floating around. Mark Fisher posted nice entry about this topic in his blog. Read More.

Pojos In Action - Sample Chapter

POJOs in Action by Chris Richardson -- In this book excerpt from POJOs in Action, Chris Richardson explores the benefits and drawbacks of using the Transaction Script pattern and describes how to implement this pattern using POJOs and the Spring framework

Hibernate Mapping XML to Oracle XMLTYPE

Oracle XMLTYPE attribute type can be mapped to a W3C Document type representation. Hibernate's UserType mechanism allows to create vendor specific data types. There are certain points to consider when mapping an object to an Oracle XMLType.
Please read more.

Want to try Spring Web Flow ?

SpringFramework announced that Spring Web Flow 1.0.1 was released.

What is Spring WebFlow?
Spring Web Flow is a next generation Java web application controller framework that allows developers to model user actions as high-level modules called flows. The framework delivers improved productivity and testability while providing a strong solution to enforcing navigation rules and managing application state.

Getting Started

The best way to get started with Spring Web Flow is to download the release, read Erwin's practical introduction, and walk through the sample applications. We recommend reviewing all samples, starting with Phonebook, supplementing with reference manual material as needed. Ten sample applications ship with the release, each demonstrating a distinct set of product features.

Spring 2.0 Features - Introduction (Part 1)

Spring 2.0: What's New and Why it Matters is an infoQ article by Rod Johnson, the first of two part. This in-depth piece is well worth reading for anybody wishing to understand the evolution of Spring 2.0 as it introduces significant new features, and how these combine to provide the simplicity and power that is the central theme of this release.

ZK - Ajax but no JavaScipt

ZK is an open-source Ajax Web framework that enables rich user interface for Web applications with no JavaScript and little programming.

It has got support for Spring. See the following links for HOW-TO guide.

Contact List with ZK and Spring - Contact List Project with MySql, Spring and ZK.
ZK with Spring DAO and JDBC - How to setup ZK, Spring DAO and JDBC.

Configuring Single Sign-On using SAML in WebLogic Server 9.2

Configuring Single Sign-On using SAML in WebLogic Server 9.2 by Vikrant Sawant -- In this tutorial Vikrant Sawant shows how to configure SAML on your WebLogic Server domains to enable single sign-on across all deployed Web applications.

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.

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.