Re: [JBoss-user] Finder generating wrong SQL statement in Jboss-3.2.1

2003-07-01 Thread Janardhan Burugupalli
Hi All, I have a finder defined in the jwas.xml like this below finder namefindAllOrdered/name query/ orderCREATINGTIME DESC/order /finder i dont have any query because i want all results only in the Creating time desc format but jboss is generating the following

RE: [JBoss-user] Finder generating wrong SQL statement in Jboss-3.2.1

2003-07-01 Thread Danny . Yates
10:04 To: [EMAIL PROTECTED] Subject: Re: [JBoss-user] Finder generating wrong SQL statement in Jboss-3.2.1 Hi All, I have a finder defined in the jwas.xml like this below finder namefindAllOrdered/name query/ orderCREATINGTIME DESC/order /finder i dont have

Re[2]: [JBoss-user] Finder generating wrong SQL statement in Jboss-3.2.1

2003-07-01 Thread Alexey Loubyansky
Hello Janardhan, JAWS was replaced with JBossCMP a long time ago and is not supported anymore. Sorry, I really don't know what is wrong with your finder. alex Tuesday, July 01, 2003, 12:03:42 PM, Janardhan Burugupalli wrote: JB Hi All, JB I have a finder defined in the jwas.xml like this

Re: [JBoss-user] Finder generating wrong SQL statement in Jboss-3.2.1

2003-07-01 Thread Janardhan Burugupalli
[EMAIL PROTECTED] wrote: I'm guessing here, but: 1) Can you remove the query/ element? Does this stop JBoss from generating the where clause? 2) Can you set the query to something like 1=1? Dan. Hi Dan, I made it so that i was equating a filed with thee same like finder