关于cmp在查找时抛出的"在关键字 'FROM' 附近有语法错误。"

这个是ejb-jar.xml文件<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE ejb-jar PUBLIC "-//Sun Microsystems, Inc.//DTD Enterprise JavaBeans 2.0//EN" "http://java.sun.com/dtd/ejb-jar_2_0.dtd"><ejb-jar >   <description><![CDATA[No Description.]]></description>
   <display-name>Generated by XDoclet</display-name>   <enterprise-beans>      <!-- Session Beans -->
      <session >
         <description><![CDATA[Session facade for RptClass.]]></description>         <ejb-name>RptClassFacade</ejb-name>         <local-home>com.yksoft.report.ejb.facade.interfaces.RptClassFacadeLocalHome</local-home>
         <local>com.yksoft.report.ejb.facade.interfaces.RptClassFacadeLocal</local>
         <ejb-class>com.yksoft.report.ejb.facade.RptClassFacadeSession</ejb-class>
         <session-type>Stateless</session-type>
         <transaction-type>Container</transaction-type>         <ejb-local-ref >
            <ejb-ref-name>ejb/RptClassLocal</ejb-ref-name>
            <ejb-ref-type>Entity</ejb-ref-type>
            <local-home>com.yksoft.report.ejb.interfaces.RptClassLocalHome</local-home>
            <local>com.yksoft.report.ejb.interfaces.RptClassLocal</local>
            <ejb-link>RptClass</ejb-link>
         </ejb-local-ref>
         <ejb-local-ref >
            <ejb-ref-name>ejb/RptTableLocal</ejb-ref-name>
            <ejb-ref-type>Entity</ejb-ref-type>
            <local-home>com.yksoft.report.ejb.interfaces.RptTableLocalHome</local-home>
            <local>com.yksoft.report.ejb.interfaces.RptTableLocal</local>
            <ejb-link>RptTable</ejb-link>
         </ejb-local-ref>      </session>
      <entity >
         <description><![CDATA[]]></description>         <ejb-name>RptTable</ejb-name>         <home>com.yksoft.report.ejb.interfaces.RptTableHome</home>
         <remote>com.yksoft.report.ejb.interfaces.RptTable</remote>
         <local-home>com.yksoft.report.ejb.interfaces.RptTableLocalHome</local-home>
         <local>com.yksoft.report.ejb.interfaces.RptTableLocal</local>         <ejb-class>com.yksoft.report.ejb.RptTableCMP</ejb-class>
         <persistence-type>Container</persistence-type>
         <prim-key-class>com.yksoft.common.object.RptTablePK</prim-key-class>
         <reentrant>False</reentrant>
         <cmp-version>2.x</cmp-version>
         <abstract-schema-name>RptTable</abstract-schema-name>
         <cmp-field >
            <description><![CDATA[Returns the RptCode]]></description>
            <field-name>rptCode</field-name>
         </cmp-field>
         <cmp-field >
            <description><![CDATA[Returns the PrptClassCode]]></description>
            <field-name>prptClassCode</field-name>
         </cmp-field>
         <cmp-field >
            <description><![CDATA[Returns the RptType]]></description>
            <field-name>rptType</field-name>
         </cmp-field>
         <cmp-field >
            <description><![CDATA[Returns the rptDesc]]></description>
            <field-name>rptDesc</field-name>
         </cmp-field>
         <cmp-field >
            <description><![CDATA[Returns the DataType]]></description>
            <field-name>dataType</field-name>
         </cmp-field>
         <cmp-field >
            <description><![CDATA[Returns the Explain]]></description>
            <field-name>explain</field-name>
         </cmp-field>
         <cmp-field >
            <description><![CDATA[Returns the Filter]]></description>
            <field-name>filter</field-name>
         </cmp-field>
         <cmp-field >
            <description><![CDATA[Returns the UserName]]></description>
            <field-name>userName</field-name>
         </cmp-field>
         <cmp-field >
            <description><![CDATA[Returns the GroupName]]></description>
            <field-name>groupName</field-name>
         </cmp-field>
         <cmp-field >
            <description><![CDATA[Returns the UserRptCode]]></description>
            <field-name>userRptCode</field-name>
         </cmp-field>
       
         <query>
            <query-method>
               <method-name>findByParentClassCode</method-name>
               <method-params>
                  <method-param>int</method-param>
               </method-params>
            </query-method>
            <ejb-ql><![CDATA[select OBJECT(o) from RptTable as o where o.prptClassCode=?1]]></ejb-ql>
         </query>
         <query>
            <query-method>
               <method-name>findAll</method-name>
               <method-params>
               </method-params>
            </query-method>
            <ejb-ql><![CDATA[select OBJECT(o) from RptTable as o ]]></ejb-ql>
         </query>      </entity>      <entity >
         <description><![CDATA[]]></description>         <ejb-name>RptClass</ejb-name>         <home>com.yksoft.report.ejb.interfaces.RptClassHome</home>
         <remote>com.yksoft.report.ejb.interfaces.RptClass</remote>
         <local-home>com.yksoft.report.ejb.interfaces.RptClassLocalHome</local-home>
         <local>com.yksoft.report.ejb.interfaces.RptClassLocal</local>         <ejb-class>com.yksoft.report.ejb.RptClassCMP</ejb-class>
         <persistence-type>Container</persistence-type>
         <prim-key-class>com.yksoft.common.object.RptClassPK</prim-key-class>
         <reentrant>False</reentrant>
         <cmp-version>2.x</cmp-version>
         <abstract-schema-name>RptClass</abstract-schema-name>
         <cmp-field >
            <description><![CDATA[Returns the rptClassCode]]></description>
            <field-name>rptClassCode</field-name>
         </cmp-field>
         <cmp-field >
            <description><![CDATA[Returns the PrptClassCode]]></description>
            <field-name>prptClassCode</field-name>
         </cmp-field>
         <cmp-field >
            <description><![CDATA[Returns the classDesc]]></description>
            <field-name>classDesc</field-name>
         </cmp-field>
         <cmp-field >
            <description><![CDATA[Returns the Cflag]]></description>
            <field-name>cflag</field-name>
         </cmp-field>
         
         <query>
            <query-method>
               <method-name>findAll</method-name>
               <method-params>
               </method-params>
            </query-method>
            <ejb-ql><![CDATA[select OBJECT(o) from RptClass as o ]]></ejb-ql>
         </query>
 
      </entity>   </enterprise-beans>   <assembly-descriptor >
   </assembly-descriptor></ejb-jar>

