0 - 6 of 6 tags for java external stored procedure

In this blog I would like to share my knowledge on how you can use a Java External Stored Procedure (JXSP) to write to a file on a file system. 

In order to perform an IO operation (e.g. write to a text file) from the JXSP, you need to do the following :

Did you know you can import existing Java Stored Procedures into the JXSP Multi-Page Editor with the JXSP Wizard using the Teradata Plug-in for Eclipse? When you use the import feature, your JXSP must have a Java Package. Do not use the default package when importing.

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.

In the first two parts of this Mini Section we have been looking at the concept of Embedding analytical processing directly within the Teradata Database. Part one used a SQL Stored Procedure to act as an Isolation layer between the Enterprise Application and the Teradata Database. Part two replicated this isolation concept using the Java External Stored Procedure (JXSP) approach. Part three combined the JXSP with the previously prepared, Spring Framework based, Business Processes. This final Part illustrates how to little code is now required in the Presentation Veneer (Web service process) due to the embedding of the Business Logic within the Teradata Database.

In the first two parts of this Mini Section we have been looking at the concept of Embedding analytical processing directly within the Teradata Database. In the first part we used a SQL Stored Procedure to act as an Isolation layer between the Enterprise Application and the Teradata Database. In the second part we progressed along the same line of providing an Isolation layer but this time we employed the Java External Stored Procedure (JXSP) approach. In this third part we combine the JXSP, as an Isolation layer in order to cross the great divide between the enterprise and the database, with the TZA-InsuranceProcess business processes developed previously.

Last time we introduced the SQL Stored Procedure as a means to provide for Embedded Analytics.

However, as of Teradata 12.0 it is possible to use the Java Language as the basis for External Stored Procedures (known as JXSP’s), so this week we will develop a Java based version of the ApplyRiskFactorsToQuote Stored Procedure.

TD12+