The Kpanchan Blog

Oracle 11G with RAC on Windows Laptop - Guide

2011-09-23T06:39:00.004-04:00

I was wake up by production call today @4:30am, but call ended in 10mins. Decided to read something from Oracle List and found message about RACATTACK event in Oracle OpenWorld OTN Lounge
http://www.blogger.com/img/blank.gifhttp://www.blogger.com/img/blank.gif
Further checking on Google found, this is Group which takes your Laptop with Windows and install Oracle RAC with VMWWARE. That allow us to play around.

They have created very nice Step-by-Step instructions with Detail Screenshots in the following link.

Oracle_RAC_At_Home from RACATTACK on Wikibook.

I haven't tried this, but Information is very nice and details.

Incremental Optimizer Statistics Gathering in 11g

2011-04-19T21:37:00.002-04:00

Writing this blog entry after long time. At work we are upgrading to 11g. We have one of the biggest table with 2Billion records with Partition and Subpartitions. This accessed by reporting tool. For better performance we analyze each partition (each will have close to 130,000,000 records). Estimate with 50% will do FTS and

130,000,000 Million / 2 (for 50% Estimate) = 65,000,000 Million.

AVG_ROW_LEN = 1400 bytes

Total Temp Memory required to analyze with 50% Percent is
65,000,000 * 1400 bytes = 91,000,000,000 bytes

This is close to 85GB

We need 85GB Temp space exclusively for this process. If there is any other process run in parallel, Analyze job fail due to insufficient TEMP space.

11G has cool feature.

We need to have
This new feature in database 11g could be most useful, especially for large partitioned tables.

Gathering global statistics for a partitioned table would typically require a FTS of all table rows, even when only rows for a few partitions have changed. Using the INCREMENTAL=true setting global statistics can be gathered by scanning only the partitions that have changed.

Oracle® Database Performance Tuning Guide
11g Release 2 (11.2)
13.3.1.3.2 Incremental Statistics Gathering
http://download.oracle.com/docs/cd/E11882_01/server.112/e16638/stats.htm#i42218

The requirements for enabling incremental statistics gathering:

* The INCREMENTAL value for the partitioned table is true.
* The PUBLISH value for the partitioned table is true.
* The user specifies AUTO_SAMPLE_SIZE for ESTIMATE_PERCENT and AUTO for GRANULARITY when gathering statistics on the table.

That may in turn lead to questions as to what the PUBLISH value for a table is. Prior to 11g when gathering statistics they are immediately "published" for use, in 11g one can gather statistics and choose to not have them published immediately but rather do so at some later time. An example might be gathering statistics across a number of tables and/or table partitions and then publish them all at once when it's desirable to do so. See:

Private Statistics Using DBMS_STATS in 11g (Doc ID 567683.1)

Some examples here as well:

Statistics Collection Enhancements in Oracle Database 11g Release 1
http://www.oracle-base.com/articles/11g/StatisticsCollectionEnhancements_11gR1.php

Afer long time !!!!

2009-10-24T08:59:00.001-04:00

To break the silence after long time, I posting this entry which I read today.

I got this reference arcticle while I was reading TomKyte blog.

http://www.snopes.com/autos/law/noplate.asp

This link talks about How data was maintained in California DMV in 1972.

It shows what happens when best practice was not followed to maintain data.

An Introduction To Servlet 3.0

2008-11-08T05:45:00.000-05:00

An Introduction To Servlet 3.0
Nice article by Deepa Sobhana at Java.net for Servlet 3.0 feature compared with Servlet 2.5. Code snippets comparision very good approach in this article.

WebLogic Workshop - Custom Project Template

2007-12-01T00:14:00.000-05:00

In WebLogic Workshop 9.1 and above, we can create following directory structure create custom EAR application, which can be used under Eclipse.

Best Practices from (edocs.bea.com)

# Use the same source directory structure with your own J2EE application projects, so you can utilize the WebLogic Server build scripts to compile and deploy your applications. The following summarizes the contents of a simple source directory that follows the WebLogic split development directory structure format:

\myProject

\myProject\myEar

\myProject\myEar\META-INF\application.xml

\myProject\myEar\myEjb\com\*\MyEjbGenEjb.ejb

\myProject\myEar\myEjb\com\*\*.java

\myProject\myEar\myWebService\com\*.*.java

\myProject\myEar\myWebApp\*.jsp

\myProject\myEar\myWebApp\WEB-INF\web.xml

\myProject\myEar\myWebApp\WEB-INF\src\com\*\*.java

Switch to OpenOffice - FREE

2007-11-21T06:33:00.000-05:00

Tired of buying Microsoft Office software everytime. Are you spending too much money to buy Microsoft Office?

Time to say Final Goodbye to Microsoft Office.

Sun donated OpenOffice to public.

