Eranda Sooriyabandara wrote: > Hi, > I try to test Derby JDBC using JDBC API Test Suit 1.3.1. But I don't > know how to configure it so that we can run it against Derby. If anybody > knows how to do configuration please help me to figure it out. (It > doesn't need not to be Derby. Also documents at the > http://java.sun.com/products/jdbc/jdbctestsuite-1_3_1.html does not work > for me)
I don't know exactly how to configure this, but I did configure and run the JDBC CTS (which is set up in a similar way to the JDBC API Test Suite) against Derby some years ago (2006). The docs at the URL you provided gives configuration examples for Cloudscape (Derby's ancestor). So you would need to replace all Cloudscape-specific config by Derby config (jar file names, JDBC driver names, SQL statement dialect files etc.) and try from there. Note that back in the days I was told that neither the test suite nor the J2EE implementation (app server) I was using fully supported the embedded driver, so you may want to try a client-server configuration first (start the Derby server separately, then try to run the tests using the client driver). -- John
