10:53 p.m.
Have teiid emulate a native postgresql database connection
----------------------------------------------------------
Key: TEIID-1460
URL: https://issues.jboss.org/browse/TEIID-1460
Project: Teiid
Issue Type: Feature Request
Components: Server
Affects Versions: 7.3
Environment: All environments
Reporter: Graeme Gillies
Assignee: Steven Hawkins
Priority: Minor
Currently we are using postgresql-odbc, and unixODBC to connect to teiid via the emulated
postgresql ODBC connection on port 35432. Unfortunately, this is cumbersome to use,
requires fiddling with setting up ODBC, and is difficult for integration into non-java
languages (that have to use the ODBC connection).
What we would like is for teiid to emulate a postgresql database such that we can point
typical postgresql tools (such as psql) to port 35432 (or some other port) and they will
"work". That would also allow us to use each languages native/preferred method
of connecting to a postgresql database to connect to teiid. E.g. DBD::Postgres for perl,
ruby-pg for ruby, pg/pgdb in python, etc.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:46 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1460) Have teiid emulate a native postgresql database connection
[
https://issues.jboss.org/browse/TEIID-1460?page=com.atlassian.jira.plugin...
]
Ramesh Reddy commented on TEIID-1460:
-------------------------------------
Teiid does implement the majority of the server side interface that emulates the postgres
for the ODBC connection. I suspect except for for metadata calls most of it might just
work, as you are asking. We have not tried, I tried psql that failed but others *may*
work.
Have teiid emulate a native postgresql database connection
----------------------------------------------------------
Key: TEIID-1460
URL: https://issues.jboss.org/browse/TEIID-1460
Project: Teiid
Issue Type: Feature Request
Components: Server
Affects Versions: 7.3
Environment: All environments
Reporter: Graeme Gillies
Assignee: Steven Hawkins
Priority: Minor
Currently we are using postgresql-odbc, and unixODBC to connect to teiid via the emulated
postgresql ODBC connection on port 35432. Unfortunately, this is cumbersome to use,
requires fiddling with setting up ODBC, and is difficult for integration into non-java
languages (that have to use the ODBC connection).
What we would like is for teiid to emulate a postgresql database such that we can point
typical postgresql tools (such as psql) to port 35432 (or some other port) and they will
"work". That would also allow us to use each languages native/preferred method
of connecting to a postgresql database to connect to teiid. E.g. DBD::Postgres for perl,
ruby-pg for ruby, pg/pgdb in python, etc.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:27 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1460) Have teiid emulate a native postgresql database connection
[
https://issues.jboss.org/browse/TEIID-1460?page=com.atlassian.jira.plugin...
]
Steven Lawrance commented on TEIID-1460:
----------------------------------------
I tried several Python client libraries -- some ODBC, some pure Python, some wrappers for
the C library -- and could not get any of them to work. These included bpgsql, ocpgdb,
pg8000 and pyodbc. In the case of pyodbc, using the postgres ODBC client library (ANSI
version!), the client seemed to give up after receiving some server capability messages.
Have teiid emulate a native postgresql database connection
----------------------------------------------------------
Key: TEIID-1460
URL: https://issues.jboss.org/browse/TEIID-1460
Project: Teiid
Issue Type: Feature Request
Components: Server
Affects Versions: 7.3
Environment: All environments
Reporter: Graeme Gillies
Assignee: Steven Hawkins
Priority: Minor
Currently we are using postgresql-odbc, and unixODBC to connect to teiid via the emulated
postgresql ODBC connection on port 35432. Unfortunately, this is cumbersome to use,
requires fiddling with setting up ODBC, and is difficult for integration into non-java
languages (that have to use the ODBC connection).
What we would like is for teiid to emulate a postgresql database such that we can point
typical postgresql tools (such as psql) to port 35432 (or some other port) and they will
"work". That would also allow us to use each languages native/preferred method
of connecting to a postgresql database to connect to teiid. E.g. DBD::Postgres for perl,
ruby-pg for ruby, pg/pgdb in python, etc.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
2:02 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1460) Have teiid emulate a native postgresql database connection
[
https://issues.jboss.org/browse/TEIID-1460?page=com.atlassian.jira.plugin...
]
Ramesh Reddy commented on TEIID-1460:
-------------------------------------
Can you attach some of your test scripts, I will try to debug and see if there is some
thing I can quickly fix.
Have teiid emulate a native postgresql database connection
----------------------------------------------------------
Key: TEIID-1460
URL: https://issues.jboss.org/browse/TEIID-1460
Project: Teiid
Issue Type: Feature Request
Components: Server
Affects Versions: 7.3
Environment: All environments
Reporter: Graeme Gillies
Assignee: Steven Hawkins
Priority: Minor
Currently we are using postgresql-odbc, and unixODBC to connect to teiid via the emulated
postgresql ODBC connection on port 35432. Unfortunately, this is cumbersome to use,
requires fiddling with setting up ODBC, and is difficult for integration into non-java
languages (that have to use the ODBC connection).
What we would like is for teiid to emulate a postgresql database such that we can point
typical postgresql tools (such as psql) to port 35432 (or some other port) and they will
"work". That would also allow us to use each languages native/preferred method
of connecting to a postgresql database to connect to teiid. E.g. DBD::Postgres for perl,
ruby-pg for ruby, pg/pgdb in python, etc.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:05 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1460) Have teiid emulate a native postgresql database connection
[
https://issues.jboss.org/browse/TEIID-1460?page=com.atlassian.jira.plugin...
]
Steven Lawrance commented on TEIID-1460:
----------------------------------------
For python, here are a few things I tried:
# Using PyGreSQL DBAPI to connect directly:
import pgdb
conn = pgdb.connect(host="teiidserver:35432", user="test",
password="123")
That results in 'pg.InternalError: received invalid response to SSL negotiation:
'
Using stunnel to handle the SSL, listening locally on 5432 and forwarding to
server:35432.. we need to set the environment variable PGSSLMODE=disable (or we could
change the connect params). It seems to get further but we get an exception from teiid:
>> import pgdb
>> conn = pgdb.connect(host="localhost", user="test",
password="123")
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "/usr/lib64/python2.7/site-packages/pgdb.py", line 381, in connect
dbtty, dbuser, dbpasswd)
pg.InternalError: ERROR: org.teiid.core.TeiidException
DETAIL: org.teiid.jdbc.TeiidSQLException: org.teiid.core.TeiidException
No luck with the pg8000 module either:
# pg8000, connecting via stunnel as above
from pg8000 import DBAPI
conn = DBAPI.connect(host="localhost", user="test",
password="123")
That complains about the authentication method not being supported. It hangs if I try to
connect directly using SSL:
from pg8000 import DBAPI
conn = DBAPI.connect(host="teeidserver", port=35432, user="test",
password="123")
Have teiid emulate a native postgresql database connection
----------------------------------------------------------
Key: TEIID-1460
URL: https://issues.jboss.org/browse/TEIID-1460
Project: Teiid
Issue Type: Feature Request
Components: Server
Affects Versions: 7.3
Environment: All environments
Reporter: Graeme Gillies
Assignee: Steven Hawkins
Priority: Minor
Currently we are using postgresql-odbc, and unixODBC to connect to teiid via the emulated
postgresql ODBC connection on port 35432. Unfortunately, this is cumbersome to use,
requires fiddling with setting up ODBC, and is difficult for integration into non-java
languages (that have to use the ODBC connection).
What we would like is for teiid to emulate a postgresql database such that we can point
typical postgresql tools (such as psql) to port 35432 (or some other port) and they will
"work". That would also allow us to use each languages native/preferred method
of connecting to a postgresql database to connect to teiid. E.g. DBD::Postgres for perl,
ruby-pg for ruby, pg/pgdb in python, etc.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:35 a.m.
New subject: [JBoss JIRA] Commented: (TEIID-1460) Have teiid emulate a native postgresql database connection
[
https://issues.jboss.org/browse/TEIID-1460?page=com.atlassian.jira.plugin...
]
Steven Lawrance commented on TEIID-1460:
----------------------------------------
Oops, if I actually remember to specify the database name (i.e. with
database="dbname" as an additional parameter) it gets ever so slightly further.
I then get "pg.InternalError: server closed the connection unexpectedly.. This
probably means the server terminated abnormally before or while processing the
request.".
Wireshark shows the connection being made, authentication succeeding followed by a
"Parameter status" message but then the connection is just closed.
Have teiid emulate a native postgresql database connection
----------------------------------------------------------
Key: TEIID-1460
URL: https://issues.jboss.org/browse/TEIID-1460
Project: Teiid
Issue Type: Feature Request
Components: Server
Affects Versions: 7.3
Environment: All environments
Reporter: Graeme Gillies
Assignee: Steven Hawkins
Priority: Minor
Currently we are using postgresql-odbc, and unixODBC to connect to teiid via the emulated
postgresql ODBC connection on port 35432. Unfortunately, this is cumbersome to use,
requires fiddling with setting up ODBC, and is difficult for integration into non-java
languages (that have to use the ODBC connection).
What we would like is for teiid to emulate a postgresql database such that we can point
typical postgresql tools (such as psql) to port 35432 (or some other port) and they will
"work". That would also allow us to use each languages native/preferred method
of connecting to a postgresql database to connect to teiid. E.g. DBD::Postgres for perl,
ruby-pg for ruby, pg/pgdb in python, etc.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:02 a.m.
New subject: [JBoss JIRA] Commented: (TEIID-1460) Have teiid emulate a native postgresql database connection
[
https://issues.jboss.org/browse/TEIID-1460?page=com.atlassian.jira.plugin...
]
Steven Lawrance commented on TEIID-1460:
----------------------------------------
I did get further with pyodbc and the official postgresql ODBC driver. With ~/.odbc.ini
containing all the connection info (and set to connect via stunnel), I can connect and
execute a query. The funny thing is, I have to run it twice to get the results:
>> import pyodbc
>> conn = pyodbc.connect("DSN=PostgreSQL")
>> cursor = conn.cursor()
>> query = ...
>> cursor.execute(query)
<pyodbc.Cursor object at 0x1988210>
>> rows = cursor.fetchall()
>> rows
[('BEGIN', )]
>> cursor.execute(query)
<pyodbc.Cursor object at
0x1988270>
>> rows = cursor.fetchall()
>> rows
[actual, sensible results here]
I can see in wireshark the results are being returned the first time but that other table
is returned before it. Perhaps it's meant to indicate the query has started executing
but it's just that the client library doesn't understand it...
Have teiid emulate a native postgresql database connection
----------------------------------------------------------
Key: TEIID-1460
URL: https://issues.jboss.org/browse/TEIID-1460
Project: Teiid
Issue Type: Feature Request
Components: Server
Affects Versions: 7.3
Environment: All environments
Reporter: Graeme Gillies
Assignee: Steven Hawkins
Priority: Minor
Currently we are using postgresql-odbc, and unixODBC to connect to teiid via the emulated
postgresql ODBC connection on port 35432. Unfortunately, this is cumbersome to use,
requires fiddling with setting up ODBC, and is difficult for integration into non-java
languages (that have to use the ODBC connection).
What we would like is for teiid to emulate a postgresql database such that we can point
typical postgresql tools (such as psql) to port 35432 (or some other port) and they will
"work". That would also allow us to use each languages native/preferred method
of connecting to a postgresql database to connect to teiid. E.g. DBD::Postgres for perl,
ruby-pg for ruby, pg/pgdb in python, etc.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:19 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1460) Have teiid emulate a native postgresql database connection
[
https://issues.jboss.org/browse/TEIID-1460?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-1460:
---------------------------------------
Is the BEGIN value coming back as an initial result?
Have teiid emulate a native postgresql database connection
----------------------------------------------------------
Key: TEIID-1460
URL: https://issues.jboss.org/browse/TEIID-1460
Project: Teiid
Issue Type: Feature Request
Components: Server
Affects Versions: 7.3
Environment: All environments
Reporter: Graeme Gillies
Assignee: Steven Hawkins
Priority: Minor
Currently we are using postgresql-odbc, and unixODBC to connect to teiid via the emulated
postgresql ODBC connection on port 35432. Unfortunately, this is cumbersome to use,
requires fiddling with setting up ODBC, and is difficult for integration into non-java
languages (that have to use the ODBC connection).
What we would like is for teiid to emulate a postgresql database such that we can point
typical postgresql tools (such as psql) to port 35432 (or some other port) and they will
"work". That would also allow us to use each languages native/preferred method
of connecting to a postgresql database to connect to teiid. E.g. DBD::Postgres for perl,
ruby-pg for ruby, pg/pgdb in python, etc.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:21 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1460) Have teiid emulate a native postgresql database connection
[
https://issues.jboss.org/browse/TEIID-1460?page=com.atlassian.jira.plugin...
]
Ramesh Reddy commented on TEIID-1460:
-------------------------------------
When AutoCommit = false, the driver sends a implicit "BEGIN" to the engine, that
will return single column result 'BEGIN' as acknowledgement.
Have teiid emulate a native postgresql database connection
----------------------------------------------------------
Key: TEIID-1460
URL: https://issues.jboss.org/browse/TEIID-1460
Project: Teiid
Issue Type: Feature Request
Components: Server
Affects Versions: 7.3
Environment: All environments
Reporter: Graeme Gillies
Assignee: Steven Hawkins
Priority: Minor
Currently we are using postgresql-odbc, and unixODBC to connect to teiid via the emulated
postgresql ODBC connection on port 35432. Unfortunately, this is cumbersome to use,
requires fiddling with setting up ODBC, and is difficult for integration into non-java
languages (that have to use the ODBC connection).
What we would like is for teiid to emulate a postgresql database such that we can point
typical postgresql tools (such as psql) to port 35432 (or some other port) and they will
"work". That would also allow us to use each languages native/preferred method
of connecting to a postgresql database to connect to teiid. E.g. DBD::Postgres for perl,
ruby-pg for ruby, pg/pgdb in python, etc.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:11 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1460) Have teiid emulate a native postgresql database connection
[
https://issues.jboss.org/browse/TEIID-1460?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-1460:
---------------------------------------
Can you also experiment with 7.4 using trunk or starting with beta2 when available? I
have had good success using the standard postgres jdbc driver against it.
Have teiid emulate a native postgresql database connection
----------------------------------------------------------
Key: TEIID-1460
URL: https://issues.jboss.org/browse/TEIID-1460
Project: Teiid
Issue Type: Feature Request
Components: Server
Affects Versions: 7.3
Environment: All environments
Reporter: Graeme Gillies
Assignee: Steven Hawkins
Priority: Minor
Currently we are using postgresql-odbc, and unixODBC to connect to teiid via the emulated
postgresql ODBC connection on port 35432. Unfortunately, this is cumbersome to use,
requires fiddling with setting up ODBC, and is difficult for integration into non-java
languages (that have to use the ODBC connection).
What we would like is for teiid to emulate a postgresql database such that we can point
typical postgresql tools (such as psql) to port 35432 (or some other port) and they will
"work". That would also allow us to use each languages native/preferred method
of connecting to a postgresql database to connect to teiid. E.g. DBD::Postgres for perl,
ruby-pg for ruby, pg/pgdb in python, etc.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
2:47 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1460) Have teiid emulate a native postgresql database connection
[
https://issues.jboss.org/browse/TEIID-1460?page=com.atlassian.jira.plugin...
]
Ramesh Reddy commented on TEIID-1460:
-------------------------------------
I have tested successfully with
1) psql - use like psql -U user -W -host localhost -port 35432 <vdb>
2) perl using DBD:ODBC
3) python using psycopg2
4) pyton using PyGreSQL
Sample programs I used are attached. I feel this multi client is looking good, I tried
looking for sample programs for the libraries mentioned above, but did not turn up much
results. If you can verify again with 7.4, we can close this JIRA.
Have teiid emulate a native postgresql database connection
----------------------------------------------------------
Key: TEIID-1460
URL: https://issues.jboss.org/browse/TEIID-1460
Project: Teiid
Issue Type: Feature Request
Components: Server
Affects Versions: 7.3
Environment: All environments
Reporter: Graeme Gillies
Assignee: Steven Hawkins
Priority: Minor
Currently we are using postgresql-odbc, and unixODBC to connect to teiid via the emulated
postgresql ODBC connection on port 35432. Unfortunately, this is cumbersome to use,
requires fiddling with setting up ODBC, and is difficult for integration into non-java
languages (that have to use the ODBC connection).
What we would like is for teiid to emulate a postgresql database such that we can point
typical postgresql tools (such as psql) to port 35432 (or some other port) and they will
"work". That would also allow us to use each languages native/preferred method
of connecting to a postgresql database to connect to teiid. E.g. DBD::Postgres for perl,
ruby-pg for ruby, pg/pgdb in python, etc.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
2:51 p.m.
New subject: [JBoss JIRA] Updated: (TEIID-1460) Have teiid emulate a native postgresql database connection
[
https://issues.jboss.org/browse/TEIID-1460?page=com.atlassian.jira.plugin...
]
Ramesh Reddy updated TEIID-1460:
--------------------------------
Attachment: preparedodbctest.pl
testselect.py
pgclient.py
If somebody written more, especially one that shows schema metadata please share, we could
use while we test.
Have teiid emulate a native postgresql database connection
----------------------------------------------------------
Key: TEIID-1460
URL: https://issues.jboss.org/browse/TEIID-1460
Project: Teiid
Issue Type: Feature Request
Components: Server
Affects Versions: 7.3
Environment: All environments
Reporter: Graeme Gillies
Assignee: Steven Hawkins
Priority: Minor
Attachments: pgclient.py, preparedodbctest.pl, testselect.py
Currently we are using postgresql-odbc, and unixODBC to connect to teiid via the emulated
postgresql ODBC connection on port 35432. Unfortunately, this is cumbersome to use,
requires fiddling with setting up ODBC, and is difficult for integration into non-java
languages (that have to use the ODBC connection).
What we would like is for teiid to emulate a postgresql database such that we can point
typical postgresql tools (such as psql) to port 35432 (or some other port) and they will
"work". That would also allow us to use each languages native/preferred method
of connecting to a postgresql database to connect to teiid. E.g. DBD::Postgres for perl,
ruby-pg for ruby, pg/pgdb in python, etc.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:49 a.m.
New subject: [JBoss JIRA] Commented: (TEIID-1460) Have teiid emulate a native postgresql database connection
[
https://issues.jboss.org/browse/TEIID-1460?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-1460:
---------------------------------------
SSL support has been added for the 7.5 (7.4.1) release.
Have teiid emulate a native postgresql database connection
----------------------------------------------------------
Key: TEIID-1460
URL: https://issues.jboss.org/browse/TEIID-1460
Project: Teiid
Issue Type: Feature Request
Components: Server
Affects Versions: 7.3
Environment: All environments
Reporter: Graeme Gillies
Assignee: Steven Hawkins
Priority: Minor
Attachments: pgclient.py, preparedodbctest.pl, testselect.py
Currently we are using postgresql-odbc, and unixODBC to connect to teiid via the emulated
postgresql ODBC connection on port 35432. Unfortunately, this is cumbersome to use,
requires fiddling with setting up ODBC, and is difficult for integration into non-java
languages (that have to use the ODBC connection).
What we would like is for teiid to emulate a postgresql database such that we can point
typical postgresql tools (such as psql) to port 35432 (or some other port) and they will
"work". That would also allow us to use each languages native/preferred method
of connecting to a postgresql database to connect to teiid. E.g. DBD::Postgres for perl,
ruby-pg for ruby, pg/pgdb in python, etc.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:19 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1460) Have teiid emulate a native postgresql database connection
[
https://issues.jboss.org/browse/TEIID-1460?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-1460:
---------------------------------------
I vote for closing this issue and picking up remaining work in specific JIRAs, such as
TEIID-1687.
Have teiid emulate a native postgresql database connection
----------------------------------------------------------
Key: TEIID-1460
URL: https://issues.jboss.org/browse/TEIID-1460
Project: Teiid
Issue Type: Feature Request
Components: Server
Affects Versions: 7.3
Environment: All environments
Reporter: Graeme Gillies
Assignee: Steven Hawkins
Priority: Minor
Attachments: pgclient.py, preparedodbctest.pl, testselect.py
Currently we are using postgresql-odbc, and unixODBC to connect to teiid via the emulated
postgresql ODBC connection on port 35432. Unfortunately, this is cumbersome to use,
requires fiddling with setting up ODBC, and is difficult for integration into non-java
languages (that have to use the ODBC connection).
What we would like is for teiid to emulate a postgresql database such that we can point
typical postgresql tools (such as psql) to port 35432 (or some other port) and they will
"work". That would also allow us to use each languages native/preferred method
of connecting to a postgresql database to connect to teiid. E.g. DBD::Postgres for perl,
ruby-pg for ruby, pg/pgdb in python, etc.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:38 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1460) Have teiid emulate a native postgresql database connection
[
https://issues.jboss.org/browse/TEIID-1460?page=com.atlassian.jira.plugin...
]
Ramesh Reddy commented on TEIID-1460:
-------------------------------------
+1
Have teiid emulate a native postgresql database connection
----------------------------------------------------------
Key: TEIID-1460
URL: https://issues.jboss.org/browse/TEIID-1460
Project: Teiid
Issue Type: Feature Request
Components: Server
Affects Versions: 7.3
Environment: All environments
Reporter: Graeme Gillies
Assignee: Steven Hawkins
Priority: Minor
Attachments: pgclient.py, preparedodbctest.pl, testselect.py
Currently we are using postgresql-odbc, and unixODBC to connect to teiid via the emulated
postgresql ODBC connection on port 35432. Unfortunately, this is cumbersome to use,
requires fiddling with setting up ODBC, and is difficult for integration into non-java
languages (that have to use the ODBC connection).
What we would like is for teiid to emulate a postgresql database such that we can point
typical postgresql tools (such as psql) to port 35432 (or some other port) and they will
"work". That would also allow us to use each languages native/preferred method
of connecting to a postgresql database to connect to teiid. E.g. DBD::Postgres for perl,
ruby-pg for ruby, pg/pgdb in python, etc.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:45 p.m.
New subject: [JBoss JIRA] Resolved: (TEIID-1460) Have teiid emulate a native postgresql database connection
[
https://issues.jboss.org/browse/TEIID-1460?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-1460.
-----------------------------------
Fix Version/s: 7.4.1
7.5
7.1.1
Resolution: Done
Marking as resolved in 7.1.1, with additional features added in 7.4.1/7.5 such as ssl and
declared cursors.
Have teiid emulate a native postgresql database connection
----------------------------------------------------------
Key: TEIID-1460
URL: https://issues.jboss.org/browse/TEIID-1460
Project: Teiid
Issue Type: Feature Request
Components: Server
Affects Versions: 7.3
Environment: All environments
Reporter: Graeme Gillies
Assignee: Steven Hawkins
Priority: Minor
Fix For: 7.4.1, 7.5, 7.1.1
Attachments: pgclient.py, preparedodbctest.pl, testselect.py
Currently we are using postgresql-odbc, and unixODBC to connect to teiid via the emulated
postgresql ODBC connection on port 35432. Unfortunately, this is cumbersome to use,
requires fiddling with setting up ODBC, and is difficult for integration into non-java
languages (that have to use the ODBC connection).
What we would like is for teiid to emulate a postgresql database such that we can point
typical postgresql tools (such as psql) to port 35432 (or some other port) and they will
"work". That would also allow us to use each languages native/preferred method
of connecting to a postgresql database to connect to teiid. E.g. DBD::Postgres for perl,
ruby-pg for ruby, pg/pgdb in python, etc.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:44 a.m.
New subject: [JBoss JIRA] (TEIID-1460) Have teiid emulate a native postgresql database connection
[
https://issues.jboss.org/browse/TEIID-1460?page=com.atlassian.jira.plugin...
]
Steven Hawkins updated TEIID-1460:
----------------------------------
Affects: Documentation (Ref Guide, User Guide,
etc.),Compatibility/Configuration,Release Notes
See also the admin guide for the system properties to emulate pg query semantics.
Have teiid emulate a native postgresql database connection
----------------------------------------------------------
Key: TEIID-1460
URL: https://issues.jboss.org/browse/TEIID-1460
Project: Teiid
Issue Type: Feature Request
Components: Server
Affects Versions: 7.3
Environment: All environments
Reporter: Graeme Gillies
Assignee: Steven Hawkins
Priority: Minor
Fix For: 7.1.1, 7.4.1, 7.5
Attachments: pgclient.py, preparedodbctest.pl, testselect.py
Currently we are using postgresql-odbc, and unixODBC to connect to teiid via the emulated
postgresql ODBC connection on port 35432. Unfortunately, this is cumbersome to use,
requires fiddling with setting up ODBC, and is difficult for integration into non-java
languages (that have to use the ODBC connection).
What we would like is for teiid to emulate a postgresql database such that we can point
typical postgresql tools (such as psql) to port 35432 (or some other port) and they will
"work". That would also allow us to use each languages native/preferred method
of connecting to a postgresql database to connect to teiid. E.g. DBD::Postgres for perl,
ruby-pg for ruby, pg/pgdb in python, etc.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:57 a.m.
New subject: [JBoss JIRA] (TEIID-1460) Have teiid emulate a native postgresql database connection
[
https://issues.jboss.org/browse/TEIID-1460?page=com.atlassian.jira.plugin...
]
Steven Hawkins closed TEIID-1460.
---------------------------------
Have teiid emulate a native postgresql database connection
----------------------------------------------------------
Key: TEIID-1460
URL: https://issues.jboss.org/browse/TEIID-1460
Project: Teiid
Issue Type: Feature Request
Components: Server
Affects Versions: 7.3
Environment: All environments
Reporter: Graeme Gillies
Assignee: Steven Hawkins
Priority: Minor
Fix For: 7.1.1, 7.4.1, 7.5
Attachments: pgclient.py, preparedodbctest.pl, testselect.py
Currently we are using postgresql-odbc, and unixODBC to connect to teiid via the emulated
postgresql ODBC connection on port 35432. Unfortunately, this is cumbersome to use,
requires fiddling with setting up ODBC, and is difficult for integration into non-java
languages (that have to use the ODBC connection).
What we would like is for teiid to emulate a postgresql database such that we can point
typical postgresql tools (such as psql) to port 35432 (or some other port) and they will
"work". That would also allow us to use each languages native/preferred method
of connecting to a postgresql database to connect to teiid. E.g. DBD::Postgres for perl,
ruby-pg for ruby, pg/pgdb in python, etc.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
4181
days inactive
4838
days old
17 comments
4 participants
participants (4)
-
Graeme Gillies (JIRA) -
Ramesh Reddy (JIRA)
-
Steven Hawkins (JIRA)
-
Steven Lawrance (JIRA)