Introduction

Mimer JDBC Drivers provide access to Mimer SQL databases from Java applications and applets. The drivers are type 4 drivers, which means that they are written entirely in Java. As they are written in Java, they can be downloaded in applets.

Mimer JDBC Drivers can also be used on all platforms that support Java Virtual Machine (JVM) and so provide a very high degree of portability.

About this Guide

The guide is intended for Java application developers working with Mimer SQL. It covers all available Mimer JDBC drivers.

The guide describes the usage of SQL in Java applications, and provides, together with the Mimer SQL Reference Manual, the complete reference material for Mimer SQL.

To read more about JDBC and JVM, visit https://www.oracle.com/technetwork/java/javase/tech/index-jsp-136101.html.

The JDBC API specification implemented by this driver (packages java.sql and javax.sql) is found at http://download.oracle.com/javase/1.4.2/docs/api/java/sql/package-summary.html and http://download.oracle.com/javase/1.4.2/docs/api/javax/sql/package-summary.html.

Definitions, Terms and Trademarks

API

Application Programming Interface

EJB

Enterprise Java Beans

JCP

Java Community Process

JDBC

The Java database API

JDK

Java Development Kit

JNDI

Java Naming and Directory Interface

JNI

Java Native Interface

JRE

Java Runtime Environment

JVM

Java Virtual Machine

OCC

Optimistic Concurrency Control

PSM

Persistent Stored Modules, the term used by ISO/ANSI for stored procedures

SQL

Structured Query Language

URL

Uniform Resource Locator

All other trademarks are the property of their respective holders.

Requirements

•Mimer SQL server version 9.2 or later

•JRE 1.4 or later

Environment

Mimer JDBC has a complete range of functionality and support for the smallest devices to the high-end systems and application servers. In the picture below the various Java environments are described and coupled with computer environments and Mimer JDBC drivers:

jdbc_overview.png

 

 

Logging

To keep the driver size small and to optimize performance the Mimer JDBC drivers do not perform any logging. For logging, we provide a separate driver, Mimer JDBC Trace driver.

Mimer JDBC Trace driver is a full JDBC Driver that covers all of JDBC by calling the matching routines of the logged JDBC Driver.

It produces a log of every JDBC call an application makes, and also measures the elapsed time for each call. The log can be written to a file, or can be displayed directly in a window.

For more information, see https://developer.mimer.com/article/jdbc/.