50 - 95 of 95 tags for java

Pages

Data Mover is a Teradata Application that allows users to copy databases or tables between Teradata systems. It is a J2EE-based application that is composed of three major code components: the Client (Command-line interface or Viewpoint portlet), the Daemon, and the Agent.

iBatis and MyBatis support custom types to override JDBC and other types when using the iBatis or MyBatis frameworks. A custom data type gives you the ability to deal with any kind of special input and output handling you may need for a database data type. For example, a User Defined Type (UDT)  that represents a point would require an X and Y Position to be entered for input and an X and Y position to be retrieved from the database. The custom data type gives you a clearly defined programmatic mechanism to do this.

iBatis is now called MyBatis (iBatis 3.0). MyBatis is no longer sponsored by Apache. It is now supported on Google code. The MyBatis framework is a lightweight data mapping framework and persistence API. It couples objects with stored procedures or SQL statements using an XML descriptor.  The Teradata Plug-in for Eclipse allows you to switch between creating projects that use MyBatis or iBatis using the Teradata Project preferences. When you switch to use MyBatis, you can use new features like User Generated Keys.

User Generated Keys are unique identifiers returned from MyBatis during an insert operation. This tutorial will go through creating a Web service using user generated keys with MyBatis.

The iBatis (MyBatis) Stored Procedure Wizard allows you to right click on a Stored Procedure in the Teradata plug-in for Eclipse and quickly create a Web service.

The iBatis Stored Procedure Wizard wraps a Stored Procedure into an iBatis or MyBatis SQL Map. The generated SQL map can then be used to create a Web service or it can be used to create a Java application that uses the iBatis or MyBatis frame works.

Teradata Studio Express is an information discovery tool that retrieves data from Teradata and Aster Database systems and allows the data to be manipulated and stored on the desktop. It is built on top of the Eclipse Rich Client Platform (RCP).

Teradata Studio Express 14.00 (formerly Teradata SQL Assistant Java Edition) is now available for download. Teradata Studio Express is an information discovery tool for retrieving and displaying data from your Teradata Database systems.

Teradata’s latest and greatest Eclipse offering has been released and is available in the Teradata Developer Exchange download section (Teradata Plug-in for Eclipse) . The 14.00.00 release builds on the 13.11.00 offering by boasting increased functionality.

Reviewing the TPT manuals, I do not see a set of coding examples using Java.  This is a show-stopper for anyone using Java programs to use TPT.  I would like to see such an example in this forum and in the manuals because Java is arguably the most important enterprise languag

As most of you might agree, managing our collections of digitial pictures is becoming quite a challenge.  The number of photos continues to increase and now includes pictures from cameras as well as multiple mobile devices.  And to add to my troubles, I find that I have duplicate copies in different folders and on different computers.  Getting this organized is becoming a high priority.  Sure there are management solutions already available, but hey, we're tech people and it's more fun to try to build our own!  With the free Teradata Express database and some java coding, we have the right tools to get started.

CRUD is defined as the following functions of persistent storage:

  • Create — Insert a row into a Database Table
  • Read — Selecting information from a Database Table
  • Update — Update a row for a Database Table
  • Delete — Remove a row from a Database Table

The iBatis CRUD Wizard will generate the SQL and the iBatis code for all the CRUD operations for a selected database table in the Teradata Plug-in for Eclipse.  The generated iBatis SQL map can then be used to create a Web Service or used to create a Java application that uses the iBatis frame work. This will give you a quick and easy way to create an application that can do basic operations on a Teradata database table.

Teradata’s latest and greatest Eclipse offering has been released and is available in the Teradata Developer Exchange download section (Teradata Plug-in for Eclipse) . The 13.11.00 release builds on the 13.10.00 offering by boasting increased functionality.

Teradata SQL Assistant Java Edition release 13.11 is now available for download. SQLA JE is an information discovery tool for retrieving and displaying data from your Teradata Database systems. It can be run on multiple operating system platforms, such as Windows, Linux, and Mac OSX.

Hi guys I am a beginner and received an email from Oracle regarding JavaOne & Oracle Develop conference 2011 to be held in Hyderabad..

The iBatis DAO with Web Services Wizard will generate a Web Service from an iBatis SQL Map. The wizard derives all of the information needed from the iBatis SQL Map to generate the following components to create a Web service:

  • DAO (Data Access Object)
  • WSDL (Web Service Definition Language)
  • XSD (XML Schema Definition)
  • Spring Configuration files

The wizard will then use the Eclipse Web Tools Platform (WTP) and Apache Axis to generate the server and client classes for the Web service. The generated classes will include code that supports Query Bands via the Teradata Access Session Manager.

 

