Connect 1.1 Download

Trusted Windows (PC) download Optris PI Connect 1.1. Virus-free and 100% clean download. Get Optris PI Connect alternative downloads.

OpenSSL is a robust, commercial-grade, and full-featured toolkit for the Transport Layer Security (TLS) and Secure Sockets Layer (SSL) protocols. It is also a general-purpose cryptography library. For more information about the team and community around the project, or to start making your own contributions, start with the community page. To get the latest news, download the source, and so on, please see the sidebar or the buttons at the top of every page.

OpenSSL is licensed under an Apache-style license, which basically means that you are free to get and use it for commercial and non-commercial purposes subject to some simple license conditions.

For a list of vulnerabilities, and the releases in which they were found and fixes, see our Vulnerabilities page.

Latest News

Legalities

Please remember that export/import and/or use of strongcryptography software, providing cryptography hooks, or even justcommunicating technical details about cryptography software isillegal in some parts of the world. So when you import thispackage to your country, re-distribute it from there or evenjust email technical suggestions or even source patches to theauthors or other people you are strongly advised to pay closeattention to any laws or regulations which apply toyou. The authors of OpenSSL are not liable for any violationsyou make here. So be careful, it is your responsibility.

Released:

Use JDBC database drivers from Python 2/3 or Jython with a DB-API.

Project description

The JayDeBeApi module allows you to connect from Python code todatabases using Java JDBC. It provides aPython DB-API v2.0 to that database.

It works on ordinary Python (cPython) using the JPype Javaintegration or on Jython to make use ofthe Java JDBC driver.

In contrast to zxJDBC from the Jython project JayDeBeApi let’s youaccess a database with Jython AND Python with only minor codemodifications. JayDeBeApi’s future goal is to provide a unique andfast interface to different types of JDBC-Drivers through a flexibleplug-in mechanism.

Contents

Install

You can get and install JayDeBeApi with pip

If you want to install JayDeBeApi in Jython make sure to have pip orEasyInstall available for it.

Or you can get a copy of the source by cloning from the JayDeBeApigithub project and installwith

or if you are using Jython use

It has been tested with Jython 2.7.0.

Download ExpanDrive for macOS or Windows for free. By downloading, installing and/or using ExpanDrive you agree to be bound by our End User License Agreement. Expandrive alternative. ExpanDrive builds cloud storage in every application, acts just like a USB drive plugged into your Mac. With ExpanDrive, you can securely access any remote file server directly from the Finder or even the terminal. ExpanDrive supports: SFTP/FTP/FTPS Amazon S3 Dropbox WebDAV Rackspace Clo.

If you are using cPython ensure that you have installed JPypeproperly. It has been tested with JPype1 0.5.7. Older JPypeinstallations may cause problems.

Usage

Basically you just import the jaydebeapi Python module and executethe connect method. This gives you a DB-API conform connection tothe database.

The first argument to connect is the name of the Java driverclass. The second argument is a string with the JDBC connectionURL. Third you can optionally supply a sequence consisting of user andpassword or alternatively a dictionary containing arguments that areinternally passed as properties to the JavaDriverManager.getConnection method. See the Javadoc ofDriverManager class for details.

The next parameter to connect is optional as well and specifiesthe jar-Files of the driver if your classpath isn’t set upsufficiently yet. The classpath set in CLASSPATH environmentvariable will be honored. See the documentation of your Java runtimeenvironment.

Here is an example:

An alternative way to establish connection using connectionproperties:

If you’re having trouble getting this work check if your JAVA_HOMEenvironmentvariable is set correctly. For example I have to set it onmy Ubuntu machine like this

Supported databases

In theory every database with a suitable JDBC driver should work. Itis confirmed to work with the following databases:

• SQLite
• Hypersonic SQL (HSQLDB)
• IBM DB2
• IBM DB2 for mainframes
• Oracle
• Teradata DB
• Netezza
• Mimer DB
• Microsoft SQL Server
• MySQL
• PostgreSQL
• many more…

Contributing

Please submit bugs and patches. All contributorswill be acknowledged. Thanks!

License

JayDeBeApi is released under the GNU Lesser General Public license(LGPL). See the file COPYING and COPYING.LESSER in thedistribution for details.

Changelog

• Next version - unreleased
• 1.1.1 - 2017-03-21
  • Don’t fail on dates before 1900 on Python < 3.
• 1.1.0 - 2017-03-19
  • Support BIT and TINYINT type mappings (thanks @Mokubyow forreporting the issue).
• 1.0.0 - 2017-01-10
  • Allow for db properties to be passed to the connectmethod. Probably incompatible to code based on previousversions. See documentation of the connect method. (Thanks@testlnord for you efforts and the patience.)
  • New major version due to possible api incompatibility.
• 0.2.0 - 2015-04-26
  • Python 3 support (requires JPype1 >= 0.6.0).
• 0.1.6 - 2015-04-10
  • Fix Jython handling of Java exceptions that don’t subclass python Exception
  • Enrich exceptions with message from java SQLExceptions
  • Be more specific about DB API exceptions: Distinguish DatabaseError andInterfaceError.
  • Fix typo LONGNARCHAR vs LONGVARCHAR (thanks @datdo for reporting #4)
• 0.1.5 - 2015-03-02
  • Add version number to module.
  • Improve robustness of java to python type conversion.
  • Support Time type.
  • Add DB-API compliant exception handling.
  • Minor documentation improvements.
  • Some development related changes (Host project at github, useTravis CI, use JPype1 for tests).
• 0.1.4 - 2013-10-29
  • More convenient way to setup Java classpath. Important notecheck the changes to the connect method and adapt your code.
  • Honor CLASSPATH if used in JPype mode.
  • Set .rowcount properly.
  • Changed signature of .setoutputsize() to be DB-API compliant.
• 0.1.3 - 2011-01-27
  • Fixed DB-API violation: Use curs.execute('foo?', (bar, baz))instead of curs.execute('foo?', bar, baz).
  • Free resources after executemany call.
  • Improved type handling. Initial support for BLOB columns.
• 0.1.2 - 2011-01-25
  • easy_install JayDeBeApi should really work.
• 0.1.1 - 2010-12-12
  • Fixed bug #688290 “NULL values with converters error on fetch”.
  • Fixed bug #684909 “Selecting ROWIDs errors out on fetch”.
• 0.1 - 2010-08-10
  • Initial release.

To do

• Extract Java calls to separate Java methods to increase performance.
• Check if https://code.launchpad.net/dbapi-compliance can help makingJayDeBeApi more DB-API compliant.
• Test it on different databases and provide a flexible db specificpluign mechanism.
• SQLAlchemy modules (separate project)

Release historyRelease notifications

1.1.1

1.1.0

1.0.0

0.2.0

0.1.6

0.1.5

0.1.4

0.1.3

0.1.2

0.1.1

0.1

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Hashes for JayDeBeApi-1.1.1-py2-none-any.whl

Hashes for JayDeBeApi-1.1.1-py3-none-any.whl

Hashes for JayDeBeApi-1.1.1.tar.gz