Tech Guy on September 30th, 2009

With Visual Studio 2010 and the .NET Framework 4.0, Microsoft is focused on the core pillars of developer experience, support for the latest platforms spanning client, server, services and devices, targeted experiences for specific application types, and core architecture improvements
Much awaiting features are expected to be included with this release, Some of them are [...]

Continue reading about Visual Studio 2010 Great functionality for Developers

To export the dynamic contents into Microsoft Excel’s multiple sheets.
JSP:
Through JSP the data could be added to the xls by setting the content type as “vnd.ms-excel” as below
response.setContentType("application/vnd.ms-excel");
But the data could only be appended to single sheet of the spreadsheet. Formatting of data will be difficult
JavaScript:
Java script dose not have any ready to access objects [...]

Continue reading about How to Export Data to Multiple sheets of Microsoft Excel Using VBScript

Tech Guy on September 30th, 2009

In Oracle 10G, when we return from a java stored a response which size can be greater than 32767 (PLSQL limit for a varchar2) then we get “ORA-24345: A TRUNCATION OR NULL FETCH ERROR ” error.
To avoid getting this error is to return a Clob instead of Varchar2.
Steps to be followed

Create a [...]

Continue reading about Good to use CLOB instead of VARCHAR2 in Java Stored Procedure

Tech Guy on September 24th, 2009

Overview of Jquery Ajax
Jquery API is extension of the JavaScript language. It supports methods which make it easy to write complex client side scripts. The creators of JQuery specifically created the library to make common tasks trivial.
Ajax is key part of the websites now a days and asynchronous JavaScript is used widely to do [...]

Continue reading about Call ASP.net MVC Server side function using Jquery Ajax

Tech Guy on September 24th, 2009

HOW TO USE LOG4J WITHIN ECLIPSE WHILE RUNNING JUNIT TEST CASES If the loggers are not initialized or set properly in eclipse while running the junit test cases we get the following error message:
“log4j:WARN No appenders could be found for logger log4j:WARN Please initialize the log4j system [...]

Continue reading about How to print loggers(log4j) while running Junit Test cases.

Tech Guy on September 23rd, 2009

Contents

Credit Cards

Monthly Billing Cycle
Grace period
Late Payment

How credit card companies make money?
Overview of Credit Card Processing

Authorization
Canceling an authorization hold
Batching
Clearing and Settlement
Funding
Process Flow Diagram

Chargebacks

Some of the reasons for a chargeback
Process Flow Diagram

Glossary of terms

1 Credit Cards
A credit card is part of a system of payments named after the small plastic card issued to users of the system. [...]

Continue reading about Credit Card Transaction Lifecycle

Tech Guy on September 23rd, 2009

Virtual Private Database
Virtual Private Database which is also known as Fine Grained Access Control (FGAC) is a new feature available with Oracle for providing row level restrictions on tables. Normally data restrictions are provided with views. The complexity grows exponentially with the number of views present in a database. Maintenance becomes a big task with [...]

Continue reading about Virtual Private Database (ORACLE)

Tech Guy on September 23rd, 2009

The best practices in software testing can be classified into the following types:

Basic Best Practices
Foundational Best Practices

Basic Best Practices
As the name indicates these are the best practices known to a tester with a minimal testing experience.
Functional Specifications
The testers use this to write down test cases from a black box testing perspective. The advantage of having [...]

Continue reading about Software Testing Best Practices

Tech Guy on September 22nd, 2009

Microsoft says that SQL Server Integration Services (SSIS) “is a platform for building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.” A simpler way to think of SSIS is that it’s the solution for automating SQL Server. SSIS provides a way to build packages made up of tasks [...]

Continue reading about Steps to Create and Deploy SSIS Package as a SQLAgent Job

Tech Guy on September 22nd, 2009

JavaScript tricks for ASP.Net developers
Every ASP.Net site on the Internet has various user controls and almost every developer have to handle these controls in JavaScript. Most developers face problem finding these ASP.net user controls in JavaScript side. If you have ever wanted to handle ASP.Net controls in JavaScript, this article should [...]

Continue reading about Handling ASP.Net Controls in JavaScript