Teradata SQL Assistant Java Edition release 13.10 is now available for download. SQLA JE is an information discovery tool for retrieving and displaying data from your Teradata Database systems. It can be run on multiple operating system platforms, such as Windows, Linux, and Mac OSX.

Teradata’s latest and greatest Eclipse offering has been released and is available in the Teradata Developer Exchange download section (Teradata Eclipse_13.10.00). The 13.10.00 release builds on the 13.02.00 offering by boasting increased functionality.

Disclaimer: I don't know Java nor Eclipse.

Teradata 13.0 supports a Java User Defined Function (JUDF) capability, which returns an Aggregate. Aggregate functions produce summary results. In the last Article, you were shown how simple it is to create a Table JUDF using Teradata tools. Now, in this article you will be shown how easy it is to create an Aggregate JUDF using the Teradata Plug-in from Eclipse. The Teradata JUDF Wizard and Editor simplify the process of creating, installing and editing an Aggregate JUDF.

Teradata 13.0 supports Table Java User Defined Functions (JUDF). A Table Java User Defined Function returns a table of data a row at a time in a loop to the caller of the function. This article will show you how to use the Teradata Plug-in for Eclipse to quickly create a Table Java User Defined Function.

Teradata SQL Assistant Java Edition release 13.01 is now available for download. SQLA JE provides an information discovery tool for retrieving and displaying data from your Teradata Database systems. It can be run on multiple operating system platforms, such as Windows, Linux, and Mac OSX.

Teradata’s latest and greatest Eclipse offering has been released and is available in the Teradata Developer Exchange download section (Teradata Eclipse_13.02.00). The 13.02.00 release builds on the 13.01.00 offering by boasting increased functionality.

The iBatis framework is a lightweight data mapping framework and persistence API. It couples objects with stored procedures or SQL statements using a XML descriptor. The iBatis SQL Map wizard allows you to quickly generate an iBatis SQL map for a given SQL statement or stored procedure.

External Store procedure to read a local client file

The Teradata project is an extension of a Java project in Eclipse and it can be created by using the Teradata Project Wizard. This new type of project is set up based on Teradata Standards which can be overridden with preferences. The Teradata project will give you access to Teradata libraries.

Teradata SQL Assistant Java Edition release 13.0 is available for download. It provides an information discovery tool for retrieving and displaying data from Teradata Database systems. It can be run on multiple operating system platforms, such as Windows, Linux, and Mac OSX. It is built in top of the Eclipse Rich Client Platform (RCP) which allows SQL Assistant Java Edition to benefit from the many high quality Eclipse features available while focusing on value-add for the Teradata Database.

At this point you should already be familiar with Eclipse. But if you are not, Eclipse is the de facto integrated development environment (IDE) for developing Java applications. It provides comprehensive support for Java technologies, as well as a platform for plug-in tools to extend its capabilities.

Teradata’s latest and greatest Eclipse offering has been released, and is available in the Teradata Developer Exchange download section (Eclipse_13.01.00).  Further, the 13.01.00 release builds on the 13.00.00 offering by boasting increased functionality.


In the last article, it was shown how to create Java Bean Wrapper classes that can be called from a Spring Data Access Object (DAO) using the Java Bean Wrapper Wizard.

This article will demonstrate how to tie Java Bean Wrapper classes together using the Spring DAO Wizard to create a reusable data access layer for a business service. Also it will be shown how to create an automated unit test for your DAO.

SQL Assistant Java Edition is an information discovery tool that retrieves data from Teradata Database systems and allows the data to be manipulated and stored on the desktop. It is built on top of the Eclipse Rich Client Platform (RCP).

In parts 1 and 2, we looked at how to load and retrieve large objects using Teradata BLOBs and CLOBs. In part 1, I put forward my unbreakable golden rule that you shouldn’t simply store Object Models as Large Objects. Rather, always map your objects’ attributes to columns in a table; don’t just serialize a bunch of classes and store them in a BLOB.

In part 3, I present another of my unbreakable golden rules; which is “Rules were made to be broken”. The focus of this article is how to serialize and persist (store) an Object Model into a BLOB on Teradata and reinstate it.

This will be a series of articles explaining how the Spring framework can be used with the Teradata Plug-in for Eclipse to create a data access layer for your business services. The Java Bean Wrapper wizard allows the user to quickly generate a Java Bean class for a given SQL statement or stored procedure. Also the Wizard has an option to generate a Java Bean which can be run with the Spring Data Access Object (DAO) framework. By calling a generated Java Bean from a DAO, the Bean will have access to the Spring transaction management. Also the Java Wrapper Beans are reusable components which could be used in different DAOs. The Bean Helper Classes can be used as Spring domain objects. Also the Bean will facilitate the support of OUT parameters for stored procedures and multiple result sets inside of a Spring DAO.