It is FREE and replacement to MICROSOFT OFFICE.

Here is the link.

http://java.com/en/download/javacom_update.jsp

Spring 2.0 - Rod Johnson Presentation

2007-10-09T05:54:00.000-04:00

Rod Johnson, Founder of the open source Spring Framework, Author of J2EE without EJB
Topic: Spring 2.0 and Beyond
In this presentation, recorded at TSSJS 2007, Rod Johnson details the improvements made to the Spring 2.0 framework. Spring 2.0 introduced major enhancements in the Spring Framework making it both simpler to use and more powerful. In this session, Rod discusses some of the enhancements through code examples, focusing on: - Extensible XML configuration, support for dynamic languages in the Spring component model, and support for JPA.

Oracle - Shared Server

2007-10-09T05:48:00.000-04:00

I got blog pointer from Jonathan Lewis about Oracle Shared Server

This is well written by Howard Rogers. Here is info from Jonathan Lewis, Oracle Scratchpad.

This item from Howard Rogers sums up the shared server technology (formerly multi-threaded server, or MTS) so well that I decided it was worth a special mention.

Spring 2.0 with Hibernate Tutorials - Links

2007-10-05T06:57:00.000-04:00

From Interface blog

From Apache Wiki, Struts2, Spring2, Ajax and JPA

From IBM DeveloperWork, Java,Spring 2 and JPA

From BEA Dev2Dev, Java,Spring 2 and JPA

Further Reading

SpringFramework JPA

Java Web Services, Part 3: Axis2 Data Binding

2007-08-03T22:31:00.000-04:00

Nice article in developerWorks by
Java Web Services, Part 3: Axis2 Data Binding
by
Dennis Sosnoski

10 things I learned about using Hibernate/JPA successfully

2007-08-03T22:28:00.000-04:00

Nice article link posted by suresk
10 things I learned about using Hibernate/JPA successfully

JBossSeamFramework - Deep Integeration

2007-08-03T21:55:00.000-04:00

JBossSeamFramework - Deep Integeration by Michel Yuan

Playing Around with Star Transformations and Bitmap Indexes

2007-08-03T21:52:00.000-04:00

Mark Rittman Mand Consulting has blog entry about

Playing Around with Star Transformations and Bitmap Indexes

It is very nice article about Oracle, Star Transformation.

Must read article.

Web page to PDF Firefox extension

2007-07-26T06:20:00.000-04:00

Found following information from Vinny Carpenter's Blog

Web page to PDF Firefox extension - LOOP is a unique extension for Firefox that converts the web browser into a proper PDF writer that can do some amazing things sometime not possible in other free PDF conversion software

JasperReports - Introduction with Priting

2007-07-26T06:17:00.000-04:00

Marc Nuri's Happy Coding Blog nice code snippets and step by step guide to create JasperReports setup and printing.

REST webservices on RAILS

2007-07-26T06:13:00.000-04:00

Nice article introduces Web services in Rails and focuses on a strategy known as Representational State Transfer (REST). This articled posted in developerWorks of IBM by Bruce Tate, President,RapidRed

What is JAXB?

2007-07-26T06:09:00.000-04:00

Java Architecture for XML Binding (JAXB)

Nice introduction article from SDN

Java-XML mapping made easy with JAXB 2.0 tutorial was posted by John Ferguson Smart on Javaworld on 06/26/06

Google Gears

2007-06-19T06:17:00.000-04:00

Google Gears: Enabling Offline Web Applications

Google Gears is an open source browser extension that lets developers create web applications that can run offline

Restricting Access to your AJAX Services

2007-06-19T06:14:00.000-04:00

Come across, how to restrict access to Ajax Services from Greg Murray blog.

Creating and Using API Keys with Java Based Ajax Services

Google - Guice

2007-06-12T21:53:00.000-04:00

google-guice

Guice (pronounced 'juice') is a lightweight dependency injection framework for Java 5, brought to you by Google.

Introduction to Guice Video (Redux) by Bob Lee

Google Guice User Guide

Google Guice comparison with Spring

Database App Development and Migration: Tools That Rock

2007-06-12T21:51:00.000-04:00

Man, Mike Hichwa's team at Oracle is spinning out some incredible database tools. These are the guys and gals responsible for two of the most innovative things to come out of here in a long time, Application Express and SQL Developer. I view this group as a "skunk works" that has some pretty nice flexibility in terms of its role within the Server Technologies division here at Oracle, and the results show it.

Read More

dW: Enable REST with Web services, Part 1: REST and Web services in WSDL 2.0

2007-06-12T21:48:00.000-04:00

Glen Mazz posted blog about dW: Enable REST with Web services, Part 1: REST and Web services in WSDL 2.0

Flex - Open Source

2007-06-11T21:50:00.000-04:00

