• Olena
  • NEWBIE
  • 10 Points
  • Member since 2021

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 2
    Questions
  • 5
    Replies

Hello guys,

Please advise how I can change the batch size for Bulk Insert via Bulk API? Is there a parameter, like 'batchSize=some_value' and if so, where should I use I this parameter (when create a job or when execute it)?

Thanks a lot in advance.

  • March 01, 2021
  • Like
  • 0
Hello guys,
I am connecting to Salesforce in Apache NiFi using Reliersoft JDBC driver.
But I cannot connect because of this issue: "Cannot create PoolableConnectionFactory (Login to "login.salesforce.com" failed: Invalid username, password, security token; or user locked out.)".

I created connection string based on their documentation and it looks this way: 
jdbc:sforce://login.salesforce.com?user="my_username"&password="my_password"&token="my_token"&api=50.0
Here is database driver class name: 
com.reliersoft.sforce.jdbc.Driver

Also I tried to use combination password+token but the error remains.
The username, password and token are 100% correct. The user is not locked out.
Moreover, when I am using CData JDBC driver, everything works fine.

Please let me know what else can be an issue except incorrect username/password/token?
  • February 03, 2021
  • Like
  • 0

Hello guys,

Please advise how I can change the batch size for Bulk Insert via Bulk API? Is there a parameter, like 'batchSize=some_value' and if so, where should I use I this parameter (when create a job or when execute it)?

Thanks a lot in advance.

  • March 01, 2021
  • Like
  • 0
Hello guys,
I am connecting to Salesforce in Apache NiFi using Reliersoft JDBC driver.
But I cannot connect because of this issue: "Cannot create PoolableConnectionFactory (Login to "login.salesforce.com" failed: Invalid username, password, security token; or user locked out.)".

I created connection string based on their documentation and it looks this way: 
jdbc:sforce://login.salesforce.com?user="my_username"&password="my_password"&token="my_token"&api=50.0
Here is database driver class name: 
com.reliersoft.sforce.jdbc.Driver

Also I tried to use combination password+token but the error remains.
The username, password and token are 100% correct. The user is not locked out.
Moreover, when I am using CData JDBC driver, everything works fine.

Please let me know what else can be an issue except incorrect username/password/token?
  • February 03, 2021
  • Like
  • 0