[ 
https://issues.apache.org/jira/browse/DBCP-471?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

happybuddha updated DBCP-471:
-----------------------------
    Description: 
Error : 

{code}Caused by: org.springframework.beans.NotWritablePropertyException: 
Invalid property 'connectionInitSqls' of bean class 
[org.apache.commons.dbcp2.BasicDataSource]: Bean property 'connectionInitSqls' 
is not writable or has an invalid setter method. Does the parameter type of the 
setter match the return type of the getter?
        at 
org.springframework.beans.BeanWrapperImpl.setPropertyValue(BeanWrapperImpl.java:1042)
        at 
org.springframework.beans.BeanWrapperImpl.setPropertyValue(BeanWrapperImpl.java:902)
        at 
org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(AbstractPropertyAccessor.java:75)
{code}
Configuration : 
{code}
  <bean id="dataSource" class="org.apache.commons.dbcp2.BasicDataSource" 
destroy-method="close">
    <property name="driverClassName" value="${database.driverClassName}" />
    <property name="url" value="${database.url}" />
    <property name="username" value="${database.username}" />
    <property name="password" value="${database.password}" />
    <property name="connectionInitSqls">
    <list>
        <value>BEGIN call initialise_connection(); END;</value>
    </list>
    </property>
  </bean>
{code}

Similar issue for another bean : https://issues.apache.org/jira/browse/DBCP-469

The property is listed as a List<String>, has a getter which returns a 
List<String> but has a setter which takes a Collection<String> 
This is also not in line with what was in versions before 2 
(dbcp.BasicDataSource)

  was:
Error : 

{code}Caused by: org.springframework.beans.NotWritablePropertyException: 
Invalid property 'connectionInitSqls' of bean class 
[org.apache.commons.dbcp2.BasicDataSource]: Bean property 'connectionInitSqls' 
is not writable or has an invalid setter method. Does the parameter type of the 
setter match the return type of the getter?
        at 
org.springframework.beans.BeanWrapperImpl.setPropertyValue(BeanWrapperImpl.java:1042)
        at 
org.springframework.beans.BeanWrapperImpl.setPropertyValue(BeanWrapperImpl.java:902)
        at 
org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(AbstractPropertyAccessor.java:75)
{code}
Configuration : 
{code}
  <bean id="dataSource" class="org.apache.commons.dbcp2.BasicDataSource" 
destroy-method="close">
    <property name="driverClassName" value="${database.driverClassName}" />
    <property name="url" value="${database.url}" />
    <property name="username" value="${database.username}" />
    <property name="password" value="${database.password}" />
    <property name="connectionInitSqls">
    <list>
        <value>BEGIN call initialise_connection(); END;</value>
    </list>
    </property>
  </bean>
{code}
Similar issue for another bean : https://issues.apache.org/jira/browse/DBCP-469


> Cannot use connectionInitSqls property in BasicDataSource
> ---------------------------------------------------------
>
>                 Key: DBCP-471
>                 URL: https://issues.apache.org/jira/browse/DBCP-471
>             Project: Commons Dbcp
>          Issue Type: Bug
>    Affects Versions: 2.1.1
>            Reporter: happybuddha
>
> Error : 
> {code}Caused by: org.springframework.beans.NotWritablePropertyException: 
> Invalid property 'connectionInitSqls' of bean class 
> [org.apache.commons.dbcp2.BasicDataSource]: Bean property 
> 'connectionInitSqls' is not writable or has an invalid setter method. Does 
> the parameter type of the setter match the return type of the getter?
>       at 
> org.springframework.beans.BeanWrapperImpl.setPropertyValue(BeanWrapperImpl.java:1042)
>       at 
> org.springframework.beans.BeanWrapperImpl.setPropertyValue(BeanWrapperImpl.java:902)
>       at 
> org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(AbstractPropertyAccessor.java:75)
> {code}
> Configuration : 
> {code}
>   <bean id="dataSource" class="org.apache.commons.dbcp2.BasicDataSource" 
> destroy-method="close">
>     <property name="driverClassName" value="${database.driverClassName}" />
>     <property name="url" value="${database.url}" />
>     <property name="username" value="${database.username}" />
>     <property name="password" value="${database.password}" />
>     <property name="connectionInitSqls">
>     <list>
>       <value>BEGIN call initialise_connection(); END;</value>
>     </list>
>     </property>
>   </bean>
> {code}
> Similar issue for another bean : 
> https://issues.apache.org/jira/browse/DBCP-469
> The property is listed as a List<String>, has a getter which returns a 
> List<String> but has a setter which takes a Collection<String> 
> This is also not in line with what was in versions before 2 
> (dbcp.BasicDataSource)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to