Recently I found many interesting links about FLEX and J2EE.

James Ward Blog

Video Tutorial: Creating an expressive application using Flex, Hibernate, and XFire - by Bruce Eckel, James Ward

James Ward´s friend Tony in Japan created a pretty cool Flex app that does text diffs. Very cool and nice use of vectors! Thanks Tony!

Extract CSV file format in Oracle SQL

2007-05-15T06:12:00.000-04:00

How to extract CSV file format data in Oracle SQL Plus.

---10G Solution. On SQL Plus session
alter session set nls_date_format='YYYY-MM-DD';

Session altered.

select regexp_replace(column_value,' *<[^>]*>[^>]*>’,';’)
from table(xmlsequence(cursor(select * from emp)));

=======================

-- Oracle 9i Solution. SQL Plus session.
-- Following sql fail to give EMPTY space for NULL values properly.
-- See PL/SQL solution to handle
SELECT XMLTRANSFORM
(COLUMN_VALUE,
XMLTYPE
('

'
)
) csv
FROM TABLE (XMLSEQUENCE (CURSOR (SELECT *
FROM emp)))
/
=======================================
---- Oracle 9i PL/SQL solution
SQL> VAR cur refcursor

SQL> DECLARE
ctx DBMS_XMLGEN.ctxhandle;
BEGIN
ctx := DBMS_XMLGEN.newcontext ('select * from emp');
DBMS_XMLGEN.setnullhandling (ctx, DBMS_XMLGEN.empty_tag);

OPEN :cur FOR
SELECT (SELECT RTRIM(XMLAGG (XMLELEMENT (c,VALUE (t2),',').EXTRACT('//text()')),',')
FROM TABLE (XMLSEQUENCE (VALUE (t1).EXTRACT ('ROW/*'))) t2) csv
FROM TABLE(XMLSEQUENCE(DBMS_XMLGEN.getxmltype (ctx).EXTRACT('ROWSET/ROW'))) t1;

DBMS_XMLGEN.closecontext(ctx);
END;
/
PL/SQL procedure successfully completed.

SQL> PRINT cur
==================================

New Articles to Read - Java

2007-05-15T06:11:00.000-04:00

XML Parser Benchmarks: Part 1

JavaOne 2007, #2: Making Web Apps Easy
Summary
Today, JavaOne 2007 showcased a complete open source technology stack that lets you develop and deploy web applications quickly and easily, including JRuby, Rails, NetBeans, and Glassfish

Integrating Struts With Spring

Hibernate Interceptors - An Introduction

New Articles to Read - Java

2007-05-15T06:10:00.001-04:00

Integrating Struts With Spring

Hibernate Interceptors - An Introduction

Build an Online Reporting Application Using Oracle XML Publisher

2007-05-13T15:22:00.001-04:00

Build an Online Reporting Application Using Oracle XML Publisher

by Mark Rittman

Learn how to create an online reporting environment using XML Publisher technology, step by step.

Build an Online Reporting Application Using Oracle XML Publisher

2007-05-13T15:22:00.000-04:00

Build an Online Reporting Application Using Oracle XML Publisher

by Mark Rittman

Learn how to create an online reporting environment using XML Publisher technology, step by step.

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

2007-05-06T04:17:00.000-04:00

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.

Collection of JVM Options

2007-05-03T06:20:00.000-04:00

I found link about Collection of JVM options compiled by Joseph D. Mocker (Sun Microsystems, Inc.)

Apache Axis2 - Nice Technical Articles

2007-05-03T06:10:00.000-04:00

Today, I was looking at Jroller.com and found nice entry posted by Glen Mazza. Mazza posted Axis2 - Technical Articles. It is very good collection of articles about Apache Axis2. From his posting, I was directed to ws02.org site. This where I finally read Axis2 technical articles.

WSO2.org is Oxygen for Web Service Developers. It has got very nice detail articles and tutorials for Web Services projects related to Apache Open Source.

Thanks to Glen Mazza for his posting.

Spring Framework - Two Articles on Form Validation with DWR and AJAX

2007-04-23T05:52:00.001-04:00

Spring Framework - Two Articles on Form Validation with DWR and AJAX
Submitted by Colin Sampaleanu on Thu, 2007-04-19 23:09. Technical Article
Using AJAX (via DWR) to perform client-side validation is a useful technique that allows the implementation of both client side and server side form validation, while actually using the same (server-side) validators for both task. Here are a couple of articles that describe this technique.
Generic Validator for Spring MVC and DWR by Jose Noheda, shows one approach. His validators work off annotations in the objects to be validated (this is somewhat orthogonal to the question of validating remotely).

ForwardSourceID:NT00009002

Incremental Compilation and Error Handling in XMLBeans

2007-04-23T05:51:00.002-04:00

