Hi all , i am using RedHat6.1 , postgres7.01.,jdk1.3 , and jboss2.1.
I have finder method below :
It did not display records when call the finder method eventhough
that were some records in the database.
The errors is not always occured , this is the method in the session
bean which call the finder method :
public ArrayList searchByLikeCompanyname(String companyname) throws
RemoteException,FinderException{
ArrayList result = new ArrayList();
Collection collection =
usercompanyHome.findByLikeCompanyname(companyname);
Iterator iterator = collection.iterator();
while(iterator.hasNext()){
UserCompany usercompany =
(UserCompany)javax.rmi.PortableRemoteObject.narrow(iterator.next(),
UserCompany.class);
UserCompanyJB usercompanyJB = usercompany.getCompanyJB();
result.add(usercompanyJB);
}
return result;
}
Anybody have any idea ? I have include also my ejb.jar
<?xml version="1.0" encoding="ISO-8859-1"?>
<jaws>
<enterprise-beans>
<entity>
<ejb-name>Users</ejb-name>
<table-name>userproject</table-name>
<create-table>true</create-table>
<cmp-field>
<field-name>userid</field-name>
</cmp-field>
<cmp-field>
<field-name>username</field-name>
</cmp-field>
<cmp-field>
<field-name>password</field-name>
</cmp-field>
<cmp-field>
<field-name>isadmin</field-name>
</cmp-field>
<finder>
<name>findByUserName</name>
<query>username = {0}</query>
<order>userid</order>
</finder>
<finder>
<name>findByUsers</name>
<query>username = {0} and password = {1}</query>
<order>userid</order>
</finder>
</entity>
<entity>
<ejb-name>UserCompany</ejb-name>
<table-name>usercompany</table-name>
<create-table>true</create-table>
<cmp-field>
<field-name>companyid</field-name>
</cmp-field>
<cmp-field>
<field-name>companyname</field-name>
</cmp-field>
<cmp-field>
<field-name>natureofbusiness</field-name>
</cmp-field>
<cmp-field>
<field-name>trade</field-name>
</cmp-field>
<cmp-field>
<field-name>address</field-name>
</cmp-field>
<cmp-field>
<field-name>contactperson</field-name>
</cmp-field>
<cmp-field>
<field-name>designation</field-name>
</cmp-field>
<cmp-field>
<field-name>telephone</field-name>
</cmp-field>
<cmp-field>
<field-name>did</field-name>
</cmp-field>
<cmp-field>
<field-name>fax</field-name>
</cmp-field>
<cmp-field>
<field-name>email</field-name>
</cmp-field>
<cmp-field>
<field-name>rcbno</field-name>
</cmp-field>
<cmp-field>
<field-name>financialgrade</field-name>
</cmp-field>
<cmp-field>
<field-name>datejoin</field-name>
</cmp-field>
<cmp-field>
<field-name>projectitle</field-name>
</cmp-field>
<cmp-field>
<field-name>projectno</field-name>
</cmp-field>
<cmp-field>
<field-name>remarks</field-name>
</cmp-field>
<cmp-field>
<field-name>status</field-name>
</cmp-field>
<cmp-field>
<field-name>companyurl</field-name>
</cmp-field>
<finder>
<name>findByNatureofBusiness</name>
<query>natureofbusiness = {0}</query>
<order>companyid</order>
</finder>
<finder>
<name>findByTrade</name>
<query>trade = {0}</query>
<order>companyid</order>
</finder>
<finder>
<name>findByCompanyname</name>
<query>companyname = {0}</query>
<order>companyid</order>
</finder>
<finder>
<name>findByContactPerson</name>
<query>contactperson = {0}</query>
<order>companyid</order>
</finder>
<finder>
<name>findByFinancialGrade</name>
<query>financialgrade = {0}</query>
<order>companyid</order>
</finder>
<finder>
<name>findByProjectTitle</name>
<query>projectitle = {0}</query>
<order>companyid</order>
</finder>
<finder>
<name>findByProjectNo</name>
<query>projectno = {0}</query>
<order>companyid</order>
</finder>
<finder>
<name>findByLikeCompanyname</name>
<query>lower(companyname) like lower({0})||'%'</query>
<order>companyid</order>
</finder>
<finder>
<name>findByLikeNatureofBusiness</name>
<query>lower(natureofbusiness) like lower({0})||'%'</query>
<order>companyid</order>
</finder>
<finder>
<name>findByLikeTrade</name>
<query>lower(trade) like lower({0})||'%'</query>
<order>companyid</order>
</finder>
<finder>
<name>findByLikeContactPerson</name>
<query>lower(contactperson )like lower({0})||'%'</query>
<order>companyid</order>
</finder>
<finder>
<name>findByLikeProjectTitle</name>
<query>lower(projectitle) like lower({0})||'%'</query>
<order>companyid</order>
</finder>
</entity>
<entity>
<ejb-name>ProjectInfo</ejb-name>
<table-name>userprojectinfo</table-name>
<create-table>true</create-table>
<cmp-field>
<field-name>projectid</field-name>
</cmp-field>
<cmp-field>
<field-name>projectno</field-name>
</cmp-field>
<cmp-field>
<field-name>companyid</field-name>
</cmp-field>
<cmp-field>
<field-name>country</field-name>
</cmp-field>
<cmp-field>
<field-name>projecttype</field-name>
</cmp-field>
<cmp-field>
<field-name>projectname</field-name>
</cmp-field>
<cmp-field>
<field-name>client</field-name>
</cmp-field>
<cmp-field>
<field-name>agreementdate</field-name>
</cmp-field>
<cmp-field>
<field-name>commencementdate</field-name>
</cmp-field>
<cmp-field>
<field-name>completedate</field-name>
</cmp-field>
<cmp-field>
<field-name>inchargeperson</field-name>
</cmp-field>
<cmp-field>
<field-name>inchargedp</field-name>
</cmp-field>
<cmp-field>
<field-name>servicescope</field-name>
</cmp-field>
<cmp-field>
<field-name>status</field-name>
</cmp-field>
<cmp-field>
<field-name>contractvalue</field-name>
</cmp-field>
<cmp-field>
<field-name>contractor</field-name>
</cmp-field>
<cmp-field>
<field-name>contractorperiod</field-name>
</cmp-field>
<cmp-field>
<field-name>othersconsultant</field-name>
</cmp-field>
<cmp-field>
<field-name>comments</field-name>
</cmp-field>
<finder>
<name>findByProjectNo</name>
<query>projectno = {0}</query>
<order>projectid</order>
</finder>
<finder>
<name>findByProjecName</name>
<query>projectname = {0}</query>
<order>projectid</order>
</finder>
<finder>
<name>findByLikeProjectName</name>
<query>lower(projectname) like lower({0})||'%'</query>
<order>projectid</order>
</finder>
</entity>
</enterprise-beans>
<datasource>PostgresDS</datasource>
<type-mapping>PostgreSQL</type-mapping>
<type-mappings>
<type-mapping>
<name>PostgreSQL</name>
<mapping>
<java-type>java.lang.Boolean</java-type>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>BOOL</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Short</java-type>
<jdbc-type>INTEGER</jdbc-type>
<sql-type>INTEGER</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.sql.Date</java-type>
<jdbc-type>DATE</jdbc-type>
<sql-type>DATE</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Double</java-type>
<jdbc-type>DOUBLE</jdbc-type>
<sql-type>DOUBLE</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.Object</java-type>
<jdbc-type>BLOB</jdbc-type>
<sql-type>BLOB</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.Integer</java-type>
<jdbc-type>INTEGER</jdbc-type>
<sql-type>INTEGER</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Byte</java-type>
<jdbc-type>TINYINT</jdbc-type>
<sql-type>TINYINT</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Float</java-type>
<jdbc-type>FLOAT</jdbc-type>
<sql-type>FLOAT</sql-type>
</mapping>
<mapping>
<java-type>java.lang.String</java-type>
<jdbc-type>VARCHAR</jdbc-type>
<sql-type>TEXT</sql-type>
</mapping>
<mapping>
<java-type>java.lang.Long</java-type>
<jdbc-type>BIGINT</jdbc-type>
<sql-type>BIGINT</sql-type>
</mapping>
</type-mapping>
</type-mappings>
</jaws>
userproject.jar