search

oracle / python-cx_Oracle

Python interface to Oracle Database now superseded by python-oracledb
https://oracle.github.io/python-cx_Oracle
Other
888 stars 361 forks source link

TimesTen: suggestion #47

Closed az-z closed 7 years ago

az-z commented 7 years ago

Not an issue, since CX doesn't officially support TimesTen, but i figured it would be nice: a. either include the support into the roadmap b. note that TT can be used with the cx.

az-z commented 7 years ago

I'll take my suggestions to the mailing list. Please ignore the issue.

cjbj commented 7 years ago

@az-z the TimesTen team is (of course) keen for language APIs to be able to work with TimesTen. There was a PHP effort a while back, see this very old article Installing PHP and the Oracle TimesTen In-Memory Database on Linux, and more recently we've had some talk about ODPI-C but no solid work.

Have you tried using the TT DSN as the connect string?

az-z commented 7 years ago

@christinabrashear Chirstopher,

.. Have you tried using the TT DSN as the connect string?

I haven't tried. But what worked for me is to use OCI with connect string like : connection = cx_Oracle.Connection("user/pass@127.0.0.1/DB:timesten:direct") like in : connection = cx_Oracle.Connection("user/pass@127.0.0.1/TT_1122:timesten:direct")

i haven't noticed any difference if i were to use :timestendirect full disclosure - i just got this setup to work, so there maybe some differences i'm not aware of.