• Doesn't understand the standard timstamp escape sequence.
• Doesn't understand repeated single quotes '' or double quotes "" as a single character.
• Doesn't support REPEATABLE_READ and READ_COMMITTED transaction isolation levels.
• Only supports a single active results set per statement - This is in accordance with the JDBC™ specification. However some other drivers do support this.

Reporting Bugs

An example of a small sample script is shown below.

; load the idb driver and open the database "sample.prp"
d jdbc.idbDriver;
o jdbc:idb:sample.prp;

; dump SQL and results to "trace.log"
e SET EXPORT "trace.log" TRACE 2 CONSOLE;

; start off a new thread executing another.txt
t another.txt;

; create a test table and insert a row
e DROP TABLE test1;
e CREATE TABLE test1 (
id int PRIMARY KEY AUTO INCREMENT,
fullName CHAR(30));
e INSERT INTO test1 (fullname) VALUES ("fred");

; Do a select and dump results to console
q SELECT * FROM test1;

; create a prepared statement and then set and execute its parameters
p SELECT * FROM test1 WHERE ?=?;
s test1,1000;

c close;

e SET EXPORT "trace.log" TRACE 18 CONSOLE;