Ask Questions and Find Answers

HI Team,

i am getting the following error, while trying to connect to another DB.

service.xml:

<entity cache-enabled="true" table="TBL_ACCOUNT" name="TBL_ACCOUNT" local-service="true" remote-service="true" data-source="customerDataSource" >
<column name="ACCOUNTID" type="long" primary="true" />
<column name="ACCOUNTNAME" type="String" />
<column name="ACCOUNTSTATUS" type="long" />
<column name="ACCOUNTTYPE" type="long" />
<column name="PARENTACCOUNTID" type="long" />
<column name="CREATEDATE" type="Date" />
<column name="CREATEDABY" type="String" />
<column name="LASTUPDATEDDATE" type="Date" />
<column name="LASTUPDATEDBY" type="String" />

<finder return-type="Collection" name="name">
<finder-column name="ACCOUNTNAME"></finder-column>
</finder>
</entity>

ext-db-spring.xml:

<?xml version="1.0"?>

<beans
default-destroy-method="destroy"
default-init-method="afterPropertiesSet"
xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd"
>

<!--
NOTE: Current restriction in LR7's handling of external data sources requires us to redefine the
liferayDataSource bean in our spring configuration.

The following beans define a new liferayDataSource based on the jdbc.ext. prefix in portal-ext.properties.
-->
<bean class="com.liferay.portal.dao.jdbc.spring.DataSourceFactoryBean" id="liferayDataSourceImpl">
<property name="propertyPrefix" value="jdbc.customer." />
</bean>

<bean class="org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy" id="liferayDataSource">
<property name="targetDataSource" ref="liferayDataSourceImpl" />
</bean>

<!--
So our entities are all appropriately tagged with the extDataSource, we'll alias the above
liferayDataSource so it matches the entities.
-->

<alias alias="customerDataSource" name="liferayDataSource" />
</beans>


while doing deployment, i am getting the following error:

19:27:53,793 ERROR [localhost-startStop-1][vf-goop-webservices-service:97] Unable to start vf-goop-webservices-service
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'com.liferay.portal.spring.aop.ServiceBeanAutoProxyCreator#0' defined in URL [bundleentry://344.fwk52906764/META-INF/spring/parent/base-spring.xml]: Invocation of init method failed; nested exception is org.springframework.beans.factory.CannotLoadBeanClassException: Cannot find class [org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy] for bean with name 'liferayDataSource' defined in URL [bundleentry://44.fwk52906764/META-INF/spring/ext-db-spring.xml]; nested exception is java.lang.ClassNotFoundException: org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy

can you please let me know, is i missed any configuration?

Thanks,
Murali