Resolution: Won't Fix
Affects Version/s: 6.1.1 CE GA2, 6.2.0 CE M4
Similar Issues:Show 5 results
LPS-25519 Ability to use multiple datasources LPS-27666 default portlet-ext.xml file doesn't have namespace/schema declartion LPS-6651 DB schema not being created for plugins in multiple shards LPS-18050 Jackrabbit 1.6 doesn't work with JNDI datasource against Oracle database LPS-30505 A portlet can not use a jndi datasource after portal is started on tomcat 7.0.27
Liferay Portal Community Edition 6.1.1 CE GA2 (Paton / Build 6101 / July 31, 2012)
I'm building a portlet for my project, the portlets has a service.xml with multiple entities, all entities us an alternative datasource. The biggest part is working fine, finders work when using only one column. When i use 2 column then liferay doesn't use the data-source of the entity but searches inside it's own database.
Example, i have a page with searchcontainer, the row are standard filter with
That works fine, there is only one column called projectId which is defined as a finder column in the service.xml, this query is executed on the database "dashboard".
But when a user wants to search through the data, they enter a value in the search form and then an other finder is used:
Then i get an JDBCException:
09:33:07,297 ERROR [http-bio-8080-exec-107][JDBCExceptionReporter:76] Table 'dashboard_portal_nico.workitem' doesn't exist
com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
// get items by search input or get all workitems
Service Builder workitem entity: