SwisSQL - SQLOne API ( Java
)3.0
|
|
SwisSQL SQLOne API is a multi-dialect
SQL parser and conversion engine. SQLOne API enables applications
to work with multiple databases without the need to port
proprietary SQL queries from one database to another. It
offers a JDBC API wrapper interface that bridges RDBMS vendors'
JDBC drivers and end user applications. Applications using
JDBC calls need not embed SwisSQL SQLOne API. SQLOne
API supports Oracle, SQL Server, DB2, Sybase, Informix,
PostgreSQL and MySQL SQL dialects.
|
|
Download SwisSQL - SQLOne API (Java)
|
|
|
|
Features and Benefits:
- Multi-Dialect
SQL parser parses all SQL dialect including SQL-99, SQL-92,
Oracle, IBM DB2, Informix, Sybase, MS SQL Server, MySQL,
PostgresSQL .
- Supports Select,
Update, Insert, Create, Delete and Drop statements
- High performance
SQL conversion
- 100% Java based API
for platform independent applications
- Minimal or no changes
to applications using JDBC
- Direct SwisSQL SQLOne
API for applications to directly utilize SQL conversion
features
- Low memory footprint
- SQL Object model
for advanced users
- Enriches the Java
Paradigm "Write SQL Once, Run Any Database"
|
|
|
Applications
embedding SwisSQL SQLOne API can use the API in two
ways. Directly parse and convert SQL into different
dialects. The second way is to use SwisSQL SQLOne API
JDBC Wrapper, which makes the parsing and conversion
of SQL transparent to the applications.
|
|
Directly Using SwisSQL - SQLOne API From Applications
|
|
SwisSQL
- SQLOne API Release 2.0 provides a simple and easy
to use API to utilize the SQL parsing and SQL conversion
features from inside the J2EE/Java applications directly.
This feature ensures that applications are in control
of when an SQL query needs to be converted to a different
dialect. Also, repetitive parsing and conversion of
the same SQL can be avoided. This architecture is illustrated
in the figure below.
|
|
|
|
|
|
| SwisSQL SQLOne API JDBC Wrapper |
|
Applications can use SwisSQL SQLOne API's JDBC Wrapper
as bridge between the application and the database
specific JDBC driver. Existing applications can leverage
seamless integration by just loading the SwisSQL SQLOne
JDBC driver without any other changes.The working
model illustration is shown in the figure below
|
|
|
|
| |
|
|
|
|
|
SwisSQL API (Java) |
|
|
Portable
J2EE Applications through Multi-Dialect SQL Solution.
|
|
|
No
need to manually convert SQL Queries
|
|
|
Developers
can leverage full SQL features of all the databases
|
|
|
Supports
Oracle, MS-SQL Server, DB2, Informix, Sybase,
MySQL and PostgreSQL
|
 |
|
|
|
