Web Resource for Java Programmers: Work With Teradata Using Java

Interface: Interfaces can be used to implement the Inheritance relationship between the non-related classes that do not belongs to the same hierarchy, i.e. any Class and any where in hierarchy

Enterprise Java Bean Application Development With A Three-Tier Architecture

Enterprise java beans is basically a server side component architecture for developing modular enterprise applications based on the java platform

Use Of Hibernate With Java Persistence API

Hibernate has become immensely popular amongst the developer community as it is a free, powerful, high performance open source object

Java Embedded Applications

Java, or J2ME is a format for applications for mobile and PDAs. It provides software that can been added to mobile phones

How Does Java Handle Overriding?

Overriding tactics in Java is very different from C++ as methods by default in Java can be overridden unlike C++. In C++, the concept of overriding functions are handled by Virtual Table, VTable

Work With Teradata Using Java

Teradata is one of the leading vendor in data analytics and data warehousing applications and softwares.

Point To Point Video Conferencing Using Java's JMF API

When a face-to-face meeting with someone far away becomes a necessity or a compelling presentation must be given to a remote person,

Learning Java Programming Coding Language

There are many programming languages available and each of them is suitable for another program or application.

Java Hashtable

A collection allows a group of objects to be treated as a single unit.

Working With JNDI In A J2SE Application

Java Naming and Directory Interface (JNDI) allows Java objects to be published to a directory service which can be accessed by other Java applications later.

Java Games - The World Of Excitement Is Readying With Options!

Mobile phones have grown from the pedestal of a mere communication tool and with the aid of some innovative steps plus the technological up-gradation

Everything You Need To Know And How To Use Java

Java is an object-oriented programming language developed by Sun Microsystems in the early 1990s

Of CGI And Java Scripts

CGI and Java Scripts are both functional with both Netscape and Internet Explorer browsers.

Free Java Games - Entertain Yourself In Your Leisure Time

Today, you can find cell phones having multifunctional organisational tools

Ajax Applications Development

AJAX has not only sprouted but has got root hold in developing dynamic web applications,

Benefits And Pitfalls Of A Java-Based Forex Trading Platform

Many forex brokers today offer a Java-based platform to traders as opposed to the traditional software that needs to be installed on your computer.

Point To Point Video Conferencing Using Java's JMF API

When a face-to-face meeting with someone far away becomes a necessity or a compelling presentation must be given to a remote person, video conferencing is always your best choice

What Is CLASSPATH

A path specifies the name and location of a file on the file system.

Javascript Is Not Java

Repeat after me: JavaScript is not Java, JavaScript is not Java. . .

Eclipse IDE

Eclipse is an open-source, platform-independent software framework for delivering what the project calls "rich-client applications".

Tomcat Jsp Run Error:Unable To Find A Javac Compiler

I always get this error when I run simple jsp files in my Tomcat 5.0.19/win2000. These jsp files run on other versions of Tomcat on the same PC. Any ideas?

Deploying Web Applications To Tomcat

In this article we are going to cover the deployment of web applications using Tomcat.

Running The Tomcat 4.0 Servlet/JSP Container

Tomcat 4.0, a server that implements the Servlet 2.3 and JSP 1.2 Specifications from Java Software. In order to install and run this container, you must do the following

SOAP Example

In the example below, a GetStockPrice request is sent to a server. The request has a StockName parameter, and a Price parameter will be returned in the response.

SOAP HTTP Binding

HTTP communicates over TCP/IP. An HTTP client connects to an HTTP server using TCP. After establishing a connection, the client can send an HTTP request message to the server:

SOAP Fault Element

The optional SOAP Fault element is used to hold error and status information for a SOAP message.

SOAP Body Element

The mandatory SOAP Body element contains the actual SOAP message.

Introduction To SOAP

SOAP is a simple XML based protocol to let applications exchange information over HTTP.

Where Did Java Come From?

In the late 1970's Bill Joy thought about doing a language that would merge the best features of MESA and C

What Is Java?

Java, formerly known as oak, is an object-oriented programming language developed by Sun

How Do I Format Numbers Like C's Printf()?

Java does not have any built in equivalent to C's printf/sprintf/fprintf family of functions that specify the width and precision of numbers converted into strings.

How Do I Play A Sound In An Application?

Java's audio support comes from the AppletContext class and the AudioClip interface. Since applications don't have applet contexts, they have no easy way to play audio clips

Java Interview Questions

Java Interview Questions for java programmers !

Java Games For Your Cell Phone

Are you one of those people who get tired when standing in queue? Can't stop multitasking no matter what you do

Pros And Cons Of JavaScript

