![]() |
![]() |
|
![]() |
||
Problems ![]() ![]() ![]() ![]() ![]() |
Reporting Bugssample.class is InstantDB's testing and scripting tool. 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; A sample script is run by typing "java sample yourscript.txt" at the command line. Full details of sample's capabilities can be found here. 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: e SET EXPORT "trace.log" TRACE 18 CONSOLE; 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 ListTry to include all of the following in your bug report:
Please email any bug reports, comments or suggestions to: |