Incremental Compilation and Error Handling in XMLBeans by Hetal Shah -- Hetal Shah shows how to ease the maintenance of XMLBeans-based applications by using incremental compilation of schemas and custom error handling facilities.

NT00008FFE

How to configure XML Bean

2007-04-23T05:51:00.001-04:00

Configuring XMLBeans by Hetal Shah -- One of the most powerful features of XMLBeans Version 1.03 is the ability to customize its code generation through a configuration file. Configuration features of XMLBeans bring a number of benefits in terms of flexibility, reusability, simplified code, and XMLBeans"s readiness for enterprise environments.

Nice Oracle Analytic Article

2007-04-16T06:12:00.001-04:00

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

2007-04-08T12:54:00.000-04:00

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

2007-04-03T16:15:00.000-04:00

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

2007-03-30T12:53:00.000-04:00

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

2007-02-14T07:05:00.001-05:00

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

2007-02-13T06:43:00.001-05:00

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

Dynamic DataSource Routing - Spring 2.0.1

2007-01-29T22:53:00.000-05:00

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

2007-01-29T22:18:00.000-05:00

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

2007-01-18T06:42:00.000-05:00

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 ?

2007-01-18T06:41:00.000-05:00

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)

2007-01-18T06:03:00.000-05:00

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

2007-01-09T06:36:00.000-05:00

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

2007-01-09T06:34:00.000-05:00

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

2006-12-06T06:41:00.000-05:00

Java - Sorting Algorithms

2006-11-22T06:47:00.000-05:00

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?

2006-11-22T06:28:00.000-05:00

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

2006-11-20T07:08:00.000-05:00

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

2006-11-10T07:17:00.000-05:00

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

2006-11-10T06:38:00.000-05:00

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

2006-11-01T13:47:00.000-05:00

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

2006-10-30T19:55:00.000-05:00

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

2006-10-24T22:47:00.000-04:00

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

2006-10-23T08:03:00.000-04:00

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

2006-10-09T06:13:00.000-04:00

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

Introduction to Oracle Instant Portal

2006-10-05T07:14:00.000-04:00

Check the nice demo about Oracle Instant Portal.

Stripes, Spring and Hibernate Tutorial

2006-09-28T06:47:00.000-04:00

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

Useful links to read

2006-09-21T06:21:00.000-04:00

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

2006-09-12T06:35:00.000-04:00

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

2006-09-12T06:33:00.000-04:00

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

2006-09-12T06:31:00.000-04:00

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

2006-09-12T06:25:00.000-04:00

Matt Raible posted nice blog entry about Migrating to Spring 2.01

Nice OracleApps Links

2006-09-11T06:11:00.000-04:00

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?

2006-09-11T06:10:00.000-04:00

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

2006-09-06T06:31:00.000-04:00

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

Java 5 StringValuedEnumUserType in Hibernate

2006-09-06T06:29:00.000-04:00

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

2006-09-06T06:27:00.000-04:00

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?

2006-09-06T06:25:00.000-04:00

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

REST - Representational State Transfer

2006-08-22T07:01:00.000-04:00

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

2006-08-17T07:55:00.000-04:00

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

2006-08-17T07:53:00.000-04:00

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

2006-08-17T07:42:00.000-04:00

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

2006-08-17T07:41:00.000-04:00

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

2006-08-16T08:11:00.000-04:00

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

2006-08-16T08:04:00.000-04:00

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

2006-08-16T07:59:00.000-04:00

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

2006-08-11T07:52:00.000-04:00

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

2006-08-11T07:47:00.000-04:00

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

2006-08-11T07:44:00.000-04:00

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

2006-08-11T07:42:00.000-04:00

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

2006-08-11T07:38:00.000-04:00

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.

2006-08-02T07:36:00.000-04:00

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

Check his weblog entry.

SCJP5 Resources and Tutorials

2006-08-02T06:02:00.000-04:00

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

2006-08-01T06:06:00.000-04:00

Sun provides tutorials for JSE, JEE and Webservices.

Sun Tutorial Home Page

Java6 - Beta 2 features

2006-08-01T06:03:00.000-04:00

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

2006-07-31T07:44:00.000-04:00

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

2006-07-31T07:41:00.000-04:00

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

2006-07-31T07:38:00.000-04:00

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

2006-07-31T07:32:00.000-04:00

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

2006-07-31T07:29:00.000-04:00

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

2006-07-31T07:25:00.000-04:00

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

Pro EJB 3.0 Java Persistence API - Sample Chapter

2006-07-31T07:18:00.000-04:00

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

2006-07-20T07:39:00.000-04:00

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?

2006-07-20T07:27:00.000-04:00

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

2006-07-20T07:18:00.000-04:00

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

Sematic Web

2006-07-16T06:39:00.000-04:00

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

2006-07-15T06:15:00.000-04:00

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