error in create data source for sqlserver in wso2 ei

1k views Asked by At

after installing wso2 ei, i download sql server jdbc driver and copy it in wso2home/lib, i want to create service via sql query so i define below data service :

<data name="BankDB" transports="http https local">
<config enableOData="false" id="sql">
  <property name="dataSourceClassName">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>
  <property name="dataSourceProps">
     <property name="url">jdbc:sqlserver://x.x.x.x:1433/databaseName=ApiDB</property>
     <property name="username">username</property>
     <property name="password">password</property>
  </property>
</config>
<query id="MappedFaults" useConfig="sql">
  <sql>select BankCode from ApiDB.dbo.MappedFaults</sql>
  <result element="BankCode" rowName="">
     <element column="BankCode" name="BankCode" namespace="BankCode" xsdType="string"/>
  </result>
</query>
<operation name="select">
  <call-query href="MappedFaults"/>
</operation>
</data>

but i get this error :

DS Fault Message: Error creating JDBC Pool SQL Config: Error in creating external data source: Setter method for property 'password' cannot be found DS Code: UNKNOWN_ERROR Source Data Service:- Name: BankDB Location: \BankDB.dbs Description: N/A Default Namespace: http://ws.wso2.org/dataservice Nested Exception:- org.wso2.carbon.ndatasource.common.DataSourceException: Error in creating external data source: Setter method for property 'password' cannot be found at org.wso2.carbon.dataservices.core.JDBCPoolSQLConfig.getDataSource(JDBCPoolSQLConfig.java:66) at
0

There are 0 answers