关于CMP中<ejb-ql>用法的问题

Question

高手都哪儿去了?为什么我换成:<ejb-ql>
<![CDATA[SELECT OBJECT(book)
                FROM BookItem book
                WHERE book.bookName
                LIKE CONCAT('%',CONCAT(?1,'%'))]]>
</ejb-ql>也查不到结果?

Answer 1

LKE 查询要放在哪个部署文件里?

Answer 2

應該是下面這個形式;
    <ejb-ql>
<![CDATA[SELECT OBJECT(book)
                FROM BookItem book
                WHERE book.bookName
                LIKE CONCAT('%',CONCAT(?1,'%'))]]>
</ejb-ql>在ejb-jar.xml中

Answer 3

to  daixin163():我就是用你说的这样啊,同样的没法得到查询所要结果.但我帖子发上去的时候不知怎么就变成前后有---&lt;&gt;这两个玩意儿?

Answer 4

呵呵
這牽涉到太多的問題
妳可以仔細看看服務器的log文件,看是在深麼地方出錯啦
貼出有關文件看看吧

Answer 5

ejb-jar.xml   顺便问一下,那个log文件在哪里找?<?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>
  <display-name>EJBModule</display-name>
  <enterprise-beans>
    <entity>
      <display-name>BookItem</display-name>
      <ejb-name>BookItem</ejb-name>
      <home>bookstoreejb.BookItemHome</home>
      <remote>bookstoreejb.BookItem</remote>
      <ejb-class>bookstoreejb.BookItemBean</ejb-class>
      <persistence-type>Container</persistence-type>
      <prim-key-class>java.lang.String</prim-key-class>
      <reentrant>False</reentrant>
      <cmp-version>2.x</cmp-version>
      <abstract-schema-name>BookItem</abstract-schema-name>
      <cmp-field>
        <field-name>bookNO</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>bookName</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>author</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>press</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>type</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>singlePrice</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>description</field-name>
      </cmp-field>
      <primkey-field>bookNO</primkey-field>
      <query>
        <query-method>
          <method-name>findAllBook</method-name>
          <method-params />
        </query-method>
        <ejb-ql>select OBJECT(book) from BookItem book</ejb-ql>
      </query>
      <query>
        <query-method>
          <method-name>findByType</method-name>
          <method-params>
            <method-param>java.lang.String</method-param>
          </method-params>
        </query-method>
        <ejb-ql>SELECT OBJECT(book)
FROM BookItem book
WHERE book.type = ?1</ejb-ql>
      </query>
      <query>
        <query-method>
          <method-name>findBooks</method-name>
          <method-params>
            <method-param>java.lang.String</method-param>
          </method-params>
        </query-method>
        <ejb-ql>
          <![CDATA[SELECT OBJECT(book)
FROM BookItem book
WHERE book.bookName
LIKE CONCAT('%',CONCAT(?1,'%'))]]>
        </ejb-ql>
      </query>
    </entity>
    <entity>
      <display-name>OrderInfo</display-name>
      <ejb-name>OrderInfo</ejb-name>
      <home>bookstoreejb.OrderInfoHome</home>
      <remote>bookstoreejb.OrderInfo</remote>
      <ejb-class>bookstoreejb.OrderInfoBean</ejb-class>
      <persistence-type>Container</persistence-type>
      <prim-key-class>java.lang.String</prim-key-class>
      <reentrant>False</reentrant>
      <cmp-version>2.x</cmp-version>
      <abstract-schema-name>OrderInfo</abstract-schema-name>
      <cmp-field>
        <field-name>orderID</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>custName</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>creditCardNO</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>address</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>email</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>totalPrice</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>bookList</field-name>
      </cmp-field>
      <primkey-field>orderID</primkey-field>
      <query>
        <query-method>
          <method-name>findAllOrder</method-name>
          <method-params />
        </query-method>
        <ejb-ql>select OBJECT(order)
from OrderInfo  order</ejb-ql>
      </query>
    </entity>
    <entity>
      <display-name>UserItem</display-name>
      <ejb-name>UserItem</ejb-name>
      <home>bookstoreejb.UserItemHome</home>
      <remote>bookstoreejb.UserItem</remote>
      <ejb-class>bookstoreejb.UserItemBean</ejb-class>
      <persistence-type>Container</persistence-type>
      <prim-key-class>java.lang.String</prim-key-class>
      <reentrant>False</reentrant>
      <cmp-version>2.x</cmp-version>
      <abstract-schema-name>UserItem</abstract-schema-name>
      <cmp-field>
        <field-name>userName</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>password</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>address</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>email</field-name>
      </cmp-field>
      <primkey-field>userName</primkey-field>
    </entity>
    <entity>
      <display-name>AdminItem</display-name>
      <ejb-name>AdminItem</ejb-name>
      <home>bookstoreejb.AdminItemHome</home>
      <remote>bookstoreejb.AdminItem</remote>
      <ejb-class>bookstoreejb.AdminItemBean</ejb-class>
      <persistence-type>Container</persistence-type>
      <prim-key-class>java.lang.String</prim-key-class>
      <reentrant>False</reentrant>
      <cmp-version>2.x</cmp-version>
      <abstract-schema-name>AdminItem</abstract-schema-name>
      <cmp-field>
        <field-name>adminID</field-name>
      </cmp-field>
      <cmp-field>
        <field-name>password</field-name>
      </cmp-field>
      <primkey-field>adminID</primkey-field>
    </entity>

Answer 6

