Friday, 17 June 2011

Scanning Applications

When re-platforming any application, there are specific things that must be changed in order to make that application work on the new platform. Database migration has been available in SQL Developer since 1.2. However, this is only part of the process of changing an application.

In SQL Developer 3.0, we introduced the ability to scan application source code for items of interest that required migration. We call these items rules. These rules are defined in a simple XML format. We have included rules for Sybase CT and DB lib client applications by default.

In 3.1 we extended the support for applications and have opened up the rules API so that a rule can be specified for any type of file. We have included a mechanism to recognize files with and without extensions so we only apply rules appropriate to the file type.

This produces a nice summary of the contents of the application, no matter what source is used. As you can see each rule is made is made up of a regular expression. Each rule is applied to the file and the results aggregated and summarized by type, call and volume.

High Level Overview
63 total calls found
43 distinct calls found
8 files scanned
8 language types
12 total files in source
443 lines of code in scanned application

File Type Summary
perl 1 file
sql 1 file
c 2 files
php 1 file
java 1 file
ksh 2 files
asp 1 file
specialized 1 file


As we get closer to release we can take a closer look at how we can replace some of the things we found automatically.

Friday, 3 June 2011

Oracle Database Development Tools (ODDT): We are looking for APEX and HTML / CSS Developers

Oracle Database Development Tools (ODDT): We are looking for APEX and HTML / CSS Developers: The Oracle Application Express (APEX) team is expanding and looking for additional developers. We are looking for people who can build web applications, SQL and PL/SQL skills are helpful, as are HTML, CSS, JS. We are also looking for an iPhone (Objective C) developer as well. If interested apply at Oracle IRC1545977, IRC1549990, IRC1549989.