Now remove your default source folder by selecting “src” and then picking the "Remove source folder" option. Later in following articles different source folders will be added such as “src/config” and “src/test”. This is done to give the Java project structure. In this example, the “src” folder is going to be deleted and the “src/java” folder will be added. Enter “teradata_jxsp” for the Java project name. Then go to the package explorer in Eclipse and right click New->Java Project. Go to the top of the Eclipse IDE and select the pull down menu Window ->Perspective->Other. You will need to create a Java project to store the Java source of the JXSP. You will use the JXSP Wizard to implement this JXSP. In this example, you will be creating a JXSP which takes a full name and returns a last name from the full name. If you have not work through the guide Getting Started with Teradata Plug-in for Eclipse, do so now before you continue. This article will show how the Teradata Plug-in for Eclipse facilitates the process of creating and installing the Java parts and DDL for a JXSP using the JXSP Wizard and Multi-page Editor. Also Java stored procedures can perform faster than Java applications running in an application server because they are running inside their own dedicated Java Virtual Machine (JVM). A JXSP minimizes the overhead of network latency because it is operating closer to the data. The JXSP are executed via a protected mode server separate from the database process.Ī JXSP Provides an advantage over Java applications that access the database directly in that a JXSP can take advantage of the existing database access control security. Once a JAR file is installed the JXSP can be defined to use the Java class and methods within the JAR file. These JAR files are installed into the database using stored procedures in the SQLJ database. This means the source is compiled externally to the DBS and kept in Java Archive (JAR) files. Java stored procedures are implemented as external stored procedures. A Java External Stored Procedure (JXSP) is a program written in Java that is kept and executed with in a database server.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |