Thanks Dain, But where can I get the JBossCMP documentation(free or not free) you mentioned? and first, could you please tell me if I can write declared-sql with a cmr field as a parameter?
Arthur -----Original Message----- From: Dain Sundstrom [mailto:[EMAIL PROTECTED]] Sent: Friday, June 07, 2002 12:03 PM To: [EMAIL PROTECTED] Subject: Re: [JBoss-user] Boolean in the ejb-ql has sql exception If you can wait a week, this will be fixed. Also declared-sql is described in the JBossCMP documentation. -dain Arthur Wang wrote: > Hi Everyone, > > I am depoying my applcation in JBoss-Oracle, I have a query in ejb-jar.xml > taking a boolean parameter like, columnName= FALSE or TRUE, when this finder > was called, there will be a SQL exception, (Invalid Column name), I found > the reason for this is that Oracle doesn't have boolean type, so this sql > statement is invalid. And I want to fix this using declared-sql in > jbosscmp-jdbc.xml to overwrite this finder query, it works well, but another > problem is, how can I write declared-sql when this finder takes a cmr field > as a parameter, for example, findActiveAccountsForCustomer(Customer > customer), which customer is a cmr filed for account bean. > > Any reply would be highly appreciated. > > Thanks in advance. > > Arthur Wang > Ensemble Systems Inc. > Tel: (604)232-7954 Fax: (604)231-9545 > www.ensemble-systems.com > > > > _______________________________________________________________ > > Don't miss the 2002 Sprint PCS Application Developer's Conference > August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm > > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user > _______________________________________________________________ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user _______________________________________________________________ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas - http://devcon.sprintpcs.com/adp/index.cfm?source=osdntextlink _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user