Giter Club home page Giter Club logo

salesforce-jdbc-driver's People

Contributors

wise-coders avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar

salesforce-jdbc-driver's Issues

Driver errors on Java 11 method?

Hi
In trialing this driver (using dbschema-salesforce-jdbc1.2.jar; mod date August ‎03, ‎2021, ‏‎8:42:12 AM) , running adoptium jdk 8u292-b10, we got NoSuchMethodError on String.isBlank() (see below), which we found interesting because that method is a Java 11 method even though the class version is 52.

Thanks for your attention to this.
Regards
J Bocarsly

url=jdbc:dbschema:salesforce://tables=all
Data is = tables=all
key=tables val=all
Aug 13, 2021 9:45:44 AM com.dbschema.salesforce.SalesforceJdbcDriver getSalesforceConnection
INFO: Create H2 database 'jdbc:h2:file:/C:/Users/jbocarsly/.DbSchema/jdbc-salesforce-cache/d58bd64eaf4f49a79dd611cc87d684e3;database_to_upper=false'
Aug 13, 2021 9:45:44 AM com.dbschema.salesforce.SalesforceJdbcDriver getSalesforceConnection
INFO: Create H2 database 'jdbc:h2:file:/C:/Users/jbocarsly/.DbSchema/jdbc-salesforce-cache/d58bd64eaf4f49a79dd611cc87d684e3;database_to_upper=false'
Exception in thread "main" java.lang.NoSuchMethodError: java.lang.String.isBlank()Z
at com.dbschema.salesforce.SalesforceConnection.transferDataForTablesFromQuery(SalesforceConnection.java:70)
at com.dbschema.salesforce.SalesforceConnection.access$300(SalesforceConnection.java:29)
at com.dbschema.salesforce.SalesforceConnection$StatementProxy.invoke(SalesforceConnection.java:126)
at com.sun.proxy.$Proxy0.executeQuery(Unknown Source)
at com.rttsweb.util.SimpleDAO.sqlQuery(SimpleDAO.java:95)
at com.rttsweb.workspace.Workspace_SFDC_dbschema_driver.main(Workspace_SFDC_dbschema_driver.java:54)

Update SF data

"By each UPDATE, DELETE or INSERT modify back the Salesforce database"
Hi, when can we expect this functionality?

Build Fails

When I attempt to build the driver, I get the following error:

Environment: Mac OSX Latest Version
Javac version: 1.8.0_301
Java version:

java version "1.8.0_301"
Java(TM) SE Runtime Environment (build 1.8.0_301-b09)
Java HotSpot(TM) 64-Bit Server VM (build 25.301-b09, mixed mode)
 salesforce-jdbc-driver git:(master) gradle build

Welcome to Gradle 7.1.1!

Here are the highlights of this release:
 - Faster incremental Java compilation
 - Easier source set configuration in the Kotlin DSL

For more details see https://docs.gradle.org/7.1.1/release-notes.html

Starting a Gradle Daemon (subsequent builds will be faster)

FAILURE: Build failed with an exception.

* Where:
Build file 'XXXX/salesforce-jdbc-driver/build.gradle' line: 25

* What went wrong:
A problem occurred evaluating root project 'salesforce-jdbc-driver'.
> Could not find method compile() for arguments [com.force.api:force-partner-api:52.1.0] on object of type org.gradle.api.internal.artifacts.dsl.dependencies.DefaultDependencyHandler.

* Try:
Run with --stacktrace option to get the stack trace. Run with --info or --debug option to get more log output. Run with --scan to get full insights.

* Get more help at https://help.gradle.org

Deprecated Gradle features were used in this build, making it incompatible with Gradle 8.0.

You can use '--warning-mode all' to show the individual deprecation warnings and determine if they come from your own scripts or plugins.

See https://docs.gradle.org/7.1.1/userguide/command_line_interface.html#sec:command_line_warnings

BUILD FAILED in 13s

Driver throws exception when using with python

I have successfully integrated CData's JDBC driver for Salesforce into my python code. I tried to do the same with DbSchema's JDBC driver, but did not succeed. When I create a connection, it throws the following exception:

Traceback (most recent call last):
  File "org.jpype.JPypeContext.java", line -1, in org.jpype.JPypeContext.callMethod
  File "Method.java", line 498, in java.lang.reflect.Method.invoke
  File "DelegatingMethodAccessorImpl.java", line 43, in sun.reflect.DelegatingMethodAccessorImpl.invoke
  File "NativeMethodAccessorImpl.java", line 62, in sun.reflect.NativeMethodAccessorImpl.invoke
  File "NativeMethodAccessorImpl.java", line -2, in sun.reflect.NativeMethodAccessorImpl.invoke0
  File "DriverManager.java", line 270, in java.sql.DriverManager.getConnection
  File "DriverManager.java", line 664, in java.sql.DriverManager.getConnection
  File "SalesforceJdbcDriver.java", line 81, in com.dbschema.salesforce.SalesforceJdbcDriver.connect
Exception: Java Exception

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3166, in connect
    return self._connection_cls(self, close_with_result=close_with_result)
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 96, in __init__
    else engine.raw_connection()
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3245, in raw_connection
    return self._wrap_pool_connect(self.pool.connect, _connection)
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3212, in _wrap_pool_connect
    return fn()
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 307, in connect
    return _ConnectionFairy._checkout(self)
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 767, in _checkout
    fairy = _ConnectionRecord.checkout(pool)
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 425, in checkout
    rec = pool._do_get()
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/pool/impl.py", line 146, in _do_get
    self._dec_overflow()
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
    compat.raise_(
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
    raise exception
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/pool/impl.py", line 143, in _do_get
    return self._create_connection()
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 253, in _create_connection
    return _ConnectionRecord(self)
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 368, in __init__
    self.__connect()
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 611, in __connect
    pool.logger.debug("Error on connect(): %s", e)
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
    compat.raise_(
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
    raise exception
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/pool/base.py", line 605, in __connect
    connection = pool._invoke_creator(self)
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/engine/create.py", line 578, in connect
    return dialect.connect(*cargs, **cparams)
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 584, in connect
    return self.dbapi.connect(*cargs, **cparams)
  File "/home/ubuntu/.local/lib/python3.8/site-packages/jaydebeapi/__init__.py", line 412, in connect
    jconn = _jdbc_connect(jclassname, url, driver_args, jars, libs)
  File "/home/ubuntu/.local/lib/python3.8/site-packages/jaydebeapi/__init__.py", line 230, in _jdbc_connect_jpype
    return jpype.java.sql.DriverManager.getConnection(url, *dargs)
java.sql.SQLException: java.sql.SQLException: Missing username. Please add it to URL as user=<value>

Can't pull the Entity and Field Descriptions

Oddly, it appears you must use the tooling api to get the descriptions from the EntityDefinition and FieldDefinition tables.

Please implement access to this information within your driver.

I can provide the queries I used. I had to write some Python code to pull this information using the salesforce-api package. It had just enough support to make it possible.

Add License

Thank you very much for releasing this driver as an open source project. I wasn't clear what license this driver was released under, but I saw in the source code it was released under the BSD.

Could you please clarify and add a LICENSE file to the repo? Thanks!!

Broken Download Link to Binary

Thanks for all your work on this driver. It looks like the link to download the driver is broken. Can you provide a direct link to the JAR or binary?

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.