Hi
I am using CMP with Oracle .
Some of my finder methods fail espetially when they are comparing no parameteriezed
values.The finder methods worked fine with MYSQL database.
The finder methods that are failing are
findAllTopicsByCategoryId
findAllCategories
which are both checking for nonparametric values
The exceptions thrown
javax.ejb.FinderException: Find failed at
sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(StreamRemoteCall.java:245)
at sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCall.java:220) at
sun.rmi.server.UnicastRef.invoke(UnicastRef.java:122) at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker_Stub.invokeHome(Unknown Source)
at org.jboss.ejb.plugins.jrmp.interfaces.HomeProxy.invoke(HomeProxy.java:221)
at $Proxy0.findAllCategories(Unknown Source) at
pv.videoBBS.category.CategoryClient.main(CategoryClient.java:69)
javax.ejb.FinderException: Find failed at
sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(StreamRemoteCall.java:245)
at sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCall.java:220) at
sun.rmi.server.UnicastRef.invoke(UnicastRef.java:122) at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker_Stub.invokeHome(Unknown Source)
at org.jboss.ejb.plugins.jrmp.interfaces.HomeProxy.invoke(HomeProxy.java:221)
at $Pr
<?xml version="1.0" encoding="Cp1252"?>
<jaws>
<datasource>java:/BulletinboardDS</datasource>
<type-mapping>Oracle</type-mapping>
<type-mappings>
<type-mapping>
<name>Oracle</name>
<mapping>
<java-type>java.lang.Double</java-type>
<jdbc-type>DOUBLE</jdbc-type>
<sql-type>NUMBER</sql-type>
</mapping>
<mapping>
<java-type>java.lang.String</java-type>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>VARCHAR(256)</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Object</java-type>
<jdbc-type>JAVA_OBJECT</jdbc-type>
<sql-type>JAVA_OBJECT</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Character</java-type>
<jdbc-type>CHAR</jdbc-type>
<sql-type>CHAR</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Long</java-type>
<jdbc-type>BIGINT</jdbc-type>
<sql-type>NUMBER</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Float</java-type>
<jdbc-type>FLOAT</jdbc-type>
<sql-type>NUMBER</sql-type>
</mapping>
<mapping>
<java-type>java.util.Date</java-type>
<jdbc-type>DATE</jdbc-type>
<sql-type>DATE</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Integer</java-type>
<jdbc-type>INTEGER</jdbc-type>
<sql-type>NUMBER</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Byte</java-type>
<jdbc-type>TINYINT</jdbc-type>
<sql-type>NUMBER</sql-type>
</mapping>
<mapping>
<java-type>java.sql.TimeStamp</java-type>
<jdbc-type>TIMESTAMP</jdbc-type>
<sql-type>TIMESTAMP</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Short</java-type>
<jdbc-type>INTEGER</jdbc-type>
<sql-type>NUMBER</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Boolean</java-type>
<jdbc-type>BIT</jdbc-type>
<sql-type>NUMBER</sql-type>
</mapping>
</type-mapping>
</type-mappings>
<enterprise-beans>
<entity>
<ejb-name>userCategoryAccess</ejb-name>
<table-name>userCategoryAccess</table-name>
<create-table>false</create-table>
<remove-table>false</remove-table>
<tuned-updates>true</tuned-updates>
<read-only>false</read-only>
<time-out>300</time-out>
<cmp-field>
<field-name>userId</field-name>
<column-name>userId</column-name>
<sql-type>NUMBER</sql-type>
<jdbc-type>BIGINT</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>categoryAccessTimestamp</field-name>
<column-name>categoryAccessTimestamp</column-name>
<sql-type>NUMBER</sql-type>
<jdbc-type>BIGINT</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>userCategoryAccessId</field-name>
<column-name>userCategoryAccessId</column-name>
<sql-type>NUMBER</sql-type>
<jdbc-type>INTEGER</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>categoryId</field-name>
<column-name>categoryId</column-name>
<sql-type>NUMBER</sql-type>
<jdbc-type>INTEGER</jdbc-type>
</cmp-field>
<finder>
<name>findUserCategoryAccessByUserIdCategoryId</name>
<query>userId={0} AND categoryId={1}</query>
<order></order>
</finder>
<finder>
<name>findAllUserCategoryAccessByUserId</name>
<query>userId = {0}</query>
<order></order>
</finder>
</entity>
<entity>
<ejb-name>bbsLogger</ejb-name>
<table-name>bbsLogger</table-name>
<create-table>false</create-table>
<remove-table>false</remove-table>
<tuned-updates>true</tuned-updates>
<read-only>false</read-only>
<time-out>300</time-out>
<cmp-field>
<field-name>sessionId</field-name>
<column-name>sessionId</column-name>
<sql-type>VARCHAR(256)</sql-type>
<jdbc-type>VARCHAR</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>details</field-name>
<column-name>details</column-name>
<sql-type>VARCHAR(256)</sql-type>
<jdbc-type>VARCHAR</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>logType</field-name>
<column-name>logType</column-name>
<sql-type>VARCHAR(256)</sql-type>
<jdbc-type>VARCHAR</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>messageId</field-name>
<column-name>messageId</column-name>
<sql-type>NUMBER</sql-type>
<jdbc-type>INTEGER</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>bbsLoggerId</field-name>
<column-name>bbsLoggerId</column-name>
<sql-type>NUMBER</sql-type>
<jdbc-type>INTEGER</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>userId</field-name>
<column-name>userId</column-name>
<sql-type>NUMBER</sql-type>
<jdbc-type>BIGINT</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>logTime</field-name>
<column-name>logTime</column-name>
<sql-type>NUMBER</sql-type>
<jdbc-type>BIGINT</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>categoryId</field-name>
<column-name>categoryId</column-name>
<sql-type>NUMBER</sql-type>
<jdbc-type>INTEGER</jdbc-type>
</cmp-field>
<finder>
<name>findAllUserFavoriteByUserId</name>
<query>userId={0}</query>
<order></order>
</finder>
<finder>
<name>findAllUserFavoriteByUserIdAndCategoryId</name>
<query>userId={0} AND categoryId={1}</query>
<order></order>
</finder>
</entity>
<entity>
<ejb-name>category</ejb-name>
<table-name>category</table-name>
<create-table>false</create-table>
<remove-table>false</remove-table>
<tuned-updates>true</tuned-updates>
<read-only>false</read-only>
<time-out>300</time-out>
<cmp-field>
<field-name>metaCategoryId</field-name>
<column-name>metaCategoryId</column-name>
<sql-type>NUMBER</sql-type>
<jdbc-type>INTEGER</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>categoryId</field-name>
<column-name>categoryId</column-name>
<sql-type>NUMBER</sql-type>
<jdbc-type>INTEGER</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>messageFlag</field-name>
<column-name>messageFlag</column-name>
<sql-type>NUMBER</sql-type>
<jdbc-type>INTEGER</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>categoryName</field-name>
<column-name>categoryName</column-name>
<sql-type>VARCHAR(256)</sql-type>
<jdbc-type>VARCHAR</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>mediaClipFlag</field-name>
<column-name>mediaClipFlag</column-name>
<sql-type>NUMBER</sql-type>
<jdbc-type>INTEGER</jdbc-type>
</cmp-field>
<finder>
<name>findAllCategories</name>
<query>categoryId > 0</query>
<order>categoryId</order>
</finder>
<finder>
<name>findByMetaCategoryId</name>
<query>metaCategoryId = {0}</query>
<order>categoryId</order>
</finder>
</entity>
<entity>
<ejb-name>mediaClip</ejb-name>
<table-name>mediaClip</table-name>
<create-table>false</create-table>
<remove-table>false</remove-table>
<tuned-updates>true</tuned-updates>
<read-only>false</read-only>
<time-out>300</time-out>
<cmp-field>
<field-name>clipId</field-name>
<column-name>clipId</column-name>
<sql-type>NUMBER</sql-type>
<jdbc-type>INTEGER</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>url</field-name>
<column-name>url</column-name>
<sql-type>VARCHAR(256)</sql-type>
<jdbc-type>VARCHAR</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>categoryId</field-name>
<column-name>categoryId</column-name>
<sql-type>NUMBER</sql-type>
<jdbc-type>INTEGER</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>clipType</field-name>
<column-name>clipType</column-name>
<sql-type>VARCHAR(256)</sql-type>
<jdbc-type>VARCHAR</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>clipName</field-name>
<column-name>clipName</column-name>
<sql-type>VARCHAR(256)</sql-type>
<jdbc-type>VARCHAR</jdbc-type>
</cmp-field>
<finder>
<name>findAllClipsByClipType</name>
<query>clipType={0}</query>
<order></order>
</finder>
<finder>
<name>findAllClipsByCategoryId</name>
<query>categoryId={0}</query>
<order></order>
</finder>
</entity>
<entity>
<ejb-name>message</ejb-name>
<table-name>message</table-name>
<create-table>false</create-table>
<remove-table>false</remove-table>
<tuned-updates>true</tuned-updates>
<read-only>false</read-only>
<time-out>300</time-out>
<cmp-field>
<field-name>postTime</field-name>
<column-name>postTime</column-name>
<sql-type>NUMBER</sql-type>
<jdbc-type>BIGINT</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>messageId</field-name>
<column-name>messageId</column-name>
<sql-type>NUMBER</sql-type>
<jdbc-type>INTEGER</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>messageSubject</field-name>
<column-name>messageSubject</column-name>
<sql-type>VARCHAR(256)</sql-type>
<jdbc-type>VARCHAR</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>postUserName</field-name>
<column-name>postUserName</column-name>
<sql-type>VARCHAR(256)</sql-type>
<jdbc-type>VARCHAR</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>categoryId</field-name>
<column-name>categoryId</column-name>
<sql-type>NUMBER</sql-type>
<jdbc-type>INTEGER</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>messageBody</field-name>
<column-name>messageBody</column-name>
<sql-type>VARCHAR(256)</sql-type>
<jdbc-type>VARCHAR</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>topicId</field-name>
<column-name>topicId</column-name>
<sql-type>NUMBER</sql-type>
<jdbc-type>INTEGER</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>postUserId</field-name>
<column-name>postUserId</column-name>
<sql-type>NUMBER</sql-type>
<jdbc-type>BIGINT</jdbc-type>
</cmp-field>
<finder>
<name>findAllMessagesByCategoryId</name>
<query>categoryId={0}</query>
<order>messageId</order>
</finder>
<finder>
<name>findAllMessagesByPostUserId</name>
<query>postUserId={0}</query>
<order>messageId</order>
</finder>
<finder>
<name>findAllTopicsByCategoryId</name>
<query>categoryId={0} AND topicId=1</query>
<order>messageId</order>
</finder>
<finder>
<name>findAllMessagesByTopicId</name>
<query>topicId={0}</query>
<order>messageId</order>
</finder>
<finder>
<name>findAllMessages</name>
<query>messageId>'0'</query>
<order>messageId</order>
</finder>
</entity>
<entity>
<ejb-name>bbsUser</ejb-name>
<table-name>bbsUser</table-name>
<create-table>false</create-table>
<remove-table>false</remove-table>
<tuned-updates>true</tuned-updates>
<read-only>false</read-only>
<time-out>300</time-out>
<cmp-field>
<field-name>userId</field-name>
<column-name>userId</column-name>
<sql-type>VARCHAR(256)</sql-type>
<jdbc-type>VARCHAR</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>password</field-name>
<column-name>password</column-name>
<sql-type>VARCHAR(256)</sql-type>
<jdbc-type>VARCHAR</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>userType</field-name>
<column-name>userType</column-name>
<sql-type>NUMBER</sql-type>
<jdbc-type>INTEGER</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>nickname</field-name>
<column-name>nickname</column-name>
<sql-type>VARCHAR(256)</sql-type>
<jdbc-type>VARCHAR</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>lastVisitTimestamp</field-name>
<column-name>lastVisitTimestamp</column-name>
<sql-type>NUMBER</sql-type>
<jdbc-type>BIGINT</jdbc-type>
</cmp-field>
<finder>
<name>findByNickNamePassWord</name>
<query>nickname={0} AND password={1}</query>
<order></order>
</finder>
</entity>
</enterprise-beans>
</jaws>
_____________________________________________________
Chat with your friends as soon as they come online. Get Rediff Bol at
http://bol.rediff.com
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
List Help?: [EMAIL PROTECTED]