<message-driven>
      <display-name>OrderMessageBean</display-name>
      <ejb-name>OrderMessageBean</ejb-name>
      <ejb-class>bookstoreejb.OrderMessageBean</ejb-class>
      <transaction-type>Container</transaction-type>
      <message-driven-destination>
        <destination-type>javax.jms.Queue</destination-type>
      </message-driven-destination>
      <ejb-ref>
        <ejb-ref-name>ejb/OrderInfo</ejb-ref-name>
        <ejb-ref-type>Entity</ejb-ref-type>
        <home>bookstoreejb.OrderInfoHome</home>
        <remote>bookstoreejb.OrderInfo</remote>
        <ejb-link>OrderInfo</ejb-link>
      </ejb-ref>
    </message-driven>
    <session>
      <display-name>Facade</display-name>
      <ejb-name>Facade</ejb-name>
      <home>bookstoreejb.FacadeHome</home>
      <remote>bookstoreejb.Facade</remote>
      <ejb-class>bookstoreejb.FacadeBean</ejb-class>
      <session-type>Stateless</session-type>
      <transaction-type>Container</transaction-type>
      <ejb-ref>
        <ejb-ref-name>ejb/BookItem</ejb-ref-name>
        <ejb-ref-type>Entity</ejb-ref-type>
        <home>bookstoreejb.BookItemHome</home>
        <remote>bookstoreejb.BookItem</remote>
        <ejb-link>BookItem</ejb-link>
      </ejb-ref>
      <ejb-ref>
        <ejb-ref-name>ejb/OrderInfo</ejb-ref-name>
        <ejb-ref-type>Entity</ejb-ref-type>
        <home>bookstoreejb.OrderInfoHome</home>
        <remote>bookstoreejb.OrderInfo</remote>
        <ejb-link>OrderInfo</ejb-link>
      </ejb-ref>
      <ejb-ref>
        <ejb-ref-name>ejb/UserItem</ejb-ref-name>
        <ejb-ref-type>Entity</ejb-ref-type>
        <home>bookstoreejb.UserItemHome</home>
        <remote>bookstoreejb.UserItem</remote>
        <ejb-link>UserItem</ejb-link>
      </ejb-ref>
      <ejb-ref>
        <ejb-ref-name>ejb/AdminItem</ejb-ref-name>
        <ejb-ref-type>Entity</ejb-ref-type>
        <home>bookstoreejb.AdminItemHome</home>
        <remote>bookstoreejb.AdminItem</remote>
        <ejb-link>AdminItem</ejb-link>
      </ejb-ref>
    </session>
    <session>
      <display-name>MyCart</display-name>
      <ejb-name>MyCart</ejb-name>
      <home>bookstoreejb.MyCartHome</home>
      <remote>bookstoreejb.MyCart</remote>
      <ejb-class>bookstoreejb.MyCartBean</ejb-class>
      <session-type>Stateful</session-type>
      <transaction-type>Container</transaction-type>
    </session>
    <entity>
      <display-name>OrderInfoBMP</display-name>
      <ejb-name>OrderInfoBMP</ejb-name>
      <home>bookstoreejb.OrderInfoHomeBMP</home>
      <remote>bookstoreejb.OrderInfoBMP</remote>
      <ejb-class>bookstoreejb.OrderInfoBeanBMP</ejb-class>
      <persistence-type>Bean</persistence-type>
      <prim-key-class>java.lang.String</prim-key-class>
      <reentrant>False</reentrant>
      <cmp-version>2.x</cmp-version>
    </entity>
  </enterprise-beans>
  <assembly-descriptor>
    <container-transaction>
      <method>
        <ejb-name>BookItem</ejb-name>
        <method-name>*</method-name>
      </method>
      <trans-attribute>Required</trans-attribute>
    </container-transaction>
    <container-transaction>
      <method>
        <ejb-name>OrderInfo</ejb-name>
        <method-name>*</method-name>
      </method>
      <trans-attribute>Required</trans-attribute>
    </container-transaction>
    <container-transaction>
      <method>
        <ejb-name>UserItem</ejb-name>
        <method-name>*</method-name>
      </method>
      <trans-attribute>Required</trans-attribute>
    </container-transaction>
    <container-transaction>
      <method>
        <ejb-name>AdminItem</ejb-name>
        <method-name>*</method-name>
      </method>
      <trans-attribute>Required</trans-attribute>
    </container-transaction>
    <container-transaction>
      <method>
        <ejb-name>OrderMessageBean</ejb-name>
        <method-name>*</method-name>
      </method>
      <trans-attribute>Required</trans-attribute>
    </container-transaction>
    <container-transaction>
      <method>
        <ejb-name>Facade</ejb-name>
        <method-name>*</method-name>
      </method>
      <trans-attribute>Required</trans-attribute>
    </container-transaction>
    <container-transaction>
      <method>
        <ejb-name>MyCart</ejb-name>
        <method-name>*</method-name>
      </method>
      <trans-attribute>Required</trans-attribute>
    </container-transaction>
    <container-transaction>
      <method>
        <ejb-name>OrderInfoBMP</ejb-name>
        <method-name>*</method-name>
      </method>
      <trans-attribute>Required</trans-attribute>
    </container-transaction>
  </assembly-descriptor>
</ejb-jar>

Answer 7

看上去沒甚麼錯誤,建議樓主單單就其中的一個CMP逕行測試,這樣子較容易發現問題!!!
jboss的日誌在deploy/log下

Answer 8

上面寫錯啦
應該是default/log下面的日誌文件

Answer 9

我用的是weblogic ,日志文件我找到了,但是没有找到问题的原因.
我再多试试!

Answer 10

结贴了,谢谢 daixin163() 多日来不厌其烦的帮助,虽然问题还是没有得到解决!