The Type 3 JDBC driver is written purely in Java, but it does not send SQL calls directly to the database. Instead, a Type 3 JDBC driver communicates with a separate piece of software that then ...

SQL_DATETIME_SUB int: unused CHAR_OCTET_LENGTH int : for char types the maximum number of bytes in the column ORDINAL_POSITION int : index of columns in table (starting at 1) ...

There a number of pure Java SQL database systems develolpers can embed into applications. In this tip we introduce two open source projects, HSQLDB and Apache Derby.