1 Reply Latest reply on Mar 20, 2005 4:45 PM by Johan Borchers

    SQL92 and Left-join read-ahead

    Johan Borchers Newbie


      It is possible that the SQL92 compiler ignores the left-join tags in the jbosscmp-jdbc.xml file.
      If I do a test with a bean A and parent bean B and in a finder method of bean A I specify with a left-join tag that the fields of bean B should also be read from the database an be put in the read-ahead cache.

      It works for the normal compiler. All fields are loaded with just 1 SQL statement. But with the SQL92 compiler the all the fields of bean A are selected from the database and the fields of bean B are then selected from the database with load relation SQL. So with the SQL92 compiler 2 SQL queries are needed.

      Also the 2 queries needed depends on the read-ahead tags in the relation specification in the jbosscmp-jdbc.xml file.