andrews web site

Role Base Security Data Base Design (MYSQL Script)

2011-08-25T12:59:00.000-07:00

-- phpMyAdmin SQL Dump
-- version 3.2.0.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 25, 2011 at 07:58 PM
-- Server version: 5.1.36
-- PHP Version: 5.3.0

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `security`
--

-- --------------------------------------------------------

--
-- Table structure for table `roles`
--

CREATE TABLE IF NOT EXISTS `roles` (
`pk_role_id` varchar(50) NOT NULL,
`role_name` varchar(50) NOT NULL,
`created_by` varchar(50) NOT NULL,
`created_datettime` datetime NOT NULL,
`modified_by` varchar(50) NOT NULL,
`modified_datetime` datetime NOT NULL,
PRIMARY KEY (`pk_role_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`pk_role_id`, `role_name`, `created_by`, `created_datettime`, `modified_by`, `modified_datetime`) VALUES
('psu1001', 'prod_support', 'andrew', '2011-08-20 11:51:58', 'andrew', '2011-08-20 11:52:02'),
('ops1001', 'order pro specialist', 'andrew', '2011-08-20 11:52:51', 'vdsi', '2011-08-20 11:52:55');

-- --------------------------------------------------------

--
-- Table structure for table `role_screen`
--

CREATE TABLE IF NOT EXISTS `role_screen` (
`pk_role_screen_id` varchar(50) NOT NULL,
`fk_role_id` varchar(50) NOT NULL,
`fk_screen_id` varchar(50) NOT NULL,
`created_by` varchar(50) NOT NULL,
`created_datettime` datetime NOT NULL,
`modified_by` varchar(50) NOT NULL,
`modified_datetime` datetime NOT NULL,
PRIMARY KEY (`pk_role_screen_id`),
KEY `fk_role_id` (`fk_role_id`),
KEY `fk_screen_id` (`fk_screen_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `role_screen`
--

INSERT INTO `role_screen` (`pk_role_screen_id`, `fk_role_id`, `fk_screen_id`, `created_by`, `created_datettime`, `modified_by`, `modified_datetime`) VALUES
('1', 'psu1001', 'oes1001', 'andrew', '2011-08-20 12:01:35', 'andrew', '2011-08-20 12:01:40'),
('2', 'psu1001', 'psu1001', 'andrew', '2011-08-20 12:02:11', 'andrew', '2011-08-20 12:02:17'),
('3', 'oes1001', 'oes1001', 'andrew', '2011-08-20 12:03:46', 'andrew', '2011-08-20 12:03:50');

-- --------------------------------------------------------

--
-- Table structure for table `screens`
--

CREATE TABLE IF NOT EXISTS `screens` (
`screen_id` varchar(50) NOT NULL,
`screen_name` varchar(50) NOT NULL,
`created_by` varchar(50) NOT NULL,
`created_datettime` datetime NOT NULL,
`modified_by` varchar(50) NOT NULL,
`modified_datetime` datetime NOT NULL,
PRIMARY KEY (`screen_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `screens`
--

INSERT INTO `screens` (`screen_id`, `screen_name`, `created_by`, `created_datettime`, `modified_by`, `modified_datetime`) VALUES
('oes1001', 'order_entry', 'andew', '2011-08-20 11:56:47', 'andrew', '2011-08-20 11:56:57'),
('pss1001', 'production support', 'andrewq', '2011-08-20 11:58:01', 'andrew', '2011-08-20 11:58:08'),
('1111', 'scree', 'andrew', '2011-08-20 11:56:47', 'andrew', '2011-08-20 11:56:47');

-- --------------------------------------------------------

--
-- Table structure for table `userinfo`
--

CREATE TABLE IF NOT EXISTS `userinfo` (
`pk_user_id` varchar(50) NOT NULL,
`user_name` varchar(50) NOT NULL,
`password` varchar(50) NOT NULL,
`email_id` varchar(50) NOT NULL,
`current_designation` varchar(50) NOT NULL,
`current_role` varchar(50) NOT NULL,
`created_by` varchar(50) NOT NULL,
`created_datettime` datetime NOT NULL,
`modified_by` varchar(50) NOT NULL,
`modified_datetime` datetime NOT NULL,
PRIMARY KEY (`pk_user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `userinfo`
--

INSERT INTO `userinfo` (`pk_user_id`, `user_name`, `password`, `email_id`, `current_designation`, `current_role`, `created_by`, `created_datettime`, `modified_by`, `modified_datetime`) VALUES
('z381466', 'anton', 'anton', 'anton@gmail.com', 'developer', 'developer', 'andrew ', '2011-08-20 11:50:46', 'andrew', '2011-08-20 11:50:46'),
('z381455', 'andrews ', 'andrvdsiews', 'andrew_india@yahoo.com', 'analyst', 'developer', 'vdsi', '2011-08-20 11:49:22', 'andrew', '2011-08-20 11:49:22'),
('oiu', 'oiuo', 'oiu', 'ioou', '98', '9809', '098', '2011-11-11 00:00:00', '890', '2011-11-11 00:00:00');

-- --------------------------------------------------------

--
-- Table structure for table `user_role`
--

CREATE TABLE IF NOT EXISTS `user_role` (
`pk_user_role_id` varchar(50) NOT NULL,
`fk_role_id` varchar(50) NOT NULL,
`fk_user_id` varchar(50) NOT NULL,
`created_by` varchar(50) NOT NULL,
`created_datettime` datetime NOT NULL,
`modified_by` varchar(50) NOT NULL,
`modified_datetime` datetime NOT NULL,
PRIMARY KEY (`pk_user_role_id`),
KEY `fk_role_id` (`fk_role_id`),
KEY `fk_user_id` (`fk_user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_role`
--

INSERT INTO `user_role` (`pk_user_role_id`, `fk_role_id`, `fk_user_id`, `created_by`, `created_datettime`, `modified_by`, `modified_datetime`) VALUES
('1', 'psu1001', 'z381455', 'vdsi', '2011-08-20 11:55:23', 'andrew', '2011-08-20 11:55:33'),
('2', 'ops1001', 'z381455', 'andewq', '2011-08-20 11:55:54', 'vdsi', '2011-08-20 11:55:58');

Inventory database Design

2011-08-25T12:56:00.000-07:00

Hi All Please find a DB Design for inventory and you can use it in your projects.
post questions if youn have any questions or comments.

-- phpMyAdmin SQL Dump
-- version 3.2.0.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 25, 2011 at 07:43 PM
-- Server version: 5.1.36
-- PHP Version: 5.3.0

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `inventory`
--

-- --------------------------------------------------------

--
-- Table structure for table `branch_info`
--

CREATE TABLE IF NOT EXISTS `branch_info` (
`pk_branch_id` varchar(50) NOT NULL,
`fk_company_id` varchar(50) NOT NULL,
`branch_name` varchar(50) NOT NULL,
`branch_poc` varchar(50) NOT NULL,
`branch_detail` varchar(200) NOT NULL,
`website` varchar(100) NOT NULL,
`created_by` varchar(50) NOT NULL,
`created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`last_updated_by` varchar(50) NOT NULL,
`last_updated_datetime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`status` varchar(1) NOT NULL,
PRIMARY KEY (`pk_branch_id`),
KEY `FK_branch_info_company_info` (`fk_company_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `branch_info`
--

-- --------------------------------------------------------

--
-- Table structure for table `company_info`
--

CREATE TABLE IF NOT EXISTS `company_info` (
`pk_company_id` varchar(50) NOT NULL,
`company_name` varchar(50) NOT NULL,
`company_type` varchar(25) NOT NULL,
`company_detail` varchar(100) NOT NULL,
`website` varchar(50) NOT NULL,
`created_by` varchar(25) NOT NULL,
`created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`last_updated_by` varchar(50) NOT NULL,
`last_updated_datetime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`status` varchar(1) NOT NULL,
PRIMARY KEY (`pk_company_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `company_info`
--

-- --------------------------------------------------------

--
-- Table structure for table `inventory`
--

CREATE TABLE IF NOT EXISTS `inventory` (
`pk_inventory_id` varchar(50) NOT NULL,
`fk_product_id` varchar(50) NOT NULL,
`fk_company_id` varchar(50) NOT NULL,
`fk_branch_id` varchar(50) NOT NULL,
`quantity` int(5) NOT NULL,
`calculation_unit` varchar(4) NOT NULL,
`io_type` varchar(1) NOT NULL,
`created_by` varchar(25) NOT NULL,
`created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`last_updated_by` varchar(50) NOT NULL,
`last_updated_datetime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`status` varchar(1) NOT NULL,
PRIMARY KEY (`pk_inventory_id`),
KEY `FK_inventory_product_info` (`fk_product_id`),
KEY `FK_inventory_company_info` (`fk_company_id`),
KEY `FK_inventory_branch_info` (`fk_branch_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `inventory`
--

-- --------------------------------------------------------

--
-- Table structure for table `product_info`
--

CREATE TABLE IF NOT EXISTS `product_info` (
`pk_product_id` varchar(50) NOT NULL,
`product_name` varchar(50) NOT NULL,
`product_detail` varchar(100) NOT NULL,
`model` varchar(50) NOT NULL,
`material_type` varchar(50) NOT NULL,
`quantity` int(5) NOT NULL,
`calculation_unit` varchar(4) NOT NULL,
`current_rate` decimal(8,0) NOT NULL,
`created_by` varchar(25) NOT NULL,
`created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`last_updated_by` varchar(50) NOT NULL,
`last_updated_datetime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`status` varchar(1) NOT NULL,
PRIMARY KEY (`pk_product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `product_info`
--

-- --------------------------------------------------------

--
-- Table structure for table `product_supplier`
--

CREATE TABLE IF NOT EXISTS `product_supplier` (
`pk_product_supplier_id` varchar(101) NOT NULL,
`fk_product_id` varchar(50) NOT NULL,
`fk_supplier_id` varchar(50) NOT NULL,
`created_by` varchar(25) NOT NULL,
`created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`last_updated_by` varchar(50) NOT NULL,
`last_updated_datetime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`status` varchar(1) NOT NULL,
PRIMARY KEY (`pk_product_supplier_id`),
KEY `FK_product_supplier_product_info` (`fk_product_id`),
KEY `FK_product_supplier_supplier_info` (`fk_supplier_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `product_supplier`
--

-- --------------------------------------------------------

--
-- Table structure for table `supplier_info`
--

CREATE TABLE IF NOT EXISTS `supplier_info` (
`pk_supplier_id` varchar(50) NOT NULL,
`supplier_name` varchar(50) NOT NULL,
`supplier_type` varchar(25) NOT NULL,
`supplier_detail` varchar(100) NOT NULL,
`website` varchar(50) NOT NULL,
`created_by` varchar(25) NOT NULL,
`created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`last_updated_by` varchar(50) NOT NULL,
`last_updated_datetime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`status` varchar(1) NOT NULL,
PRIMARY KEY (`pk_supplier_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `supplier_info`
--

--
-- Constraints for dumped tables
--

--
-- Constraints for table `branch_info`
--
ALTER TABLE `branch_info`
ADD CONSTRAINT `FK_branch_info_company_info` FOREIGN KEY (`fk_company_id`) REFERENCES `company_info` (`pk_company_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `inventory`
--
ALTER TABLE `inventory`
ADD CONSTRAINT `FK_inventory_branch_info` FOREIGN KEY (`fk_branch_id`) REFERENCES `branch_info` (`pk_branch_id`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `FK_inventory_company_info` FOREIGN KEY (`fk_company_id`) REFERENCES `company_info` (`pk_company_id`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `FK_inventory_product_info` FOREIGN KEY (`fk_product_id`) REFERENCES `product_info` (`pk_product_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `product_supplier`
--
ALTER TABLE `product_supplier`
ADD CONSTRAINT `FK_product_supplier_product_info` FOREIGN KEY (`fk_product_id`) REFERENCES `product_info` (`pk_product_id`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `FK_product_supplier_supplier_info` FOREIGN KEY (`fk_supplier_id`) REFERENCES `supplier_info` (`pk_supplier_id`) ON DELETE CASCADE ON UPDATE CASCADE;

PHP TUTOR

2011-08-17T21:37:00.000-07:00

What is PHP?
PHP is one of the langauge for Web Programming.
It is used to develop dynamic web sites like Online shopping, Exam results and railway reservation.

What is Know as Dynamic web Pages and static web Page? (Basic)
Dyanmic Web Site :
Web Page Content is taken and displayed from database, It is Dynamic Content.
Example : Exam Results. Here student info and marks are taken from database.

Static Web Site :
In web Page, Content is entered in web page it self is known as static content.
Example : About us, Contact us pages in web site.

What is Database commonly used for PHP and WHY? (Basic)
MYSQL because it is open source.

Eclipse weblogic Debug Setup

2010-05-25T03:55:00.000-07:00

Debugging WebLogic

Debugging WebLogic is no different than debugging any other Java remote application. You need to make sure to launch it with the required debugging arguments and attach a debugger. In the case of WebLogic 8.1, you need to add these arguments to the startup script. WebLogic comes with several launch scripts (*.sh and *.cmd) under BEA_HOME/weblogic81/server/bin.

1. Locate startWSL.cmd and add the following variable DEBUG_OPTS:
set DEBUG_OPTS = -Xdebug -Xrunjdwp:transport= dt_socket,address=1044,server=y,suspend=n

2. Next, insert the new variable to the WebLogic startup command, after "%JAVA_HOME%\bin\java" and preferably before the other options.

3. Your startup script should look like:
"%JAVA_HOME%\bin\java" %DEBUG_OPTS% %JAVA_VM% %MEM_ARGS% %JAVA_OPTIONS%-Dweblogic.Name=%SERVER_NAME% -Dweblogic.management.username= %WLS_USER%-Dweblogic.management.password= %WLS_PW% -Dweblogic.management.server= %ADMIN_URL%-Dweblogic.ProductionModeEnabled= %PRODUCTION_MODE%-Djava.security.policy= "%WL_HOME%\server\lib\weblogic.policy" weblogic.Server

SCEA Useful Links

2010-03-20T21:13:00.000-07:00

SCEA Useful Links

Thread _ Notes

2009-12-12T09:33:00.000-08:00

Threads can be created by extending Thread and overriding the
public void run() method.
q Thread objects can also be created by calling the Thread constructor that
takes a Runnable argument. The Runnable object is said to be the target of
the thread.
q You can call start() on a Thread object only once. If start() is called
more than once on a Thread object, it will throw a RuntimeException.
q It is legal to create many Thread objects using the same Runnable object as
the target.
q When a Thread object is created, it does not become a thread of execution
until its start() method is invoked. When a Thread object exists but hasn't
been started, it is in the new state and is not considered alive.
Transitioning Between Thread States (Objective 4.2)
q Once a new thread is started, it will always enter the runnable state.
q The thread scheduler can move a thread back and forth between the
runnable state and the running state.
q For a typical single-processor machine, only one thread can be running at a
time, although many threads may be in the runnable state.
q There is no guarantee that the order in which threads were started
determines the order in which they'll run.
q There's no guarantee that threads will take turns in any fair way. It's up
to the thread scheduler, as determined by the particular virtual machine
implementation. If you want a guarantee that your threads will take turns
regardless of the underlying JVM, you can use the sleep() method. This
prevents one thread from hogging the running process while another thread
starves. (In most cases, though, yield() works well enough to encourage
your threads to play together nicely.)
q A running thread may enter a blocked/waiting state by a wait(), sleep(),
or join() call.
3
q A running thread may enter a blocked/waiting state because it can't acquire
the lock for a synchronized block of code.
q When the sleep or wait is over, or an object's lock becomes available, the
thread can only reenter the runnable state. It will go directly from waiting to
running (well, for all practical purposes anyway).
q A dead thread cannot be started again.
Sleep, Yield, and Join (Objective 4.2)
q Sleeping is used to delay execution for a period of time, and no locks are
released when a thread goes to sleep.
q A sleeping thread is guaranteed to sleep for at least the time specified in
the argument to the sleep() method (unless it's interrupted), but there is
no guarantee as to when the newly awakened thread will actually return to
running.
q The sleep() method is a static method that sleeps the currently executing
thread's state. One thread cannot tell another thread to sleep.
q The setPriority() method is used on Thread objects to give threads
a priority of between 1 (low) and 10 (high), although priorities are not
guaranteed, and not all JVMs recognize 10 distinct priority levels—some
levels may be treated as effectively equal.
q If not explicitly set, a thread's priority will have the same priority as the
priority of the thread that created it.
q The yield() method may cause a running thread to back out if there are
runnable threads of the same priority. There is no guarantee that this will
happen, and there is no guarantee that when the thread backs out there
will be a different thread selected to run. A thread might yield and then
immediately reenter the running state.
q The closest thing to a guarantee is that at any given time, when a thread
is running it will usually not have a lower priority than any thread in the
runnable state. If a low-priority thread is running when a high-priority thread
enters runnable, the JVM will usually preempt the running low-priority
thread and put the high-priority thread in.
q When one thread calls the join() method of another thread, the currently
running thread will wait until the thread it joins with has completed. Think
of the join() method as saying, "Hey thread, I want to join on to the end
of you. Let me know when you're done, so I can enter the runnable state."
Two-Minute Drill 731
732 Chapter 9: Threads
Concurrent Access Problems and Synchronized Threads (Obj. 4.3)
q synchronized methods prevent more than one thread from accessing an
object's critical method code simultaneously.
q You can use the synchronized keyword as a method modifier, or to start a
synchronized block of code.
q To synchronize a block of code (in other words, a scope smaller than the
whole method), you must specify an argument that is the object whose lock
you want to synchronize on.
q While only one thread can be accessing synchronized code of a particular
instance, multiple threads can still access the same object's unsynchronized code.
q When a thread goes to sleep, its locks will be unavailable to other threads.
q static methods can be synchronized, using the lock from the
java.lang.Class instance representing that class.
Communicating with Objects by Waiting and Notifying (Obj. 4.4)
q The wait() method lets a thread say, "there's nothing for me to do now, so
put me in your waiting pool and notify me when something happens that I
care about." Basically, a wait() call means "wait me in your pool," or "add
me to your waiting list."
q The notify() method is used to send a signal to one and only one of the
threads that are waiting in that same object's waiting pool.
q The notify() method can NOT specify which waiting thread to notify.
q The method notifyAll() works in the same way as notify(), only it sends
the signal to all of the threads waiting on the object.
q All three methods—wait(), notify(), and notifyAll()—must be
called from within a synchronized context! A thread invokes wait() or
notify() on a particular object, and the thread must currently hold the lock
on that object.
Deadlocked Threads (Objective 4.4)
q Deadlocking is when thread execution grinds to a halt because the code is
waiting for locks to be removed from objects.
q Deadlocking can occur when a locked object attempts to access another
locked object that is trying to access the first locked object. In other words,
both threads are waiting for each other's locks to be released; therefore, the
locks will never be released!
q Deadlocking is bad. Don't do it.

SCJP 5.0 Syllabus

2009-12-08T20:22:00.000-08:00

Objectives

Section 1: Declarations, Initialization and Scoping

· Develop code that declares classes (including abstract and all forms of nested classes), interfaces, and enums, and includes the appropriate use of package and import statements (including static imports).
· Develop code that declares an interface. Develop code that implements or extends one or more interfaces. Develop code that declares an abstract class. Develop code that extends an abstract class.
· Develop code that declares, initializes, and uses primitives, arrays, enums, and objects as static, instance, and local variables. Also, use legal identifiers for variable names.
· Given a code example, determine if a method is correctly overriding or overloading another method, and identify legal return values (including covariant returns), for the method.
· Given a set of classes and superclasses, develop constructors for one or more of the classes. Given a class declaration, determine if a default constructor will be created, and if so, determine the behavior of that constructor. Given a nested or non-nested class listing, write code to instantiate the class.

Section 2: Flow Control

· Develop code that implements an if or switch statement; and identify legal argument types for these statements.
· Develop code that implements all forms of loops and iterators, including the use of for, the enhanced for loop (for-each), do, while, labels, break, and continue; and explain the values taken by loop counter variables during and after loop execution.
· Develop code that makes use of assertions, and distinguish appropriate from inappropriate uses of assertions.
· Develop code that makes use of exceptions and exception handling clauses (try, catch, finally), and declares methods and overriding methods that throw exceptions.
· Recognize the effect of an exception arising at a specified point in a code fragment. Note that the exception may be a runtime exception, a checked exception, or an error.
· Recognize situations that will result in any of the following being thrown: ArrayIndexOutOfBoundsException,ClassCastException, IllegalArgumentException, IllegalStateException, NullPointerException, NumberFormatException, AssertionError, ExceptionInInitializerError, StackOverflowError or NoClassDefFoundError. Understand which of these are thrown by the virtual machine and recognize situations in which others should be thrown programatically.

Section 3: API Contents

· Develop code that uses the primitive wrapper classes (such as Boolean, Character, Double, Integer, etc.), and/or autoboxing & unboxing. Discuss the differences between the String, StringBuilder, and StringBuffer classes.
· Given a scenario involving navigating file systems, reading from files, or writing to files, develop the correct solution using the following classes (sometimes in combination), from java.io: BufferedReader,BufferedWriter, File, FileReader, FileWriter and PrintWriter.
· Use standard J2SE APIs in the java.text package to correctly format or parse dates, numbers, and currency values for a specific locale; and, given a scenario, determine the appropriate methods to use if you want to use the default locale or a specific locale. Describe the purpose and use of the java.util.Locale class.
· Write code that uses standard J2SE APIs in the java.util and java.util.regex packages to format or parse strings or streams. For strings, write code that uses the Pattern and Matcher classes and the String.split method. Recognize and use regular expression patterns for matching (limited to: . (dot), * (star), + (plus), ?, \d, \s, \w, [], ()). The use of *, +, and ? will be limited to greedy quantifiers, and the parenthesis operator will only be used as a grouping mechanism, not for capturing content during matching. For streams, write code using the Formatter and Scanner classes and the PrintWriter.format/printf methods. Recognize and use formatting parameters (limited to: %b, %c, %d, %f, %s) in format strings.

Section 4: Concurrency

· Write code to define, instantiate, and start new threads using both java.lang.Thread and java.lang.Runnable.
· Recognize the states in which a thread can exist, and identify ways in which a thread can transition from one state to another.
· Given a scenario, write code that makes appropriate use of object locking to protect static or instance variables from concurrent access problems.

Section 5: OO Concepts

· Develop code that implements tight encapsulation, loose coupling, and high cohesion in classes, and describe the benefits.
· Given a scenario, develop code that demonstrates the use of polymorphism. Further, determine when casting will be necessary and recognize compiler vs. runtime errors related to object reference casting.
· Explain the effect of modifiers on inheritance with respect to constructors, instance or static variables, and instance or static methods.
· Given a scenario, develop code that declares and/or invokes overridden or overloaded methods and code that declares and/or invokes superclass or overloaded constructors.
· Develop code that implements "is-a" and/or "has-a" relationships.

Section 6: Collections / Generics

· Given a design scenario, determine which collection classes and/or interfaces should be used to properly implement that design, including the use of the Comparable interface.
· Distinguish between correct and incorrect overrides of corresponding hashCode and equals methods, and explain the difference between == and the equals method.
· Write code that uses the generic versions of the Collections API, in particular, the Set, List, and Map interfaces and implementation classes. Recognize the limitations of the non-generic Collections API and how to refactor code to use the generic versions.
· Develop code that makes proper use of type parameters in class/interface declarations, instance variables, method arguments, and return types; and write generic methods or methods that make use of wildcard types and understand the similarities and differences between these two approaches.
· Use capabilities in the java.util package to write code to manipulate a list by sorting, performing a binary search, or converting the list to an array. Use capabilities in the java.util package to write code to manipulate an array by sorting, performing a binary search, or converting the array to a list. Use the java.util.Comparator and java.lang.Comparable interfaces to affect the sorting of lists and arrays. Furthermore, recognize the effect of the "natural ordering" of primitive wrapper classes and java.lang.String on sorting.

Section 7: Fundamentals

· Given a code example and a scenario, write code that uses the appropriate access modifiers, package declarations, and import statements to interact with (through access or inheritance) the code in the example.
· Given an example of a class and a command-line, determine the expected runtime behavior.
· Determine the effect upon object references and primitive values when they are passed into methods that perform assignments or other modifying operations on the parameters.
· Given a code example, recognize the point at which an object becomes eligible for garbage collection, and determine what is and is not guaranteed by the garbage collection system. Recognize the behaviors of System.gc and finalization.
· Given the fully-qualified name of a class that is deployed inside and/or outside a JAR file, construct the appropriate directory structure for that class. Given a code example and a classpath, determine whether the classpath will allow the code to compile successfully.
· Write code that correctly applies the appropriate operators including assignment operators (limited to: =, +=, -=), arithmetic operators (limited to: +, -, *, /, %, ++, --), relational operators (limited to: <, <=, >, >=, ==, !=), the instanceof operator, logical operators (limited to: &, |, ^, !, &&, ||), and the conditional operator ( ? : ), to produce a desired result. Write code that determines the equality of two objects or two primitives.

reference : http://java.sun.com/docs/books/tutorial/extra/certification/index.html

Design Pattern - Java

2009-11-28T23:56:00.000-08:00

Creational Patterns
Factory Pattern :
Used to create Object Through an interface

Abstract Factory Pattern :
Create an instance of several families of subclasses, It is one more level of abstraction in Factory Pattern

Singleton Pattern :
A class produces only a single instance of its

Builder Pattern :

Prototype Pattern : A pttern to clone an fully initialised object.

Structural Patterns

Adapter Pattern :

A class which connects unrelated classes through interfaces.

Bridge Pattern :
Interface and its implementation of an object is separateed Here.

Composite Pattern :

Used to defined tree structured objects

Decorator Pattern :

Used to add an object at runtime.

Facade Pattern :

A class whic represent entire sub system

Flyweight Pattern :
Proxy Pattern :

Behavioral Patterns (behavioral pattern can alter the program's running behavior.
)

Chain of Responsibility :
Way of passing a request between a chain of objects : Example Excelption handling.

Command Pattern :
command pattern is a design pattern in which an object is used to represent and encapsulate all the information needed to call a method at a later time

Interpreter Pattern :

Include Language Element in program
Example : "expression ::= plus | minus | variable"

Iterator Pattern :
Used to access collection of object in sequence.

Mediator Pattern :
provides a unified interface to a set of interfaces in a subsystem.

Momento Pattern :

This pattern gets the previous state of an object

Observer Pattern:

A way of notifying change to number of classes

State Pattern :
This pattern is used in computer programming to represent the state of an object. This is a clean way for an object to partially change its type at runtime.

Strategy Pattern :
Encapsulates an algorithm in inside a class.

Template Pattern :
- Define the skeleton of an algorithm in an operation, deferring some steps to subclasses.
- Template Method lets subclasses redefine certain steps of an algorithm without letting them to change the algorithm's structure.

Visitor Pattern :

adds a new operation in a class with out changing the class

j2ee design pattern

2009-11-24T22:29:00.001-08:00

----------------------------------------------------
>>>>>>>>>>>>>>>>Presentation Tier<<<<<<<<<<<<<<<<<<
---------------------------------------------------

Intercepting Filter :
A centralised control which hadles request from the web client.
--------------------------------------------------------------------------------
Front Controller :
A centralized point of contact for handling a request may be useful, for example, to control and log a user's progress through the site.

What is the difference betwenn Intercepting Filter and Front Controller.
--------------------------------------------------------------------------------
Composite View :
A Framework to present content in a single web page, from numerous data sources.
Tiles is a good example for this pattern

Alos it is good to refer this link
http://java.sun.com/blueprints/patterns/CompositeView.html

1. The client requests service

2. After processing the request, MainServlet (the Front Controller) directs the ScreenFlowManager to select the next view

3. The ScreenFlowManager determines the name of the screen to display

4. The request is forwarded to TemplateServlet

5. The TemplateServlet identifies the requested Screen object and stores it in HttpSession

6. The request is forwarded to the template JSP page

7. The template JSP page executes an insert tag

8. The insert tag retrieves the screen from HttpSession

9. The insert tag inserts the content from the URL corresponding to the value of its parameter attribute

10 - 12. The template JSP page executes another insert tag, which inserts the content as in the steps 7 - 9.

13. Template execution is complete, and the server returns the generated response to the client.

--------------------------------------------------------------------------------
View Helper :
Helpers provide a clean separation between presentation and business data by acting as intermediaries between the two
--------------------------------------------------------------------------------
Dispatcher View :
System controls flow of execution and access to presentation processing, which is responsible for generating dynamic content
--------------------------------------------------------------------------------
Service to Worker :
The system controls flow of execution and access to business data, from which it creates presentation content
Refer Link : http://www.corej2eepatterns.com/Patterns/ServiceToWorker.htm
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>Business Tier<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
--------------------------------------------------------------------------------

Business Delegate
The business delegate object abstracts the business services API and provides standard interface to al the client components.
--------------------------------------------------------------------------------
Session Facade :
Use a session bean as a facade to encapsulate the complexity of interactions between the business objects participating in a workflow. The Session Facade manages the business objects, and provides a uniform coarse-grained service access layer to clients.
--------------------------------------------------------------------------------
Service Locator
--------------------------------------------------------------------------------
Transfer Object Assembler :
The Transfer Object Assembler uses Transfer Objects to retrieve data from various business objects and other objects that define the model or part of the model.

--------------------------------------------------------------------------------
Value List Handler
--------------------------------------------------------------------------------
Composite Entity
--------------------------------------------------------------------------------
Transfer Object :

A pattern used to "Application clients need to exchange data with enterprise beans".

or

Transfer object / value object is a plain serializable Java class that represents a snapshot of some server side data, as in the following code example:
--------------------------------------------------------------------------------
>>>>>>>>>>>>>>>>>>>>>>>>>>>>Integration Tier<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
--------------------------------------------------------------------------------
Service Activator :

Enterprise beans and other business services need a way to be activated asynchronously
--------------------------------------------------------------------------------
Data Access Object :

A Pattern which abstracts and encapsulate all access to the database.The DAO manages the connection with the data source to obtain and store data.

Access to persistent storage, such as to a database, varies greatly depending on the type of storage (relational databases, object-oriented databases, flat files, and so forth) and the vendor implementation.

AJAX with EXCEL POI Import

2009-11-13T00:11:00.000-08:00

Import EXCEL Data into Table using POI:
<%@page import="org.apache.poi.poifs.filesystem.POIFSFileSystem"%>
<%@page import="java.io.*"%>
<%@page import="java.sql.*"%>
<%@page import="org.apache.poi.hssf.usermodel.*"%>
<html>
<body>

<%

String DRIVER = "org.gjt.mm.mysql.Driver";
Class.forName(DRIVER).newInstance();

String sql="";
Connection con=null;
ResultSet rst=null;
Statement stmt=null;

try{
String url="jdbc:mysql://localhost/csr?user=root&password=";

con=DriverManager.getConnection(url);

stmt=con.createStatement();

//==========
POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream("D:\\ABC.xls"));
HSSFWorkbook wb = new HSSFWorkbook(fs);
HSSFSheet sheet = wb.getSheetAt(0);
HSSFRow row;
HSSFCell cell;

int rows; // No of rows
rows = sheet.getPhysicalNumberOfRows();

int cols = 0; // No of columns
int tmp = 0;
out.println("<table border=1>");
// This trick ensures that we get the data properly even if it doesnâ??t start from first few rows
for(int i = 0; i < rows; i++)
{
row = sheet.getRow(i);
if(row != null)
{
tmp = sheet.getRow(i).getPhysicalNumberOfCells();
if(tmp > cols) cols = tmp;
}

else
{
out.println("ROW is null"+ i+"<BR>");
}

}

out.println("Total Row "+rows+"<BR>");

for(int r = 1; r < rows; r++)
{
out.println("Row "+r+"<BR>");
sql = "insert into csr_mst values (";
row = sheet.getRow(r);
if(row != null)
{
// out.println("<tr><td>"+row.getRowNum()+"</td>");

for(int c = 0; c < cols; c++)
{

cell = row.getCell((short)c);
if(cell == null)
{
sql = sql + "'',";
}
else if(cell != null)
{
// Your code here
// s = cell.getData();
// out.println("<td>");
//out.println(cell);

String cellValue = cell.toString();
CharSequence singleQuote = "'";
CharSequence singleQuoteReplace = "`";
if(cellValue.contains("'"))
{
cellValue = cellValue.replace(singleQuote,singleQuoteReplace);

}
sql = sql + "'"+cellValue+"',";

//out.println("</td>");
}
}
// out.println("</tr>");
sql = sql.substring(0,sql.length()-1);
sql = sql +")";
out.println("<BR>"+sql+"<BR>");
//stmt.addBatch(sql);
con.setAutoCommit(false);
stmt.execute(sql);
con.commit();
}

}

con.close();
}
catch (BatchUpdateException be) {
out.println(be.getMessage());
//handle batch update exception
int[] counts = be.getUpdateCounts();
for (int i=0; i< counts.length; i++) {
System.out.println("Statement["+i+"] :"+counts[i]);
}
con.rollback();
}
catch (SQLException e) {
out.println(e.getMessage());

//handle SQL exception
con.rollback();
}
catch(Exception ioe)
{
out.println(ioe.getMessage());
ioe.printStackTrace();
}

out.println("</table>");

out.println("ALL Infomrations are updated successfully");

%>
</body>
</html>

Table structure which is being imported :

CREATE TABLE /*!32312 IF NOT EXISTS*/ "csr_mst" (
"ATS_ID" varchar(200) DEFAULT NULL,
"Application_Name" varchar(200) DEFAULT NULL,
"Application_Acronym" varchar(200) DEFAULT NULL,
"Sector" varchar(200) DEFAULT NULL,
"GSC" varchar(200) DEFAULT NULL,
"CSR_Number" varchar(200) DEFAULT NULL,
"Priority" varchar(200) DEFAULT NULL,
"CSR_Title" varchar(1000) DEFAULT NULL,
"Business_Case" longtext,
"Change_Classification" varchar(200) DEFAULT NULL,
"State" varchar(200) DEFAULT NULL,
"Business_Request_Date" varchar(200) DEFAULT NULL,
"Proposal_Approved_Date" varchar(200) DEFAULT NULL,
"Implemented_Canceled_Date" varchar(200) DEFAULT NULL,
"Request_Submitted_Date" varchar(200) DEFAULT NULL,
"ROM" varchar(200) DEFAULT NULL,
"CRB1_Approved_Date" varchar(200) DEFAULT NULL,
"Final_Estimated_Hours" varchar(200) DEFAULT NULL,
"Proposal_Date" varchar(200) DEFAULT NULL,
"Project_Status" varchar(200) DEFAULT NULL,
"GM_Requestor" varchar(200) DEFAULT NULL,
"GM_Requestor_Phone" varchar(200) DEFAULT NULL,
"GM_Requestor_Email" varchar(200) DEFAULT NULL,
"GM_Sustain_Lead" varchar(200) DEFAULT NULL,
"GM_Sustain_Lead_Phone" varchar(200) DEFAULT NULL,
"GM_Sustain_Lead_Email" varchar(200) DEFAULT NULL,
"EDS_Sustain_Lead" varchar(200) DEFAULT NULL,
"EDS_Sustain_Lead_Phone" varchar(200) DEFAULT NULL,
"EDS_Sustain_Lead_Email" varchar(200) DEFAULT NULL,
"Impl_Mgmt_Number" varchar(200) DEFAULT NULL,
"Proposed_Implementation_Date" varchar(200) DEFAULT NULL,
"CRB2_Approved_Date" varchar(200) DEFAULT NULL,
"Comments" longtext,
"Funding_Source" varchar(200) DEFAULT NULL,
"SOX_Impact" varchar(200) DEFAULT NULL,
"Change_Category" varchar(200) DEFAULT NULL,
"SAP_Code" varchar(200) DEFAULT NULL,
"Attachment00" varchar(200) DEFAULT NULL,
"Note00" longtext,
"Attachment01" varchar(200) DEFAULT NULL,
"Note01" longtext,
"Attachment02" varchar(200) DEFAULT NULL,
"Note02" longtext,
"Attachment03" varchar(200) DEFAULT NULL,
"Note03" longtext,
"Attachment04" varchar(200) DEFAULT NULL,
"Note04" longtext,
"Attachment05" varchar(200) DEFAULT NULL,
"Note05" longtext
) /*!40100 DEFAULT CHARSET=latin1*/;

#
# Dumping data for table 'csr_mst'
#

LOCK TABLES "csr_mst" WRITE;
/*!40000 ALTER TABLE "csr_mst" DISABLE KEYS;*/
REPLACE INTO "csr_mst" ("ATS_ID", "Application_Name", "Application_Acronym", "Sector", "GSC", "CSR_Number", "Priority", "CSR_Title", "Business_Case", "Change_Classification", "State", "Business_Request_Date", "Proposal_Approved_Date", "Implemented_Canceled_Date", "Request_Submitted_Date", "ROM", "CRB1_Approved_Date", "Final_Estimated_Hours", "Proposal_Date", "Project_Status", "GM_Requestor", "GM_Requestor_Phone", "GM_Requestor_Email", "GM_Sustain_Lead", "GM_Sustain_Lead_Phone", "GM_Sustain_Lead_Email", "EDS_Sustain_Lead", "EDS_Sustain_Lead_Phone", "EDS_Sustain_Lead_Email", "Impl_Mgmt_Number", "Proposed_Implementation_Date", "CRB2_Approved_Date", "Comments", "Funding_Source", "SOX_Impact", "Change_Category", "SAP_Code", "Attachment00", "Note00", "Attachment01", "Note01", "Attachment02", "Note02", "Attachment03", "Note03", "Attachment04", "Note04", "Attachment05", "Note05") VALUES
('2704.0','SAP Compass','SAP Finance,
PRIDE','GMAP','20','8410.0','14.0','Confiigeration for ZPRC to operated for HNZ','HNZ currently updates the Condition Records Manually into the different condition types and this can lead to errors.','Business Improvement','Design','23-Jun-2009','07-Jul-2008','','02-Jul-2008','Large','07-Jul-2008','105.0','07-Jul-2008','','Jan Smillie','+64 9 9783643','Jan.Smillie@gm.com','Steven Celar',' +61 3 9038 4666','steven.celar@gm.com','Atul Gokhale','020-66069000','atul.gokhale@eds.com','','','07-Jul-2008','"18 Nov - Awaiting resourcing at completion of CR 8923.
07 Nov - This CR is necessary before an important change to DDR payments (CR being drafted by HNZ). Priority increased to 1.4
02 Sep - Placed on hold at GM request, pending refinement of business reqts.
29 Jul - Grant in discussion with Wilhelm/Jan for review of business requirements. Meeting scheduled
07 Jul - ROM submitted"','Discretionary','No','Enhancement','','','0 7/2/2008 It is required that ZPRC program works for HNZ the same way that GMH operates ZPRC, however requires to be altered for HNZ rules.

NZ populates the ZPRC price master tables via an Excel upload file or manual input, including contract table.','','','','','','','','','','');
REPLACE INTO "csr_mst" ("ATS_ID", "Application_Name", "Application_Acronym", "Sector", "GSC", "CSR_Number", "Priority", "CSR_Title", "Business_Case", "Change_Classification", "State", "Business_Request_Date", "Proposal_Approved_Date", "Implemented_Canceled_Date", "Request_Submitted_Date", "ROM", "CRB1_Approved_Date", "Final_Estimated_Hours", "Proposal_Date", "Project_Status", "GM_Requestor", "GM_Requestor_Phone", "GM_Requestor_Email", "GM_Sustain_Lead", "GM_Sustain_Lead_Phone", "GM_Sustain_Lead_Email", "EDS_Sustain_Lead", "EDS_Sustain_Lead_Phone", "EDS_Sustain_Lead_Email", "Impl_Mgmt_Number", "Proposed_Implementation_Date", "CRB2_Approved_Date", "Comments", "Funding_Source", "SOX_Impact", "Change_Category", "SAP_Code", "Attachment00", "Note00", "Attachment01", "Note01", "Attachment02", "Note02", "Attachment03", "Note03", "Attachment04", "Note04", "Attachment05", "Note05") VALUES
('2704.0','SAP Compass','SAP Finance,
PRIDE','GMAP','20','8412.0','12.0','BULLETIN INPUT SCREEN (ZDC1) & ZVI001 TABLES - ADD AUSTRALIAN STATE','The business has made a decision via Sales and Marketing to begin processing bonus bulletin payments across each Australian state .','Business Improvement','Testing','01-Oct-2008','04-Jul-2008','','03-Jul-2008','Small','04-Jul-2008','80.0','04-Jul-2008','','LOU BASCHIERA','+61 3 96472534','lou.baschiera@gm.com','Steven Celar',' +61 3 9038 4666','steven.celar@gm.com','Atul Gokhale','020-66069000','atul.gokhale@eds.com','','','04-Jul-2008','"
15 July- UATTesting in progress
8 july - Issues identified during testing in QBS. Team reviewing the code again.
24 June - Build completed. Stamp Duty Claim amount upload successful. Currently testing the automatic claims process
17 june- SOL prepration in progress.
10 june- Priority moved up to 1.2
03 June - SOL prepartion is in progress.
18-May - Team discussing on requirements of bulletin number validation, upload of stamp duty claim file etc. Design and Build could take longer time as the logic to be built is complex
15-May- Clarified points on claim code maintenance and Aus state as unique key field in custom table. additional requirement of bulletin number also was raised
13 May, 4-May- SOL is under progress. Priority changed from 1.9 to 1.5
29Apr - Team discussed with Lou on 21/04/2009. Additional input of claim code needs to be taken care. Also discussed internally on 22/04/2009. Work in progress
24 Apr - Few modifications recognized in SOL. Also, need few clarifications in the process to make this work
22 Apr- ABAP team is modifying SOL to meet the requirements.
17 Mar - Design underway. prasad is working on Design. As other high priority CR`s are in progress, this will be taken care in parallel.
07 Nov - Impacted by LEPA; no development until 25/01/09.
23 Sep - Coding underway.
16 Sep - Design progressing
01 Sep - Seeking customer feedback on requirements.
18 Aug - Working on design in background
07 Aug - Implementation pending completion of VDC project. Will attempt to work around
05 Aug - Design proceeding
22 Jul - Seeking customer feedback on requirements.
04 Jul - ROM submitted and approved."','Discretionary','No','Enhancement','','','0 7/3/2008 Currently Holden has many bonus driveaway deals. These deals are seperated by Australian state due to onroad costs being different across each state.

We would like the facility to add the Australian state to the bulletin input screen (ZDC1','','1 7/3/2008','','','','','','','','');
REPLACE INTO "csr_mst" ("ATS_ID", "Application_Name", "Application_Acronym", "Sector", "GSC", "CSR_Number", "Priority", "CSR_Title", "Business_Case", "Change_Classification", "State", "Business_Request_Date", "Proposal_Approved_Date", "Implemented_Canceled_Date", "Request_Submitted_Date", "ROM", "CRB1_Approved_Date", "Final_Estimated_Hours", "Proposal_Date", "Project_Status", "GM_Requestor", "GM_Requestor_Phone", "GM_Requestor_Email", "GM_Sustain_Lead", "GM_Sustain_Lead_Phone", "GM_Sustain_Lead_Email", "EDS_Sustain_Lead", "EDS_Sustain_Lead_Phone", "EDS_Sustain_Lead_Email", "Impl_Mgmt_Number", "Proposed_Implementation_Date", "CRB2_Approved_Date", "Comments", "Funding_Source", "SOX_Impact", "Change_Category", "SAP_Code", "Attachment00", "Note00", "Attachment01", "Note01", "Attachment02", "Note02", "Attachment03", "Note03", "Attachment04", "Note04", "Attachment05", "Note05") VALUES
('2704.0','SAP Compass','SAP Finance,
PRIDE','GMAP','20','8640.0','33.0','CLAIMS NOT PAID ON OPTIONS - (ZDC1)','The business is not able to pay dealers any claims relating to options within the ZDC1 bulletin input screen , causing much frustration and disatisfaction amongst the dealer network across Australia','Business Improvement','Workload','01-Oct-2008','05-Aug-2008','','29-Jul-2008','Large','05-Aug-2008','154.5','04-Aug-2008','','LOU BASCHIERA','+61 3 96472534','lou.baschiera@gm.com','Steven Celar',' +61 3 9038 4666','steven.celar@gm.com','Atul Gokhale','020-66069000','atul.gokhale@eds.com','','','05-Aug-2008','"07 Nov - Impacted by LEPA; no development until 25/01/09.
07 Aug - Placed on hold, pending completion of VDC project.
05 Aug - ROM approved
04 Aug - ROM submitted for approval"','Discretionary','No','Enhancement','','','0 7/29/2008 Currently all Vehicles ("VE") and Smartpacks ("SP" ) are loaded to the bulletin input screen and claims are automatically paid if the retail (RETL) records matches the material codes loaded within the bulletin input screen.

Issue is that a','','','','','','','','','','');
REPLACE INTO "csr_mst" ("ATS_ID", "Application_Name", "Application_Acronym", "Sector", "GSC", "CSR_Number", "Priority", "CSR_Title", "Business_Case", "Change_Classification", "State", "Business_Request_Date", "Proposal_Approved_Date", "Implemented_Canceled_Date", "Request_Submitted_Date", "ROM", "CRB1_Approved_Date", "Final_Estimated_Hours", "Proposal_Date", "Project_Status", "GM_Requestor", "GM_Requestor_Phone", "GM_Requestor_Email", "GM_Sustain_Lead", "GM_Sustain_Lead_Phone", "GM_Sustain_Lead_Email", "EDS_Sustain_Lead", "EDS_Sustain_Lead_Phone", "EDS_Sustain_Lead_Email", "Impl_Mgmt_Number", "Proposed_Implementation_Date", "CRB2_Approved_Date", "Comments", "Funding_Source", "SOX_Impact", "Change_Category", "SAP_Code", "Attachment00", "Note00", "Attachment01", "Note01", "Attachment02", "Note02", "Attachment03", "Note03", "Attachment04", "Note04", "Attachment05", "Note05") VALUES
('2704.0','SAP Compass','SAP Finance,
PRIDE','GMAP','20','8748.0','11.0','Create SAP Finance interface to accept SAP Extract file out of LN Sundry Invoicing','Load LN invoice & credit notes into SAP and streamline GMH & HNZ processes.','Business Improvement','Testing','31-Dec-2008','13-Aug-2008','','08-Aug-2008','Small','13-Aug-2008','80.0','12-Aug-2008','','Jan Smillie','+64 9 9783643','Jan.Smillie@gm.com','Steven Celar',' +61 3 9038 4666','steven.celar@gm.com','Atul Gokhale','020-66069000','atul.gokhale@eds.com','','','13-Aug-2008','17 Mar - Customer confirmation that testing will recommence 18/03.
20 Jan - Awaiting UAT.
10 Dec - Testing delayed by CR 9734.
24 Nov - Testing progressing
13 Aug - ROM approved
12 Aug - ROM submitted for approval','Discretionary','No','Enhancement','','','0 8/8/2008 Create a new SAP Finance interface to upload and process a newly generated SAP Extract file out of LN Sundry invoicing.
The SAP Finance interface needs to be able to accept and process a file with the following information:
- Header
- Q','','','','','','','','','','');

<strong>AJAX</strong>

The Ajax technique accomplishes this by using the following technologies:

JavaScript that allows for interaction with the browser and responding to events
The DOM for accessing and manipulating the structure of the HTML of the page
XML, which represents the data passed between the server and client.
An XMLHttpRequest object for asynchronously exchanging the XML data between the client and the server.
The following graphic shows how these technologies work together to update a piece of a page with new data from the server.

Figure 1: General Sequence of Ajax Request

Figure 1 illustrates the following steps in a generalized Ajax request:

The user generates an event, such as by clicking a button. This results in a JavaScript call.
An XMLHttpRequest object is created and configured with a request parameter that includes the ID of the component that generated the event and any value that the user might have entered.
The XMLHttpRequest object makes an asynchronous request to the web server. An object (such as a servlet or listener) receives the request, processes it, and stores any data in the request to the data store. In the case of Ajax-aware JavaServer Faces components, the object that processes the request is a PhaseListener object. We'll cover that more later in the document.
The object that processed the request returns an XML document containing any updates that need to go to the client.
The XMLHttpRequest object receives the XML data, processes it, and updates the HTML DOM representing the page with the new data.

In the below Example

Run ->Call.jsp it invokes db.jsp through Ajax

<strong>
CALL.JSP</strong>

<%@page contentType="text/html"%>


<%@page pageEncoding="UTF-8"%>



<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN""http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>

<script language="javascript" src="ajax.js"></script> .
<meta http-equiv="Content-Type" content="text/html;charset=UTF-8">
<title>JSP Page using AJAX
</title>
</head>
<body>
<form name=testFrm">

Sector : <select name="sector" id="sector">
<option value=''></option>
<option value='GME'>GME</option>
<option value='Corp Finance'>Corp Finance</option>
<option value='GMNA'>GMNA</option>
<option value='Corp Staff - EDES'>Corp Staff - EDES</option>

</select>

Application Acronym :

<select name="application_acronym" id="application_acronym">
<option value=''></option>
<option value='eCVMS'>eCVMS</option>
<option value='vcps'>vcps</option>
<option value='e.VPS'>e.VPS</option>
</select>

State : <select name="state" id="state">
<option value=''></option>
<option value='ROM'>ROM</option>
<option value='Design'>Design</option>
<option value='Workload'>Workload</option>
<option value='Testing'>Testing</option>
<option value='Build'>Build</option>
<option value='Deploy'>Deploy</option>
<option value='On Hold'>On Hold</option>

</select>

ATS No : <input type='text' name="ats_id" id="ats_id"/>
CR#: <input type='text' name="csr_number" id="csr_number"/>
<input id="submit" type="button" value="Submit" onclick="sendRequest('GET','db.jsp')">

<div id="ajax_res"> Please get CR detail by entering the above values
</div>
</form>
</body>
</html>

AJAX.js
=======
function createRequestObject(){
var req; try {
// Firefox, Opera, Safari
req = new XMLHttpRequest();
} catch (e) {
// Internet Explorer
try {
//For IE 6
req = new ActiveXObject("Msxml2.XMLHTTP");
} catch (e) {
try {
//For IE 5
req = new ActiveXObject("Microsoft.XMLHTTP");
} catch (e) {
alert('Your browser is not IE 5 or higher, or Firefox or Safari or Opera');
}
}
}
return req;
}
//Make the XMLHttpRequest Object
var http = createRequestObject();

function sendRequest(method, url){
if(method == 'get' || method == 'GET'){
var ats_id = document.getElementById("ats_id").value;
var sector = document.getElementById("sector").value;
var application_acronym = document.getElementById("application_acronym").value;
var csr_number = document.getElementById("csr_number").value;
var state = document.getElementById("state").value;

url=url+"?ats_id="+ats_id;
url=url+"§or="+sector;
url=url+"&application_acronym="+application_acronym;
url=url+"&csr_number="+csr_number;
url=url+"&state="+state;

url=url+"&sid="+Math.random();
http.open(method,url,true);
http.onreadystatechange = antonyfntest;
http.send(null);}
}
function antonyfntest(){
//alert('Hi Antony');
if(http.readyState == 4 && http.status == 200){
var response = http.responseText;
if(response){
document.getElementById("ajax_res").innerHTML = response;
}
}
}

========

DB.JSP

<%@page import="java.sql.*"%>

<html>
<body>

<table>
<tbody>
<div>
<center>
<%
String ats_id= request.getParameter("ats_id");
String sector= request.getParameter("sector");
String application_acronym = request.getParameter("application_acronym");
String csr_number= request.getParameter("csr_number");
String state= request.getParameter("state");

String sql = null;

/*
out.println("<BR>*******************ats_id*********************==>"+ats_id);
out.println("<BR>*******************sector*********************==>"+sector);
out.println("<BR>*******************application_acronym*********************==>"+application_acronym);
out.println("<BR>*******************csr_number*********************==>"+csr_number);
out.println("<BR>*******************state*********************==>"+state);
*/

String condition = null;
if(ats_id != null || sector != null || application_acronym != null || csr_number != null)
{
condition = " where ";
}

if (ats_id != null && !ats_id.equalsIgnoreCase(""))
{
ats_id = ats_id +".0";
condition = condition + "ats_id ='"+ats_id+"' and ";
}

if (sector != null && !sector.equalsIgnoreCase(""))
{
condition = condition + "sector ='"+sector+"' and ";
}

if (application_acronym != null && !application_acronym.equalsIgnoreCase(""))
{
condition = condition + "application_acronym ='"+application_acronym+"' and ";
}

if (csr_number != null && !csr_number.equalsIgnoreCase(""))
{
csr_number = csr_number+".0";
condition = condition + "csr_number ='"+csr_number+"' and ";
}

if (state != null && !state.equalsIgnoreCase(""))
{
condition = condition + "state ='"+state+"' and";
}

//out.println("Copndtin ="+condition);

if(condition!=null)
{
int len = condition.length();
//out.println("Beforecondition"+condition);
condition = condition.substring(1,len-4);
}
else
{
condition = "";
}

String DRIVER = "org.gjt.mm.mysql.Driver";
Class.forName(DRIVER).newInstance();

Connection con=null;
ResultSet rs=null;
Statement stmt=null;

try{
String url="jdbc:mysql://localhost/csr?user=root&password=";

con=DriverManager.getConnection(url);
stmt=con.createStatement();
sql = "select * from csr_mst " + condition;
rs=stmt.executeQuery(sql);

//out.println("SQL"+sql);

String column="";

ResultSetMetaData rsm =rs.getMetaData();
out.println("<table border=1>");
int cc = rsm.getColumnCount();
System.out.println("running......cnt...."+cc);
int c=1;
String header ="<tr><td>S.No</td>";
for(int i=1;i<=cc;i++)
{
System.out.println("is "+rsm.getColumnName(i));
header = header+"<td>"+rsm.getColumnName(i)+"</td>";

}
header = header+"</tr>";
out.println(header);

int row = 0;
while(rs.next())
{
row= row +1;
System.out.println(row);
out.println("<tr><td>"+row+"</td>");

for(int i=1;i<=cc;i++)
{
//column = column+rs.getString(rsm.getColumnName(i))+"#";
out.println("<td>"+rs.getString(rsm.getColumnName(i))+"</td>");

}
out.println("</tr>");
}

out.println("</table>");

rs.close();
stmt.close();
con.close();
}catch(Exception e){out.println(e.getMessage()+"<BR>"+sql);
}
%>

</tbody>
</table>
</center>
</div>

</body>
</html>

Good Design for your websites

2009-11-10T03:46:00.000-08:00

http://www.multiprobe.com/

Java Interview Question

2009-11-07T21:47:00.000-08:00

Questions:
Core
Type I
1. What is Oops?
2. What is function overloading
3. What is function overriding
4.
Type II
1. What is abstract Class?
2. What is Interface?
3. What is a difference between abstract and interface?
4. What is Vector, Array List?2
5. What is Hash table and Hash map
6. What is StringTokenizer?
7. What is the difference between string and string buffer?
8. What is Exception? How many type of Exceptions
9. What is the difference between compile time exception and run time exception
10. What is synchronization
11.
Type III
1. What is Hash Tree and Hash map?
2. What is IO?
3. What is socket and datagram?
4.

Type IV
1. What is Thread?
2. What is wait, Join, sleep?

DataBase:

Standard Questions:
1. How will you connect to the Database?
2. What is mean by Class.forName, sun.jdbc.odbc
3. What is the difference between prepared statement and callable statement.
4. How many types of dirvers available? *
5. What is difference between statement and prepared statement?
6. What is the difference between executeQuery, executeUpdate and execute.
7. What is ResultSet meta data and database meta data? *
8.
9.

Servlet
1. What is servlet?
2. What is the difference between doGet and doPost?

JSP
1. What are the advantages of the JSP
2. What is difference between include and forward? *
3. What is the difference between sendreaderwrite and forward *
4. What are the implicits objects in JSP
5. How will you handle error page in Java. *
6. What is the difference between page, session, request and application
7. How will you make JSP thread at safe? *
8.

Face to Face Interview Questions:
1. How will setup Tomcat:

HTML ADD Dynamic ROW in table

2009-11-07T05:30:00.000-08:00

Sample table
1

This code is taken from http://www.mredkj.com/tutorials/tableaddrow.html it is an excellent site for DHTML

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
<script language="javascript">

function addRowToTable()
{
var tbl = document.getElementById('tblSample');
var lastRow = tbl.rows.length;
// if there's no header row in the table, then iteration = lastRow + 1
var iteration = lastRow;
var row = tbl.insertRow(lastRow);

// left cell
var cellLeft = row.insertCell(0);
var textNode = document.createTextNode(iteration);
cellLeft.appendChild(textNode);

// right cell
var cellRight = row.insertCell(1);
var el = document.createElement('input');
el.type = 'text';
el.name = 'txtRow' + iteration;
el.id = 'txtRow' + iteration;
el.size = 40;

el.onkeypress = keyPressTest;
cellRight.appendChild(el);

// select cell
var cellRightSel = row.insertCell(2);
var sel = document.createElement('select');
sel.name = 'selRow' + iteration;
sel.options[0] = new Option('text zero', 'value0');
sel.options[1] = new Option('text one', 'value1');
cellRightSel.appendChild(sel);
}
function keyPressTest(e, obj)
{
var validateChkb = document.getElementById('chkValidateOnKeyPress');
if (validateChkb.checked) {
var displayObj = document.getElementById('spanOutput');
var key;
if(window.event) {
key = window.event.keyCode;
}
else if(e.which) {
key = e.which;
}
var objId;
if (obj != null) {
objId = obj.id;
} else {
objId = this.id;
}
displayObj.innerHTML = objId + ' : ' + String.fromCharCode(key);
}
}
function removeRowFromTable()
{
var tbl = document.getElementById('tblSample');
var lastRow = tbl.rows.length;
if (lastRow > 2) tbl.deleteRow(lastRow - 1);
}
function openInNewWindow(frm)
{
// open a blank window
var aWindow = window.open('', 'TableAddRowNewWindow',
'scrollbars=yes,menubar=yes,resizable=yes,toolbar=no,width=400,height=400');

// set the target to the blank window
frm.target = 'TableAddRowNewWindow';

// submit
frm.submit();
}
function validateRow(frm)
{
var chkb = document.getElementById('chkValidate');
if (chkb.checked) {
var tbl = document.getElementById('tblSample');
var lastRow = tbl.rows.length - 1;
var i;
for (i=1; i<=lastRow; i++) {
var aRow = document.getElementById('txtRow' + i);
if (aRow.value.length <= 0) {
alert('Row ' + i + ' is empty');
return;
}
}
}
openInNewWindow(frm);
}

</script>
</HEAD>

<BODY>
<form action="tableaddrow_nw.html" method="get">
<p>
<input type="button" value="Add" onclick="addRowToTable();" />
<input type="button" value="Remove" onclick="removeRowFromTable();" />
<input type="button" value="Submit" onclick="validateRow(this.form);" />
<input type="checkbox" id="chkValidate" /> Validate Submit
</p>
<p>
<input type="checkbox" id="chkValidateOnKeyPress" checked="checked" /> Display OnKeyPress
<span id="spanOutput" style="border: 1px solid #000; padding: 3px;"> </span>
</p>
<table border="1" id="tblSample">
<tr>
<th colspan="3">Sample table</th>
</tr>
<tr>
<td>1</td>
<td><input type="text" name="txtRow1"
id="txtRow1" size="40" onkeypress="keyPressTest(event, this);" /></td>
<td>
<select name="selRow0">
<option value="value0">text zero</option>
<option value="value1">text one</option>
</select>
</td>
</tr>
</table>
</form>

</BODY>
</HTML>

New Document

Good Flash Templates

2009-09-24T00:45:00.000-07:00

http://www.flashvillage.com/ is the best site to view and download Flash Templates

MY Back UP

2009-08-21T10:14:00.000-07:00

PHP BACK UP :

This is only for my reference others dont use it
http://www.efreelearn.com/BCP/test/BCP_CALL_COMMON.html

PHP Oject CODE

// first test simple associative arrays
$memory1 = xdebug_memory_usage( );

$data = array();

for($i=0;$i<1000;$i++) {

$data[] = array(
'property1' => md5(microtime()),
'property2' => md5(microtime()),
'property3' => md5(microtime()),
);

}

$array = xdebug_memory_usage()-$memory1 . "\n";

// Now do the same thing, but with a class..

class Test {

public $property1;
public $property2;
public $property3;

}

$data = array();

$memory1 = xdebug_memory_usage( );

for($i=0;$i<1000;$i++) {

$test = new Test();
$test->property1 = md5(microtime());
$test->property2 = md5(microtime());
$test->property3 = md5(microtime());
$data[] = $test;

}

$object = xdebug_memory_usage()-$memory1;

echo 'Arrays: ' . $array . "\n";
echo 'Objects: ' . $object;

?>

Spring Tutor

2009-08-05T08:57:00.000-07:00

Spring Practical Questions : (reference http://www.java2s.com/Code/Java/Spring/RegexpPointcutExample.htm)
===================
1. What is dependencyInjection explain with Configuration Example?

Instead of a code calls a component a configuration file will be used to call component this is known us dependencyInjection.

- Container Takes care maintainblity of Component. Detail information will updated later.
- Loose coupling exists between Component and Client.

<beans>
<bean class="com.seetab.scar.matchmaker.impl.StudyDaoImpl" id="studyDao">
</beans>

2.How many types of depency Injections are there? Explain with Code.
-Constructor Injection.
-Setter Injection.
-Interface Injection.

3.Please explain the follwing terms in AOP?
a.org.springframework.aop.framework.ProxyFactoryBean - Spring Defined Proxy Bean
b.proxyInterfaces - Defines which interface needs to be called.
c.interceptorNames - Defines which Impl needs to be mapped

<bean id = "beforeCall" class = "com.spring.aop.LogBeforeCallAdvice" />

<bean id = "adderImpl" class = "com.spring.aop.AdderImpl" />

<bean id = "adder" class = "org.springframework.aop.framework.ProxyFactoryBean">
<property name = "proxyInterfaces">
<value>com.spring.aop.Adder</value>
</property>
<property name = "interceptorNames">
<list>
<value>beforeCall</value>
</list>
</property>
<property name = "target">
<ref bean = "adderImpl"/>
</property>
</bean>
4.What is Static Point Cuts (Name Method Match and Regular Expression Point Cuts)?
5.How a constructor values are initialised in IOC or Dependency Injection?
6.What is interceptor Pattern?
7.Please Explain Steps to Integrate spring with Hiberante?
- Required Component : ______.HBM.XML, Configuration.XML (Spring Configuration File)
1)Create Bean ID for DAO or Impl
2)Create Datasource. Note : datasource Name
3)Create Session Factory From
org.springframework.orm.hibernate3.LocalSessionFactoryBean (datasource,mappingreosurces,hibernateproperties are mapped).

8.How the Client Program is defined?
1.Define classpath : ClassPathXmlApplicationContext
2.getBean
3.Assign Bean to DAO
4.Save

9.What is HIbernate Template?

1. What is IOC (or Dependency Injection)?
The basic concept of the Inversion of Control pattern (also known as dependency injection) is that you do not create your objects but describe how they should be created. You don't directly connect your components and services together in code but describe which services are needed by which components in a configuration file. A container (in the case of the Spring framework, the IOC container) is then responsible for hooking it all up.i.e., Applying IoC, objects are given their dependencies at creation time by some external entity that coordinates each object in the system. That is, dependencies are injected into objects. So, IoC means an inversion of responsibility with regard to how an object obtains references to collaborating objects.

2. What are the different types of IOC (dependency injection) ?
There are three types of dependency injection:
Constructor Injection (e.g. Pico container, Spring etc): Dependencies are provided as constructor parameters.
Setter Injection (e.g. Spring): Dependencies are assigned through JavaBeans properties (ex: setter methods).
Interface Injection (e.g. Avalon): Injection is done through an interface.
Note: Spring supports only Constructor and Setter Injection

3. What are the benefits of IOC (Dependency Injection)?
Benefits of IOC (Dependency Injection) are as follows:
Minimizes the amount of code in your application. With IOC containers you do not care about how services are created and how you get references to the ones you need. You can also easily add additional services by adding a new constructor or a setter method with little or no extra configuration.
Make your application more testable by not requiring any singletons or JNDI lookup mechanisms in your unit test cases. IOC containers make unit testing and switching implementations very easy by manually allowing you to inject your own objects into the object under test.
Loose coupling is promoted with minimal effort and least intrusive mechanism. The factory design pattern is more intrusive because components or services need to be requested explicitly whereas in IOC the dependency is injected into requesting piece of code. Also some containers promote the design to interfaces not to implementations design concept by encouraging managed objects to implement a well-defined service interface of your own.
IOC containers support eager instantiation and lazy loading of services. Containers also provide support for instantiation of managed objects, cyclical dependencies, life cycles management, and dependency resolution between managed objects etc.
4. What is Spring ?
Spring is an open source framework created to address the complexity of enterprise application development. One of the chief advantages of the Spring framework is its layered architecture, which allows you to be selective about which of its components you use while also providing a cohesive framework for J2EE application development.

5. What are the advantages of Spring framework?
The advantages of Spring are as follows:
Spring has layered architecture. Use what you need and leave you don't need now.
Spring Enables POJO Programming. There is no behind the scene magic here. POJO programming enables continuous integration and testability.
Dependency Injection and Inversion of Control Simplifies JDBC
Open source and no vendor lock-in.
6. What are features of Spring ?
Lightweight:
spring is lightweight when it comes to size and transparency. The basic version of spring framework is around 1MB. And the processing overhead is also very negligible.
Inversion of control (IOC):
Loose coupling is achieved in spring using the technique Inversion of Control. The objects give their dependencies instead of creating or looking for dependent objects.
Aspect oriented (AOP):
Spring supports Aspect oriented programming and enables cohesive development by separating application business logic from system services.
Container:
Spring contains and manages the life cycle and configuration of application objects.
MVC Framework:
Spring comes with MVC web application framework, built on core Spring functionality. This framework is highly configurable via strategy interfaces, and accommodates multiple view technologies like JSP, Velocity, Tiles, iText, and POI. But other frameworks can be easily used instead of Spring MVC Framework.
Transaction Management:
Spring framework provides a generic abstraction layer for transaction management. This allowing the developer to add the pluggable transaction managers, and making it easy to demarcate transactions without dealing with low-level issues. Spring's transaction support is not tied to J2EE environments and it can be also used in container less environments.
JDBC Exception Handling:
The JDBC abstraction layer of the Spring offers a meaningful exception hierarchy, which simplifies the error handling strategy. Integration with Hibernate, JDO, and iBATIS: Spring provides best Integration services with Hibernate, JDO and iBATIS
7. How many modules are there in Spring? What are they?
(Roll over to view the Image )

Spring comprises of seven modules. They are..
The core container:
The core container provides the essential functionality of the Spring framework. A primary component of the core container is the BeanFactory, an implementation of the Factory pattern. The BeanFactory applies the Inversion of Control (IOC) pattern to separate an application's configuration and dependency specification from the actual application code.
Spring context:
The Spring context is a configuration file that provides context information to the Spring framework. The Spring context includes enterprise services such as JNDI, EJB, e-mail, internalization, validation, and scheduling functionality.
Spring AOP:
The Spring AOP module integrates aspect-oriented programming functionality directly into the Spring framework, through its configuration management feature. As a result you can easily AOP-enable any object managed by the Spring framework. The Spring AOP module provides transaction management services for objects in any Spring-based application. With Spring AOP you can incorporate declarative transaction management into your applications without relying on EJB components.
Spring DAO:
The Spring JDBC DAO abstraction layer offers a meaningful exception hierarchy for managing the exception handling and error messages thrown by different database vendors. The exception hierarchy simplifies error handling and greatly reduces the amount of exception code you need to write, such as opening and closing connections. Spring DAO's JDBC-oriented exceptions comply to its generic DAO exception hierarchy.
Spring ORM:
The Spring framework plugs into several ORM frameworks to provide its Object Relational tool, including JDO, Hibernate, and iBatis SQL Maps. All of these comply to Spring's generic transaction and DAO exception hierarchies.
Spring Web module:
The Web context module builds on top of the application context module, providing contexts for Web-based applications. As a result, the Spring framework supports integration with Jakarta Struts. The Web module also eases the tasks of handling multi-part requests and binding request parameters to domain objects.
Spring MVC framework:
The Model-View-Controller (MVC) framework is a full-featured MVC implementation for building Web applications. The MVC framework is highly configurable via strategy interfaces and accommodates numerous view technologies including JSP, Velocity, Tiles, iText, and POI.
8. What are the types of Dependency Injection Spring supports?>
Setter Injection:
Setter-based DI is realized by calling setter methods on your beans after invoking a no-argument constructor or no-argument static factory method to instantiate your bean.
Constructor Injection:
Constructor-based DI is realized by invoking a constructor with a number of arguments, each representing a collaborator.
9. What is Bean Factory ?
A BeanFactory is like a factory class that contains a collection of beans. The BeanFactory holds Bean Definitions of multiple beans within itself and then instantiates the bean whenever asked for by clients.
BeanFactory is able to create associations between collaborating objects as they are instantiated. This removes the burden of configuration from bean itself and the beans client.
BeanFactory also takes part in the life cycle of a bean, making calls to custom initialization and destruction methods.

10. What is Application Context?
A bean factory is fine to simple applications, but to take advantage of the full power of the Spring framework, you may want to move up to Springs more advanced container, the application context. On the surface, an application context is same as a bean factory.Both load bean definitions, wire beans together, and dispense beans upon request. But it also provides:
A means for resolving text messages, including support for internationalization.
A generic way to load file resources.
Events to beans that are registered as listeners.

11. What is the difference between Bean Factory and Application Context ?
On the surface, an application context is same as a bean factory. But application context offers much more..
Application contexts provide a means for resolving text messages, including support for i18n of those messages.
Application contexts provide a generic way to load file resources, such as images.
Application contexts can publish events to beans that are registered as listeners.
Certain operations on the container or beans in the container, which have to be handled in a programmatic fashion with a bean factory, can be handled declaratively in an application context.
ResourceLoader support: Spring’s Resource interface us a flexible generic abstraction for handling low-level resources. An application context itself is a ResourceLoader, Hence provides an application with access to deployment-specific Resource instances.
MessageSource support: The application context implements MessageSource, an interface used to obtain localized messages, with the actual implementation being pluggable
12. What are the common implementations of the Application Context ?
The three commonly used implementation of 'Application Context' are
ClassPathXmlApplicationContext : It Loads context definition from an XML file located in the classpath, treating context definitions as classpath resources. The application context is loaded from the application's classpath by using the code .ApplicationContext context = new ClassPathXmlApplicationContext("bean.xml");
FileSystemXmlApplicationContext : It loads context definition from an XML file in the filesystem. The application context is loaded from the file system by using the code . ApplicationContext context = new FileSystemXmlApplicationContext("bean.xml");
XmlWebApplicationContext : It loads context definition from an XML file contained within a web application.

13. How is a typical spring implementation look like ?
For a typical Spring Application we need the following files:
An interface that defines the functions.
An Implementation that contains properties, its setter and getter methods, functions etc.,
Spring AOP (Aspect Oriented Programming)
A XML file called Spring configuration file.
Client program that uses the function.
14. What is the typical Bean life cycle in Spring Bean Factory Container ?
Bean life cycle in Spring Bean Factory Container is as follows:
The spring container finds the bean’s definition from the XML file and instantiates the bean.
Using the dependency injection, spring populates all of the properties as specified in the bean definition
If the bean implements the BeanNameAware interface, the factory calls setBeanName() passing the bean’s ID.
If the bean implements the BeanFactoryAware interface, the factory calls setBeanFactory(), passing an instance of itself.
If there are any BeanPostProcessors associated with the bean, their post- ProcessBeforeInitialization() methods will be called.
If an init-method is specified for the bean, it will be called.
Finally, if there are any BeanPostProcessors associated with the bean, their postProcessAfterInitialization() methods will be called.

15. What do you mean by Bean wiring ?
The act of creating associations between application components (beans) within the Spring container is reffered to as Bean wiring.
16. What do you mean by Auto Wiring?
The Spring container is able to autowire relationships between collaborating beans. This means that it is possible to automatically let Spring resolve collaborators (other beans) for your bean by inspecting the contents of the BeanFactory. The autowiring functionality has five modes.
no
byName
byType
constructor
autodirect
17. What is DelegatingVariableResolver?
Spring provides a custom JavaServer Faces VariableResolver implementation that extends the standard Java Server Faces managed beans mechanism which lets you use JSF and Spring together. This variable resolver is called as DelegatingVariableResolver

18. How to integrate Java Server Faces (JSF) with Spring?
JSF and Spring do share some of the same features, most noticeably in the area of IOC services. By declaring JSF managed-beans in the faces-config.xml configuration file, you allow the FacesServlet to instantiate that bean at startup. Your JSF pages have access to these beans and all of their properties.We can integrate JSF and Spring in two ways:
DelegatingVariableResolver: Spring comes with a JSF variable resolver that lets you use JSF and Spring together.

org.springframework.web.jsf.DelegatingVariableResolver

The DelegatingVariableResolver will first delegate value lookups to the default resolver of the underlying JSF implementation, and then to Spring's 'business context' WebApplicationContext. This allows one to easily inject dependencies into one's JSF-managed beans.
FacesContextUtils:custom VariableResolver works well when mapping one's properties to beans in faces-config.xml, but at times one may need to grab a bean explicitly. The FacesContextUtils class makes this easy. It is similar to WebApplicationContextUtils, except that it takes a FacesContext parameter rather than a ServletContext parameter.
ApplicationContext ctx = FacesContextUtils.getWebApplicationContext(FacesContext.getCurrentInstance());
19. What is Java Server Faces (JSF) - Spring integration mechanism?
Spring provides a custom JavaServer Faces VariableResolver implementation that extends the standard JavaServer Faces managed beans mechanism. When asked to resolve a variable name, the following algorithm is performed:
Does a bean with the specified name already exist in some scope (request, session, application)? If so, return it
Is there a standard JavaServer Faces managed bean definition for this variable name? If so, invoke it in the usual way, and return the bean that was created.
Is there configuration information for this variable name in the Spring WebApplicationContext for this application? If so, use it to create and configure an instance, and return that instance to the caller.
If there is no managed bean or Spring definition for this variable name, return null instead.
BeanFactory also takes part in the life cycle of a bean, making calls to custom initialization and destruction methods.
As a result of this algorithm, you can transparently use either JavaServer Faces or Spring facilities to create beans on demand.

20. What is Significance of JSF- Spring integration ?
Spring - JSF integration is useful when an event handler wishes to explicitly invoke the bean factory to create beans on demand, such as a bean that encapsulates the business logic to be performed when a submit button is pressed.

21. How to integrate your Struts application with Spring?
To integrate your Struts application with Spring, we have two options:
Configure Spring to manage your Actions as beans, using the ContextLoaderPlugin, and set their dependencies in a Spring context file.
Subclass Spring's ActionSupport classes and grab your Spring-managed beans explicitly using a getWebApplicationContext() method.
22. What are ORM’s Spring supports ?
Spring supports the following ORM’s :
Hibernate
iBatis
JPA (Java Persistence API)
TopLink
JDO (Java Data Objects)
OJB
23. What are the ways to access Hibernate using Spring ?
There are two approaches to Spring’s Hibernate integration:
Inversion of Control with a HibernateTemplate and Callback
Extending HibernateDaoSupport and Applying an AOP Interceptor
24. How to integrate Spring and Hibernate using HibernateDaoSupport?
Spring and Hibernate can integrate using Spring’s SessionFactory called LocalSessionFactory. The integration process is of 3 steps.
Configure the Hibernate SessionFactory
Extend your DAO Implementation from HibernateDaoSupport
Wire in Transaction Support with AOP

25. What are Bean scopes in Spring Framework ?
The Spring Framework supports exactly five scopes (of which three are available only if you are using a web-aware ApplicationContext). The scopes supported are listed below:
Scope
Description
singleton
Scopes a single bean definition to a single object instance per Spring IoC container.
prototype
Scopes a single bean definition to any number of object instances.
request
Scopes a single bean definition to the lifecycle of a single HTTP request; that is each and every HTTP request will have its own instance of a bean created off the back of a single bean definition. Only valid in the context of a web-aware Spring ApplicationContext.
session
Scopes a single bean definition to the lifecycle of a HTTP Session. Only valid in the context of a web-aware Spring ApplicationContext.
global session
Scopes a single bean definition to the lifecycle of a global HTTP Session. Typically only valid when used in a portlet context. Only valid in the context of a web-aware Spring ApplicationContext.

26. What is AOP?
Aspect-oriented programming, or AOP, is a programming technique that allows programmers to modularize crosscutting concerns, or behavior that cuts across the typical divisions of responsibility, such as logging and transaction management. The core construct of AOP is the aspect, which encapsulates behaviors affecting multiple classes into reusable modules.

27. How the AOP used in Spring?
AOP is used in the Spring Framework: To provide declarative enterprise services, especially as a replacement for EJB declarative services. The most important such service is declarative transaction management, which builds on the Spring Framework's transaction abstraction.To allow users to implement custom aspects, complementing their use of OOP with AOP.

28. What do you mean by Aspect ?
A modularization of a concern that cuts across multiple objects. Transaction management is a good example of a crosscutting concern in J2EE applications. In Spring AOP, aspects are implemented using regular classes (the schema-based approach) or regular classes annotated with the @Aspect annotation (@AspectJ style).

29. What do you mean by JointPoint?
A point during the execution of a program, such as the execution of a method or the handling of an exception. In Spring AOP, a join point always represents a method execution.

30. What do you mean by Advice?
Action taken by an aspect at a particular join point. Different types of advice include "around," "before" and "after" advice. Many AOP frameworks, including Spring, model an advice as an interceptor, maintaining a chain of interceptors "around" the join point.

31. What are the types of Advice?
Types of advice:
Before advice: Advice that executes before a join point, but which does not have the ability to prevent execution flow proceeding to the join point (unless it throws an exception).
After returning advice: Advice to be executed after a join point completes normally: for example, if a method returns without throwing an exception.
After throwing advice: Advice to be executed if a method exits by throwing an exception.
After (finally) advice: Advice to be executed regardless of the means by which a join point exits (normal or exceptional return).
Around advice: Advice that surrounds a join point such as a method invocation. This is the most powerful kind of advice. Around advice can perform custom behavior before and after the method invocation. It is also responsible for choosing whether to proceed to the join point or to shortcut the advised method execution by returning its own return value or throwing an exception
32. What are the types of the transaction management Spring supports ?
Spring Framework supports:
Programmatic transaction management.
Declarative transaction management.

33. What are the benefits of the Spring Framework transaction management ?
The Spring Framework provides a consistent abstraction for transaction management that delivers the following benefits:
Provides a consistent programming model across different transaction APIs such as JTA, JDBC, Hibernate, JPA, and JDO.
Supports declarative transaction management.
Provides a simpler API for programmatic transaction management than a number of complex transaction APIs such as JTA.
Integrates very well with Spring's various data access abstractions.

34. Why most users of the Spring Framework choose declarative transaction management ?
Most users of the Spring Framework choose declarative transaction management because it is the option with the least impact on application code, and hence is most consistent with the ideals of a non-invasive lightweight container.

35. Explain the similarities and differences between EJB CMT and the Spring Framework's declarative transaction management ?
The basic approach is similar: it is possible to specify transaction behavior (or lack of it) down to individual method level. It is possible to make a setRollbackOnly() call within a transaction context if necessary. The differences are:
Unlike EJB CMT, which is tied to JTA, the Spring Framework's declarative transaction management works in any environment. It can work with JDBC, JDO, Hibernate or other transactions under the covers, with configuration changes only.
The Spring Framework enables declarative transaction management to be applied to any class, not merely special classes such as EJBs.
The Spring Framework offers declarative rollback rules: this is a feature with no EJB equivalent. Both programmatic and declarative support for rollback rules is provided.
The Spring Framework gives you an opportunity to customize transactional behavior, using AOP. With EJB CMT, you have no way to influence the container's transaction management other than setRollbackOnly().
The Spring Framework does not support propagation of transaction contexts across remote calls, as do high-end application servers.
37. When to use programmatic and declarative transaction management ?
Programmatic transaction management is usually a good idea only if you have a small number of transactional operations. On the other hand, if your application has numerous transactional operations, declarative transaction management is usually worthwhile. It keeps transaction management out of business logic, and is not difficult to configure.

38. Explain about the Spring DAO support ?
The Data Access Object (DAO) support in Spring is aimed at making it easy to work with data access technologies like JDBC, Hibernate or JDO in a consistent way. This allows one to switch between the persistence technologies fairly easily and it also allows one to code without worrying about catching exceptions that are specific to each technology.

google_protectAndRun("ads_core.google_render_ad", google_handleError, google_render_ad);

39. What are the exceptions thrown by the Spring DAO classes ?
Spring DAO classes throw exceptions which are subclasses of DataAccessException(org.springframework.dao.DataAccessException).Spring provides a convenient translation from technology-specific exceptions like SQLException to its own exception class hierarchy with the DataAccessException as the root exception. These exceptions wrap the original exception.

40. What is SQLExceptionTranslator ?
SQLExceptionTranslator, is an interface to be implemented by classes that can translate between SQLExceptions and Spring's own data-access-strategy-agnostic org.springframework.dao.DataAccessException.
41. What is Spring's JdbcTemplate ?
Spring's JdbcTemplate is central class to interact with a database through JDBC. JdbcTemplate provides many convenience methods for doing things such as converting database data into primitives or objects, executing prepared and callable statements, and providing custom database error handling.
JdbcTemplate template = new JdbcTemplate(myDataSource);

42. What is PreparedStatementCreator ?
PreparedStatementCreator:
Is one of the most common used interfaces for writing data to database.
Has one method – createPreparedStatement(Connection)
Responsible for creating a PreparedStatement.
Does not need to handle SQLExceptions.

43. What is SQLProvider ?
SQLProvider:
Has one method – getSql()
Typically implemented by PreparedStatementCreator implementers.
Useful for debugging.

44. What is RowCallbackHandler ?
The RowCallbackHandler interface extracts values from each row of a ResultSet.
Has one method – processRow(ResultSet)
Called for each row in ResultSet.
Typically stateful.

45. What are the differences between EJB and Spring ?
Spring and EJB feature comparison.
Feature
EJB
Spring
Transaction management
Must use a JTA transaction manager.
Supports transactions that span remote method calls.
Supports multiple transaction environments through its PlatformTransactionManager interface, including JTA, Hibernate, JDO, and JDBC.
Does not natively support distributed transactions—it must be used with a JTA transaction manager.
Declarative transaction support
Can define transactions declaratively through the deployment descriptor.
Can define transaction behavior per method or per class by using the wildcard character *.
Cannot declaratively define rollback behavior—this must be done programmatically.
Can define transactions declaratively through the Spring configuration file or through class metadata.
Can define which methods to apply transaction behavior explicitly or by using regular expressions.
Can declaratively define rollback behavior per method and per exception type.
Persistence
Supports programmatic bean-managed persistence and declarative container managed persistence.
Provides a framework for integrating with several persistence technologies, including JDBC, Hibernate, JDO, and iBATIS.
Declarative security
Supports declarative security through users and roles. The management and implementation of users and roles is container specific.
Declarative security is configured in the deployment descriptor.
No security implementation out-of-the box.
Acegi, an open source security framework built on top of Spring, provides declarative security through the Spring configuration file or class metadata.
Distributed computing
Provides container-managed remote method calls.
Provides proxying for remote calls via RMI, JAX-RPC, and web services.

These questions are taken from http://www.developersbook.com/spring/interview-questions/spring-interview-questions-faqs.php

My Questions :

What is Spring ? How it is better than other Framework?
Exlain AOP in detail : What is point cut,How log implemented
what is the difference between ref- Bean and bean-id
What is the difference between Normal Exception and Spring way of exceptionHandling
What are the core components of Spring?
What is AutoWiring?

How to Intergrate Spring with Hibernate?
How to Intergrate Spring with Struts?
How to Intergrate Spring with JSF?

How Transctions are handled in Spring?

Hibernate Practical & Interview Questions

2009-08-04T06:37:00.000-07:00

Hibernate Practical Questions :

1.In which folder hibernate.cfg.xml & ____.hbm.xml will be there?
hibernate.cfg.xml in root folder and ____.hbm.xml will be in Bean Folder.

2)What is the key defines it is a Composite Key?
composite-id

3.What are the Key properties while defining Composite key?
a)Create CompositePK Class
b)Defined parameter in XML
<class name="com.hibernate.composite.Book_info" table="book_info">
<composite-id name="bookPK" class="com.hibernate.composite.BookPK">
<key-property name="book_id" column="book_id" type="string" />
<key-property name="book_name" column="book_name" type="string" />
</composite-id>
<property name="author" column="author" type="string"/>
</class>

c) Send Composite Key values as Object

Hibernate Interview Questions :

Q1. Which statement is correct ?
1 session.contains() method to determine if an instance belongs to the session cache.
2 session.contains() method to determine if an instance belongs to the data base .
3 Both are correct
4 none of the above
4Correct Answer is :

Q2. What does hibernate.show_sql true mean ?
1 show sql results on console.
2 show sql inputs on console.
3 show sql statement on console.
4 None
Correct Answer is : 3

Q3. What is the naming convention for Hibernate XML mapping file extensions?
1 .hbm.xml
2 .hhm.xml
3 .hb.xml
4 none of the above
Correct Answer is : 1

Q4. What does session.createCriteria().uniqueResult() return ?
1 Object
2 String
3 ResultSet
4 HibernateResultSet
Correct Answer is : 1

Q5. ____ forces hibernate to bypass the setter method and access the instance variable directly while initializing a newly loaded object.
1 By mapping the property with access="onlyfield" in Hibernate metadata
2 By mapping the property with access="variable" in Hibernate metadata
3 By mapping the property with access="field" in Hibernate metadata
4 none of the above
Correct Answer is : 3

Q6. What does session.load() return if there is no matching database row ?
1 NULL
2 Empty Object
3 unrecoverable exception
4 None of the above
Correct Answer is : 3

Q7. It is possible to re-load an object and all its collections at any time, using the xxxx() method. This is useful when database triggers are used to initialize some of the properties of the object. What is the xxxx() method ?
1 refresh();
2 flush();
3 fetch();
4 load()
Correct Answer is : 1

Q8. What happens when both hibernate.properties and hibernate.cfg.xml are in the classpath?
1 The settings of the properties file will override the settings used in the XML configuration
2 The settings of the XML configuration file will override the settings used in the properties
3 DuplicateConfigurationException
4 None
Correct Answer is : 2

Q9. What is the naming convention for Hibernate XML mapping file extensions?
1 .hibernate.xml
2 .hbm.xml
3 .hibernate_data.xml
4 none
Correct Answer is : 1

Q10. What is dirty checking in Hibernate?
1 bject state changes in order to synchronize the updated state with the database
2 remove the dirty data from data base.
3 check the data when insert into data base.
4 None
Correct Answer is : 1

Q11. If instances are not in the session or second-level cache which will give better performance?
1 Query.list()
2 Query.iterate()
3 Both are same
4 None of the above
Correct Answer is : 1

Q12. Which fetching strategy tuned query automatically ?
1 session.createQuery();
2 session.createCriteria();
3 session.createSQLQuery();
4 None Of the above
Correct Answer is : 2

Q13. Is Hibernate Session threadsafe?
1 threadsafe
2 not threadsafe
3 No relation to Thread
4 None of the above
Correct Answer is : 2

Q14. In the .bhm.xml file ? ] ]> What is correct way of executipon of the above query in the .bhm.xml file.
1 Query q = sess.getNamedQuery("abc");
2 Query q = sess.createQuery("abc");
3 Query q = sess.createSQLQuery("abc");
4 none of the above
Correct Answer is : 1

Q15. What is Configuration interface in hibernate?
1 used to create SessionFactory.
2 used to create Session.
3 used to create Transaction.
4 none of the above

Correct Answer is : 1

Q16. By default, Hibernate uses _ for JVM-level caching.
1 OSCache
2 EHCache
3 JBOSSCache
4 None of the above

Correct Answer is : 2

Q17. Which Cache Strategy particularly useful in cases where underlying data may have been updated via a separate process (i.e., not modified through Hibernate)?
1 Query.setCacheMode(CacheMode.READ).
2 Query.setCacheMode(CacheMode.REFRESH).
3 Query.setCacheMode(CacheMode.NONE).
4 Query.setCacheMode(CacheMode.REFRESHDATABASE).

Correct Answer is : 2

Q18. What does session.evict() method do ?
1 remove the object and its collections from the first level cache
2 remove the object and its collections from the second level cache
3 remove the object and its collections from the data base
4 None of the above
Correct Answer is : 1

Q19. Is the below code work ? Session session = sessionFactory.openSession(); Transaction tx = session.beginTransaction(); for ( int i=0; i<100000; i++ ) { Customer customer = new Customer(.....); session.save(customer); } tx.commit(); session.close();
1 true
2 false
3 can't say
4 none
Correct Answer is : 2

Q20. SessionFactory represent which level of cache ?
1 2nd
2 Ist
3 3rd
4 4th
Correct Answer is : 1

Q21. How can get a session object ?
1 SessionFactory.getSession();
2 SessionFactory.openSession();
3 SessionFactory.get();
4 (session)SessionFactory.getObject();
Correct Answer is : 2

Q22. To completely evict all objects from the session cache which method is appropriate ?
1 Session.evict()
2 Session.clear()
3 Session.flush()
4 None of the above
Correct Answer is : 2

Hibernate Mock Online test
Q23. What Session.flush() do ?
1 the state of that object will be synchronized with the database.
2 the state of that object will be synchronized with the SessionFactory.
3 remove state of that object from Session.
4 remove state of that object from SessionFactory.
Correct Answer is : 1

Q24. How to create SessionFactory ?
1 configuration.buildSessionFactory();
2 configuration.createSessionFactory();
3 configuration.createNewSessionFactory();
4 none of the above

Correct Answer is : 1

Q25. Difference between Emp e = session.load(Emp.class) and Emp e = session.createCriteria(Emp.class) ?
1 On session close session.load() Emp Object unavilabe to access.
2 On session close session.createCriteria() Emp unavilabe to access.
3 None
4 None
Correct Answer is : 1

Q26. Which statement is correct ?
1 A Session will not obtain a JDBC Connection (or a Datasource) unless it is needed
2 A Session will obtain a JDBC Connection (or a Datasource) on object create
3 A Session has no relation with JDBC Connection (or a Datasource)
4 none of the above
Correct Answer is : 2

Q27. what is the default value in hibernate ?
1 lazy=false;
2 lazy=true;
3 lazy=yes;
4 lazy=no;
You have choosen : 1Correct Answer is : 2You were wrong.
Explanations : null

Q28. Which statement is correct
1 The CacheMode controls how a particular session interacts with the second-level cache.
2 The CacheMode don't controls session interaction with the second-level cache.
3 both
4 none
Correct Answer is : 1

Q29. Which statement is true about session.saveOrUpdate()?
1 if another object associated with the session has the same identifier, throw an exception
2 if the object has no identifier property, save() it
3 Both of the above
4 none of the above
Correct Answer is : 1

Q30. Which statement is correct ?
1 Specifying join as the fetch strategy in the mapping document does affect HQL queries.
2 Specifying join as the fetch strategy in the mapping document does not affect HQL queries.
3 None
4 None
Correct Answer is : 2

HIBERNATE INTERVIEW QUESTION & Practical Questions

2009-08-04T06:35:00.000-07:00

HIBERNATE INTERVIEW QUESTION
Q1. Which statement is correct ?
1 session.contains() method to determine if an instance belongs to the session cache.
2 session.contains() method to determine if an instance belongs to the data base .
3 Both are correct
4 none of the above
You have choosen : 4Correct Answer is : 1You were wrong.

Q2. What does hibernate.show_sql true mean ?
1 show sql results on console.
2 show sql inputs on console.
3 show sql statement on console.
4 None
You have choosen : 3Correct Answer is : 3You were correct.
Explanations : null

Q3. What is the naming convention for Hibernate XML mapping file extensions?
1 .hbm.xml
2 .hhm.xml
3 .hb.xml
4 none of the above
You have choosen : 1Correct Answer is : 1You were correct.
Explanations : null

Q4. What does session.createCriteria().uniqueResult() return ?
1 Object
2 String
3 ResultSet
4 HibernateResultSet
You have choosen : 1Correct Answer is : 1You were correct.
Explanations : null

Q5. ____ forces hibernate to bypass the setter method and access the instance variable directly while initializing a newly loaded object.
1 By mapping the property with access="onlyfield" in Hibernate metadata
2 By mapping the property with access="variable" in Hibernate metadata
3 By mapping the property with access="field" in Hibernate metadata
4 none of the above
You have choosen : 1Correct Answer is : 3You were wrong.
Explanations : null

Q6. What does session.load() return if there is no matching database row ?
1 NULL
2 Empty Object
3 unrecoverable exception
4 None of the above
You have choosen : 1Correct Answer is : 3You were wrong.
Explanations : null

Q7. It is possible to re-load an object and all its collections at any time, using the xxxx() method. This is useful when database triggers are used to initialize some of the properties of the object. What is the xxxx() method ?
1 refresh();
2 flush();
3 fetch();
4 load()
You have choosen : 2Correct Answer is : 1You were wrong.
Explanations : null

Q8. What happens when both hibernate.properties and hibernate.cfg.xml are in the classpath?
1 The settings of the properties file will override the settings used in the XML configuration
2 The settings of the XML configuration file will override the settings used in the properties
3 DuplicateConfigurationException
4 None
You have choosen : 3Correct Answer is : 2You were wrong.
Explanations : null

Q9. What is the naming convention for Hibernate XML mapping file extensions?
1 .hibernate.xml
2 .hbm.xml
3 .hibernate_data.xml
4 none
You have choosen : 2Correct Answer is : 1You were wrong.
Explanations : null

Q10. What is dirty checking in Hibernate?
1 bject state changes in order to synchronize the updated state with the database
2 remove the dirty data from data base.
3 check the data when insert into data base.
4 None
You have choosen : 3Correct Answer is : 1You were wrong.
Explanations : null

Q11. If instances are not in the session or second-level cache which will give better performance?
1 Query.list()
2 Query.iterate()
3 Both are same
4 None of the above
You have choosen : 2Correct Answer is : 1You were wrong.
Explanations : null

Q12. Which fetching strategy tuned query automatically ?
1 session.createQuery();
2 session.createCriteria();
3 session.createSQLQuery();
4 None Of the above
You have choosen : 3Correct Answer is : 2You were wrong.
Explanations : null

Q13. Is Hibernate Session threadsafe?
1 threadsafe
2 not threadsafe
3 No relation to Thread
4 None of the above
You have choosen : 2Correct Answer is : 2You were correct.
Explanations : null

Q14. In the .bhm.xml file ? ] ]> What is correct way of executipon of the above query in the .bhm.xml file.
1 Query q = sess.getNamedQuery("abc");
2 Query q = sess.createQuery("abc");
3 Query q = sess.createSQLQuery("abc");
4 none of the above
You have choosen : 1Correct Answer is : 1You were correct.
Explanations : null

Q15. What is Configuration interface in hibernate?
1 used to create SessionFactory.
2 used to create Session.
3 used to create Transaction.
4 none of the above
You have choosen : 3Correct Answer is : 1You were wrong.
Explanations : null

Q16. By default, Hibernate uses _ for JVM-level caching.
1 OSCache
2 EHCache
3 JBOSSCache
4 None of the above
You have choosen : 1Correct Answer is : 2You were wrong.

Q17. Which Cache Strategy particularly useful in cases where underlying data may have been updated via a separate process (i.e., not modified through Hibernate)?
1 Query.setCacheMode(CacheMode.READ).
2 Query.setCacheMode(CacheMode.REFRESH).
3 Query.setCacheMode(CacheMode.NONE).
4 Query.setCacheMode(CacheMode.REFRESHDATABASE).
You have choosen : 1Correct Answer is : 2You were wrong.
Explanations : null

Q18. What does session.evict() method do ?
1 remove the object and its collections from the first level cache
2 remove the object and its collections from the second level cache
3 remove the object and its collections from the data base
4 None of the above
You have choosen : 2Correct Answer is : 1You were wrong.
Explanations : null

Q19. Is the below code work ? Session session = sessionFactory.openSession(); Transaction tx = session.beginTransaction(); for ( int i=0; i<100000; i++ ) { Customer customer = new Customer(.....); session.save(customer); } tx.commit(); session.close();
1 true
2 false
3 can't say
4 none
You have choosen : 1Correct Answer is : 2You were wrong.
Explanations : null

Q20. SessionFactory represent which level of cache ?
1 2nd
2 Ist
3 3rd
4 4th
You have choosen : 1Correct Answer is : 1You were correct.
Explanations : null

Q21. How can get a session object ?
1 SessionFactory.getSession();
2 SessionFactory.openSession();
3 SessionFactory.get();
4 (session)SessionFactory.getObject();
You have choosen : 1Correct Answer is : 2You were wrong.

Q22. To completely evict all objects from the session cache which method is appropriate ?
1 Session.evict()
2 Session.clear()
3 Session.flush()
4 None of the above
You have choosen : 1Correct Answer is : 2You were wrong.
Explanations : null

Hibernate Mock Online test
Q23. What Session.flush() do ?
1 the state of that object will be synchronized with the database.
2 the state of that object will be synchronized with the SessionFactory.
3 remove state of that object from Session.
4 remove state of that object from SessionFactory.
You have choosen : 3Correct Answer is : 1You were wrong.
Explanations : null

Q24. How to create SessionFactory ?
1 configuration.buildSessionFactory();
2 configuration.createSessionFactory();
3 configuration.createNewSessionFactory();
4 none of the above
You have choosen : 3Correct Answer is : 1You were wrong.
Explanations : null

Q25. Difference between Emp e = session.load(Emp.class) and Emp e = session.createCriteria(Emp.class) ?
1 On session close session.load() Emp Object unavilabe to access.
2 On session close session.createCriteria() Emp unavilabe to access.
3 None
4 None
You have choosen : 1Correct Answer is : 1You were correct.
Explanations : null

Q26. Which statement is correct ?
1 A Session will not obtain a JDBC Connection (or a Datasource) unless it is needed
2 A Session will obtain a JDBC Connection (or a Datasource) on object create
3 A Session has no relation with JDBC Connection (or a Datasource)
4 none of the above
You have choosen : 1Correct Answer is : 1You were correct.

Q27. what is the default value in hibernate ?
1 lazy=false;
2 lazy=true;
3 lazy=yes;
4 lazy=no;
You have choosen : 1Correct Answer is : 2You were wrong.
Explanations : null

Q28. Which statement is correct
1 The CacheMode controls how a particular session interacts with the second-level cache.
2 The CacheMode don't controls session interaction with the second-level cache.
3 both
4 none
You have choosen : 1Correct Answer is : 1You were correct.
Explanations : null

Q29. Which statement is true about session.saveOrUpdate()?
1 if another object associated with the session has the same identifier, throw an exception
2 if the object has no identifier property, save() it
3 Both of the above
4 none of the above
You have choosen : 2Correct Answer is : 1You were wrong.
Explanations : null

Q30. Which statement is correct ?
1 Specifying join as the fetch strategy in the mapping document does affect HQL queries.
2 Specifying join as the fetch strategy in the mapping document does not affect HQL queries.
3 None
4 None
You have choosen : 1Correct Answer is : 2You were wrong.

Free project management Software Links

2009-07-31T11:03:00.000-07:00

VIEW PATH

XML & XSL Advance Example

2009-07-31T10:14:00.000-07:00

<?xml version='1.0'?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="text" omit-xml-declaration="yes"/>

<xsl:template match="/">
<xsl:apply-templates select="GeneralReport/Carlines/Carline/Prices"/>
<xsl:apply-templates select="GeneralReport/Prices"/>
</xsl:template>

<xsl:template match="Prices">
<xsl:apply-templates select="LocalReport"/>
<xsl:apply-templates select="DomesticOptionPrice"/>
<xsl:apply-templates select="ExportModelPrice"/>
<xsl:apply-templates select="ExportOptionPrice"/>
</xsl:template>

<xsl:template match="DomesticOptionPrice">
<xsl:for-each select="Models/Model">
<xsl:apply-templates select="Code"/>
<xsl:apply-templates select="../../Code"/>
<xsl:apply-templates select="../../ORS"/>
<xsl:apply-templates select="Name"/>
<xsl:apply-templates select="../../Name"/>
<xsl:apply-templates select="../../MSRP"/>
<xsl:apply-templates select="../../MSRPNet"/>
<xsl:apply-templates select="../../DealerNet"/>
<xsl:apply-templates select="../../Taxes"/>
<xsl:apply-templates select="../../EffectiveDate"/>
<xsl:apply-templates select="../../MY"/>
<xsl:apply-templates select="../../MYS"/>
<xsl:apply-templates select="../../Carline"/>
<xsl:apply-templates select="../../DealerIndex"/>
<xsl:apply-templates select="../../Currency"/>
<xsl:if test="not(position()=last())">
<xsl:call-template name="newline"/>
</xsl:if>
</xsl:for-each>
<xsl:if test="not(position()=last())">
<xsl:call-template name="newline"/>
</xsl:if>
</xsl:template>

<xsl:template match="ExportOptionPrice">
<xsl:for-each select="Models/Model">
<xsl:apply-templates select="Code"/>
<xsl:apply-templates select="../../Code"/>
<xsl:apply-templates select="../../ORS"/>
<xsl:apply-templates select="Name"/>
<xsl:apply-templates select="../../Name"/>
<xsl:apply-templates select="../../PlantPrice"/>
<xsl:text>+000000000</xsl:text>
<xsl:text>+000000000</xsl:text>
<xsl:apply-templates select="../../Taxes"/>
<xsl:apply-templates select="../../EffectiveDate"/>
<xsl:apply-templates select="../../MY"/>
<xsl:apply-templates select="../../MYS"/>
<xsl:apply-templates select="../../Carline"/>
<xsl:apply-templates select="../../DealerIndex"/>
<xsl:apply-templates select="../../Currency"/>
<xsl:if test="not(position()=last())">
<xsl:call-template name="newline"/>
</xsl:if>
</xsl:for-each>
<xsl:if test="not(position()=last())">
<xsl:call-template name="newline"/>
</xsl:if>
</xsl:template>

<xsl:template match="LocalReport">
<xsl:apply-templates select="Models/Model/Code"/>

<xsl:text> </xsl:text>
<xsl:apply-templates select="ORS"/>
<xsl:apply-templates select="Models/Model/Name"/>

<xsl:text> </xsl:text>
<xsl:apply-templates select="MSRP"/>
<xsl:apply-templates select="MSRPNet"/>
<xsl:apply-templates select="DealerNet"/>
<xsl:apply-templates select="Taxes"/>
<xsl:apply-templates select="EffectiveDate"/>
<xsl:apply-templates select="MY"/>
<xsl:apply-templates select="MYS"/>
<xsl:apply-templates select="Carline"/>
<xsl:apply-templates select="DealerIndex"/>
<xsl:apply-templates select="Currency"/>
<xsl:call-template name="newline"/>
</xsl:template>

<xsl:template match="ExportModelPrice">
<xsl:apply-templates select="Models/Model/Code"/>

<xsl:text> </xsl:text>
<xsl:apply-templates select="ORS"/>
<xsl:apply-templates select="Models/Model/Name"/>

<xsl:text> </xsl:text>
<xsl:apply-templates select="PlantPrice"/>
<xsl:text>+000000000</xsl:text>
<xsl:text>+000000000</xsl:text>
<xsl:apply-templates select="Taxes"/>
<xsl:apply-templates select="EffectiveDate"/>
<xsl:apply-templates select="MY"/>
<xsl:apply-templates select="MYS"/>
<xsl:apply-templates select="Carline"/>
<xsl:apply-templates select="DealerIndex"/>
<xsl:apply-templates select="Currency"/>
<xsl:call-template name="newline"/>
</xsl:template>

<xsl:template name="fillBefore">
<xsl:param name="objectString"/>
<xsl:param name="numberOfChars"/>
<xsl:param name="fillCharacter"/>
<xsl:variable name="size" select="string-length($objectString)"/>
<xsl:choose>
<xsl:when test="$size < $numberOfChars">
<xsl:call-template name="fillBefore">
<xsl:with-param name="objectString"><xsl:value-of select="concat($fillCharacter, $objectString)"/></xsl:with-param>
<xsl:with-param name="numberOfChars"><xsl:value-of select="$numberOfChars"/></xsl:with-param>
<xsl:with-param name="fillCharacter"><xsl:value-of select="$fillCharacter"/></xsl:with-param>
</xsl:call-template>
</xsl:when>
<xsl:when test="$size > $numberOfChars">
<xsl:value-of select="substring($objectString,1,$numberOfChars)"/>


</xsl:when>
<xsl:otherwise>
<xsl:value-of select="$objectString"/>
</xsl:otherwise>
</xsl:choose>
</xsl:template>

<xsl:template name="fillAfter">
<xsl:param name="objectString"/>
<xsl:param name="numberOfChars"/>
<xsl:param name="fillCharacter"/>
<xsl:variable name="size" select="string-length($objectString)"/>
<xsl:choose>
<xsl:when test="$size < $numberOfChars">
<xsl:call-template name="fillAfter">
<xsl:with-param name="objectString"><xsl:value-of select="concat($objectString,$fillCharacter)"/></xsl:with-param>
<xsl:with-param name="numberOfChars"><xsl:value-of select="$numberOfChars"/></xsl:with-param>
<xsl:with-param name="fillCharacter"><xsl:value-of select="$fillCharacter"/></xsl:with-param>
</xsl:call-template>
</xsl:when>
<xsl:when test="$size > $numberOfChars">
<xsl:value-of select="substring($objectString,1,$numberOfChars)"/>
</xsl:when>
<xsl:otherwise>
<xsl:value-of select="$objectString"/>
</xsl:otherwise>
</xsl:choose>
</xsl:template>


<xsl:template name="newline">
<xsl:text>
</xsl:text>
</xsl:template>

<xsl:template match="Code">
<xsl:call-template name="fillAfter">
<xsl:with-param name="objectString"><xsl:value-of select="."/></xsl:with-param>
<xsl:with-param name="numberOfChars">10</xsl:with-param>
<xsl:with-param name="fillCharacter"><xsl:text> </xsl:text></xsl:with-param>
</xsl:call-template>
</xsl:template>

<xsl:template match="Model">
<xsl:call-template name="fillAfter">
<xsl:with-param name="objectString"><xsl:value-of select="."/></xsl:with-param>
<xsl:with-param name="numberOfChars">10</xsl:with-param>
<xsl:with-param name="fillCharacter"><xsl:text> </xsl:text></xsl:with-param>
</xsl:call-template>
</xsl:template>

<xsl:template match="MSRP | MSRPNet | DealerNet | PlantPrice">
<xsl:choose>
<xsl:when test="@sign">
<xsl:variable name="price" select="."/>
<xsl:call-template name="getPrice">
<xsl:with-param name="value" select="substring-after($price,'-')"/>
</xsl:call-template>
<xsl:value-of select="@sign"/>
</xsl:when>
<xsl:otherwise>
<xsl:call-template name="getPrice">
<xsl:with-param name="value" select="."/>
</xsl:call-template>
<xsl:text>+</xsl:text>
</xsl:otherwise>
</xsl:choose>
</xsl:template>

<xsl:template name="getPrice">
<xsl:param name="value"/>
<xsl:choose>
<xsl:when test="not(contains($value,'.'))">
<xsl:text>000000000</xsl:text>
</xsl:when>
<xsl:otherwise>
<xsl:variable name="before">
<xsl:call-template name="fillBefore">
<xsl:with-param name="objectString"><xsl:value-of select="substring-before($value,'.')"/></xsl:with-param>
<xsl:with-param name="numberOfChars">7</xsl:with-param>
<xsl:with-param name="fillCharacter"><xsl:text>0</xsl:text></xsl:with-param>
</xsl:call-template>
</xsl:variable>
<xsl:variable name="after" select="substring-after($value,'.')"/>
<xsl:value-of select="concat($before, $after)"/>
</xsl:otherwise>
</xsl:choose>
</xsl:template>

<xsl:template name="getTax">
<xsl:param name="value"/>
<xsl:choose>
<xsl:when test="not(contains($value,'.'))">
<xsl:text>000000</xsl:text>
</xsl:when>
<xsl:otherwise>
<xsl:variable name="before">
<xsl:call-template name="fillBefore">
<xsl:with-param name="objectString"><xsl:value-of select="substring-before($value,'.')"/></xsl:with-param>
<xsl:with-param name="numberOfChars">3</xsl:with-param>
<xsl:with-param name="fillCharacter"><xsl:text>0</xsl:text></xsl:with-param>
</xsl:call-template>
</xsl:variable>

<xsl:variable name="after_long">
<xsl:value-of select="substring-after($value,'.')"/>
</xsl:variable>
<xsl:variable name="after">
<xsl:value-of select="substring($after_long,1,3)"/>
</xsl:variable>
<xsl:value-of select="concat($before, $after)"/>
</xsl:otherwise>
</xsl:choose>
</xsl:template>

<xsl:template name="getSpecialTaxAmount">
<xsl:param name="value"/>
<xsl:choose>
<xsl:when test="not(contains($value,'.'))">
<xsl:text>+000000000</xsl:text>
</xsl:when>
<xsl:otherwise>
<xsl:variable name="minsign">
<xsl:if test="(contains($value,'-'))">
<xsl:text>-</xsl:text>
</xsl:if>
<xsl:if test="not(contains($value,'-'))">
<xsl:text>+</xsl:text>
</xsl:if>
</xsl:variable>
<xsl:variable name="removeminus">
<xsl:if test="(contains($value,'-'))">
<xsl:value-of select="substring-after($value,'-')"/>
</xsl:if>
<xsl:if test="not(contains($value,'-'))">
<xsl:value-of select="string($value)"/>
</xsl:if>
</xsl:variable>
<xsl:variable name="before">
<xsl:call-template name="fillBefore">
<xsl:with-param name="objectString"><xsl:value-of select="substring-before($removeminus,'.')"/></xsl:with-param>
<xsl:with-param name="numberOfChars">7</xsl:with-param>
<xsl:with-param name="fillCharacter"><xsl:text>0</xsl:text></xsl:with-param>
</xsl:call-template>
</xsl:variable>

<xsl:variable name="after_long">
<xsl:value-of select="substring-after($before,'.')"/>
</xsl:variable>
<xsl:variable name="after">
<xsl:value-of select="substring($before,1,2)"/>
</xsl:variable>
<xsl:value-of select="concat($minsign,$before, $after)"/>
</xsl:otherwise>
</xsl:choose>
</xsl:template>

<xsl:template match="EffectiveDate">
<xsl:variable name="date" select="."/>
<xsl:value-of select="substring($date, 1, 2)"/>
<xsl:value-of select="substring($date, 4, 2)"/>
<xsl:value-of select="substring($date, 7, 4)"/>
</xsl:template>

<xsl:template match="ORS">
<xsl:call-template name="fillAfter">
<xsl:with-param name="objectString"><xsl:value-of select="."/></xsl:with-param>
<xsl:with-param name="numberOfChars">25</xsl:with-param>
<xsl:with-param name="fillCharacter"><xsl:text> </xsl:text></xsl:with-param>
</xsl:call-template>
</xsl:template>



<xsl:template match="Name">
<xsl:call-template name="fillAfter">
<xsl:with-param name="objectString"><xsl:value-of select="."/></xsl:with-param>
<xsl:with-param name="numberOfChars">40</xsl:with-param>
<xsl:with-param name="fillCharacter"><xsl:text> </xsl:text></xsl:with-param>
</xsl:call-template>
</xsl:template>

<xsl:template match="Taxes">
<xsl:call-template name="getTax">
<xsl:with-param name="value" select="./SpecialTax"/>
</xsl:call-template>
<xsl:call-template name="getTax">
<xsl:with-param name="value" select="./Tax"/>
</xsl:call-template>

<xsl:call-template name="getSpecialTaxAmount">
<xsl:with-param name="value" select="./SpecialTaxAmount"/>
</xsl:call-template>

</xsl:template>

<xsl:template match="Carline">
<xsl:value-of select="substring(.,1,2)"/>
</xsl:template>

</xsl:stylesheet>



============================
XML Data
============================
<?xml version="1.0" encoding="ISO-8859-1"?>
<?xml-stylesheet type="text/xsl" href="export.xsl"?>
<GeneralReport module="Domestic">
<Meta>
<User>TZG136</User>
<CreationDate>31.07.2009</CreationDate>
<CreationTime>15:16</CreationTime>
<Comment></Comment>
<SelectionCriteria>
<LegalEntityName>Austria</LegalEntityName>
<Carline>Agila</Carline>
<MY>2</MY>
<MYS>A</MYS>
<DealerIndex>000</DealerIndex>
<Currency>EUR</Currency>
<EffectiveDate>= 14.12.2001</EffectiveDate>
<ModelPrices>true</ModelPrices>
<Model>0HF68</Model>
<Option>*</Option>
<OptionIndicator>M</OptionIndicator>
<Active>true</Active>
<ORS apply="false">*</ORS>
</SelectionCriteria>
</Meta>
<AllModels>
<Model>0HF68</Model>
<Model>0HL68</Model>
<Model>0HN68</Model>
<Model>0HP68</Model>
</AllModels>
<Models>
<Model>0HF68</Model>
</Models>
<Prices>
<LocalReport>
<LegalEntityName>Austria</LegalEntityName>
<OptionIndicator>M</OptionIndicator>
<Carline>Agila</Carline>
<Code></Code>
<Name></Name>
<Models>
<Model>
<Code>0HF68</Code>
<Name>Agila Agila 5</Name>
</Model>
</Models>
<MY>2</MY>
<MYS>A</MYS>
<EffectiveDate>14.12.2001</EffectiveDate>
<DealerIndex>000</DealerIndex>
<MSRP sign="-">-90.00</MSRP>
<MSRPNet sign="-">-182.73</MSRPNet>
<DealerNet sign="-">-182.73</DealerNet>
<TransferPrice sign="-">-183.00</TransferPrice>
<Currency>EUR</Currency>
<ORS></ORS>
<Taxes>
<Tax>0.0000</Tax>
<SpecialTax>10.0000</SpecialTax>
<SpecialTaxAmount>500.00</SpecialTaxAmount>
</Taxes>
</LocalReport>
</Prices>
</GeneralReport>

PHP MYSQL APACHE Installation

2009-07-29T02:59:00.000-07:00

Hi

Please Use the below link Which gives you the details information about PHP MYSQL APACHE Installation

Click Here Download Link - PHP MYSQL APACHE Installation instruction

After you install PHP - You can install HEIDSQL which is MYSQL front END.
Click Here Download Link : HEIDSQL - MYSQL Front End

Needs Answers :

2009-07-15T04:37:00.000-07:00

1.How to retrieve values from Oracle's ref cursor using java Program.?

Oracle Types access through Java Object

2009-07-09T09:41:00.000-07:00

package com.oracleObjects.AcessOracleObjects;

import java.io.IOException;

import java.sql.*;
import java.util.List;
import java.util.Properties;

import oracle.sql.STRUCT;
import oracle.sql.StructDescriptor;
/**
* @author tzg136
*
* TODO To change the template for this generated type comment go to
* Window - Preferences - Java - Code Style - Code Templates
*/
public class AcessOracleObjectsUsingJava_EMP {
Connection conn = null;
String driverName ="";
String serverName = "";
String username ="";
String password = "";

String portNumber ="";
String sid = "";
String databaseName = "";

public AcessOracleObjectsUsingJava_EMP()
{
Properties configFile = new Properties();
try {
configFile.load(AcessOracleObjectsUsingJava_EMP.class.getClassLoader().getResourceAsStream("config.properties"));
driverName =configFile.getProperty("driverName");
serverName = configFile.getProperty("serverName");
username =configFile.getProperty("username");
password = configFile.getProperty("password");
portNumber =configFile.getProperty("portNumber");
sid = configFile.getProperty("sid");
databaseName = configFile.getProperty("databaseName");

} catch (IOException e) {
e.printStackTrace();
}

}
public Connection getConnection()
{
try
{
Class.forName(driverName);
String url = "jdbc:oracle:thin:@" + serverName + ":" + portNumber + ":" + sid;
conn = DriverManager.getConnection(url, username, password);
System.out.println("Connected Sucessfully");

}
catch (ClassNotFoundException e) {
System.out.println("ClassNotFoundException "+e.getMessage());

} catch (SQLException e) {
System.out.println("SQl Syntaxt Error "+e.getMessage());

}
catch (Exception e) {
System.out.println("Exception "+e.getMessage());

}
return conn;
}
public void insertTableObjectValue(Emp objEmp)
{
try {
Object objArray[] = new Object[4];
objArray[0] = objEmp.getEmp_id();
objArray[1] = objEmp.getEmp_Name();
objArray[2] = objEmp.getAge();
objArray[3] = new Integer(objEmp.getSalary());

StructDescriptor colStructDesc = StructDescriptor.createDescriptor("OBJ_TYPE_EMP", conn);

oracle.sql.STRUCT colStruct = new STRUCT(colStructDesc,conn, objArray);

PreparedStatement prepa_stmt= conn.prepareStatement( "INSERT INTO TABLE_EMP_OBJ VALUES (?)");
prepa_stmt.setObject(1,colStruct); // Bind the Java Object to the above Statement ps.executeUpdate();
prepa_stmt.executeUpdate();

} catch (SQLException e) {
System.out.println("SQLException"+ e.getMessage());
}
catch (Exception e) {
System.out.println("Exception"+ e.getMessage());
}
}

public void createTableWithObject()
{
/*
*
* CREATE TYPE OBJ_TYPE_EMP as OBJECT (
EMP_ID VARCHAR2(40),
EMP_NAME VARCHAR2(40),
AGE VARCHAR2(10) ,
SALARY NUMBER )

CREATE TABLE TABLE_EMP_OBJ (ObjEmp OBJ_TYPE_EMP )
*/
}

public void selectTableObjectValue()
{
try {

Statement stmt = conn.createStatement();

// Select rows from object1_table
ResultSet resultSet = stmt.executeQuery("SELECT * FROM TABLE_EMP_OBJ");

// OracleResultSet resultSet = (OracleResultSet)pst.executeQuery();

java.util.Hashtable mymap = new java.util.Hashtable();
Class obj = Class.forName("com.oracleObjects.AcessOracleObjects.Emp");
// Map the loaded java class to the object-type
mymap.put ("OBJ_TYPE_EMP", obj);

// Get the OBJECT values from each row
while (resultSet.next())
{
Emp objEmp;
objEmp = (Emp)resultSet.getObject(1, mymap);
System.out.println(""+objEmp.getEmp_Name());
System.out.println(""+objEmp.getAge());
}

}
catch (SQLException e) {
System.out.println("SQLException"+ e.getMessage());
e.printStackTrace();
}
catch (Exception e) {
System.out.println("Exception"+ e.getMessage());
}
}
public void closeConnection()
{
try
{
conn.close();
}
catch (Exception e) {
System.out.println("Exception"+ e.getMessage());
}

}

public static void main(String[] args) {
AcessOracleObjectsUsingJava_EMP objAccessJavaObject= new AcessOracleObjectsUsingJava_EMP();
Emp objEmp= new Emp();
objEmp.setEmp_id("1000");
objEmp.setEmp_Name("Andrew");
objEmp.setAge("34");
objEmp.setSalary(500);

Connection conn= objAccessJavaObject.getConnection();
if(args[0].equalsIgnoreCase("I"))
{
objAccessJavaObject.insertTableObjectValue(objEmp);
}
if(args[0].equalsIgnoreCase("S"))
{
objAccessJavaObject.selectTableObjectValue();
}

objAccessJavaObject.closeConnection();

}
}

Oracle Object Types - Java Implementation

2009-07-07T09:31:00.000-07:00

Please find the code which has the implementation of inserting values in Oracle Objects and table.

CREATE TYPE product_detail_info AS object (product_detail_id VARCHAR(30), product_name VARCHAR(30),product_rate NUMBER)
CREATE TYPE product_type AS object (product_type_id VARCHAR(30), product_type_Name VARCHAR(30),obj_product_detail_info product_detail_info )
CREATE TABLE Electronics_Products(Electronics_Products_id VARCHAR(30), Electronics_Products_name VARCHAR(30),obj_product_type product_type)

Note :
While running this program Please give args[0] value as below
I- I - Insert
II- C - create Object and Table
III- S - Select

Java Code :

package com.oracleObjects.AcessOracleObjects;

import java.io.IOException;
import java.math.BigDecimal;
import java.sql.*;
import java.util.Properties;
/**
* @author tzg136
*
* TODO To change the template for this generated type comment go to
* Window - Preferences - Java - Code Style - Code Templates
*/
public class AcessOracleObjects_ElectronicsItem {
Connection conn = null;
String driverName ="";
String serverName = "";
String username ="";
String password = "";

String portNumber ="";
String sid = "";
String databaseName = "";

public AcessOracleObjects_ElectronicsItem()
{
Properties configFile = new Properties();
try {
configFile.load(AcessOracleObjects_ElectronicsItem.class.getClassLoader().getResourceAsStream("config.properties"));
driverName =configFile.getProperty("driverName");
serverName = configFile.getProperty("serverName");
username =configFile.getProperty("username");
password = configFile.getProperty("password");
portNumber =configFile.getProperty("portNumber");
sid = configFile.getProperty("sid");
databaseName = configFile.getProperty("databaseName");

} catch (IOException e) {
e.printStackTrace();
}

}
public Connection getConnection()
{
try
{
Class.forName(driverName);
String url = "jdbc:oracle:thin:@" + serverName + ":" + portNumber + ":" + sid;
conn = DriverManager.getConnection(url, username, password);
System.out.println("Connected Sucessfully");

}
catch (ClassNotFoundException e) {
System.out.println("ClassNotFoundException "+e.getMessage());
} catch (SQLException e) {
System.out.println("SQl Syntaxt Error "+e.getMessage());
}
catch (Exception e) {
System.out.println("Exception "+e.getMessage());
}
return conn;
}
public void insertTableObjectValue()
{
try {
// Create an oracle.sql.ARRAY object to hold the values
Statement stmt = conn.createStatement();
//CREATE TYPE product_detail_info AS object (product_detail_id VARCHAR(30), product_name VARCHAR(30),product_rate NUMBER)
//product_detail_info('TV_FLAT21_001' , '21 Inch Flat TV ' ,2000 )
String product_detail_info_sql = "product_detail_info('D.Info TV_FLAT21_001' , '21 Inch Flat TV ' ,2000 )";

// CREATE TYPE product_type AS object (product_type_id VARCHAR(30), product_type_Name VARCHAR(30),obj_product_detail_info product_detail_info )
// product_type (product_type_id , product_type_Name,product_detail_info_sql )
String product_type_sql= "product_type( 'TV', 'This contains TV',("+product_detail_info_sql+"))";

//CREATE TABLE Electronics_Products(Electronics_Products_id VARCHAR(30), Electronics_Products_name VARCHAR(30),obj_product_type product_type)
//Electronics_Products(Electronics_Products_id, Electronics_Products_name ,product_type_sql)
String Electronics_Products_sql = "INSERT INTO Electronics_Products VALUES('ELE_item','this Elec items',"+product_type_sql+")";

// Insert a row with values for both the object1 and object2 types
System.out.println("SQL is = \n"+Electronics_Products_sql);
int row = stmt.executeUpdate(Electronics_Products_sql);
System.out.println("Row Count"+row);
//stmt.execute("INSERT INTO object1_table VALUES(1, object1('str1', object2('obj2str1', 123)))");

} catch (SQLException e) {
System.out.println("SQLException"+ e.getMessage());
}
catch (Exception e) {
System.out.println("Exception"+ e.getMessage());
}
}
public void createTableWithObject()
{
try {
// Create an oracle.sql.ARRAY object to hold the values
// Create a statement
Statement stmt = conn.createStatement();
String prod_de_in= "CREATE TYPE product_detail_info AS object (product_detail_id VARCHAR(30), product_name VARCHAR(30),product_rate NUMBER)";
// Create the object2 type
stmt.execute(prod_de_in);
String prod_type= "CREATE TYPE product_type AS object (product_type_id VARCHAR(30), product_type_Name VARCHAR(30),obj_product_detail_info product_detail_info )";
stmt.execute(prod_type);
String elect_Prod= "CREATE TABLE Electronics_Products(Electronics_Products_id VARCHAR(30), Electronics_Products_name VARCHAR(30),obj_product_type product_type)";
stmt.execute(elect_Prod);
// Create a table with a column to hold a number and the new object1 type
} catch (SQLException e) {
System.out.println("SQLException"+ e.getMessage());
}
catch (Exception e) {
System.out.println("Exception"+ e.getMessage());
}
}

public void selectTableObjectValue()
{
try {

Statement stmt = conn.createStatement();

// Select rows from object1_table
ResultSet resultSet = stmt.executeQuery("SELECT * FROM Electronics_Products");

// Get the OBJECT values from each row
while (resultSet.next()) {
// Get the integer from the first column col_integer of the row
String ele_prod_id = resultSet.getString("ELECTRONICS_PRODUCTS_ID");
String ele_prod_name = resultSet.getString("ELECTRONICS_PRODUCTS_NAME");

// Get the object1 value from the second column col_object1
oracle.sql.STRUCT obj_PRODUCT_TYPE = (oracle.sql.STRUCT)resultSet.getObject("OBJ_PRODUCT_TYPE");

// Get the object1 values from each row
Object[] obj_PRODUCT_TYPEValues = obj_PRODUCT_TYPE.getAttributes();

System.out.println("obj_PRODUCT_TYPEValues"+obj_PRODUCT_TYPEValues.toString());

int obj_PRODUCT_length = obj_PRODUCT_TYPEValues.length;

for(int i=0;i<obj_PRODUCT_length;i++)
{
System.out.println(i+" Product Type "+obj_PRODUCT_TYPEValues[0]);
System.out.println(i+"Product Type"+obj_PRODUCT_TYPEValues[1]);

// Product Detail Info
oracle.sql.STRUCT Obj_product_detail_info = (oracle.sql.STRUCT)obj_PRODUCT_TYPEValues[2];
Object[] obj_product_detail_info_Values = Obj_product_detail_info.getAttributes();
int obj_product_detail_info_length = obj_product_detail_info_Values.length;
for(int j=0;j<obj_product_detail_info_length;j++)
{
System.out.println(j+" Product Detail Info "+obj_product_detail_info_Values[0]);
System.out.println(j+" Product Detail Info "+obj_product_detail_info_Values[1]);
System.out.println(j+" Product Detail Info "+obj_product_detail_info_Values[2]);

}
}

// Get the first value of object1, which is a string
/* String str = (String)object1Values[0];

System.out.println(""+str);

// Get the second value of object1, which is of the type object2
oracle.sql.STRUCT object2 = (oracle.sql.STRUCT)object1Values[1];

// Get the values of object2
Object object2Values[] = object2.getAttributes();
str = (String)object2Values[0];
BigDecimal num = (BigDecimal)object2Values[1];
System.out.println(""+str);*/
}

}
catch (SQLException e) {
System.out.println("SQLException"+ e.getMessage());
}
catch (Exception e) {
System.out.println("Exception"+ e.getMessage());
}
}
public void closeConnection()
{
try
{
conn.close();
}
catch (Exception e) {
System.out.println("Exception"+ e.getMessage());
}

}

public static void main(String[] args) {
AcessOracleObjects_ElectronicsItem v= new AcessOracleObjects_ElectronicsItem();
Connection conn= v.getConnection();
if(args[0].equalsIgnoreCase("C"))
{
v.createTableWithObject();
}
else if(args[0].equalsIgnoreCase("I"))
{
v.insertTableObjectValue();
}
else if(args[0].equalsIgnoreCase("S"))
{
v.selectTableObjectValue();
}
else
{
System.out.println("No vlaida option is selected");
}
v.closeConnection();
}
}

Database Configuration :
driverName=oracle.jdbc.driver.OracleDriver
serverName=139.73.41.135
portNumber=1521
username=scott
password=tiger
databaseName=facisdev
sid=facisdev

ENGLISH BEST LINK

2009-04-16T01:45:00.000-07:00

Hi Friend

I have found this is the one of the best link for English Communication.Please try it by clikcing below
English Communication

AJAX

2009-04-03T04:12:00.000-07:00

1.What is expanstion for AJAX?
AJAX = Asynchronous JavaScript and XML

2.How Ajax Loads the data without relaoding the page?
Ajax Uses XMLHttpRequest object which directly interacts with seb server.

AJAX uses asynchronous data transfer (HTTP requests) between the browser and the web server, allowing web pages to request small bits of information from the server instead of whole pages.

Back Base Steps

2009-04-01T08:15:00.000-07:00

Steps to Implement BACKBASE

1.Install Jar
backbase-dataservices-core-1.1.0.jar—core functionality
backbase-dataservices-servlet-1.1.0.jar—servlet bridge classes
2.Set Up Dataservice - add in Servlet web.xml
<display-name>datamodule-web-example</display-name>
<servlet>
<servlet-name>datamodule-web-example</servlet-name>
<servlet-class>
com.backbase.datamodule.servlet.DatamoduleServlet
</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>datamodule-web-example</servlet-name>
<url-pattern>/data/*</url-pattern>
</servlet-mapping>
3.Client-Side Implementation
Data Source Definition
Widget Binding
4.Add datamodule-config - for Pagination

Hibenate Coding Steps

2009-03-31T01:24:00.000-07:00

Steps to Code Hibenate :
1.Edit hibernate.cfg.xml :
Hibernate uses the hibernate.cfg.xml to create the connection pool and setup required environment. Add an Entry for ???.hbm.xml

2.Create Table in databse

3.Create POJO Class which contains getter and setter method

4.Map Table Column vs POJO Class in .hbm.xml

5.Write Client Program

SessionFactory factory=null;
Session ses=null;
Transaction tx=null;
try
{ factory=new Configuration().configure().buildSessionFactory();
ses=factory.openSession();
tx = ses.beginTransaction();
ses.save(emp);
tx.commit();
}
catch (Exception e)
{
}

JavaScript

2009-03-30T03:08:00.000-07:00

How to set Select a particular value when Select box is loaded?

1.Find Length of Select Box.
document.mtstafftransferform.qualification.options.length
2.Loop through
a)get the value of combobox
var val = document.mtstafftransferform.qualification.options[i].value;
b)match option value with value whihc needs to selected.
3.If matches
select the value selected
document.mtstafftransferform.qualification.selectedIndex=i;

Example :

<SCRIPT language=JavaScript type=text/javascript>
var qualify ="MATHS";
var comp_len = document.mtstafftransferform.qualification.options.length;
for (i=0; i<comp_len; i++)
{
var val = document.mtstafftransferform.qualification.options[i].value;
alert(""+val);
if(val == qualify)
{
document.mtstafftransferform.qualification.selectedIndex=i;
}
}
</SCRIPT>

SWING

2009-03-26T00:17:00.001-07:00

Hibernate Important Interview Question

2009-03-17T04:56:00.000-07:00

1.What is O-R Mapping?
2.What is the difference between createCriteria and createQuery in Hibernate?
3.How would you implement on deletecasecade in Hiberante?
4.How Inheritance Implemented in Hiberante?
5.Is one Bean class can be involved with more than one relationship?
For example 1 class may have 1 to 1 and 1 to many
6.How do define compound primary key?
7.How to implement Oncasecasde deletion?
8.What is cascade="all"

Code Examples :

What are the steps to be followed to implement 1 to 1 database insert/update/delete?

Pre - Request :
Check we able to connect databse through Sample JSP program.

Step 1:

Table and Bean :

Create master table and Child table
Create bean for Master and Child table. Here Both Bean should contain gettter and setter value of other bean.

XML Entry :

In Master

Apart from XML Entry, There should be map to child table

<one-to-one name="<<Childtablename>>" class="<<ChildtableClass>>" cascade="all" />

<one-to-one name="employeeSalary" class="EmployeeSalary" cascade="all" />

Note : it refers only the class

In Child table

refer the master table's as below

In reference key column,

a)metioned generator class =foreign then mention property name
b)define one to one with property name and Class

EXCEL MACRO

2009-03-13T01:00:00.000-07:00

a. Code for connecting to the excel file
Sub connectivity()
On Error GoTo myerr:
Set cn1 = New ADODB.Connection
With cn1
.Provider = "Microsoft.Jet.OLEDB.4.0"
.ConnectionString = "Data Source='" & ThisWorkbook.FullName & "'; Extended Properties=Excel 8.0;"
.Open
End With
myerr:
If Err.Number <> 0 Then
MsgBox Err.Description
End If
End Sub

B. Code for reading the datas from the excel file
Sub readingrecord()
connectivity
Set rs = New ADODB.Recordset
rs.Open "select * from [sheet1$]", cn1, adOpenStatic, adLockOptimistic
If rs.EOF = False Then
rs.MoveFirst
Do While Not rs.EOF
myName = rs.Fields(1).Value & "," & rs.Fields(2).Value
Set rs1 = New ADODB.Recordset
rs1.Open "select * from [sheet1$] where [Namefield] ='" & myName & "'", cn1, adOpenStatic, adLockOptimistic
If rs1.EOF = True Then
Sheet7.Cells(i, 1) = myName
Sheet7.Cells(i, 2) = 0
i = i + 1
End If
rs.MoveNext
Loop
End If
End sub

C. Code for save the data to the external excel file.
Sub fileupload()
Sheets("sheet1").Select
Cells.Select
Selection.Copy
Workbooks.Add
ActiveSheet.Paste
ActiveWorkbook.SaveAs Filename:= _
"C:\test.xls", FileFormat:=xlNormal, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False
Sheets("Sheet1").Select
Sheets("Sheet1").Name = "sheet1"
Range("C8").Select
ActiveWorkbook.Save
ActiveWorkbook.Close
Range("A1").Select
End Sub

SQL Server Back Up and Restoration

2009-03-12T07:07:00.001-07:00

. Installation of SQL Server Database:
Click on SQLeval.exe.
Once the extraction is complete, click on setup.bat
Follow the below Instruction and complete the database server Installation.

1

2

3

4

5

Password as ehr/ehr

SQL Server Installation completed.
Configure DSN :
Start the database.
Click on SQL Server Enterprise Manager.
Expand the top most node.
Right click on database and click on New Database.
Create two databases core_db and core_db_session and note down the location of the data file and log file in both the cases.

Right click on core_db and click on All tasks menu. Click on Restore Database.
Click on From Device button as shown below in Fig 23
Fig 23:

Locate the core_db file and core_db_session file as shown below in Fig 24.
Fig 24:

On doing this, the following screen as shown below in Fig 25
will get displayed :

Click on Options tab and provide the locations of data file and the log files whose location was recorded in the previous steps and as shown below in Fig 26.
Fig 26:

Click on Ok button. The message will get displayed as shown below in Fig 27.
Fig 27

8. Configuration of Datasource:

Go to Control Panel. Click on Administrative tools / DataSources. On doing so a popup window will appear as shown below in Fig 28.
Fig 28:

Click on System DSN tab as shown below in Fig 29.
Fig 29:

Click on Add button. A popup screen similar to the one shown below in Fig 30
will appear .
Fig 30:

Select SQL Server and click on Finish Button. On Doing so another popup screen will get displayed as shown below in Fig 31
Fig 31:

Fill the data source name and select the server as shown above. Click on Next button
And fill the login id as well as the password. Use sa as login id and password as ehr
Fig 32:

Click on Next button and the following screen as shown below in Fig 33 will get displayed.

Fig 33

Click on Next button and the screen as shown below in Fig 34 will get displayed.
Fig 34:

Click on Finish.
Test the DSN Set up

Similarly create another datasource core_db_session.

My Code Link

2009-03-11T06:33:00.000-07:00

Hi Friends

Here I have attached some of the samples I have developed

Please use it wherever is it required.

The Link is :MY CODES

XML Code GEN

2009-03-11T06:22:00.000-07:00

XML & XSL EXAMPLE

2009-03-11T05:58:00.000-07:00

<?xml version="1.0"?>

<?xml-stylesheet type="text/xsl" href="Input.xsl"?>

<project>
<class>
<type>private</type>
<Name>AddTwasdsoNumbers</Name>
</class>
<variable>
<var>
<type> int </type>
<Name>x</Name>
</var>
<var>
<type> int </type>
<Name>y</Name>
</var>

</variable>
<funtionmodule>
<var>
<Name>addtwonumber</Name>
<arg>
<type> int </type>
<Name>x</Name>
</arg>
<arg>
<type> int </type>
<Name>y</Name>
</arg>
<returntype> int </returntype>
</var>
</funtionmodule>

</project>

<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:template match="/">
<html>
<body>
<xsl:call-template name="project_class"/>
</body>
</html>
</xsl:template>

<xsl:template name="project_class">

<xsl:value-of select="project/class/type" disable-output-escaping="no"/>
<font color="red">class <xsl:value-of select="project/class/Name" disable-output-escaping="no"/> {
<br/></font> <div/>
<xsl:call-template name="project_Variable"/>
<br/>
<xsl:call-template name="project_Methods"/>
<br/>
}
</xsl:template>

<xsl:template name="project_Variable">

<xsl:for-each select="project/variable/var">

<xsl:value-of select="type" disable-output-escaping="no"/>

<xsl:value-of select="Name"/>
<br/>

</xsl:for-each>

</xsl:template>

<xsl:template name="project_Methods">
<xsl:for-each select="project/funtionmodule/var">
public <xsl:value-of select="returntype" disable-output-escaping="no"/> <xsl:value-of select="Name"/>() thrwos Exception{
<br/>
Rajnikanth

}
</xsl:for-each>

</xsl:template>

</xsl:stylesheet>

Another Example :

<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="emp.xsl"?>

<database name="scott">
<table-name name="Employee">
<fields>
<column-name>empid</column-name>
<column-type>number</column-type>
<column-size>5</column-size>
</fields>
<fields>
<column-name>empname</column-name>
<column-type>varchar</column-type>
<column-size>5</column-size>
</fields>
</table-name>
<table-name name="Student">
<fields>
<column-name>studentid</column-name>
<column-type>number</column-type>
<column-size>5</column-size>
</fields>
<fields>
<column-name>studentname</column-name>
<column-type>varchar</column-type>
<column-size>5</column-size>
</fields>
</table-name>
</database>

<?xml version='1.0'?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:output method="html"/>

<xsl:template match="/">

<html>
<body>

<xsl:for-each select="database/table-name">
<table>
<tr>
<td><h4>Table Name:</h4></td><td><xsl:value-of select="@name"/></td>
</tr>
</table>
<table>
<tr width="250">
<th width="100">Name</th>
<th width="100">Type</th>
<th width="50">Size</th>
</tr>
<xsl:for-each select="fields">
<tr>
<td>
<xsl:value-of select="column-name"/>
</td>
<td>
<xsl:value-of select="column-type"/>
</td>
<td>
<xsl:value-of select="column-size"/>
</td>
</tr>
</xsl:for-each>
</table>
<br/>
<br/>
<br/>
</xsl:for-each>

========================
form submition
========================

<xsl:for-each select="database/table-name">
Table:<xsl:value-of select="@name"/>
<table>

<xsl:for-each select="fields">
<tr>

DB EMP NAME :<xsl:value-of select="column-name"/> :
USEREMPNAME :

<input type="text">
<xsl:attribute name="value"> <xsl:value-of select="column-name"/>
</xsl:attribute>
</input>
</tr>

</xsl:for-each>
</table>
</xsl:for-each>

</body>
</html>
</xsl:template>

</xsl:stylesheet>

Code Gen

2009-03-11T05:55:00.000-07:00

Add Code Gen by JSP and then Convert to PHP

Java XML Example

2009-03-11T05:41:00.000-07:00

import java.io.StringWriter;
import java.util.ArrayList;

import javax.xml.transform.OutputKeys;
import javax.xml.transform.Transformer;
import javax.xml.transform.TransformerFactory;
import javax.xml.transform.dom.DOMSource;
import javax.xml.transform.stream.StreamResult;

import org.apache.xerces.dom.DocumentImpl;
import org.w3c.dom.Document;
import org.w3c.dom.Element;

/**
* @author tzg136
*
* TODO To change the template for this generated type comment go to
* Window - Preferences - Java - Code Style - Code Templates
*/
public class XMLCreator {
Document xmlDoc = null;
Element rootElement = null;
Element topElement = null;
public Document getData()
{
xmlDoc = new DocumentImpl();
topElement = xmlDoc.createElement("source");

//data
ArrayList alEmp = new ArrayList();
EmployeeBean e= new EmployeeBean();
e.setEmp_ID("3636");
e.setEmp_Name("Andrew");
e.setEmp_Sal("60000");
alEmp.add(e);
e.setEmp_ID("2");
e.setEmp_Name("kumas");
e.setEmp_Sal("60asd000");
alEmp.add(e);

// data end

for(int i=0;i < alEmp.size();i++)
{
EmployeeBean emp = (EmployeeBean)alEmp.get(i);
createXml(emp);
}
System.out.println("TOP SIZE"+alEmp.size());
xmlDoc.appendChild(topElement);
System.out.println("OP NN"+xmlDoc.getNodeName());
System.out.println("OP"+xmlDoc.toString());
return xmlDoc;
}
public void createXml(EmployeeBean emp)
{
Element innnerElement = xmlDoc.createElement("EMPINFO");
org.w3c.dom.Node node_Empid = xmlDoc.createElement("Empid");
org.w3c.dom.Node node_EmpName = xmlDoc.createElement("EmpName");
org.w3c.dom.Node node_EmpSal = xmlDoc.createElement("EmpAge");

node_Empid.appendChild(xmlDoc.createTextNode(emp.getEmp_ID()));
node_EmpName.appendChild(xmlDoc.createTextNode(emp.getEmp_Name()));
node_EmpSal.appendChild(xmlDoc.createTextNode(emp.getEmp_Sal()));

innnerElement.appendChild(node_Empid);
innnerElement.appendChild(node_EmpName);
innnerElement.appendChild(node_EmpSal);

topElement.appendChild(innnerElement);

}
public String toString()
{
return this.getClass().getName();
}

public static void main(String args[])
{
XMLCreator a = new XMLCreator();
//StreamResult result = new StreamResult(System.out);
//System.out.println("Out put"+a.getData().toString());
try
{
Document doc = a.getData();

Transformer transformer = TransformerFactory.newInstance().newTransformer();
transformer.setOutputProperty(OutputKeys.INDENT, "yes");

//initialize StreamResult with File object to save to file
StreamResult result = new StreamResult(new StringWriter());
DOMSource source = new DOMSource(doc);
transformer.transform(source, result);

String xmlString = result.getWriter().toString();
System.out.println(xmlString);
}
catch(Exception e)
{
e.getMessage();
}

//System.out.println(doc.getElementsByTagName("Empid").);

}
}

class EmployeeBean
{
/**
* @return Returns the emp_ID.
*/
public String getEmp_ID() {
return emp_ID;
}
/**
* @param emp_ID The emp_ID to set.
*/
public void setEmp_ID(String emp_ID) {
this.emp_ID = emp_ID;
}
/**
* @return Returns the emp_Sal.
*/
public String getEmp_Sal() {
return emp_Sal;
}
/**
* @param emp_Sal The emp_Sal to set.
*/
public void setEmp_Sal(String emp_Sal) {
this.emp_Sal = emp_Sal;
}

String emp_ID;
/**
* @return Returns the emp_Name.
*/
public String getEmp_Name() {
return emp_Name;
}
/**
* @param emp_Name The emp_Name to set.
*/
public void setEmp_Name(String emp_Name) {
this.emp_Name = emp_Name;
}
String emp_Name;

String emp_Sal;
}

java Interface Example

2009-03-11T05:37:00.000-07:00

Do reports

Java Abstract Class Example

2009-03-11T05:29:00.000-07:00

Base Class :
=============

package pkg_abstract;

import java.awt.Frame;
public class BaseWindow extends Frame {
}
Derived Class :
=============

package pkg_abstract;

public class EDSWindow extends BaseWindow{
public static void main(String args[])
{
EDSWindow a = new EDSWindow();
a.show();
}
}

Filter Pattern

2009-03-11T05:24:00.000-07:00

package com.filter;

import java.util.Iterator;
import java.util.Vector;

public class FilterChain {
// filter chain
private Vector myFilters = new Vector();

// Creates new FilterChain
public FilterChain() {
// plug-in default filter services for example
// only. This would typically be done in the
// FilterManager, but is done here for example
// purposes
addFilter(new DebugFilter());
addFilter(new LoginFilter());
addFilter(new AuditFilter());
}

public void processFilter(
javax.servlet.http.HttpServletRequest request,
javax.servlet.http.HttpServletResponse response)
throws javax.servlet.ServletException,
java.io.IOException {
Filter filter;

// apply filters
Iterator filters = myFilters.iterator();
while (filters.hasNext())
{
filter = (Filter)filters.next();
// pass request & response through various
// filters
filter.execute(request, response);
}
}

public void addFilter(Filter filter) {
myFilters.add(filter);
}
}

===============================================================
/*
* Created on Oct 13, 2005
*
* TODO To change the template for this generated file go to
* Window - Preferences - Java - Code Style - Code Templates
*/
package com.filter;

/**
* @author tzg136
*
* TODO To change the template for this generated type comment go to
* Window - Preferences - Java - Code Style - Code Templates
*/
public class FilterManager {
public void processFilter(Filter target,
javax.servlet.http.HttpServletRequest request,
javax.servlet.http.HttpServletResponse response)
throws javax.servlet.ServletException,
java.io.IOException {
FilterChain filterChain = new FilterChain();

// The filter manager builds the filter chain here
// if necessary

// Pipe request through Filter Chain
filterChain.processFilter(request, response);

//process target resource
target.execute(request, response);

}
}

Value List Handler

2009-03-11T05:07:00.000-07:00

Client - Displays the result
=============================
package com.ValueList.client;

import com.ValueList.controller.EmpController;

public class EmpClient {
public void result()
{
EmpController e = new EmpController();
e.getAllEmpInfo();
}

public static void main(String args[])
{
EmpClient e = new EmpClient();
e.result();
}

}
===============================================
Controller :
===============================================
Client Calls controller :

package com.ValueList.controller;

import com.ValueList.common.ValueListHandler;
import com.ValueList.model.EmpDBManager;

public class EmpController {

public void getAllEmpInfo()
{
EmpDBManager objEmpDBManager = new EmpDBManager();
ValueListHandler allempInfo = objEmpDBManager.empInfo();
Object empbean = allempInfo.getCurrentElement();
System.out.println("CURRENT ELEMENT ");
System.out.println("CURRENT ELEMENT "+allempInfo.getCurrentElement());
System.out.println("SIZE "+allempInfo.getSize());
System.out.println("HAS NEXT "+allempInfo.hasNext());
}
}
============================
package com.ValueList.common;

// Import List class
import java.util.List;

public interface ValueListHandler {
public void setList(List list);
public int getSize();
public boolean hasNext();
public Object nextElement() ;
public Object getCurrentElement();
public void resetIndex() ;
}
====================================
Employee Value List Handler:
===================================
package com.ValueList.handler;

// Import List class
import java.util.List;

import com.ValueList.common.ValueListHandler;

/**
* This class holds the list of orders. The presentation layer uses the
* methods from this class to display the Order information.
* This class implements the ValueListHandler interface, which provides the
* necessary methods to iterate through the list.
*/
public class EmployeeHandler implements ValueListHandler {

private List ordersList = null;
private int listIndex = -1;
private int allRecordsSize = -1;

/**
* Sets the Orders list
* @param list - Order List
*/
public void setList(List list) {
ordersList = list;
}

/**
* Returns the size of the list
* @return - Size
*/
public int getSize() {
return ordersList.size();
}

/**
* Returns true if there are more elements in the list
* @return - true/false
*/
public boolean hasNext() {
return ( (listIndex+1) < ordersList.size() && ordersList.size() > 0 ) ;
}

/**
* Returns the next element in the list
* @return Next element
*/
public Object nextElement() {
return ordersList.get(++listIndex) ;
}

/**
* Returns the current element in the list
* @return Current element
*/
public Object getCurrentElement() {
if ( listIndex < 0 || ordersList.size() < 1 ) {
return null;
}
return ordersList.get(listIndex) ;
}

/**
* Resets the index
*/
public void resetIndex() {
listIndex = -1;
}
}
=========================================================
/*
* Created on Oct 5, 2005
*
* TODO To change the template for this generated file go to
* Window - Preferences - Java - Code Style - Code Templates
*/
package com.ValueList.model;

import java.util.ArrayList;

import com.ValueList.bean.EmployeeBean;
import com.ValueList.common.ValueListHandler;
import com.ValueList.handler.EmployeeHandler;

/**
* @author tzg136
*
* TODO To change the template for this generated type comment go to
* Window - Preferences - Java - Code Style - Code Templates
*/
public class EmpDBManager {

EmployeeHandler empValueListHandler = new EmployeeHandler();
public ValueListHandler empInfo()
{

ArrayList orderList = new ArrayList();

EmployeeBean oEmployeeBean = new EmployeeBean();
oEmployeeBean.setEmp_ID("3939");
oEmployeeBean.setEmp_Name("ANDREW");
oEmployeeBean.setEmp_Sal("5.5LKS");

orderList.add(oEmployeeBean);

oEmployeeBean = new EmployeeBean();
oEmployeeBean.setEmp_ID("1 3939");
oEmployeeBean.setEmp_Name("1 ANDREW");
oEmployeeBean.setEmp_Sal("1 5.5LKS");

orderList.add(oEmployeeBean);

oEmployeeBean = new EmployeeBean();
oEmployeeBean.setEmp_ID("3 3939");
oEmployeeBean.setEmp_Name("3 ANDREW");
oEmployeeBean.setEmp_Sal("3 5.5LKS");

orderList.add(oEmployeeBean);

oEmployeeBean = new EmployeeBean();
oEmployeeBean.setEmp_ID("4 3939");
oEmployeeBean.setEmp_Name("4 ANDREW");
oEmployeeBean.setEmp_Sal("4 5.5LKS");

orderList.add(oEmployeeBean);

oEmployeeBean = new EmployeeBean();
oEmployeeBean.setEmp_ID("5 3939");
oEmployeeBean.setEmp_Name("5 ANDREW");
oEmployeeBean.setEmp_Sal("5 5.5LKS");

orderList.add(oEmployeeBean);

oEmployeeBean = new EmployeeBean();
oEmployeeBean.setEmp_ID("6 3939");
oEmployeeBean.setEmp_Name("6 ANDREW");
oEmployeeBean.setEmp_Sal("6 5.5LKS");

orderList.add(oEmployeeBean);

empValueListHandler.setList(orderList);

return empValueListHandler;
}

}
=======================================================

STRUTS - Iterator Example

2009-03-11T04:54:00.000-07:00

update with MT CODE

PL SQL

2009-03-04T05:35:00.003-08:00

SQL

2009-03-04T05:35:00.001-08:00

EJB

2009-03-04T05:34:00.003-08:00

Struts Dynaform example

2009-03-04T05:34:00.001-08:00

JSP PAGE :
=========
<%@ taglib uri="struts/bean-el" prefix="bean" %>
<%@ taglib uri="struts/html-el" prefix="html" %>
<%@ taglib uri="struts/logic-el" prefix="logic" %>
<%@ taglib uri="jstl/c" prefix="c" %>
<html>
<head>
<link href="<html:rewrite page="/rr.css" />" rel="stylesheet" type="text/css">
<title><bean:message key="title.employee.employeeform"/></title>
</head>
<body>

<c:choose>
<c:when test="${employeeForm.map.methodToCall == 'insert'}">
<h1><bean:message key="title.employee.insert"/></h1>
</c:when>
<c:otherwise>
<h1><bean:message key="title.employee.update"/></h1>
</c:otherwise>
</c:choose>

<logic:messagesPresent>
<span id="errorsHeader"><bean:message key="errors.validation.header"/></span>
<html:messages id="error">
<li><c:out value="${error}"/></li>
</html:messages>
<hr>
</logic:messagesPresent>

<logic:messagesPresent message="true">
<html:messages id="message" message="true">
<span id="success"><c:out value="${message}"/></span><br>
</html:messages>
</logic:messagesPresent>

<html:form action="employeeAction" focus="name">
<table>
<tr>
<td >Name:</td>
<td><html:text property="name"/></td>
</tr>
<tr>
<td>Age:</td>
<td><html:text property="age"/></td>
</tr>

<tr>
<td>Department:</td>
<td>
<html:select name="employeeForm" property="department">
<html:options collection="departments" property="id" labelProperty="description"/>
</html:select>
</td>
</tr>
<tr>
<td>Favorite ice cream flavors:</td>
<td>
<c:forEach var="flavor" items="${flavors}">
<html:multibox name="employeeForm" property="flavorIDs">
<c:out value="${flavor.flavorID}"/>
</html:multibox>
<c:out value="${flavor.description}"/>

</c:forEach>
</td>
</tr>

</table>
<html:hidden name="employeeForm" property="methodToCall"/>

<c:choose>
<c:when test="${employeeForm.map.methodToCall == 'insert'}">
<html:submit><bean:message key="button.submit"/></html:submit>
</c:when>
<c:otherwise>
<html:submit><bean:message key="button.update"/></html:submit>
</c:otherwise>
</c:choose>

</html:form>

</body>
</html>

ACTION CLASS (DISPATCH):
=======================
package com.validate.action;

import org.apache.struts.action.*;
import org.apache.struts.actions.DispatchAction;
import org.apache.commons.beanutils.BeanUtils;

import com.validate.databasebean.EmployeeDTO;
import com.validate.handler.EmployeeService;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public final class EmployeeDispatchAction extends DispatchAction {

public ActionForward insert(ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response)
throws Exception {
System.out.println("DISPATCHER INSERT ");
EmployeeService service = new EmployeeService();
DynaActionForm employeeForm = (DynaActionForm)form;
EmployeeDTO employeeDTO = new EmployeeDTO();
BeanUtils.copyProperties( employeeDTO, employeeForm );
service.insertEmployee( employeeDTO );
ActionMessages messages = new ActionMessages();
ActionMessage message = new ActionMessage("message.employee.insert.success");
messages.add( ActionMessages.GLOBAL_MESSAGE, message );
saveMessages( request, messages );
employeeForm.set("methodToCall","update");
return (mapping.findForward("insertSuccess"));
}

public ActionForward update(ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response)
throws Exception {
System.out.println("DISPATCHER Update");
EmployeeService service = new EmployeeService();
DynaActionForm employeeForm = (DynaActionForm)form;
EmployeeDTO employeeDTO = new EmployeeDTO();
BeanUtils.copyProperties( employeeDTO, employeeForm );
service.updateEmployee( employeeDTO );
ActionMessages messages = new ActionMessages();
ActionMessage message = new ActionMessage("message.employee.update.success");
messages.add( ActionMessages.GLOBAL_MESSAGE, message );
saveMessages( request, messages );
return (mapping.findForward("updateSuccess"));
}
}
=======================================================================
package com.validate.databasebean;
public class EmployeeDTO {
private String name;
private int age;
private int department;
private String[] flavorIDs;

public void setName(String name) {
this.name = name;
}
public void setAge(int age) {
this.age = age;
}
public void setDepartment(int department) {
this.department = department;
}
public void setFlavorIDs(String[] flavorIDs) {
this.flavorIDs = flavorIDs;
}

public String getName() {
return name;
}
public int getAge() {
return age;
}
public int getDepartment() {
return department;
}
public String[] getFlavorIDs() {
return flavorIDs;
}
}
======================================================

package com.validate.handler;

import java.util.ArrayList;
import java.util.Collection;

import com.validate.databasebean.DepartmentBean;
import com.validate.databasebean.EmployeeDTO;
import com.validate.databasebean.FlavorBean;

public class EmployeeService {
public EmployeeDTO insertEmployee( EmployeeDTO employee ) {
//in real life call other business classes to do insert
//ie:
//EmployeeDAO.insertEmployee( employee );
System.out.println("INSERT");
return employee;
}
public EmployeeDTO updateEmployee( EmployeeDTO employee ) {
//in real life call other business classes to do insert
//ie:
//EmployeeDAO.insertEmployee( employee );
System.out.println("UPDATE");
return employee;
}

}
====================================================

Hibernate Example

2009-03-04T05:33:00.002-08:00

CREATE TABLE /*!32312 IF NOT EXISTS*/ `employee` (
`id` int(10) unsigned default NULL,
`empname` varchar(50) default NULL,
`date_of_joining` date default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
===================

hibernate.cfg.xml
===================
<?xml version="1.0" encoding="UTF-8"?>
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory name="myfactory">
<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="hibernate.connection.url">jdbc:mysql://localhost/csr</property>
<property name="hibernate.connection.username">root</property>
<property name="hibernate.connection.password">admin</property>
<property name="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</property>
<property name="hibernate.show_sql">true</property>
<property name="hbm2ddl.auto">update</property>
<mapping resource="com/csr/bean/Employee.hbm.xml"/>
</session-factory>
</hibernate-configuration>
============================
Employee.hbm.xml
============================
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="com.csr.bean">
<class name="Employee" >
<id name="id" column="id" type="integer">
<generator class="increment"></generator>
</id>
<property name="empname" column="employeename" type="string"/>
<property name="DOJ" column="date_of_joining" type="date"/>
</class>
</hibernate-mapping>

=============
package com.csr.bean;

import java.util.Date;

public class Employee {
private int id;
private String empname;
private Date DOJ;
public Date getDOJ() {
return DOJ;
}
public void setDOJ(Date doj) {
DOJ = doj;
}
public String getEmpname() {
return empname;
}
public void setEmpname(String empname) {
this.empname = empname;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}

}
===============
<%
SessionFactory factory=null;
Session ses=null;
Transaction trans=null;
try
{
String bookname = request.getParameter("bookname");
factory=new Configuration().configure().buildSessionFactory();
ses=factory.openSession();
trans=ses.beginTransaction();
Book book = new Book();
book.setLngBookId(4);
book.setStrBookName(bookname);
//ses.update(book);
ses.delete(book);
trans.commit();
ses.flush();
ses.close();
System.out.println("Book object persisted to the database.");
}
catch(Exception e)
{
out.println("error "+e.getMessage());
}
%>

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

ITIL

2009-03-04T05:33:00.001-08:00

FUTURE PLAN

2009-03-02T23:21:00.000-08:00

Do PHD in Computer Science

English Grammer

2009-02-03T02:52:00.000-08:00

Reference : http://esl.about.com/library/grammar/blgr_adverbclauses_time.htm

When :
Sherly was sleeping when I arrived.

Before :
We will coding before he arrives.

After :
While, as
By the time
Until, till
Since
As soon as
Whenever, every time
The first, second, third, fourth etc., next, last time

'IF' SENTENCES AND THE 'UNREAL' FUTURE

Will it be the same situation if the company pays for the shift in the future

Website Free templates

2009-01-22T03:32:00.000-08:00

1.where Can i Find best Website Free templates?
www.freewebsitetemplates.com

PHP-EXT :
2.http://php-ext.quimera-solutions.com/

UML Design Question

2009-01-14T03:40:00.001-08:00

1.Define subsystem?

Classes that collaborate among themselves to accomplish a set of cohesive (consistent) responsibilities are referred to as subsystem or packages.

2.What are the two types of dependency that can be used from a subsystem?
3.which task is performed during use-case realization refinement?
4.Define design subsystems?
5.Which process document describes design mechanisms, any mappings between design
mechanisms, and the details regarding their use?
6.Which process document describes design mechanisms, any mappings between design
mechanisms, and the details regarding their use?
7.In the state of a state machine, a behavior can be defined
A. before reaching a state
B. upon reaching a state
C. upon leaving a state
D. inside a state
Answer: B, C, D
8.What is a gate?
9.When identifying design elements, a simple analysis class will map to a(n)______
10.In which OOAD activity is the distribution mechanism identified?
14.What is the relationship between operation and method?
15.Why would you use subsystem interfaces rather than subsystem instances on sequence diagrams?
16.Which is an input artifact to the Identify Design Elements activity?
17.What is an important consideration when allocating processes to nodes?
18.Which type of mechanism is a connector on a deployment diagram?
19.Define Desing mechanism
20.How to identify Design Elements ?
21.Additional subsystems can be discovered during Use Case Design by noting- Define
22.Which activities are performed during Use Case Design?
23.On a sequence diagram, what is used to represent a specific subsystem?
24.Which UML elements are used to describe the physical architecture of a system?
25.Which artifact is used to describe use-case realizations?
26.What defines a subsystems responsibilities?
27.Which is a design mechanism?
28.To begin identifying design mechanisms, you start by categorizing analysis mechanisms.

What are three steps in the process of Categorizing Analysis Mechanisms?
29.In Subsystem Design, what happens in the step, Distribute Subsystem Responsibilities?
30.Which entity has a well-defined boundary and identity that encapsulates state and

behavior?
31.What is the purpose of the Identify Design Mechanisms activity?
32.In a dependency, through what reference does the client class gain visibility to the

supplier?
33.In which Analysis and Design activity are subsystems mapped to analysis classes?
34.Which design element is used to represent a concurrent object?
35.The Describe Distribution activity is where the processes defined in the Describe the Run-

time
Architecture activity are allocated to ______
36.During Subsystem Design, how many interaction diagrams (sequence or communication)

should be created?
37.A directed graph of nodes connected by transitions is a _____ diagram.
39.Use Case Design is part of which workflow detail?
40.When does an analysis class map directly to a design class?
41.What is a design subsystems primary purpose?
42.What is the purpose of subsystem design?
44.Defining the network configuration is the ______ step of the Describe the Distribution

activity.
46.Which statement is true about packages and subsystems?
47.How many physical nodes should be identified in order to perform the Describe Distribution

activity?
48.Supplemental sequence diagram documentation, in the form of notes and scripts, is

commonly
used for ______. (Choose three.)
49 What is used to describe the process of applying a distribution mechanism during
implementation?
What does an underlined attribute indicate?
51.What does an underlined attribute indicate?

UML ANALYSIS - Question

2009-01-14T03:34:00.000-08:00

1.What is UML and What is current Version?

UML is language and notation system used to specify, construct, visualise and document models of a software system.

2.What is the difference 1.0 and 2.0?

2a.what is association?
An association is a structural relationship that describes a set of links; a link is a connection among objects.

3.What are the types of Structural classes?

Boundary class,Control class and Entity Class

Boundary class:

This is the first type of an analysis class. In a system consisting of a boundary class, the users interact with the system through the boundary classes.

Control class:

This is the second type of an analysis class. A control class typically does not perform any business functions, but only redirects to the appropriate business function class depending on the function requested by the boundary class or the user.

Entity class:

This is the third type of an analysis class. An entity class consists of all the business logic and interactions with databases.

4.What is the difference between Traditional Class & Structural class?

Traditional Class plays multiple roles that vary on the objects that interact with it.

5.Why iterative development process is important?

5.Define Interface.
An interface is a group of related methods with empty bodies.

Interface used to interact with object and This can be achived by Implementing in interface in java.

6.What is the focus of analysis?
7.Why is encapsulation important?
10.Which is most important in Analysis Model for a system?.
12.In a sequence diagram, each interaction on the diagram maps to the transition on a state diagram
13.Explain Mutiplicity
14.What are two important considerations when diagramming state?
15.wht is Circular depnedency
16.What is the purpose of Architectural Analysis?
17.How Ports are defined?
18.Define Attribute : They change value from object to object of the same class.
19.What are the purposes of Analysis and Design
20.Objects that are polymorphic may have the same operation names but the operations
perform differently
21. Waht is nesting structured classes?
22 .During Architectural Analysis, a Software Architect wants to reduce the complexity of the

system at work and improve its consistency. What should the Software Architect define to

accomplish this?
A. coding rules
B. use-case realizations
C. analysis mechanisms
D. design mechanisms
Answer: C
23.
24.Analysis classes evolve into ______?
25.What happens when a superclass is changed?
26.waht is use Case realization?
27.Which state does NOT contain another state?
28.How we need to group element into packages
29.What are three architectural mechanism categories?
30.In a sequence diagram, what can be defined by the interactions between participants in

the interactions?
31.Which view focuses on the physical realization of the system?
32.Define an active object?
33.During Use Case Analysis, what is generally allocated to control classes?
QUESTION 34
What are three sources for Key Abstractions identification? (Choose three.)
A. domain knowledge
B. requirements
C. design classes
D. glossary
Answer: A, B, D
35.What is object in UML and how it is defined
36.During Use Case Analysis, an attribute should be used instead of a class when the

information
37.Which view is NOT part of the RUP 4+1 View Model?
38.What are two functions of visual modeling? (Choose two.)
39.During Use Case Analysis, why are analysis mechanisms used?
40.Define Pattern
41.During Use Case Analysis, why is it sometimes necessary to supplement the use-case

description?
42.In Use Case Analysis, what is the purpose of the Unify Analysis Classes step?
43 . Which three processes are best suited for UML? (Choose three.)
A. use-case driven
B. waterfall development-based
C. iterative and incremental
D. architecture-centric
E. requirements-centric
Answer: A, C, D

QUESTION 44
Architectural layers are commonly modeled in UML using a _____
A. package stereotyped <>
B. subsystem stereotyped <>
C. composite class stereotyped <>
D. class diagram entitled Layer
Answer: A
QUESTION 45
In a state diagram, a state has two transitions. One of the transitions is an internal transition

and the other is an external transition. Which state(s) can perform an exit action?
46.Define Use case Driven Process
47.Which is the primary function of entity classes?
48.Which is a UML general-purpose mechanism for organizing elements into groups?
49.During Use Case Analysis, how many interaction diagrams (sequence or communication)

should be drawn for each use-case?
50.In Use Case Analysis, what is the flinction of boundary classes?

To do

2009-01-13T05:05:00.001-08:00

Find the string position wihihc needs to be extracted

இங்கிலீஷ் தமிழ்

2009-01-13T00:20:00.000-08:00

Grammer
அவன் இருந்தால் அவனிடம் கொடுப்பேன்

Code Gen from DDL

2009-01-12T02:54:00.000-08:00

Convert the below DDL to Java/PHP Code
/**
** atm.sql
** $Revision: 1.1 $
** $Log: atm.sql,v $
** Revision 1.1 2004/08/23 20:22:55 vz86k2
** check in
**
**/

/**
** ATM_VENDOR Table
**/

DROP TABLE ATM_VENDOR CASCADE CONSTRAINTS;

CREATE TABLE ATM_VENDOR (
VENDOR_ID NUMBER(10) NOT NULL,
NAME VARCHAR2(50) NOT NULL
);
ALTER TABLE ATM_VENDOR
ADD ( PRIMARY KEY (VENDOR_ID) );

DROP SEQUENCE ATM_VENDOR_SEQUENCE;
CREATE SEQUENCE ATM_VENDOR_SEQUENCE START WITH 100;

/**
** ATM_USER Table
**/

DROP TABLE ATM_USER CASCADE CONSTRAINTS;

CREATE TABLE ATM_USER (
USER_ID NUMBER(10) NOT NULL,
NETID VARCHAR2(8) NOT NULL
);

ALTER TABLE ATM_USER
ADD ( PRIMARY KEY (USER_ID) );

DROP SEQUENCE ATM_USER_SEQUENCE;
CREATE SEQUENCE ATM_USER_SEQUENCE START WITH 100;

/**
** ATM_USER_ROLE Table
**/

DROP TABLE ATM_USER_ROLE CASCADE CONSTRAINTS;

CREATE TABLE ATM_USER_ROLE (
ROLE_ID NUMBER(10) NOT NULL,
ROLE VARCHAR2(30) NOT NULL
);

ALTER TABLE ATM_USER_ROLE
ADD ( PRIMARY KEY (ROLE_ID) );

DROP SEQUENCE ATM_USER_ROLE_SEQUENCE;
CREATE SEQUENCE ATM_USER_ROLE_SEQUENCE START WITH 100;

/**
** ATM_USER_ROLE_TO_USER Table
**/

DROP TABLE ATM_USER_ROLE_TO_USER CASCADE CONSTRAINTS;

CREATE TABLE ATM_USER_ROLE_TO_USER (
ROLE_ID NUMBER(10) NOT NULL,
USER_ID NUMBER(10) NOT NULL
);

ALTER TABLE ATM_USER_ROLE_TO_USER
ADD ( PRIMARY KEY (ROLE_ID, USER_ID) );

CREATE INDEX ATM_USER_ROLE_TO_USER_INDEX ON ATM_USER_ROLE_TO_USER
(
USER_ID ASC
);

ALTER TABLE ATM_USER_ROLE_TO_USER
ADD ( FOREIGN KEY (USER_ID)
REFERENCES ATM_USER );

ALTER TABLE ATM_USER_ROLE_TO_USER
ADD ( FOREIGN KEY (ROLE_ID)
REFERENCES ATM_USER_ROLE );

/**
** ATM_CODE Table
**/

DROP TABLE ATM_CODE CASCADE CONSTRAINTS;

CREATE TABLE ATM_CODE (
CODE_ID NUMBER(10) NOT NULL,
CODE_GROUP VARCHAR2(50) NOT NULL,
VALUE VARCHAR2(100) NOT NULL
);

ALTER TABLE ATM_CODE
ADD ( PRIMARY KEY (CODE_ID) );

DROP SEQUENCE ATM_CODE_SEQUENCE;
CREATE SEQUENCE ATM_CODE_SEQUENCE START WITH 100;

CREATE INDEX ATM_CODE_INDEX_2 ON ATM_CODE
(
CODE_GROUP ASC
);

/**
** ATM_PRODUCT Table
**/

DROP TABLE ATM_PRODUCT CASCADE CONSTRAINTS;

CREATE TABLE ATM_PRODUCT (
PRODUCT_ID NUMBER(10) NOT NULL,
VENDOR_ID NUMBER(10) NOT NULL,
NAME VARCHAR2(100) NOT NULL,
DESCRIPTION VARCHAR2(255) NOT NULL,
CATEGORY_CD_ID NUMBER(10) NOT NULL,
ACQUISITION_METHOD VARCHAR2(255) NOT NULL,
LICENSE_PRICE DECIMAL(12,2) NOT NULL,
MAINTENANCE_COST DECIMAL(12,2) NOT NULL,
EXT_MAINTENANCE_COST DECIMAL(12,2) NOT NULL,
LICENSE_TYPE_CD_ID NUMBER(10) NOT NULL,
LICENSE_QUANTITY NUMBER(10) NOT NULL,
TOTAL_COST DECIMAL(10,2) NOT NULL,
LICENSE_OWNER_CD_ID NUMBER(10) NOT NULL,
LICENSE_RENEWED_CD_ID NUMBER(10) NOT NULL,
LICENSE_RENEWED_BY_DT DATE NOT NULL,
TOOL_STATUS_CD_ID NUMBER(10) NOT NULL,
PRODUCT_COMMENT VARCHAR(512) NOT NULL
);

ALTER TABLE ATM_PRODUCT
ADD ( PRIMARY KEY (PRODUCT_ID) );

DROP SEQUENCE ATM_PRODUCT_SEQUENCE;
CREATE SEQUENCE ATM_PRODUCT_SEQUENCE START WITH 100;

ALTER TABLE ATM_PRODUCT
ADD ( FOREIGN KEY (VENDOR_ID)
REFERENCES ATM_VENDOR );

ALTER TABLE ATM_PRODUCT
ADD ( FOREIGN KEY (CATEGORY_CD_ID)
REFERENCES ATM_CODE );

ALTER TABLE ATM_PRODUCT
ADD ( FOREIGN KEY (LICENSE_TYPE_CD_ID)
REFERENCES ATM_CODE );

ALTER TABLE ATM_PRODUCT
ADD ( FOREIGN KEY (LICENSE_OWNER_CD_ID)
REFERENCES ATM_CODE );

ALTER TABLE ATM_PRODUCT
ADD ( FOREIGN KEY (LICENSE_RENEWED_CD_ID)
REFERENCES ATM_CODE );

ALTER TABLE ATM_PRODUCT
ADD ( FOREIGN KEY (TOOL_STATUS_CD_ID)
REFERENCES ATM_CODE );

/**
** ATM_PROJECT Table
**/

DROP TABLE ATM_PROJECT CASCADE CONSTRAINTS;

CREATE TABLE ATM_PROJECT (
PROJECT_ID NUMBER(10) NOT NULL,
NAME VARCHAR2(50) NOT NULL
);

ALTER TABLE ATM_PROJECT
ADD ( PRIMARY KEY (PROJECT_ID) );

DROP SEQUENCE ATM_PROJECT_SEQUENCE;
CREATE SEQUENCE ATM_PROJECT_SEQUENCE START WITH 100;

/**
** ATM_PRODUCT_TO_PROJECT Table
**/

DROP TABLE ATM_PRODUCT_TO_PROJECT CASCADE CONSTRAINTS;

CREATE TABLE ATM_PRODUCT_TO_PROJECT (
PRODUCT_ID NUMBER(10) NOT NULL,
PROJECT_ID NUMBER(10) NOT NULL
);

ALTER TABLE ATM_PRODUCT_TO_PROJECT
ADD ( PRIMARY KEY (PRODUCT_ID, PROJECT_ID) );

ALTER TABLE ATM_PRODUCT_TO_PROJECT
ADD ( FOREIGN KEY (PRODUCT_ID)
REFERENCES ATM_PRODUCT );

ALTER TABLE ATM_PRODUCT_TO_PROJECT
ADD ( FOREIGN KEY (PROJECT_ID)
REFERENCES ATM_PROJECT );

English Learn a new Word

2009-01-12T01:58:00.000-08:00

1)Indulge - Spoil (21/12/2009)

2)Pledge - Promise (21/12/2009)
I Pledge to live by company values

3)relentless - persistent (21/12/2009)
Example : Behind the contract there is and relentless team.

4.)Snap - Break (21/12/2009)
Example : Vaiko dont want to Snap AIADMK relation

29/12/2009
===========
5) Vain : Unproductive of success.
Jeyasurya's 100 in first Test went vain.

6) Speculation - Guess

7) Conviction - strong beleive
(An unshakable belief in something without need for proof or evidence)

Sentense : no Speculation pure Conviction (a stement by CIBIL)

8)Refrain - avoid doing (30/12/2009)
Example : I am going to refrain from falling into that trap.

9)Scary- frightening- fearsome
Example - It was a scary thought to go and work somewhere else.

10)depicts - show , describe (04/02/2009)
"This scene depicts country life"

11)enmity - un friendly
“Ramadoss trying to create enmity between me and Centre”

12)India clinches series with a thumping win

Un completed task

2009-01-09T04:51:00.000-08:00

Extract Multiple line Using regular expresion by PHP

On Line Test Creator

2009-01-05T06:45:00.000-08:00

How to covenvert the below questions into SQL Insert Statement using regular expression

QUESTION 31

What is the purpose of the Identify Design Mechanisms activity?
A. to refine the analysis mechanisms and specify the exact implementation of the mechanism
B. to provide a conceptual set of services that is used by analysis objects
C. to refine analysis mechanisms into design mechanisms, based on the constraints imposed by the implementation environment
D. to define design placeholders in the architecture so the architecting effort remains focused and is less likely to become sidetracked
Answer: C

Tech detail required in regular expression :

1.Create a class
2.Find match for required string
3.Read line and store in class

Logic :

Read Line till the EOF
Find Question :
Check for the word “Question “ and a “Numeric Value”.
If true then split question and Question Number by using “Question Symbol” or “A.”.

Find Answer description :
Continue reading lines and splits answers by using “A.”. “B.”. “C.”. “D.”. until it finds a word with “Answer:”

Find Answer :

Split the line which contains Answer: into the words Answer: and Answers Symbols.

Note : Multiple answers considered as same word.
Assumption In multiple choice questions answer notation are stored in Sorted order.

Class Question
{
int question_topic;
int question_number;
String question;
}
Class Answers
{
int question_topic;
int question_number;
String answer;
String correct_answer;
}

Tech Detail :
Parse Question :
Set int question_topic; int question_number; String question; into Question Object

Answer : Looping till find “Answer:” and Parse Answers :
set int question_topic; int question_number; String answer; String correct_answer; into Answers object.

Notes :
1 to many
Has a
Composite

Approach 1 :
read line by line.

Issue :
If question contains more than one line It won't handled

Approach 2 :
Read Question by question

Analyse :
How to read question by question

Issue :
If question contains more than one line It won't handled

Approach 3 :

read line by until it a question completes. Use String tokeniser, string existence and manipulate

UML Link

2008-12-19T06:54:00.003-08:00

http://kickstartuml.googlepages.com/

Analysis :

Section 1: UML and the Modeling Process
Section 2: Concepts of Object Orientation
Section 3: Architectural Analysis
Section 4: Use Case Analysis

Design :
Section 1: Identify Design Elements
Section 2: Concepts of Object Orientation
Section 3: Distribution
Section 4: Use Case Design
Section 5: Subsystem Design
Section 6: Class Design

Test 833: Object Oriented Analysis and Design - Part 1 (Analysis)

Section 1: UML and the Modeling Process (20%)

a. The Unified Modeling Language
b. Process and Visual Modeling
c. Analysis & Design Key Concepts

Section 2: Concepts of Object Orientation (40%)

a. Relationships
b. Class
c. Polymorphism
d. Interface
1. Provided
2. Required
e. Structured Classes & Ports

Section 3: Architectural Analysis (20%)

a. Key Concepts
b. Define high-level organization of the model
c. Identify analysis mechanisms
d. Identify key abstractions
e. Create use-case realizations

Section 4: Use Case Analysis (20%)

a. Supplement the Use-Case Description
b. For each Use-Case Realization
1. Find Classes from Use-Case Behavior
2. Distribute Use-Case Behavior to Classes

c. For each resulting analysis class
1. Describe Responsibilities
2. Describe Attributes and Associations
3. Qualify Analysis Mechanisms

d. Unify Analysis Classes

Test 834: Object Oriented Analysis and Design - Part 2 (Design)

Section1: Identify Design Elements (17%)

a. Identify classes and subsystems
b. Identify subsystem interfaces
c. Update the organization of the Design Model

Section 2: Identify Design Mechanisms (8%)

a. Categorize clients of analysis mechanisms
b. Document architectural mechanisms

Section 3: Distribution (17%)

a. Define the network configuration
b. Allocate processes to nodes
c. Define the distribution mechanism

Section 4: Use Case Design (22%)

a. Describe interaction among design objects
b. Simplify sequence diagrams using subsystems
c. Describe persistence-related behavior
d. Refine the flow of events description
e. Unify classes and subsystems

Section 5: Subsystem Design (11%)
a. Distribute subsystem behavior to subsystem elements
b. Document subsystem elements
c. Describe subsystem dependencies

Section 6: Class Design (25%)

a. Create Initial Design Classes
b. Define Operations
c. Define Methods
d. Define States
e. Define Attributes
f. Define Dependencies
g. Define Associations
h. Define Internal Structure
i. Define Generalizations
j. Resolve Use-Case Collisions
k. Handle Nonfunctional Requirements in General

SCJP 1.5 Link

2008-12-19T06:54:00.001-08:00

http://www.examulator.com/phezam/selectsubject.php http://www.indijava.in/community/forum/imporatantmust-have-questions-scjp-java-5

regular Expression Samples

2008-12-19T06:46:00.000-08:00

This is good example for regular Expression

http://www.phpf1.com/tutorial/php-regular-expression.html

Useful php link for regular expression extractor

HTML FILE READ using regular expresssion

Simple PHP Examples

Regular expression Cheat Sheet

The regular expressions basic syntax
To use regular expressions first you need to learn the syntax of the patterns. We can group the characters inside a pattern like this:
Normal characters which match themselves like hello
Start and end indicators as ^ and $
Count indicators like +,*,?
Logical operator like
Grouping with {},(),[]
An example pattern to check valid emails looks like this:
Code: ^[a-zA-Z0-9._-]+@[a-zA-Z0-9-]+\.[a-zA-Z.]{2,5}$

Count indicators like +,*,?

“+” : There is at least 1 "d" after "worl"
“*” : There is 0 or more "d" after "worl"
“?” : There is 0 or 1 "d" after "worl"

Logical operator like

“” : The string contains the "earth" or the "world"

Grouping with {},(),[]

{} : deals with last single character
world{1} There is 1 "d" after "worl"
world{1,} There is 1 ore more "d" after "worl"
world{2,3} There are 2 or 3 "d" after "worl"
()
wo(rld)* There are 2 or 3 "d" after "worl"
[]
[abc] There is an "a" or "b" or "c" in the string abc, bbaccc

Other Symbols “.”, ”-“, “^”
. Any character in place of the dot.

- [a-z] There are any lowercase letter in the string
[a-zA-Z] There are any lower- or uppercase letter in the string

^[^wW] The actual character can not be a "w" or "W"

import java.util.regex.*;
import java.io.*;

public class MultipleFlag{
public static void main(String[] args){
String inputStr = "Abc\ndef";

//Simply print the original string.
System.out.println(inputStr);
String patternStr = "\n";

// Compile with multiline and case-insensitive enabled.
Pattern pattern = Pattern.compile(patternStr, Pattern.MULTILINE | Pattern.CASE_INSENSITIVE);
Matcher matcher = pattern.matcher(inputStr);

//Finding new line and replacing with a tab.
boolean matchFound = matcher.find();
String str = matcher.replaceAll("\t");

System.out.println(matchFound);
System.out.println(str);

//Split from where the new line character lies in the string.
String[] strg = "Abc\ndef".split("\n");
for (int i =0; i < strg.length; i++){
System.out.print(strg[i] + " ");
}
}
}

import java.util.regex.Pattern;

public class NLMatch {
public static void main(String[] argv) {

String input = "I dream of engines\nmore engines, all day long";
System.out.println("INPUT: " + input);
System.out.println();

String[] patt = { "engines.more engines", "engines$" };

for (int i = 0; i < patt.length; i++) {
System.out.println("PATTERN " + patt[i]);

boolean found;
Pattern p1l = Pattern.compile(patt[i]);
found = p1l.matcher(input).find();
System.out.println("DEFAULT match " + found);

Pattern pml = Pattern.compile(patt[i], Pattern.DOTALL
| Pattern.MULTILINE);
found = pml.matcher(input).find();
System.out.println("MultiLine match " + found);
System.out.println();
}
}
}