for JDBC 3.0
CodeBase for JDBC 3.0 is Sequiter Software Inc.'s complete Java
Database Connectivity (JDBC) client/server solution.
The client-side component, the CodeBase JDBC Driver, is a pure Java, JDBC
2.1 driver capable of connecting from Java applets or JDBC-enabled
applications. It can connect to the server-side component over Local Area
Networks (LAN), Wide Area Networks (WAN), Intranets or the Internet. It is
installed on your users' workstations (of any platform, including UNIX,
Windows and Mac), although the most common setup is a PC running a
Java-enabled web browser.
Javasoft's JDBC is a set
of standard interfaces that enable Java applications and applets to access
multiple database management systems using Structured Query Language (SQL).
The JavaSoft JDBC Driver Manager handles multiple drivers connecting to
different databases.
The server-side component, the CodeBase Database Server, is an application
installed on a Windows operating system and provides data source management
and administration tools, in addition to database connectivity services. It
supports data access also via ODBC, OLE-DB, and the CodeBase high-performance
native API.
Features
| • |
New Features Added
- Transactions
- User defined stored procedures
- Auto increment field support
- Improved deleted row handling
- Exposing of the record number as a key field
- Trim blanks feature
|
| • |
High Speed Data Access
Increasing communication efficiency between client and server is the key to improving client/server database performance, especially over the Internet, where bandwidth is always a limiting factor. The CodeBase provider employs a number of methods to optimize performance:
- Parsing and executing the SQL queries directly on the server eliminate the need to transfer large sets of data to the client for local processing, reducing network traffic and lock contention.
- CodeBase employs advanced multi-threading and multi-processing techniques to maximize server performance and reduce response times to client requests.
|
| • |
Small Footprint
|
| • |
Virtually Unlimited Database Size
With CodeBase, each table in your database can achieve a maximum theoretical limit of 4.2
million terabytes! And with no limit on the number of tables per database, there is virtually
no limit to the amount of data that your CodeBase-powered applications can store.
More…
|
| • |
JDBC 2.1 compliant
|
| • |
Multiple Operating Systems
- JDBC Client: all platforms (UNIX, Windows, Mac, ...)
- CodeBase SQL Database Server: Windows 2003, XP, 2000 or 2000 Advanced Server, NT Server or Workstation (Java applets using JDBC must connect through a web server.)
|
| • |
Type 3 Driver (Net Protocol, Fully Java
Technology-enabled)
|
| • |
Royalty-free distribution
|
| • |
Ease of Installation and Distribution
The client consists of a directory of Java class files that can be
copied simply to other computers. The server is installed from a
single setup program that you can distribute.
|
| • |
SQL Field Type Support
date, double, integer, logical, longvarbinary, memo, numeric,
smallint, time, timestamp, varchar
|
| • |
Special xBASE support
All of the standard xBASE data types (Character, Numeric, Logical, etc.) have been logically
mapped to corresponding JDBC data types, assuring full xBASE file compatibility.
CodeBase for JDBC 3.0 also includes support for new enhanced xBASE field types that map directly to
OLE DB data types, eliminating the need for data conversions, and improving read/write performance
by avoiding conversion routine overhead.
CodeBase for JDBC 3.0 is multi-user compatible with FoxPro, Clipper or dBase.
|
| • |
Support for Isolation Levels
Isolation levels simplify multi-user database programming by
providing developers well-defined control over how multiple users
access shared databases. CodeBase supports four isolation levels:
- Read Uncommitted
- Read Committed
- Repeatable Read
- Serializable
|
|
