Intelligent, Custom and Highly Automated Cross Platform Database and Application Migration

Dynamic SQL and JDBC API in Java Applications

What JDBC?

Java Database Connectivity, a Java API that enables Java programs to execute SQL statements. This allows Java programs to interact with any SQL-compliant database. JDBC is a part of the Java platform and it is divided into 2 packages: java.sql and javax.sql.

Why SQLWays?

SQLWays helps you to automatically perform comprehensive assessment and migration of embedded SQL statements in Java applications. With SQLWays there is no need extracting SQL statements from application code and convert them separately. The tool completes the whole migration process internally.

This demo shows how SQLWays can migrate Java Embedded SQL:



Conversion features

  • Converts database connection to new database (java.sql.Connection interface)
  • Converts embedded SQL statements from java.sql-interfaces to conform to the syntax of the new database:
    • java.sql.Statement interface - used to send basic SQL statements
    • java.sql.PreparedStatement interface - used to send prepared statements or basic SQL statements (derived from Statement)
    • java.sql.CallableStatement interface - used to call database stored procedures (derived from PreparedStatement)
    • java.sql.ResultSet interface - used to retrieve and update the results of a query

For example,
   Source Informix Database

  1. PreparedStatement mStmt = mConn.prepareStatement("select c_date
  2. from products where c_date<=TODAY");
  3. ResultSet Rs = mStmt.executeQuery();


 
To

   Target SQL Server Database

  1. PreparedStatement mStmt = mConn.prepareStatement("select c_date
  2. from products where c_date <= CONVERT(DATE,GetDate())");
  3. ResultSet Rs = mStmt.executeQuery();

 

 

Ispirer MnMTK is capable of supporting the various types of source and target databases in the Java applications.

How to convert?

Please take a look at the related article:

Embedded SQL and Database Access API Migration

Assessment

Assessment helps estimate the efforts and cost of a migration. For conversion of embedded SQL, the assessment can involve the following:

  • Identify source files containing database access code
    • List of files containing java.sql
    • Number of files and number of code in each
  • Identify embedded SQL statements
For detailed process of assessment please refer to following link:

Java Embedded SQL Migration Assessment

Ispirer MnMTK automates the entire migration of embedded SQL in Java applications. This allows you to dramatically decrease conversion risks and significantly reduce in-house efforts. Reasonable pricing strategy makes Ispirer MnMTK even more powerful instrument for such migration type.


If you are interested in these services, please contact us for more information.

 
Meet Ispirer MnMTK 2017!
October 4, 2017 Meet Ispirer MnMTK 2017!

We are glad to announce the Release of Ispirer Migration and Modernization Toolkit 2017! We worked in a strong cooperation with our customers to make it more convenient and powerful.


PGDay.IT 2017
September 19, 2017 PGDay.IT 2017

We are happy to announce that Ispirer Systems will support the PGDay.IT 2017 that will be held on October 13th, 2017 in Milan, Italy.


JDBC Versions

JDBC 1.0; 1.2; 2.0; 2.1; 3.0

Testimonials
November 25, 2013Ciber, Sweden
Oracle to Microsoft SQL Server Migration
(including PowerBuilder migration)

"Ciber develops system for parking permits to the major cities in Sweden.
In 2012, when the second largest city in...

...

August 21, 2014TouchStone Systems, Inc., United States
Sybase ASA to Microsoft SQL Server Migration
(including embedded SQL migration in PowerBuilder)

"To whom it may concern,

Being a leading provider in reverse logistics solutions, we continue to...

...

Case Studies
August 24, 2014PostgreSQL to Oracle Migration, United States (including embedded SQL migration in Java)

The client was a U.S.-based, non-profit organization working within the education sector, striving to ensure equal rights of students in low-income groups across the United States. This was...

...

September 11, 2014Informix to SQL Server Migration, United States (including embedded SQL migration in PowerBuilder, VB to C#, ASP to ASP.NET)

A U.S.-based renowned lessor of trailers requested the services of Ispirer to perform a major migration.

...

Feedback

It’s been pleasure that I found your tool for migrating Delphi to C#.NET. And I also see that it seamlessly migrates the Delphi features to C#.

Read more
Industry Events