Known Bugs and Limitations
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
Only supports a single active results set per statement
- This is in accordance with the JDBC specification. However some
other drivers do support this.
The easiest way to describe a possible bug in InstantDB
is to provide a "sample" script that demonstrates the problem. Your problem
will be given MUCH higher attention if it is accompanied by a sample
script. sample.class is InstantDB's testing and scripting tool.
An example of a small sample script is shown below.
A sample script is run by typing "java sample yourscript.txt" at the command line.
You may find it useful to set appropriate trace bits to highlight the problem.
For example, if it's a transaction or table locking problem, setting the SQL logging
nad transaction bits may help:
; load the idb driver and open the database "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
; create a test table and insert a row
e DROP TABLE test1;
e CREATE TABLE test1 (
id int PRIMARY KEY AUTO INCREMENT,
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 ?=?;
If you find that a sample script really isn't capable of illustrating the
problem then try writing a small Java program that does. commsql.java provides
a handy template for writing short JDBC programs. It may be that the problem
you are experiencing only becomes apparent when the database reaches a certain
size. In this case it may be necessary to send your database as well. Please
ensure that this is compressed using zip or jar. If the resultant archive
is greater than 200K in size then please contact us in advance before forwarding
the file. Check List
e SET EXPORT "trace.log" TRACE 18 CONSOLE;
Please email any bug reports, comments or suggestions to: email@example.com
Try to include all of the following in your bug report:
- A short description of the problem (no more than one or two
- A sample script or Java program.
- Your database .prp file.
- If your script is not self contained (i.e. it does not create all
of the tables required to illustrate the problem) then include a zipped
or jarred archive of the database itself (if less than 200k only).
- What operating system are you using?
- Who's Java Virtual Machine are you using?
- What development environment are you using?