[jdbc] implemented base operation test cases
Had to fix the semicolon issue for Derby. Ended up switching to HSQLDB becuase Derby does not support LIMIT.