> From: [EMAIL PROTECTED] > > Hi, > Is there a way to configure Torque to build (using generated om classes) > queries involving more than one tablespace, like this: > > SELECT POPULATION.CITIZEN.CODE, POPULATION.CITIZEN.NAME, UTIL.CITY.DESC > FROM POPULATION.CITIZEN, UTIL.CITY WHERE POPULATION.CITIZEN.BORN_IN_CITY_CODE > = UTIL.CITY.CODE > > In order to use both POPULATION and UTIL tablespaces, > we use a generic jdbc url: > jdbc:as400://<my_as400_address>;date format=eur > without tablespace specification. > > This is a common requirement, in our application. > > Roberto Resoli
Hi Roberto, I am 99% sure the answer is "No" as I don't recall seeing anything like this in the Criteria API (which tends to be fairly database agnostic anyway). I think you will either have to fall back to directly constructing the sql (and processing the village records manually) or I guess you could extend/patch criteria to support it. I wonder if OJB supports this? Cheers, Scott -- Scott Eade Backstage Technologies Pty. Ltd. http://www.backstagetech.com.au -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