Javascript use is very common across the Internet; but just because it is popular, does that mean you should use it for your site

Tag Libraries

JSP 1.1 introduces a method of extending JSP tags, called "tag libraries".

Beans And Form Processing

The standard way of handling forms in JSP is to define a "bean". This is not a full Java bean.

JSP Sessions

If you are programming the site, it is very helpful to be able to associate some data with each visitor. For this purpose, "session"s can be used in JSP

JSP Tags

Another important syntax element of JSP are tags. JSP tags do not use <%, but just the < character. A JSP tag is somewhat like an HTML tag.

JSP Directives

We have been fully qualifying the java.util.Date in the examples in the previous sections. Perhaps you wondered why we don't just import java.util.*;

Mixing Scriptlets And HTML

We have already seen how to use the "out" variable to generate HTML output from within a scriptlet.

JSP:Scriptlets

JSP also allows you to write blocks of Java code inside the JSP. You do this by placing your Java code between <% and %> characters

Related Links

Amazon.com Widgets

Java4Programmers.com This is a high-level informational site for java programmers outside of Sun Microsystems. This is a categorized directory of information sources for Java, including sources, communities, tools, etc.

J2ee : Work With Teradata Using Java

Teradata

Teradata is one of the leading vendor in data analytics and data warehousing applications and softwares. Especially the Teradata RDBMS is widely used across various industries like airlines, logistics, Insurance, Retail etc. Teradata DBMS is known for its ruggedness, scalability, handling complex queries to retrieve data and ofcourse for the better load balancing. Teradata can be interfaced by any CLI (Call Level Interface) , JDBC (Java Database Connectivity) and ODBC (Open Database Connectivity) clients. In this article we will look into how to query teradata in 3 steps using the widely used language Java programmatically.

Using Teradata driver for JDBC Interface

In this tutorial we are going to look at the example of a Java client interacting with Teradata using Teradata driver for JDBC Interface. The java client can be a normal java class or an applet. JDBC is an interface provided by Sun allows applications to interact with different databases irrespective of the vendor and platform. To interact with Teradata, the Teradata driver for JDBC Interface needs to be installed first by downloading it from the site. More information is provided in the below given section. The Teradata driver for JDBC Interface is nothing but a bridge built with java classes that helps to interact with JDBC Interface to work with Teradata database.

Java Client ----> Teradata JDBC Bridge ----> JDBC ----> Teradata RDBMS

Teradata driver for JDBC Interface uses a 3 tier architecture to access the Teradata database and it is the only because the database IPs will not be exposed to clients directly. So Teradata driver for JDBC Interface acts as a Teradata JDBC Gateway.

Assumptions:

Basic working knowledge of java and database connectivity using JDBC
A valid teradata database

Step I:

Install the right version of Teradata Driver for the JDBC Interface. Make sure that TERAJDBC variable is present in your environmental variables. If not set it to the folder where you have installed the driver.
eg) TERAJDBC = C:/NCR/TeraJDBC

Step II:

Please place the following files in your client classpath. The client can be a plain-java client or can be a web client. In case of web client pls place the files in the server classpath.

TdgssUserConfigFile.xml - configuration file for teradata
terajdbc4.jar - teradata drivers for JDBC Interface jars
tdgssjava.jar - teradata drivers for JDBC Interface jars

Step III:

Integrate the following code to connect to terradata database

/* Create the URL that is needed to connect to the Teradata RDBS */
String databaseURL = "jdbc:teradata://127.0.0.1/schema";

/* Loads the driver */
Class.forName("com.ncr.teradata.TeraDriver");

/* Creates the connection to teradata database using driver for JDBC Interface */
Connection c = DriverManager.getConnection(databaseURL, databaseUserName, databaseUserpassword);

Replace 127.0.0.1 in databaseURL with teradata database servername or IP
Replace schema in databaseURL with terdata database name
Replace databaseUserName with your terdata database user name
Replace databaseUserpassword with your terdata database user password

Note:

If you don't have the library and driver mentioned in step I and Step II download it from the URL http://www.teradata.com/resources/drivers-udfs-and-toolbox

You can find related and other java articles and technology articles at http://www.digitalprank.org

Article Source: http://EzineArticles.com/?expert=Sara_P

Other Relevant Articles from this Category:

Distributed Multitiered Applications

Working With JNDI In A J2SE Application

Work With Teradata Using Java

Use Of Hibernate With Java Persistence API

Enterprise Java Bean Application Development With A Three-Tier Architecture

Java 2 Platform Enterprise Edition (J2EE) Three-Tier Model

Hibernate Vs JDBC Performance

More Categories:

Java Script