Java Doc for F_EjbqlEC2.java in  » J2EE » JOnAS-4.8.6 » org » objectweb » jonas » jtests » clients » entity » Java Source Code / Java DocumentationJava Source Code and Java Documentation

Java Source Code / Java Documentation 1.  6.0 JDK Core 2.  6.0 JDK Modules 3.  6.0 JDK Modules com.sun 4.  6.0 JDK Modules com.sun.java 5.  6.0 JDK Modules sun 6.  6.0 JDK Platform 7.  Ajax 8.  Apache Harmony Java SE 9.  Aspect oriented 10.  Authentication Authorization 11.  Blogger System 12.  Build 13.  Byte Code 14.  Cache 15.  Chart 16.  Chat 17.  Code Analyzer 18.  Collaboration 19.  Content Management System 20.  Database Client 21.  Database DBMS 22.  Database JDBC Connection Pool 23.  Database ORM 24.  Development 25.  EJB Server geronimo 26.  EJB Server GlassFish 27.  EJB Server JBoss 4.2.1 28.  EJB Server resin 3.1.5 29.  ERP CRM Financial 30.  ESB 31.  Forum 32.  GIS 33.  Graphic Library 34.  Groupware 35.  HTML Parser 36.  IDE 37.  IDE Eclipse 38.  IDE Netbeans 39.  Installer 40.  Internationalization Localization 41.  Inversion of Control 42.  Issue Tracking 43.  J2EE 44.  JBoss 45.  JMS 46.  JMX 47.  Library 48.  Mail Clients 49.  Net 50.  Parser 51.  PDF 52.  Portal 53.  Profiler 54.  Project Management 55.  Report 56.  RSS RDF 57.  Rule Engine 58.  Science 59.  Scripting 60.  Search Engine 61.  Security 62.  Sevlet Container 63.  Source Control 64.  Swing Library 65.  Template Engine 66.  Test Coverage 67.  Testing 68.  UML 69.  Web Crawler 70.  Web Framework 71.  Web Mail 72.  Web Server 73.  Web Services 74.  Web Services apache cxf 2.0.1 75.  Web Services AXIS2 76.  Wiki Engine 77.  Workflow Engines 78.  XML 79.  XML UI Java Java Tutorial Java Open Source Jar File Download Java Articles Java Products Java by API Photoshop Tutorials Maya Tutorials Flash Tutorials 3ds-Max Tutorials Illustrator Tutorials GIMP Tutorials C# / C Sharp C# / CSharp Tutorial C# / CSharp Open Source ASP.Net ASP.NET Tutorial JavaScript DHTML JavaScript Tutorial JavaScript Reference HTML / CSS HTML CSS Reference C / ANSI-C C Tutorial C++ C++ Tutorial Ruby PHP Python Python Tutorial Python Open Source SQL Server / T-SQL SQL Server / T-SQL Tutorial Oracle PL / SQL Oracle PL/SQL Tutorial PostgreSQL SQL / MySQL MySQL Tutorial VB.Net VB.Net Tutorial Flash / Flex / ActionScript VBA / Excel / Access / Word XML XML Tutorial Microsoft Office PowerPoint 2007 Tutorial Microsoft Office Excel 2007 Tutorial Microsoft Office Word 2007 Tutorial

