|
August 18, 2003 - Vembu Technologies, a startup company
focusing on developing database tools, announced today the
general availability of PL2JSQL 1.0, a PL/SQL to Java migration
tool. The PL2JSQL tool takes Oracle PL/SQL Packages, Procedures,
Functions and Triggers and convert them into Java code. The
converted Java code can be deployed in a standalone or a J2EE
environment with EJB wrappers for the Java based Business-Logic
code. The PL2JSQL product implements most of the PL/SQL in-built
functions as Java APIs. The converted Java code is completely
standards based with direct calls to JDBC API and does not
involve any intermediate proprietary API.
The following are some of the features in PL2JSQL Product.
Features in Release 1.0
- Enables applications to be portable across databases
- Facilitates deployment of business-logic both in the middle-tier
and database-tier
- 100% java based implementation supports Windows, Solaris,
Linux and other OSs with Java virtual machine
- Support for conversion of both PL/SQL Named blocks like
Stored Procedures, Functions, Triggers, Packages etc. as
well as Anonymous blocks to Java.
- Support for conversion of all conditional Statements including
IF - THEN - ELSE , IF - THEN - ELSIF Syntax etc.
- Support for conversion of all control Statements including
FOR loops, WHILE loops, Simple loops with EXIT or EXIT-WHEN,
RETURN etc.
- Support for both Implicit and Explicit CURSOR constructs
and Cursor attributes facilitating data retrieval
- Support for PL/SQL User Defined Data Types and Structures
like PL/SQL Tables, Records, REF Cursor, Collections etc.
- Transaction features like 'COMMIT', 'ROLLBACK', 'SAVEPOINT'
etc. are supported
- Support for converting Oracle specific SQL queries into
other target database syntax like MSSQL-Server, DB2, Informix,
Postgre-SQL and MySQL.
- Support for HTP, HTF and OWA WebToolkit Packages
- Support for most PL/SQL functions as Java API
Visit www.vembu.com/PL2JSQL.html
for more details.
PL2JSQL can be downloaded for a 15 day free evaluation at
www.vembu.com
About Vembu Technologies
Vembu Technologies is focused on building database tools
including SQL migration and conversion tools to make enterprise
applications leverage multiple relational databases better.
Vembu's founders have extensive experience in building enterprise
scale applications with a deep appreciation for how enterprise
applications interact with relational databases. Vembu is
privately held with headquarters in Chennai, India.
|
