In fact, an application query need not even be SQL, or it may be a specialized derivative of SQL, e.g. for document or image queries, designed for specific DBMSs.In order to pass JDBC compliance tests and to be called "JDBC COMPLIANT ?" we require that a driver support at least ANSI SQL-2 Entry Level. This gives applications that want wide portability a guaranteed least common denominator. We believe ANSI SQL-2 Entry Level is reasonably powerful and is reasonably widely supported today.
JDBC答應(yīng)查詢表達(dá)式直接傳遞到底層的數(shù)據(jù)驅(qū)動(dòng),這樣一個(gè)程序可以獲得盡量多的SQL功能,但是可能被DBMS拒絕。事實(shí)上,一個(gè)程序的查詢甚至可以不是SQL的,或者是SQL的一個(gè)非凡演化,例如:為專門(mén)數(shù)據(jù)庫(kù)設(shè)計(jì)的文本或者圖形查詢。 為了通過(guò)JDBC兼容的測(cè)試,并且能夠被稱為JDBC兼容,我們要求一個(gè)驅(qū)動(dòng)至少支持ANSI SQL-2的標(biāo)準(zhǔn)。這使得那些需要廣泛移植性的程序獲得一個(gè)最小的分母(這句話的原文是: This gives applications that want wide portability a guaranteed least common denominator.)。 我們相信ANSI SQL-2是足夠強(qiáng)大的,并且是得到足夠支持的。