WEBLOGIC-QL
0 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Gregoire_Alain
Posted On:   Friday, September 7, 2001 01:58 AM

Hello, I would create a QL as SELECT * FROM EJBName WHERE a LIKE Param_1 ORDERBY Date_info; So I write in EJB-JAR.XML findFicheByLevel java.lang.String java.lang.String <![CDATA[WHERE niveau LIKE ?1 AND SUBSTRING(date_info,1,10) LIKE ?2]] > For add the ORDERBY, I must add in the WEBLOGIC-CMP-RDBMS-JAR.XML the follow code but I have some errors. findFicheByLevel java.lang.String java.lan   More>>

Hello,


I would create a QL as
SELECT *
FROM EJBName
WHERE a LIKE Param_1 ORDERBY Date_info;


So I write in EJB-JAR.XML





findFicheByLevel




java.lang.String



java.lang.String





<![CDATA[WHERE niveau LIKE ?1 AND
SUBSTRING(date_info,1,10) LIKE ?2]]
>




For add the ORDERBY, I must add in the WEBLOGIC-CMP-RDBMS-JAR.XML the follow code but I have some errors.





findFicheByLevel




java.lang.String



java.lang.String




<![CDATA[WHERE niveau LIKE $0 AND
SUBSTRING(date_info,1,10) LIKE $1
ORDERBY date_info]]
>



But I have some error in the parsing of this file. Could you help me please ???


Thank to all for your responses,
Alain

   <<Less
About | Sitemap | Contact