This article will show how to setup a project that uses Spring DAOs with the Teradata Plug-in for Eclipse. This article will also show how to create Java Bean Wrapper classes that can be called from a Spring DAO using the Java Bean Wrapper Wizard.

A Teradata Database Java User Defined Function (JUDF) is a program that operates on data stored in relational tables. UDFs allow users to add their own extensions to the Teradata SQL language. JUDFs are implemented as external functions. This means the source is compiled externally to the DBS and kept in Java Archive (JAR) files. These JAR files are installed into the database using stored procedures in the SQLJ database. Once a JAR file is installed a JUDF can be defined to use a Java class and method within the JAR file. The JUDF is executed via a protected mode server separate from the database process. Parameters passed from the DBS are converted to their Java form and the Java return type from the JUDF  is converted back to its DBS form.
 

In the last article, it was shown how a user can create a Java External Stored Procedure (JXSP) that reads SQL using answers sets with the Teradata Plug-in for Eclipse. This article will show how a JXSP can be automatically created that reads SQL. The only thing that is required is a SQL query from the user and the content of the JXSP is automatically generated.

The Java Bean Wrapper wizard allows the user to quickly generate a Java Bean class for a given SQL statement or stored procedure. The Java Bean Wrapper Wizard has an option to create a JXSP that calls the wrapped SQL from the Java Bean.

In a typical relational database, tables are joined together via foreign key relationships. It is also common for macros and procedures to reference tables, forming dependent relationships. When making administrative decisions about database objects, it is important to know about its object relationships.

In the last article, it was shown how a user can create an ant script to automate a build so the user can deploy a JAR and install a DDL for a Java External Stored Procedure (JXSP) outside of Eclipse. This article will show how a user can create a JXSP that reads SQL using answers sets.

Answer sets are extended result sets returned by stored procedures. This is a new feature for JXSPs in the 13.0 version of the Teradata database.

In Part 1, we looked at what Large Objects are and some tactics that we could employee to load them into Teradata. As I stated back in part 1, loading large objects is great, but by itself is pretty useless. In this article, we will look at extracting Binary Large Objects from Teradata for inclusion in a web application.

But before we get to that, we need to know something about the large objects we will be dealing with.

Lately it seems like there has been quite a few questions relating to the use of Large Objects on the various Teradata forums. Mostly these revolve around the question of how do I get Large Objects into the database. So it seems like there is a bit of mystery surrounding Large Objects.

For myself, the mystery is just who is “Large” and to what does he (or she) “Object”? Perhaps "Large" objects to the veil of mystery being lifted which is what this series of articles is about - working with Large Objects.

In part 1, we will look at getting those Large Objects of yours into the Teradata. One way or another we will get them into Teradata, kicking and screaming if need be (however, it will be relatively painless, I promise) and we will do this despite any "Objections" "Large" may have.

Later in part 2, we will drag those Large Objects back out and use them in a web application.

In the last article, it was shown how Teradata Plug-in facilitates the process of creating and installing the Java parts and DDL for a Java External Stored Procedure (JXSP) using the JXSP Wizard and Multi-page Editor.

Download the Teradata JDBC Driver 13.0.0.6. This release of the JDBC driver is backwards compatible with previous releases back to Teradata Database V2R6.0.

The objective of this article is to explain step by step how to improve Talend in Teradata environment using Teradata utilities (FastLoad, MultiLoad).

If you are like me you tend to have several sandbox databases that you use day in and day out. Some on different servers all with different names and each one needing to have the latest ddl changes applied to keep things moving.

A Java External Stored Procedure (JXSP) is a program written in Java that is kept and executed with in a database server. Java stored procedures are implemented as external stored procedures. This means the source is compiled externally to the DBS and kept in Java Archive (JAR) files. These JAR files are installed into the database using stored procedures in the SQLJ database. Once a JAR file is installed the JXSP can be defined to use the Java class and methods within the JAR file. The JXSP are executed via a protected mode server separate from the database process.

At this point you should already be familiar with Eclipse. But if you are not, Eclipse is the de facto integrated development environment (IDE) for developing Java applications. It provides comprehensive support for Java technologies, as well as a platform for plug-in tools to extend its capabilities.

HTML boasts a wide range of features to present data to end users. Add in the various frameworks that “sit on top” of HTML and the web represents a rich and powerful environment through which information may be delivered to end users.

While the web is a powerful environment, there are times when a windows based application might be better suited to the task at hand. This article presents a Java class library that makes this a lot easier.