I am moving some code from a working 7.0 GA5 environment to 7.1.1 GA2
and facing more hurdles than I expected. The latest is that after
building a service builder module and deploying the jars, it appears
that it is looking for the tables in the base Liferay MySQL database.
The service builder data-source value point to a JNDI resource that is
properly configured in server.xml and context.xml and spring-ext.xml.
The code was orginally imported from a 7.0 workspace (mistake...) so I
went ahead and created a pristine service builder module project and
then just copied the service.xml file from my working 7.0 module.
After building and deploying the modules I went over to jsonws
api panel and ran one of the API's. I get an
error: 'lportal711.person' doesn't exist
The table is in a different database on a different server as
defined in server.xml ( it's in an Aurora DB in AWS). lportal711 is
the local database for this particular instance of Liferay. So, is
there an issue with JNDI connections for the 7.1.1 service builder?
Snippets are:
spring-ext.xml:
<bean
class="com.liferay.portal.dao.jdbc.spring.DataSourceFactoryBean"
id="liferayDataSourceFactory">
<property name="propertyPrefix" value="custom."
/>
<property name="properties">
<props>
<prop
key="custom.jndi.name">jdbc/BSFAurora_data</prop>
</props>
</property>
</bean>
<bean
class="org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy"
id="liferayDataSource">
<property
name="targetDataSource"
ref="liferayDataSourceFactory" />
</bean>
<alias alias="BSFAurora_data"
name="liferayDataSource" />
And in the service.xml:
<entity name='Person' table='Person'
local-service='true' remote-service='true' data-source='BSFAurora_data'>
And server.xml:
<Resource name="jdbc/BSFAurora_data"
auth="Container"
type="javax.sql.DataSource"
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
testWhileIdle="true"
.........[other connection stuff here]
/>
And context.xml:
<ResourceLink global="jdbc/BSFAurora_data"
name="jdbc/BSFAurora_data" type="javax.sql.DataSource"/>
This configuration works fine in LR7.0 GA5 on Tomcat 8 and I checked
to see if there were breaking changes with JNDI in the LR7.1 docs and
also in the Tomcat 9 changes. Nothin....
Ideas here? The whole move to 7.1.1 has been about as painful
as the 6.0.6 to 7.0 move was...I thought the big challenges were
behind me....
