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

Reply via email to