I'm trying to add a H2 Platform for the new database engine H2
(http://www.h2database.com). Could you please tell me how to set the platform,
and what are the expected results of the test?
I got the source code and built the app server
(https://glassfish.dev.java.net/public/BuildGlassFish.html), this was quite
easy. I also run the unit tests as described in
entity-persistence-tests/readme.txt, but then there where some problems. I think
it has to do with some settings.
- The test framework always uses the (generic) DatabasePlatform for me. I
renamed the platform classes to work around this problem.
- The sequences are not created (but used) inside the test cases. I worked
around this by manually creating the sequences.
I don't think that tl.platform actually has an effect. I can write 'bla' and the
result is the same.
Sequence init script:
CREATE SEQUENCE SCIENTIST_SEQ INCREMENT BY 1;
CREATE SEQUENCE PROJECT_SEQ START WITH 10 INCREMENT BY 10;
CREATE SEQUENCE ADDRESS_SEQ START WITH 25 INCREMENT BY 25;
CREATE SEQUENCE BUYER_SEQ START WITH 10 INCREMENT BY 10;
CREATE SEQUENCE XML_MERGE_PROJECT_SEQ START WITH 10 INCREMENT BY 10;
CREATE SEQUENCE XML_MERGE_ADDRESS_SEQ START WITH 25 INCREMENT BY 25;
CREATE TABLE CMP3_XML_EMPLOYEE_SEQ(SEQ_COUNT BIGINT, SEQ_NAME VARCHAR);
INSERT INTO CMP3_XML_EMPLOYEE_SEQ VALUES(1, 'EMPLOYEE_SEQ');
This is the procedure use to run the tests:
<run the init script>
Most missing functionality in H2 is now implemented (in the next release), the
test results are:
Tests run: 482, Failures: 4, Errors: 2, Time elapsed: 42.734 sec
Is the expected result is 0 failures / errors?