Java Source Code / Java Documentation » J2EE » JOnAS 4.8.6 » org.objectweb.jonas.jtests.clients.entity   Source Cross Reference   Class Diagram   Java Document (Java Doc)   org.objectweb.jonas.jtests.clients.entity.A_Cmp2Util    org.objectweb.jonas.jtests.clients.entity.F_EjbqlEC2 F_EjbqlEC2 public class F_EjbqlEC2 extends A_Cmp2Util (Code) This is an advanced test suite for home interface on entity bean EJBQL. Field Summary protected static  AddressHomeRemote addresshome      protected static  CabinHomeRemote cabinhome      protected static  CreditCardHomeRemote creditcardhome      protected static  CruiseHomeRemote cruisehome      protected static  CustomerHomeRemote customerhome      protected  boolean isInit      protected static  ReservationHomeRemote reservationhome      protected static  SessionTestHomeRemote sessiontesthome      protected static  ShipHomeRemote shiphome      Constructor Summary public   F_EjbqlEC2(String name)      Method Summary public  void _testBeanAsParameter()      public  void _testBeanNullAsParameter()       boolean initStateOK()      public static  void main(String args)      protected  void setUp()      public static  Test suite()      public  void test2InWhere()      public  void test3InWhere()      public  void testAddrCountOfCities()      public  void testAddrCountOfDistinctCities()      public  void testAddrGetAllCities()      public  void testAddrGetAllCreditCompanies()      public  void testAddrGetAllCreditCompanyIds()      Get all the creditCompany id of addresses. public  void testAddrGetAllCreditCompanyNames()      Get all the creditCompany names of addresses. public  void testAddrGetAllCreditCompanyNums()      Get all the creditCompany id of addresses. public  void testAddrQuery300626()      public  void testAmountOfReservationsForCustomer()      Get the amount paid of all the reservations for a specific customer. public  void testAmountsForCruise()      Get the values of the amounts of the reservations for the cruise name. public  void testAnd1()      public  void testAnd2()      public  void testAverageofTonnage()      Get the average of the tonnage of all the ships. public  void testBeanLocalAsParameter()      public  void testBeanLocalNullAsParameter()      public  void testBetweenDouble()      public  void testCabinEjbSelectDeckLevel()      public  void testCountOfCustomersRingo()      public  void testCountOfCustomersWithId1()      public  void testCountOfCustomersWithId2()      public  void testCountOfReservations()      Get the count of reservations. public  void testCountOfReservationsForCustomer()      Get the count of all the reservations for a specific customer. public  void testCustEjbSelectAddr()      public  void testCustEjbSelectAddrCity()      public  void testCustEjbSelectAllCreditCartAddr()      Select the addresses of the company of the credit card of all the customers. public  void testCustEjbSelectDistinctFirstName()      Select the DISTINCT firstName of all the customers. public  void testCustEjbSelectFirstName()      Select the firstName of all the customers. public  void testCustEjbSelectLastName()      public  void testCustEjbSelectRogerAddr()      Select the adresses of all 'roger' customers. public  void testCustFindById()      public  void testCustomersCountCreditCard()      public  void testCustomersCreditCardNumbers()      public  void testDistinctInFrom()      public  void testEgalBoolean()      public  void testEgalDouble()      public  void testEgalInteger()      public  void testEgalString()      public  void testFindAllAddresses()      public  void testFindAllMike()      Test a finder method - which have no parameter and which have its name starts with 'findAll', - but which not means "findAll". public  void testFindCustAllLimit_1()      public  void testFindCustAllLimit_2()      public  void testFindCustByAddrId()      public  void testFindCustomerAll()      public  void testFindResWithLesserAmount()      Find the reservations with lesser amount. public  void testInFrom()      public  void testInWhere()      public  void testIsEmpty()      public  void testIsEmptyInExp1()      public  void testIsEmptyInExp1Bis()      public  void testIsEmptyInExp1Quad()      public  void testIsEmptyInExp1Ter()      public  void testIsEmptyInExp2()      public  void testIsEmptyIsNotEmpty()      public  void testIsNotEmpty()      public  void testIsNull1()      Test a finder method with the IS NOT NULL operator on a cmr field. public  void testIsNull1bis()      Test a finder method with the IS NULL operator on a cmr field. public  void testIsNull1ter()      Test a finder method with the IS NULL operator on a cmr field in an expression. public  void testIsNull2()      Test a finder method with the IS NOT NULL operator on a cmr field with a complex navigation. public  void testIsNull3()      Test a finder method with the IS NULL operator on a parameter which is a bean null. public  void testIsNull3bis()      Test a finder method with the IS NULL operator on a parameter which is a bean not null. public  void testMaxAmountOfReservations()      Get the max value of the amount of the reservations. public  void testMemberOfNavigate()      public  void testMinAmountForCruise()      (Bug #300635) Get the min value of the amount of the reservations for the cruise name. public  void testMinAmountOfReservations()      Get the min value of the amount of the reservations. public  void testNavigate()      public  void testNavigateOr()      public  void testNotLike()      public  void testOrderBy2()      Find the reservations ordered by their amountPaid. public  void testOrderByDescAsc()      Find all the customers ordered by their lastname (desc) and firstname (asc). public  void testSeries1()      The execution of those two tests failed. public  void testSimpleMemberOf()      Finding the customer with a specific phone number SELECT OBJECT(c) FROM jt2_Customer cust WHERE ?1 IS MEMBER OF cust.phoneNumbers This test is done via a session bean because it need to use Local interfaces. public  void testSimpleOrderBy()      Find all the customers ordered by their lastname. public  void testWildcards()      Field Detail addresshome protected static AddressHomeRemote addresshome(Code) cabinhome protected static CabinHomeRemote cabinhome(Code) creditcardhome protected static CreditCardHomeRemote creditcardhome(Code) cruisehome protected static CruiseHomeRemote cruisehome(Code) customerhome protected static CustomerHomeRemote customerhome(Code) isInit protected boolean isInit(Code) reservationhome protected static ReservationHomeRemote reservationhome(Code) sessiontesthome protected static SessionTestHomeRemote sessiontesthome(Code) shiphome protected static ShipHomeRemote shiphome(Code) Constructor Detail F_EjbqlEC2 public F_EjbqlEC2(String name)(Code) Method Detail _testBeanAsParameter public void _testBeanAsParameter() throws Exception(Code) Test for feature #300040 Finding Customer by address SELECT OBJECT(c) FROM jt2_Customer c WHERE c.homeAddress = ?1 _testBeanNullAsParameter public void _testBeanNullAsParameter() throws Exception(Code) Test for feature #300040 Finding Customer by address SELECT OBJECT(c) FROM jt2_Customer c WHERE c.homeAddress = ?1 initStateOK boolean initStateOK() throws Exception(Code) main public static void main(String args)(Code) setUp protected void setUp()(Code) suite public static Test suite()(Code) test2InWhere public void test2InWhere() throws Exception(Code) Test an IN expression with literals integer SELECT OBJECT(c) FROM jt2_Cabin as c WHERE c.deckLevel IN ( 1 , 3 , 5 ) test3InWhere public void test3InWhere() throws Exception(Code) Test an IN expression with literals integer and an input parameter SELECT OBJECT(c) FROM jt2_Cabin as c WHERE c.deckLevel IN ( 1 , 3 , ?1 ) testAddrCountOfCities public void testAddrCountOfCities() throws Exception(Code) Get the count of cities for addresses SELECT COUNT(a.city) FROM jt2_Address AS a testAddrCountOfDistinctCities public void testAddrCountOfDistinctCities() throws Exception(Code) Get the count of DISTINCT cities for addresses SELECT COUNT(DISTINCT a.city) FROM jt2_Address AS a testAddrGetAllCities public void testAddrGetAllCities() throws Exception(Code) Get all the cities of addresses SELECT a.city FROM jt2_Address AS a testAddrGetAllCreditCompanies public void testAddrGetAllCreditCompanies() throws Exception(Code) Get all the creditCompanies of addresses SELECT a.creditCompany FROM jt2_Address AS a testAddrGetAllCreditCompanyIds public void testAddrGetAllCreditCompanyIds() throws Exception(Code) Get all the creditCompany id of addresses. This is a test about Null Values in the Query Result. If the result of the query corresponds to a cmp-field not defined in term of java primitive type, the container must include null value in the result. See the EJB Specification version 2.1, chapter 11.2.7.1 SELECT a.creditCompany.id FROM jt2_Address AS a (bug #301174) testAddrGetAllCreditCompanyNames public void testAddrGetAllCreditCompanyNames() throws Exception(Code) Get all the creditCompany names of addresses. This is a test about Null Values in the Query Result. If the result of the query corresponds to a cmr-field or cmp-field not defined in term of java primitive type, the container must include null value in the result. See the EJB Specification version 2.1, chapter 11.2.7.1 SELECT a.creditCompany.name FROM jt2_Address AS a (bug #3001174) testAddrGetAllCreditCompanyNums public void testAddrGetAllCreditCompanyNums() throws Exception(Code) Get all the creditCompany id of addresses. This is a test about Null Values in the Query Result. If the result of the query corresponds to a cmp-field defined in term of java primitive type, the container must not include null value in the result. See the EJB Specification version 2.1, chapter 11.2.7.1 SELECT a.creditCompany.num FROM jt2_Address AS a (bug #301174) testAddrQuery300626 public void testAddrQuery300626() throws Exception(Code) Bug #300626 SELECT OBJECT(a) FROM jt2_Address AS a WHERE a.homecustomer.lastName = 'Smith80' AND a.homecustomer.creditCard.id = 10 AND a.homecustomer.creditCard.creditCompany.name = 'CETELEM' AND a.homecustomer.creditCard.creditCompany.id = 10 testAmountOfReservationsForCustomer public void testAmountOfReservationsForCustomer() throws Exception(Code) Get the amount paid of all the reservations for a specific customer. SELECT SUM(r.amountPaid) FROM jt2_Reservation AS r WHERE ?1 MEMBER OF r.customers (bug #300280) testAmountsForCruise public void testAmountsForCruise() throws Exception(Code) Get the values of the amounts of the reservations for the cruise name. SELECT r.amountPaid FROM jt2_Reservations AS r WHERE r.cruise.name = ?1 testAnd1 public void testAnd1() throws Exception(Code) Finding Customer having name 'John Smith85' SELECT OBJECT(c) FROM jt2_Customer c WHERE c.lastName = ?1 AND c.firstName = ?2 testAnd2 public void testAnd2() throws Exception(Code) Finding Customers having City = Minneapolis and STATE= MN SELECT OBJECT(c) FROM jt2_Customer c WHERE c.homeAddress.city = ?1 AND c.homeAddress.state = ?2 testAverageofTonnage public void testAverageofTonnage() throws Exception(Code) Get the average of the tonnage of all the ships. SELECT AVG(s.tonnage) FROM jt2_Ship AS s testBeanLocalAsParameter public void testBeanLocalAsParameter() throws Exception(Code) Finding Customers by AddressLocal SELECT OBJECT(c) FROM jt2_Customer c WHERE c.homeAddress = ?1 testBeanLocalNullAsParameter public void testBeanLocalNullAsParameter() throws Exception(Code) Finding Customers by AddressLocal SELECT OBJECT(c) FROM jt2_Customer c WHERE c.homeAddress = ?1 testBetweenDouble public void testBetweenDouble() throws Exception(Code) Finding ship by tonnage SELECT OBJECT(c) FROM jt2_Ship s WHERE s.tonnage BETWEEN ?1 AND ?2 testCabinEjbSelectDeckLevel public void testCabinEjbSelectDeckLevel() throws Exception(Code) Select the deckLevel of a cabin SELECT c.deckLevel FROM jt2_Cabin AS c WHERE c.id = ?1 testCountOfCustomersRingo public void testCountOfCustomersRingo() throws Exception(Code) Get the count of customers with a firstname 'Ringo' SELECT COUNT(c) FROM jt2_Customer AS c WHERE c.firstName = 'Ringo' testCountOfCustomersWithId1 public void testCountOfCustomersWithId1() throws Exception(Code) bug #300723 Get the count of customers with a given id SELECT COUNT(c) FROM jt2_Customer AS c WHERE c.id = ?1 testCountOfCustomersWithId2 public void testCountOfCustomersWithId2() throws Exception(Code) bug #300723 Get the count of customers with a given id SELECT COUNT(c) FROM jt2_Customer AS c WHERE c.id = ?1 testCountOfReservations public void testCountOfReservations() throws Exception(Code) Get the count of reservations. SELECT COUNT(r) FROM jt2_Reservations AS r testCountOfReservationsForCustomer public void testCountOfReservationsForCustomer() throws Exception(Code) Get the count of all the reservations for a specific customer. SELECT COUNT(r) FROM jt2_Reservation AS r WHERE ?1 MEMBER OF r.customers (bug #300280) testCustEjbSelectAddr public void testCustEjbSelectAddr() throws Exception(Code) Select the address of a customer An ejbSelect with a local bean as result SELECT c.homeAddress FROM jt2_Customer AS c WHERE c.id = ?1 testCustEjbSelectAddrCity public void testCustEjbSelectAddrCity() throws Exception(Code) Select the city of the address of a customer SELECT c.homeAddress.city FROM jt2_Customer AS c WHERE c.id = ?1 testCustEjbSelectAllCreditCartAddr public void testCustEjbSelectAllCreditCartAddr() throws Exception(Code) Select the addresses of the company of the credit card of all the customers. An ejbSelect with a collection of local bean as result SELECT c.creditCard.creditCompany.address FROM jt2_Customer c testCustEjbSelectDistinctFirstName public void testCustEjbSelectDistinctFirstName() throws Exception(Code) Select the DISTINCT firstName of all the customers. SELECT DISTINCT c.firstName FROM jt2_Customer AS c testCustEjbSelectFirstName public void testCustEjbSelectFirstName() throws Exception(Code) Select the firstName of all the customers. SELECT c.firstName FROM jt2_Customer AS c testCustEjbSelectLastName public void testCustEjbSelectLastName() throws Exception(Code) Select the lastName of a customer SELECT c.lastName FROM jt2_Customer AS c WHERE c.id = ?1 testCustEjbSelectRogerAddr public void testCustEjbSelectRogerAddr() throws Exception(Code) Select the adresses of all 'roger' customers. An ejbSelect with a collection of local bean as result SELECT c.homeAddress FROM jt2_Customer c WHERE c.firstName = 'Roger' testCustFindById public void testCustFindById() throws Exception(Code) Get the customer with a given id SELECT c FROM jt2_Customer AS c WHERE c.id = ?1 testCustomersCountCreditCard public void testCustomersCountCreditCard() throws Exception(Code) Get the count of credit card for customers SELECT COUNT(c.creditCard) FROM jt2_Customer AS c The result must be equivalent to SELECT COUNT(c.creditCard) FROM jt2_Customer AS c WHERE c.creditCard IS NOT NULL testCustomersCreditCardNumbers public void testCustomersCreditCardNumbers() throws Exception(Code) Get the list of the number of the credit card for customers SELECT DISTINCT c.creditCard.number FROM jt2_Customer AS c ORDER BY c.creditCard.number testDistinctInFrom public void testDistinctInFrom() throws Exception(Code) Finding all Customer with reservations (there will not be duplication in result) SELECT DISTINCT OBJECT(c) FROM jt2_Reservation res, IN(res.customers) c testEgalBoolean public void testEgalBoolean() throws Exception(Code) Finding Customers having GoodCredit SELECT OBJECT(c) FROM jt2_Customer c WHERE c.hasGoodCredit = TRUE testEgalDouble public void testEgalDouble() throws Exception(Code) Finding ship by tonnage SELECT OBJECT(c) FROM jt2_Ship s WHERE s.tonnage = ?1 testEgalInteger public void testEgalInteger() throws Exception(Code) Retrieve a collection of all cabins on deck 3 SELECT OBJECT(c) FROM Cabin as c WHERE c.deckLevel = ?1 testEgalString public void testEgalString() throws Exception(Code) Finding Customer 'Smith90' SELECT OBJECT(c) FROM jt2_Customer c WHERE c.lastName = 'Smith90' testFindAllAddresses public void testFindAllAddresses() throws Exception(Code) Find all the addresses SELECT OBJECT(a) FROM jt2_Address AS a testFindAllMike public void testFindAllMike() throws Exception(Code) Test a finder method - which have no parameter and which have its name starts with 'findAll', - but which not means "findAll". SELECT OBJECT(c) FROM jt2_Customer c WHERE c.firstName LIKE 'Mike' testFindCustAllLimit_1 public void testFindCustAllLimit_1() throws Exception(Code) Finding All Customer with a limiter startAt range SELECT OBJECT(c) FROM jt2_Customer AS c WHERE c.id > 0 ORDER BY c.id LIMIT ?1 testFindCustAllLimit_2 public void testFindCustAllLimit_2() throws Exception(Code) Finding All Customer with a limiter startAt range and a size range SELECT OBJECT(c) FROM jt2_Customer AS c ORDER BY c.id LIMIT ?1, 5 testFindCustByAddrId public void testFindCustByAddrId() throws Exception(Code) Finding Customers by AddressId SELECT OBJECT(c) FROM jt2_Customer c WHERE c.homeAddress.id = ?1 testFindCustomerAll public void testFindCustomerAll() throws Exception(Code) Finding All Customer SELECT OBJECT(c) FROM jt2_Customer AS c testFindResWithLesserAmount public void testFindResWithLesserAmount() throws Exception(Code) Find the reservations with lesser amount. SELECT DISTINCT OBJECT(r1) FROM jt2_Reservation AS r1, jt2_Reservation AS r2 WHERE r1.amountPaid < r2.amountPaid AND r2.id = 26 testInFrom public void testInFrom() throws Exception(Code) Finding all Customer with reservations (there will be duplication in result if customer has more than one reservation SELECT OBJECT(c) FROM jt2_Reservation res, IN(res.customers) c testInWhere public void testInWhere() throws Exception(Code) Findng Customers Living in Warm Climates SELECT OBJECT(c) FROM jt2_Customer c WHERE c.homeAddress.state IN ('FL','TX','AZ','CA') testIsEmpty public void testIsEmpty() throws Exception(Code) Finding Customers Without Reservations SELECT OBJECT(c) FROM jt2_Customer c WHERE c.reservations IS EMPTY testIsEmptyInExp1 public void testIsEmptyInExp1() throws Exception(Code) Finding Customers Without Reservations and with good credit SELECT OBJECT(c) FROM jt2_Customer c WHERE c.reservations IS EMPTY AND c.hasGoodCredit = true testIsEmptyInExp1Bis public void testIsEmptyInExp1Bis() throws Exception(Code) Finding Customers Without Reservations and with good credit Test equivalent to testIsEmptyInExp1 SELECT OBJECT(c) FROM jt2_Customer c WHERE NOT (c.reservations IS NOT EMPTY OR c.hasGoodCredit <> true) testIsEmptyInExp1Quad public void testIsEmptyInExp1Quad() throws Exception(Code) Finding Customers Without Reservations and with good credit Test equivalent to testIsEmptyInExp1 SELECT OBJECT(c) FROM jt2_Customer c WHERE NOT (c.hasGoodCredit <> true) AND c.reservations IS EMPTY testIsEmptyInExp1Ter public void testIsEmptyInExp1Ter() throws Exception(Code) Finding Customers Without Reservations and with good credit Test equivalent to testIsEmptyInExp1 SELECT OBJECT(c) FROM jt2_Customer c WHERE NOT ( NOT (c.reservations IS EMPTY AND c.hasGoodCredit = true) ) testIsEmptyInExp2 public void testIsEmptyInExp2() throws Exception(Code) Test to reproduce bug #300525 Finding Customers Without Reservations OR with good credit SELECT OBJECT(c) FROM jt2_Customer c WHERE c.reservations IS EMPTY OR c.hasGoodCredit == true testIsEmptyIsNotEmpty public void testIsEmptyIsNotEmpty() throws Exception(Code) Test to reproduce bug #300525 Finding Customers Without or With Reservations (equivalent to finding all customers) SELECT OBJECT(c) FROM jt2_Customer c WHERE c.reservations IS EMPTY OR c.reservations IS NOT EMPTY testIsNotEmpty public void testIsNotEmpty() throws Exception(Code) Finding Customers With Reservations SELECT OBJECT(c) FROM jt2_Customer c WHERE c.reservations IS NOT EMPTY testIsNull1 public void testIsNull1() throws Exception(Code) Test a finder method with the IS NOT NULL operator on a cmr field. SELECT OBJECT(c) FROM jt2_Customer c WHERE c.creditCard IS NOT NULL testIsNull1bis public void testIsNull1bis() throws Exception(Code) Test a finder method with the IS NULL operator on a cmr field. SELECT OBJECT(c) FROM jt2_Customer c WHERE c.creditCard IS NULL testIsNull1ter public void testIsNull1ter() throws Exception(Code) Test a finder method with the IS NULL operator on a cmr field in an expression. SELECT OBJECT(c) FROM jt2_Customer c WHERE c.firstName = ?1 AND c.creditCard IS NULL testIsNull2 public void testIsNull2() throws Exception(Code) Test a finder method with the IS NOT NULL operator on a cmr field with a complex navigation. SELECT OBJECT(c) FROM jt2_Customer c WHERE c.creditCard.creditCompany IS NOT NULL testIsNull3 public void testIsNull3() throws Exception(Code) Test a finder method with the IS NULL operator on a parameter which is a bean null. SELECT OBJECT(c) FROM jt2_Customer c WHERE ?1 IS NULL testIsNull3bis public void testIsNull3bis() throws Exception(Code) Test a finder method with the IS NULL operator on a parameter which is a bean not null. SELECT OBJECT(c) FROM jt2_Customer c WHERE ?1 IS NULL testMaxAmountOfReservations public void testMaxAmountOfReservations() throws Exception(Code) Get the max value of the amount of the reservations. SELECT MAX(r.amountPaid) FROM jt2_Reservations AS r testMemberOfNavigate public void testMemberOfNavigate() throws Exception(Code) Finding Customers On Alaska Cruise SELECT OBJECT(c) FROM jt2_Customer cust, Cruise cr, IN(cr.reservations) res WHERE cr = ?1 AND cust MEMBER OF res.customers testMinAmountForCruise public void testMinAmountForCruise() throws Exception(Code) (Bug #300635) Get the min value of the amount of the reservations for the cruise name. SELECT MIN(r.amountPaid) FROM jt2_Reservations AS r WHERE r.cruise.name = ?1 testMinAmountOfReservations public void testMinAmountOfReservations() throws Exception(Code) Get the min value of the amount of the reservations. SELECT MIN(r.amountPaid) FROM jt2_Reservations AS r testNavigate public void testNavigate() throws Exception(Code) A complex navigation test SELECT OBJECT(c) FROM jt2_Customer c WHERE c.creditCard.creditCompany.address.city = ?1 testNavigateOr public void testNavigateOr() throws Exception(Code) An other complex navigation test and the OR operator SELECT OBJECT(c) FROM jt2_Customer AS c WHERE c.creditCard.number = ?1 OR c.homeAddress.zip = ?2 testNotLike public void testNotLike() throws Exception(Code) (Bug #300634) Finding Customers having a name not like 'Jo%' OR not like 'S%' SELECT OBJECT(c) FROM jt2_Customer c WHERE c.lastName NOT LIKE ?1 OR c.firstName NOT LIKE ?2 testOrderBy2 public void testOrderBy2() throws Exception(Code) Find the reservations ordered by their amountPaid. The DISTINCT aggregate is used to reproduce the bug #300527 SELECT DISTINCT OBJECT(r) FROM jt2_Reservation AS r ORDER BY r.amountPaid (bug #300527) testOrderByDescAsc public void testOrderByDescAsc() throws Exception(Code) Find all the customers ordered by their lastname (desc) and firstname (asc). SELECT OBJECT(c) FROM jt2_Customer c ORDER BY c.lastName DESC, c.firstName ASC testSeries1 public void testSeries1() throws Exception(Code) The execution of those two tests failed. testSimpleMemberOf public void testSimpleMemberOf() throws Exception(Code) Finding the customer with a specific phone number SELECT OBJECT(c) FROM jt2_Customer cust WHERE ?1 IS MEMBER OF cust.phoneNumbers This test is done via a session bean because it need to use Local interfaces. testSimpleOrderBy public void testSimpleOrderBy() throws Exception(Code) Find all the customers ordered by their lastname. SELECT OBJECT(c) FROM jt2_Customer c ORDER BY c.lastName testWildcards public void testWildcards() throws Exception(Code) Finding Customer having a name exactly matching 'Joe Star' & Finding Customers having a name like 'Jo S' (no wildcards) & Finding Customers having a name like 'Jo% S%' (with wildcards) Finding Customers having a name like 'Jo% S%' and living in MN SELECT OBJECT(c) FROM jt2_Customer c WHERE c.lastName = ?1 AND c.firstName = ?2 & SELECT OBJECT(c) FROM jt2_Customer c WHERE c.lastName LIKE ?1 AND c.firstName LIKE ?2 & SELECT OBJECT(c) FROM jt2_Customer c WHERE c.lastName LIKE ?1 AND c.firstName LIKE ?2 SELECT OBJECT(c) FROM jt2_Customer c WHERE c.lastName LIKE ?1 AND c.firstName LIKE ?2 AND c.homeAddress.state = ?3 Fields inherited from org.objectweb.jonas.jtests.clients.entity.A_Cmp2Util final static int TX_CALL(Code)(Java Doc) final static int TX_CONT(Code)(Java Doc) final static int TX_NO(Code)(Java Doc) final static int TX_RB(Code)(Java Doc) Methods inherited from org.objectweb.jonas.jtests.clients.entity.A_Cmp2Util void checkIsInitialState() throws Exception(Code)(Java Doc) public static int getIntAfterDash(String s)(Code)(Java Doc) public static String getStringBeforeDash(String s)(Code)(Java Doc) abstract boolean initStateOK() throws Exception(Code)(Java Doc) static boolean isCollectionEqual(Collection c1, Collection c2)(Code)(Java Doc) protected void setUp()(Code)(Java Doc)