While migrating, enterprise print service, in the jbosscmp-jdbc.xml, we are facing the following problem.
JBoss
======
findFormNumber
java.lang.String
, TABLE1, TABLE2, TABLE3
TABLE1.RL_CD={0} AND TABLE2.FORM_USE_TYP_CD='I' AND TABLE2.FORM_NBR=TABLE3.FORM_NBR AND TABLE1.FORM_NBR=TABLE3.FORM_NBR
FORM_NM
A tag is used to join the above tables,
We could not find a similar tag for weblogic with CMP1.1.
Weblogic
========
findFormNumber
java.lang.String
// we need to write proper query to achieve about SQL