Hi guys, I am using ojb 1.0 rc6 (waiting for 1.1 later this year to migrate), PB api.
We have a db table with a compound primary key on 5 (yes really) collumns. When i perform a simple count query, with two straightforward 'is equal' criteria on two of the tables collumns, i get a query like: SELECT count(distinct concat(ORG_ID,ROLE_ID,USER_ID,ANC_ORG_ID,GROUP_ID)) FROM IBANX_ORG_ROLE_USER A0 WHERE ( A0.ORG_ID = 1815) AND (A0.ANC_ORG_ID = 1815) As we can see, a concat function is used, with five arguments, this results in an oracle error: java.sql.SQLException: ORA-00909: invalid number of arguments I think the correct syntax would have been: concat(ORG_ID, concat(ROLE_ID, concat(USER_ID, concat(ANC_ORG_ID,GROUP_ID)))) Is this correct? I will try to implement a concatenate method in the PlatformOracleImpl to overrule the one in default implementation. Would this be the correct resolution? Roger Janssen iBanx ************************************************************************* The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed.You should not copy, disclose or distribute this communication without the authority of iBanx bv. iBanx bv is neither liable for the proper and complete transmission of the information has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
