hai..Everbody,
trying for custom-sql query,with Liferay6.1 with tomcat7,mysql
M not able to generate its BooksFinder interface and BooksfinderUtil class after ant build-service also
Let me know wher i ve gone wrong..
Using Eclipse helios in Ubunto..
service.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE service-builder PUBLIC "-//Liferay//DTD Service Builder 6.0.0//EN" "http://www.liferay.com/dtd/liferay-service-builder_6_0_0.dtd">
<service-builder package-path="book.database">
<author>sourceone</author>
<namespace>B</namespace>
<entity name="Books" local-service="true" remote-service="false">
<column name="bookId" type="long" primary="true"></column>
<column name="title" type="String"></column>
<column name="author" type="String"></column>
<column name="dateOfPurchase" type="Date"></column>
<column name="pages" type="int"></column>
<column name="userId" type="long"></column>
<column name="companyId" type="long"></column>
<column name="groupId" type="long"></column>
<order by="asc">
<order-column name="bookId"></order-column>
</order>
<finder return-type="Collection" name="GroupId">
<finder-column name="groupId"></finder-column>
</finder>
<finder return-type="Collection" name="CompanyId">
<finder-column name="companyId"></finder-column>
</finder>
<finder return-type="Collection" name="UserId">
<finder-column name="userId"></finder-column>
</finder>
<finder return-type="Collection" name="Group_Title">
<finder-column name="groupId"></finder-column>
<finder-column name="title"></finder-column>
</finder>
<finder return-type="Collection" name="Group_Author">
<finder-column name="groupId"></finder-column>
<finder-column name="author"></finder-column>
</finder>
</entity>
</service-builder>
package book.database.service.persistence;
import java.util.List;
import book.database.model.impl.BooksImpl;
import com.liferay.portal.kernel.dao.orm.QueryPos;
import com.liferay.portal.kernel.dao.orm.SQLQuery;
import com.liferay.portal.kernel.dao.orm.Session;
import com.liferay.portal.service.persistence.impl.BasePersistenceImpl;
import com.liferay.util.dao.orm.CustomSQLUtil;
public class BookFinderImpl extends BasePersistenceImpl { //Here I has to use implements BooksFinder
public List findBooks(String title)
{
public final String FIND_BOOK="findBooks";
Session session=null;
session=openSession();
String sql=CustomSQLUtil.get(FIND_BOOK);
SQLQuery query=session.createSQLQuery(sql);
query.addEntity("Books",BooksImpl.class);
QueryPos qpos=QueryPos.getInstance(query);
qpos.add(title);
return (List)query.list();
}
}
/src/custom-sql/default.xml
<?xml version="1.0" encoding="UTF-8"?>
<custom-sql>
<sql id="findBooks">
<![CDATA[
SELECT
{Books.*}
FROM
Books
WHERE
(Books.title like ?)
]]>
</sql>
</custom-sql>
portal-ext.properties
custom.sql.configs=custom-sql/default.xml