解决方案 »

  1.   

    这个是jbosscmp-jdbc.xml文件<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE jbosscmp-jdbc PUBLIC "-//JBoss//DTD JBOSSCMP-JDBC 3.0//EN" "http://www.jboss.org/j2ee/dtd/jbosscmp-jdbc_3_0.dtd"><jbosscmp-jdbc>
       <defaults>
         <datasource>java:MSSQLDEMODS</datasource>
         <datasource-mapping>MS SQLSERVER2000</datasource-mapping>
         <create-table>false</create-table>
        </defaults>   <enterprise-beans>      <entity>
             <ejb-name>RptTable</ejb-name>
             <table-name>rpt_table</table-name>         <cmp-field>
                <field-name>rptCode</field-name>
                <column-name>RptCode</column-name>        </cmp-field>
             <cmp-field>
                <field-name>prptClassCode</field-name>
                <column-name>prptClassCode</column-name>        </cmp-field>
             <cmp-field>
                <field-name>rptType</field-name>
                <column-name>RptType</column-name>        </cmp-field>
             <cmp-field>
                <field-name>rptDesc</field-name>
                <column-name>rptDesc</column-name>        </cmp-field>
             <cmp-field>
                <field-name>dataType</field-name>
                <column-name>DataType</column-name>        </cmp-field>
             <cmp-field>
                <field-name>explain</field-name>
                <column-name>explain</column-name>        </cmp-field>
             <cmp-field>
                <field-name>filter</field-name>
                <column-name>filter</column-name>        </cmp-field>
             <cmp-field>
                <field-name>userName</field-name>
                <column-name>UserName</column-name>        </cmp-field>
             <cmp-field>
                <field-name>groupName</field-name>
                <column-name>GroupName</column-name>        </cmp-field>
             <cmp-field>
                <field-name>userRptCode</field-name>
                <column-name>userRptCode</column-name>        </cmp-field>      </entity>      <entity>
             <ejb-name>RptClass</ejb-name>
             <table-name>rpt_class</table-name>         <cmp-field>
                <field-name>rptClassCode</field-name>
                <column-name>rptClassCode</column-name>        </cmp-field>
             <cmp-field>
                <field-name>prptClassCode</field-name>
                <column-name>PrptClassCode</column-name>        </cmp-field>
             <cmp-field>
                <field-name>classDesc</field-name>
                <column-name>classDesc</column-name>        </cmp-field>
             <cmp-field>
                <field-name>cflag</field-name>
                <column-name>Cflag</column-name>        </cmp-field>      </entity>   </enterprise-beans></jbosscmp-jdbc>