search

forcedotcom / Salesforce-CDP-jdbc

JDBC driver to connect to Salesforce CDP.
Apache License 2.0
32 stars 29 forks source link

PreparedStatement is not supported #162

Closed suryakiran-c closed 4 months ago

suryakiran-c commented 4 months ago

I'm trying to use preparedStatement as in example provided in Readme. 

        PreparedStatement preparedStatement = connection.prepareStatement("select FirstName__c, BirthDate__c, YearlyIncome__c from Individual__dlm where FirstName__c = ? and YearlyIncome__c > ?");
        preparedStatement.setString(0, "Angella");
        preparedStatement.setInt(1, 1000);

But I get this error, Exception in thread "main" java.sql.SQLFeatureNotSupportedException: PreparedStatement is not supported at com.salesforce.cdp.queryservice.core.QueryServiceConnection.prepareStatement(QueryServiceConnection.java:147) at TestConnectivity.main(TestConnectivity.java:38)

https://github.com/forcedotcom/Salesforce-CDP-jdbc/blob/dea103d6afde802764659944e7f0932000e9f710/src/main/java/com/salesforce/cdp/queryservice/core/QueryServiceConnection.java#L146

Looks like prepareStatement is removed in new release release_2024.4b.2 But it was available till previous releases release_2024.4a.1

suryakiran-c commented 4 months ago

Never mind. It was published in Release notes.